Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

13 Replies
rajeshvaswani77
Specialist III
Specialist III

Hi, Has anyone found an answer to this one?

Anonymous
Not applicable
Author

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

rajeshvaswani77
Specialist III
Specialist III

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

Anonymous
Not applicable
Author

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.....

rajeshvaswani77
Specialist III
Specialist III

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

Anonymous
Not applicable
Author

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.... GPS.png

rajeshvaswani77
Specialist III
Specialist III

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.

Not applicable
Author

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

rajeshvaswani77
Specialist III
Specialist III

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.