<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "how to find all cities under a county or postal codes under a city (U.S.)"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "how to find all cities under a county or postal codes under a city (U.S.)"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>how to find all cities under a county or postal codes under a city (U.S.)</title>
				<description><![CDATA[ Hello,

I imported US.txt, cities1000.txt, hierarchy.txt and allCountries.txt (postal codes) to a DB, and I was wondering if there is a way to find all U.S. cities under a county or all postal codes under a city.

I think mostly cities are categorized to ADMD or PPL, so I was able to find relationships with counties or postal code in US.txt / hierarchy.txt / allCountries.txt.

Thank you.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1943.page#7881</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1943.page#7881</link>
				<pubDate><![CDATA[Wed, 9 Jun 2010 04:58:14]]> GMT</pubDate>
				<author><![CDATA[ yhosun]]></author>
			</item>
	</channel>
</rss>