Dataset

Data sources that can be used with operations in the Qlik GeoAnalytics connector.

Database

Access to tables in databases. Only available in GeoAnalytics Plus version or if enabled in local Qlik GeoAnalytics Enterprise Server installations.

Note that the JDBC driver for the particular database you access must be available to GeoAnalytics. See the Installation Instructions for GeoAnalytics Plus for further instructions.

Parameters for Database
Parameter	Type	Use	Description
URL			Url in jdbc format. Example for PostgreSQL: jdbc:postgresql://myServer/myDatabase Example for MySQL: jdbc:mysql://myServer/myDatabase Note that the JDBC driver for the particular database you access must be available to GeoAnalytics. See the Installation Instructions for GeoAnalytics Plus for further instructions.
User		default:	User name.
Password		default:	Password.
Table		default:	The table to load. One of Table or SQL must be specified. This parameter is ignored if SQL is specified.
SQL		default:	Optional SQL statement to execute. If specified then the Table parameter is ignored. Note that when reading geometries from a database they can in most databases be returned on WKT format. The following example formats a column called g in WKT format: SELECT id, name, st_astext(geometry) as g FROM road WHERE roadclass=0
Key Field	string	default:	The name of the field that contains identities for each geometry. If you leave the field empty a key field will be generated.
Geometry Field	string	default:	Name of the geometry field if any. As an alternative to a geometry a column with names of well known names of points or areas may be specified, "Geometry Type" below. If point data is in two fields then specify name of latitude field comma name of longitude field. Geometries may be specified as WKT. Points are otherwise specified as "[longitude,latitude]". A line is an array of points like "[[longitude,latitude],[longitude,latitude],...]". A polygon is an array of closed lines or array of array of closed lines in case of multi-polygons.
Geometry Type		default:WKT	Type of geometry in the Geometry Field. Allowed values are WKT, Point, Line, Polygon, Location Named Point and Location Named Area. In case of named points or areas, the geometry is looked up in the location service and a column for the geometry is added. Also columns for country, type, administrative areas are added as in the Standard areas and Points dataset.
Location ID Suffix	string		For advanced user. The specified string is appended to all IDs. This is a convenient way to specify more information to server based location services such as country code or type. The alternative is to append the extra data when loading the table into Qlik. With the following suffix all items are specified to be cities in Sweden: :P*,SE See Geometry Service Specification for more information on syntax to use.
CRS	string	default:Auto	CRS of the data to load. The data will be projected from this CRS to WGS84 (EPSG:4326) before being loaded into the app. If set to Auto then EPSG:4326 (WGS84) is used.

File based geo dataset

Different kinds of geographical file formats like GeoJSON and Shape.

Parameters for File based geo dataset
Parameter	Type	Use	Description
URL			The URL of the file containing the data. URLs with file-protocol are normally not allowed. In a local customer installation it may be allowed. When login is required for accessing the URL, user and password can be specified in the URL like this: http://username:password@hostname/.
Key Field	string	default:	The name of the field that contains identities for each geometry. If you leave the field empty a key field will be generated.
File Type	string	default:Auto	The type of file. Allowed values are: Auto - Tries to detect the file type from the name of the file. GeoJSON - The GeoJSON format as specified by geojson.org. GML - For reading GML files or connecting to WFS services. Reads featureCollection files and makes one row of each featureMember element. ESRI Shape file - A zip file with at least a shp and a dbf file. ESRI Json - JSON as returned by ESRI ArcGIS Server (see ESRI doc of format). This makes it possible to connect to ArcGIS and import data from services it has published. AutoCAD DXF file - For reading geometries from a DXF file. The following entity types are supported: Points: `POINT, TEXT, MTEXT` Lines: `ARC, CIRCLE, LINE, POLYLINE, LWPOLYLINE, SPLINE, MLINE`
Character encoding	string	default:	For some formats (like ESRI Shape) the character encoding is not defined in the format. This gives a way to provide this information. For most formats this property is ignored. Uses the Java character encodings available.
Expected Geometry Type	string	default:Auto	Auto - Tries to detect type automatically. Point - Looks for Points in the specified file. Line - Looks for Lines in the specified file. Polygon - Looks for Polygons in the specified file.
CRS	string	default:Auto	CRS of the data to load. The data will be projected from this CRS to WGS84 (EPSG:4326) before being loaded into the app. If set to Auto or if empty it will try to parse it from the file. If no CRS is found in the file, then EPSG:4326 (WGS84) is used.

Loaded table

Data that is already loaded from other sources may be used as as a dataset. For large datasets it is more efficient to load data through the Qlik GeoAnalytics Connector than first loading them and then sending them to GeoAnalytics.

