Hi Guys, I have been trying to use http://download.geonames.org/export/dump/ to get a data set where I can extract - City - County - State - Region - Country - Latitude - Longitude - Postal code/zip code The requirement is to be able to lookup places by zip code/postal code or by place name. Now the place name etc needs to be available in english as well as local language. e.x for Taipei, capital or Taiwan where the main language is Chinese, we want: - Place name (English): Taipei - Place name (Chinese): 台北市 - All other information as above Is this possible to get this info from the [http://planet.openstreetmap.org/][1]? I just downloaded a sample data xml for a region and I can see that it has lot of information. I did find a wiki for a script to import data to mysql script - [http://forum.openstreetmap.org/viewtopic.php?pid=152695][2] but I don't think I can use it as it is as because the columns data I want is not per geo boundary but more like per city/state/country. So can anyone guide me how I can use this data for my usage? usage? I don't want to run a script to export the data per geolocation or by specifying certain area. Thanks a ton! [1]: http://planet.openstreetmap.org/ [2]: http://forum.openstreetmap.org/viewtopic.php?pid=152695

Hi Guys, I have been trying to use http://download.geonames.org/export/dump/ to get a data set where I can extract - City - County - State - Region - Country - Latitude - Longitude - Postal code/zip code The requirement is to be able to lookup places by zip code/postal code or by place name. Now the place name etc needs to be available in english as well as local language. e.x for Taipei, capital or Taiwan where the main language is Chinese, we want: - Place name (English): Taipei - Place name (Chinese): 台北市 - All other information as above Is this possible to get this info from the [http://planet.openstreetmap.org/][1]? I just downloaded a sample data xml for a region and I can see that it has lot of information. I did find a wiki to import data to mysql script - [http://forum.openstreetmap.org/viewtopic.php?pid=152695][2] but I don't think I can use it as it is as the columns I want is not per geo boundary but more like per city/state/country. So can anyone guide me how I can use this data for my usage? Thanks a ton! [1]: http://planet.openstreetmap.org/ [2]: http://forum.openstreetmap.org/viewtopic.php?pid=152695