<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "list cities of specific county"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "list cities of specific county"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>list cities of specific county</title>
				<description><![CDATA[ Searching for days these forums and googled but did not find answer, I am doing something for sure wrong.

I found this query to find the counties, Iam using the dump files not the web services:

 #-- Get all counties by state/province ID. Ex: 3844419
 #SELECT g.geonameid AS id, g.name FROM geoname g JOIN hierarchy h ON h.childId = g.geonameid AND h.parentId = ? AND h.type = &quot;ADM&quot; ORDER BY g.name ASC;

and I can go through the hierarchy up to:
Continent &gt; Country &gt; State &gt; County

but I can not get the cities/villages/places etc under specific County.

I found some topic here says that I should use google reverse geo to find the county of the city/village.

Also Fields admin2, admin3, and admin4 are almost empty for all the cities/villages and no relation in the hierarchy table.

So in short how to find the cities/villages inside specific county.

I am building combo boxes like this:

Continent &gt; country &gt; state &gt; county &gt; city/village/place etc

and I am stuck now at:

Continent &gt; country &gt; state &gt; county

Please this is my first question here so be patient with me if I am doing something wrong.

Thanks in advance

]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/5697.page#14161</guid>
				<link>http://forum.geonames.org/gforum/posts/list/5697.page#14161</link>
				<pubDate><![CDATA[Mon, 27 Jan 2014 23:06:23]]> GMT</pubDate>
				<author><![CDATA[ daliaessam]]></author>
			</item>
	</channel>
</rss>