Parameters for Loaded table
Parameter	Type	Use	Description
Table Name	string		The name of the loaded table that contains the data.
Table Fields	string		The name of the fields from the table to use, separated by comma. The first field should be the key field and the second the location (unless Geometry Type is None). If latitude and longitude are in separate columns place them in second and third column. If the key and the location are in the same column, repeat it as both first and second column.
Geometry Type		default:POINT	Type of geometry in the Geometry Field. Allowed values are 'Point', 'Line', 'Polygon', 'Latitude and Longitude Point', 'Location Named Point', 'Location Named Area' and 'None'. In case of named points or areas, the geometry is looked up in the location service and a column for the geometry is added. Also columns for country, type, administrative areas are added as in the Standard areas and Points dataset.
Only load distinct		default:NO	When YES, an extra step is added that filters out distinct rows before sending data to GeoAnalytics. This might improve performance when you have many identical rows. One typically example is log files where you have rows containing IP addresses, typically many rows with same IP. Setting YES on this option speeds up the query a lot.
Location ID Suffix	string		For advanced user. The specified string is appended to all IDs. This is a convenient way to specify more information to server based location services such as country code or type. The alternative is to append the extra data when loading the table into Qlik. With the following suffix all items are specified to be cities in Sweden: :P*,SE See Geometry Service Specification for more information on syntax to use.
CRS	string	default:Auto	CRS of the data to load. The data will be projected from this CRS to WGS84 (EPSG:4326) before being loaded into the app. If set to Auto then EPSG:4326 (WGS84) is used.

Separated text file

Text files with table data, optionally with geometries. Instead of geometries also names of locations may be specified. All fields will be loaded as strings.

Parameters for Separated text file
Parameter	Type	Use	Description
URL			The URL of the file containing the data. URLs with file-protocol are normally not allowed. In a local customer installation it may be allowed. When login is required for accessing the URL, user and password can be specified in the URL like this: http://username:password@hostname/.
Key Field	string	default:	The name of the field that contains identities for each geometry. If you leave the field empty a key field will be generated.
Geometry Field	string	default:	Name of the geometry field if any. As an alternative to a geometry a column with names of well known names of points or areas may be specified, "Geometry Type" below. If point data is in two fields then specify name of latitude field comma name of longitude field. Points are otherwise specified as "[longitude,latitude]". A line is an array of points like "[[longitude,latitude],[longitude,latitude],...]". A polygon is an array of closed lines or array of array of closed lines in case of multi-polygons.
Geometry Type		default:POINT	Type of geometry in the Geometry Field. Allowed values are Point, Line, Polygon, Location Named Point and Location Named Area. In case of named points or areas, the geometry is looked up in the location service and a column for the geometry is added. Also columns for country, type, administrative areas are added as in the Standard areas and Points dataset.
Location ID Suffix	string		For advanced user. The specified string is appended to all IDs. This is a convenient way to specify more information to server based location services such as country code or type. The alternative is to append the extra data when loading the table into Qlik. With the following suffix all items are specified to be cities in Sweden: :P*,SE See Geometry Service Specification for more information on syntax to use.
Column names	string	default:	The names of the columns separated by comma. If blank, the first row is supposed to contain the header.
Field Separator	string	default:TAB	Character that separates fields. In addition to ordinary characters the key words TAB, NEWLINE, COMMA and SEMICOLON are allowed.
Record Separator	string	default:NEWLINE	Character that separates lines. In addition to ordinary characters the key words TAB, NEWLINE, COMMA and SEMICOLON are allowed.
Character Encoding	string	default:UTF-8	Character set for the file. Same values allowed as in Java.
String Quotes	string	default:DOUBLEQUOTE	Character that may be used for quoting strings. Field and record separators inside the quotes will not be parsed as such. The quotes will be removed in the imported data. In addition to ordinary characters the key words QUOTE("), DOUBLEQUOTE(") and SINGLEQUOTE(') are allowed.
CRS	string	default:Auto	CRS of the data to load. The data will be projected from this CRS to WGS84 (EPSG:4326) before being loaded into the app. If set to Auto then EPSG:4326 (WGS84) is used.

Standard areas and points

Points and areas that are available in a Qlik GeoAnalytics Server location service.

Parameters for Standard areas and points
Parameter	Type	Use	Description
Geometry kind		default:Area	Chose to access Points or Areas.
Type of data	string	default:Country	Type of data that the names represents such as countries, administrative areas, postal codes etc.
Country code(s)	string	default:	Country code (2 or 3 letters) for the country to access. Several countries may be specified, separated by comma. The default value means not restricted to a country.
Name of Service		default:default	Name of a location services that is available at the server.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here