Automatic lookup of coordinates for a list of cities

ted_striker · 2011-09-01T10:02:03.000Z

Hi,
I have a pretty long list of cities in Europe in MS Excel (information: city, state, country) and would like to add for each city the coordinates using openstreetmap. Does anybody have a good idea how I could do this in an efficient way?
Thanks a lot in advance,
ted

chris66 · 2011-09-01T11:36:18.000Z

You can do this online using the nominatim service or offline.

For example you could get a europe.osm file, filter for place=city/town/village with osmfilter.

For getting the state/country you can evalute the is_in Tag, or search for the nearest addr: node.