GeoNames Forum

I am trying to uniquely identify city/state in the raw data provided in US.zip. In some cases - 408 to be precise (query below) - there are two records with the same admin1 and name but are in fact different locations (example below). From what I can tell, one of the records is a city and the other is a road or subdivision. I was hoping population would be a way to disambiguate between city vs. road but does not work for every scenario. The feature class and feature codes are the same in all 408 cases. The admin2 field is different which can be mapped back to a county, but I don't see an easy way to determine which record is a city. Any help is much appreciated.

Example:
5832900 Mountain View Mountain View 42.8535762 -106.3886403 P PPL US WY 025 103 1585 1585 America/Denver 2006-01-15
5832901 Mountain View Mountain View 41.2688392 -110.3398785 P PPL US WY 041 1153 2074 2082 America/Denver 2006-01-15

Query:
select admin1, name, count(latitude) from us where population > 0 group by admin1, name having count(latitude) > 1;

Thanks

Romaine

Hi Romaine

City names are not unique, both are valid cities. Why do you discard the county information?

Best

Marc