List of cities by country?
October 10, 2006 4:06 AM Subscribe
I am looking for a comprehensive list of cities by country, that can be uploaded to a database. The list needs to show the local name for the city, and if it showed the English version too that would be good, but not essential. I am able to pay if required, though obviously would prefer not to.
posted by chill to grab bag (5 answers total)
As an example of what I'm looking for...
COUNTRY_CODE PLACE PLACE_EN
DE München Munich
seems to be the closest to what I want, in that it is very comprehensive and has the local version. However, I have some issues with the data, for one although it contains both local and English versions of locations, it does so in seperate rows, i.e. there's a row for Munich, and a seperate row for München.
I've also taken a look here
. Again, it's just not quite what I'm looking for. The English version of the name is the primary, and then there is a list of variations, but the proper local version is not clearly specified.