<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "US.zip and uniquely identify a city?"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "US.zip and uniquely identify a city?"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>US.zip and uniquely identify a city?</title>
				<description><![CDATA[ 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]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1323.page#5568</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1323.page#5568</link>
				<pubDate><![CDATA[Sun, 15 Mar 2009 06:08:06]]> GMT</pubDate>
				<author><![CDATA[ utopiaplan]]></author>
			</item>
			<item>
				<title>Re:US.zip and uniquely identify a city?</title>
				<description><![CDATA[ Hi Romaine

City names are not unique, both are valid cities. Why do you discard the county information?

Best

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1323.page#5572</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1323.page#5572</link>
				<pubDate><![CDATA[Sun, 15 Mar 2009 13:45:44]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>