topic Re: Macro to get address from latitude and longitude in QlikView

Macro to get address from latitude and longitude

Anonymous — Fri, 21 Jul 2017 15:15:09 GMT

Hi All,

I am having having a list of Latitude and longitude based on some dimension.

What I want now is to have the address, City, State, Country, Zip Code for all of these latitude and longitudes.

Please help me in crating a Macro which will read all the latitude and longitude from the application and return back the address, sity, state and country which I can use for further dashboard requirements.

Regards

Nitin

Re: Macro to get address from latitude and longitude

jmvilaplanap — Fri, 21 Jul 2017 16:08:24 GMT

I published a excel macro to do it, you can see it in: Address2Coord.xlsm

I think is better than create the macro directly in QV because the 2000 get restriction.

Regards

Re: Macro to get address from latitude and longitude

jmvilaplanap — Fri, 21 Jul 2017 16:09:20 GMT

Ups, is the opposite that you need.

Sorry!

Re: Macro to get address from latitude and longitude

jmvilaplanap — Fri, 21 Jul 2017 16:13:23 GMT

I found this https://www.mrexcel.com/forum/excel-questions/514384-reverse-geocoding.html

I'll try to add it to my excel.

Re: Macro to get address from latitude and longitude

Anonymous — Fri, 21 Jul 2017 16:21:50 GMT

Hi ,

Thanks for the help,

Can you help me out with the reverse also.

As I am totally new to Excel macros scripting.....

Regards

Nitin Gupta

Re: Macro to get address from latitude and longitude

Anonymous — Mon, 24 Jul 2017 13:53:44 GMT

Hi Jose,

If you implement it , please do send me the script, so that it will be helpful to me also.

Thanks

Re: Macro to get address from latitude and longitude

jmvilaplanap — Mon, 24 Jul 2017 14:10:18 GMT

Hi, I was taking a look on yesterday, but this webservice is only for US addresses...

If you find a webservice available for the whole world, please tell me and we try to implement it.

Thanks.

Re: Macro to get address from latitude and longitude

Anonymous — Tue, 25 Jul 2017 16:09:46 GMT

I need only for US, Canada and mexico.

Re: Macro to get address from latitude and longitude

Anonymous — Tue, 25 Jul 2017 17:41:04 GMT

I have a html which takes lat long as input and gives the address in alert popup.

Its using googleapis in jScript.

Hope it can help you

<head>

</head>

<body>

Latitude:

Latitude:

function GetAddress() {

var lat = parseFloat(document.getElementById("txtLatitude").value);

var lng = parseFloat(document.getElementById("txtLongitude").value);

var latlng = new google.maps.LatLng(lat, lng);

var geocoder = geocoder = new google.maps.Geocoder();

geocoder.geocode({ 'latLng': latlng }, function (results, status) {

if (status == google.maps.GeocoderStatus.OK) {

if (results[1]) {

alert("Location: " + results[1].formatted_address);

}

});

}

</script>

</body>

</html>

Re: Macro to get address from latitude and longitude

Anil_Babu_Samineni — Tue, 25 Jul 2017 17:43:15 GMT

With in the JS i didn't seen any popup Tags? Can you high light those if possible

Re: Macro to get address from latitude and longitude

Anonymous — Wed, 26 Jul 2017 13:17:32 GMT

HI,

I have highlighted it