This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Where can I find a list of cities that only have one cordinate set?

Can someone point me to a file that has all the cities for Canada and the U.S. The ones I keep finding confuse me as they got like one city listed multiple times with slightly different coordinates and I have no clue which one to use.

cites coordinates

asked 26 Apr '13, 18:42

chobo2
11●1●1●2
accept rate: 0%

One Answer:

Try naturalearthdata.com where they have a curated list of populated places that you can use.

answered 26 Apr '13, 19:27

Frederik Ramm ♦
82.5k●92●720●1273
accept rate: 23%

I downloaded the ne_10m_populated_places_simple but not sure how to open the .dbf file. Do they have like excel sheets and can you filter down to only a certain country? Also the file seems so small compared to other ones the full version is like 1.51 MB compared to the couple hundred megs to over a gb that I seen.

(26 Apr '13, 19:33) chobo2

it also seems to be missing many cities. Heck my city I live in with a population of 200,000+ is not even listed.

(26 Apr '13, 21:28) chobo2