topic How to convert Address into Latitude, Longitude Co-ordinates to use in Map? in QlikView

How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

Thu, 02 Jun 2011 14:28:25 GMT

Hi,

Is there a way to convert Customer Addresses (House No, Street Name, Post Code) into Latitude and Longitude Co-ordinates?

Any suggestion would be much appreciated. (There are close to 20,000 addresses).

Regards

Arun

How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

rajeshvaswani77 — Mon, 19 Mar 2012 14:30:42 GMT

Hi, Has anyone found an answer to this one?

How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

Anonymous — Mon, 19 Mar 2012 14:36:36 GMT

There are multiple websites that allow you to upload Post Codes and the result will be a GPS Long and Lattitude for that post code.

This would be Post codes in the UK and Zip codes in the USA. But your key is the post code, the rest of the address not required for this.

If you cant find a website for this respond to this post and I will dig it up for you

How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

rajeshvaswani77 — Mon, 19 Mar 2012 15:11:44 GMT

Hi, Thanks Hamishi. Can you get me the website for this? So did you write a job to do this?

How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

Anonymous — Mon, 19 Mar 2012 15:46:00 GMT

Here is the website link

http://www.gpsvisualizer.com/map_input?form=google

There is an option to upload a file of post codes and the return will be the GPS data.

Then you integrate with the standard Google Maps examples on this forum.....

How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

rajeshvaswani77 — Mon, 19 Mar 2012 16:24:16 GMT

Thanks very much for the link. it looks helpful. Can you suggest where I have to do the conversion
from postcode in to the coordinates? Thanks, Rajesh Vaswani

How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

Anonymous — Mon, 19 Mar 2012 16:28:48 GMT

You are not looking at the website !

There are a few options.

Option 1 is to upload a file, Option 2 is to copy and paste data....

How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

rajeshvaswani77 — Mon, 19 Mar 2012 16:39:02 GMT

Sorry to bother again. I do not have the latitude and longitude but want to get these. I see that here it takes a file and processes. How will it give an output? Its really confusing.

Re: How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

Mon, 19 Mar 2012 16:45:55 GMT

Hi Rajesh,

I am using this one - http://stevemorse.org/jcal/latlonbatch.html.

Check it out. I am looking for other sites which can handle batch processing.

Regards

Arun

Re: How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

rajeshvaswani77 — Mon, 19 Mar 2012 17:41:06 GMT

Thanks very much for the link. Thats a good one. Finally based on my needs, i prefer to write .Net code to call the google api webservice.

Re: How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

Mon, 19 Mar 2012 19:14:38 GMT

Hi,

You can see the attaches files,

Its reed from xls File the Address and transfer it to Latitude and Longitude ,

Its very usefull for me.

Hope it helps.

Yigal.

Re: How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

Tue, 20 Mar 2012 09:45:31 GMT

Hi Yigel,

That's exactly what I wanted.

Thanks!

Arun Raj

Re: How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

Anonymous — Sun, 05 Apr 2015 19:11:39 GMT

Hi Yigel,

when i try and run your QVW it says error in downloading content. can you please provide an updated version taking into account some changes google maps might have made to not let the old file work.

Thanks

Gareth

Re: How to convert Address into Latitude, Longitude Co-ordinates to use in Map?

Thu, 15 Jun 2017 13:25:34 GMT

Hi, I am sorry, I am new in Qlik sense and do not know how to run it. How can I rewrite my script?

LOAD

NAME,

ADDRESS;

[TABLE1]:

SELECT

"NAME",

"ADDRESS"

FROM "XY"."TABLE1";

Address form is: Tigergasse 7, Vienna, 1080