How to resolve addresses into Qlik Sense Geo Points?

[ArturoMuñoz]

The requirements

During the last few days I’ve been working in a new project around weather data, we wanted to visually represent how temperatures had risen during the last decades. We have a bunch of temperature data points gathered at weather stations across the globe. We were curious to check if a map would help us to visualize warming, we wanted to check whether or not the global warming is indeed global. Are the co2 emissions affecting more to the northern hemisphere? Are some continents/countries more affected?

The data issue

Qlik Sense provides with a compelling mapping object out-of-the box that would help us to geographically understand the data. However, in order to get the map object to work, it needs a latitude and longitude geo point to be able to represent the data. In this particular case we had address data of each one of the weather stations where the measurement were taken but we didn’t have geo points or any other geo reference.

The solution

Luckily we have a bunch of smart guys in the community that can help us all to solve most of our issues. GetGeoCoords is a Qlik Sense app created by Christof Schwarz( cschwarz) that does exactly what I needed. It will enrich my app by not only adding latitude and longitude data points to each one of the existing locations, but it will also include some other useful geo-information like country, state, county, district, neighborhood, city, etc.

Christof describes the app as following:

The main purpose of the app is to stand in the middle of data loads, it inputs tables and outputs files. So you likely don't need the frontend unless you like to make sanity checks of your geographic data, You may also be creative and take the code into your own final app to avoid one load sequence in the middle. My code would work in other apps as well.

You can grab the app here and learn how it works watching the video tutorial

Hope you find it as useful as I do.

AMZ

PS: Just a friendly reminder about app support. As most of the community based content this material comes with no support but the support provided by the community itself.

[olaf_gschweng]

Thanks Christof and Arturo for sharing this solution with the community.

I tested with some addresses from our CRM. While all addresses are in fact in Germany, some dots on the map appeared distributed around the globe. All belong to cities with special characters in their names (german umlaut). I also checked the streets with special characters and found bad results too. After some hours of testing I found that removing the URL encoding solved the problem. Now the minimum quality is 71 and most adresses have NoOfGeoCoords of 1.

With curl I had to encode spaces with %20 to get a result. The GetGeoCoords-app does not replace spaces - if you modify it to do so, you will get worse results. Maybe the connector does some encoding itself. Maybe the %-sign in e.g. %C3%B6 will then be replaced by %25? I did not find anything about that in the connector's manual. Unfortunately the logfiles of the connector where empty.

Has anyone made similar experiences?

[#3]

try this approach Geocoding with QlikView and Google Maps

basically this is simple script/wrapper around Google Maps geocoding  API.

it understand Russian and Polish umlauts (so it should understand German as well); you can provide different spelling and even mistakes - in most cases Google will figure out your intent and provide correct full address and lat&lng.

If you have some heavylifting to do - try Python and geocoder. Geocoder is universal wrapper/parser for many, many geo sites, including Google, Bing, Yandex, others and provides the feedback in identical json from all of them. After getting points you can use it in Qliksense.

[naveen341]

hi olaf.gschweng ,amz ,veslavvv

Can you please share the sample app where yopu are trying to pull the geo data with rest connector.

I am also facing the same data issue like my data country,city,state are not been recognised correctly by the geo maps.Can you please help in resolving the same data issu which you faced.

Regards,

Naveen.

veslavvvolaf.gschweng  @,amz

[naveen341]

HI

Can you please share the sample app where you are trying to pull the geo data with rest connector.

I am also facing the same data issue like my data country,city,state are not been recognised correctly by the geo maps.Can you please help in resolving the same data issue which you faced.

[ArturoMuñoz]

Hi Naveen,

I'm sorry but it seems Christof has removed the file from Dropbox, unfortunately I don't have a local copy.

[naveen341]

Hi Arturo

I Am trying to develop maps using Idevio line layer.that maps could not do a lookups for the city state and country.So is there a way i can do a lokup if so how?

Regards,

Naveen.

[ArturoMuñoz]

Please take a look at Idevio help http://bi.idevio.com/geoanalytics/geoanalytics-connector-examples and(or) contact support for help on this topic

[naveen341]

hi Arturo i tried to use geo analytics connector and do a address point look up.

But it throws me an error as shown in the screen shot .Any idea on what service to use for look up.

GeoAnalytics Reference.

Reference document says to lookup as Default but its not working.any idea on this

[ArturoMuñoz]

I'm sorry but I can't help with that. I'm pretty sure support could assist you with it.

[naveen341]

Thanks for your response Arturo,

It would be great if you come across the code and  code r app some thing like that which chris has developed.

If you find please share it.

Appreciate your help.

Regards,

Naveen.