create qvd of geographic data (perhaps from google map)

[yelin_nyu]

hi, I want to pull geographic data (city, country, etc) from website (ie. google) into qlikview and create qvd of it. I would set a publisher job to run the file on regular basis, so I can use the data whenever I need to.

Does anyone has any recommendation which site I should pull this data from? I was looking at google map api, but don't know if I need to write any macro to do this. thank you!!!!

[jjordaan]

What kind of information do you already have?

I mean with an address and a postal code you can fetch longitude and latitude or the other way around.

But you need to have some information to retrieve geo information.

[yelin_nyu]

im trying to do 2 things here, the tasks are not related, I am more interested in finding the solution for the first task:

1) I have a list of countries, I want to find a list of city and state/province in each country. I need to refresh the list periodically (say on an annual basis, but I want this in a qvw, so it will run after I leave the project).

2) I have a list of locations, with full address and zip code. I'm trying to get the corresponding latitudes and longitudes. I assume google api would be my best bet to get the location data.

[jjordaan]

Hi Yelin,

For point 1 I don't now how to get that. But I think there will be an Excel file, website, or API you can use on the Internet

For point 2 you can indeed use the google api. See the link below.

[http://maps.google.com/maps/api/geocode/xml?sensor=false&ie=utf8&region=$(vCountryCode)&address=$(vA...)]

Hope this helps

[vikasmahajan]

Hii,

Latitude Longitude Finder on Map Get Coordinates

From this site you can find out latitudes and longitudes

Hope this helps you

Vikas

[jpenuliar]

You can try and pull data from web: see attached Sample code fro Canada.

If you have long list of Countries, you will have to manually code them.

[jpenuliar]

Search the net for GPS Visualizer

[jpenuliar]

The site can help to extract large batch of data

[jpenuliar]

If you want US and Canada data in csv format:

geocoder.ca: geocoding for North America - USA and Canada