article Qlik Geocoding Geocoding Template, Data and presentation in Official Support Articles

Qlik Geocoding Geocoding Template, Data and presentation

Patric_Nordstrom — Mon, 15 Jan 2024 07:21:29 GMT

Qlik Geocoding is a subscription service for address to coordinate lookups and vice versa. The service is hosted, address and key get sent to remote servers for lookup. The subscription has a limited amount of lookups and is valid for one year. Qlik Geocoding is an add-on service to Qlik GeoAnalytics Base and Qlik GeoAnalytics Enterprise Server. The service is provided through the Qlik GeoAnalytics Connector using the operations “AddressPointLookup” and “PointToAddressLookup”. Forward geocoding is address to point conversion. The result includes information about match level and location structure. Reverse geocoding is point to address conversion. Useful for example converting GPS coordinates to an location.

To get started

Please contact your Qlik sales rep for pricing and license key.
Watch the Qlik Geocoding Presentation
Download the Qlik Geocoding Template
Start converting addresses!

Below you will find templates for use together with the Qlik GeoAnalytics connector for Qlik Sense and QlikView. And also a template for GeoOperations : "Qlik Geocoding Template for GeoOperations.qvf"

Re: Qlik Geocoding Geocoding Template, Data and presentation

pwagner — Wed, 19 Jun 2019 06:32:21 GMT

Hello Patric,

thank you.

The template works for a part of our adresses fine. After some lines we receive following error and we cannot continue the script:

Custom connector error

Connector reply error: QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset adr: Invalid number of columns at row 43 in CSV data. Make sure to check the quoting.

Do you have an idea what here the issue(s) can be?

Best regards, Patrick

Re: Qlik Geocoding Geocoding Template, Data and presentation

Patric_Nordstrom — Wed, 19 Jun 2019 08:58:45 GMT

Most likely due to odd characters in the indata fields. Run a small sample and try to identify the character.

Thanks,

Patric

Re: Qlik Geocoding Geocoding Template, Data and presentation

pwagner — Wed, 19 Jun 2019 09:34:11 GMT

Thanks.

Do you have an idea how I can check the adresses before running the AdressLookUp script?

Best regards, Patrick

Re: Qlik Geocoding Geocoding Template, Data and presentation

Patric_Nordstrom — Thu, 20 Jun 2019 09:35:53 GMT

Can be difficult to spot if there are many rows and fields.

I would modify the script to store the result after each lookup call and to narrow down the search, until I find the row with the problem.

Re: Qlik Geocoding Geocoding Template, Data and presentation

pwagner — Tue, 25 Jun 2019 06:39:18 GMT

I found one adress which creates the error:

id	street	isocode	city	zip
827	Schönbrunnerstraße 222-228 Stiege 1, 7. Stock	AT	Wien	1100

Do you have an idea what the reason for the error can be?

EDIT: The error was an enter (newline character) in field street. Solved with purgechar(street,CHR(10))

EDIT2: An additional error was caused by ´ within the field street. Solved with replace(street,'´','')

Re: Qlik Geocoding Geocoding Template, Data and presentation

Patric_Nordstrom — Tue, 25 Jun 2019 05:19:46 GMT

Ok, great to hear, thanks for posting the solution.

Re: Qlik Geocoding Geocoding Template, Data and presentation

craigleach — Tue, 02 Jun 2020 20:45:40 GMT

Patric,

I have a customer with on-prem Geoanalytics. They also have QSE Windows on-prem and QCS/SAAS for consumption. Is using the on-prem Geoanalytics with QCS supported / possible?

Thanks,

Craig Leach

Re: Qlik Geocoding Geocoding Template, Data and presentation

Patric_Nordstrom — Tue, 09 Jun 2020 16:14:33 GMT

In QCS the maps and geo calculations are served by maps.qlikcloud.com, no other option.

If you are running a client managed cloud with QSEoK it is possible to connect to an on-prem geo server. It's yaml parameter that is set like this

It is a yaml-parmeter, see https://github.com/qlik-trial/elastic-charts/blob/master/charts/geo-operations/README.md.

config.serverUrl

GeoAnalytics server URL (for routing, location lookups)

https://ga.qlikcloud.com

Re: Qlik Geocoding Geocoding Template, Data and presentation

julian_rodriguez — Thu, 18 Feb 2021 01:12:02 GMT

Hello Patric,

Good examples, however, I'd like to test the cluster operation with my own data. ¿Could you provide me an example, please?

thanks

Julian

Re: Qlik Geocoding Geocoding Template, Data and presentation

pwagner — Tue, 05 Oct 2021 10:09:20 GMT

Hello @Patric_Nordstrom

Is it possible to add Adm2Code and the Adm3Code at the lookup? In your template only the Adm1Code is included.

Thank you.

Best regards,

Patrick

Re: Qlik Geocoding Geocoding Template, Data and presentation

Antoine04 — Tue, 28 Feb 2023 14:13:03 GMT

Hello all,

I am not sure I have access to Geocoding. How can I be sure of it ?

Indeed, when I am searching for Operation, both Geocoding operations does not appear, as you can see below.

If it's not in the list, it means the add-on geocoding is not active, right ?

Thank you by advance