topic Re: latitude longitude in QlikView

latitude longitude

Wed, 21 Sep 2016 16:25:58 GMT

is the a free website I can load Address city and state data in excel and have it return the latitude longitude?

Currently I only have about 150 address.

Re: latitude longitude

jpenuliar — Wed, 21 Sep 2016 16:37:08 GMT

Hi Robert,

This code works to extract Lat&Long from google api:

Cities:

Load * Inline

[

City, Qty

DARDILLY,5

ECOLE VALENTIN,56

GENTILLY,2

GOUSSAINVILLE,45

LYON,8

PARIS,98

PERONNAS,56

RILLIEUX LA PAPE,74

SEYSSINET PARISET,54

SOISSONS,25

VILLEFRANCHE SUR SAONE,86

Manila,52

];

let noRows = NoOfRows('Cities')-1;

for i=0 to $(noRows)

let a = peek('City',$(i),'Cities');

let b = peek('Qty',$(i),'Cities');

LOAD

'$(a)' as CustomerCity,

'$(b)' as CustomerQuantity,

Replace([result/geometry/location/lat], '.', ',') as latitude,

Replace([result/geometry/location/lng], '.', ',') as longitude

FROM [https://maps.googleapis.com/maps/api/geocode/xml?address=$(a)] (XmlSimple, Table is [GeocodeResponse]);

next i;

Drop table Cities;

Re: latitude longitude

MK9885 — Wed, 21 Sep 2016 17:10:51 GMT

Batch Geocode

https://www.doogal.co.uk/BatchGeocoding.php

Re: latitude longitude

dandaanilreddy — Wed, 21 Sep 2016 17:35:08 GMT

Hi Robert

Please find the attached zip below.

Thanks

Anil Danda !

Re: latitude longitude

MK9885 — Wed, 21 Sep 2016 22:28:39 GMT

BTW, verify those latitude and longitude in google once you geocode it from that website.

Thanks.

Re: latitude longitude

Mon, 03 Oct 2016 21:45:04 GMT

OK thank you for your help, really appreciate it.

Thank you,

Bob

Re: latitude longitude

Mon, 22 May 2017 18:01:11 GMT

Yes, there are few out there.

You also try this one : CSV 2 Geo Data

It comes with free version and will allow you to insert flat file in csv format. All you have to do is save as csv your excel and import it or copy/paste the addresses in question.