topic Re: Map using long,lat to map out country in App Development

Map using long,lat to map out country

Rocket101 — Sat, 16 Nov 2024 18:36:52 GMT

Hi folks,

I am trying to build a dashboard in QLik Sense using the map to add an area within country. I have the latitude & longitude of every machine, the problem is that I have no country field name in my data set, so I am trying to use lat & long to achieve this. Is it possible to populate country & state codes based on a machines lat & long location.

did some research and found something in google around api's, but there seems to be a price involved in this.

any ideas please

Re: Map using long,lat to map out country

fosuzuki — Wed, 20 May 2020 22:33:50 GMT

It is called reverse geocoding - you pass the coordinates and get in return the address.

If you have GeoAnalytics, you could use it to make a a geoprocessing and intersect the coordinates with state and country shapes.

GeoAnalytics also has a reverse geocoding feature, but it is an add-on subscription-based.

Re: Map using long,lat to map out country

Rocket101 — Thu, 21 May 2020 08:16:25 GMT

thanks for the quick response, I will look into that, have you any idea of the cost involved to get it added on.

I am currently using Qliksense server version nov 2018 version.

thanks

Re: Map using long,lat to map out country

fosuzuki — Thu, 21 May 2020 08:43:42 GMT

Not sure on the cost for Geocoding subscription in GeoAnalytics.

Of course you could use other geo apis like Google Maps or Here. Some have a free limit, depending on the data volume they may be enough for you. But you would also need some scripting magic to get the response from their APIs.

This is a good starting point: http://livingqlikview.com/wheres-qlik-waldo/. In this scenario, he wants to get the coordinates. Note that you need the inverse, so you'll need to change the code a bit.