<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "All places within one state (ADM1)"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "All places within one state (ADM1)"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>All places within one state (ADM1)</title>
				<description><![CDATA[ Hi Marc,

How can I query all places within the ADM1 category... (and forget adm2 (counties etc..)

Example.. Give me all the places of the state OHIO...

There is also an adm2 but i am not interested in that..(except the places of course)

Thanks,
Ron Sahertian
]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1639.page#6774</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1639.page#6774</link>
				<pubDate><![CDATA[Mon, 30 Nov 2009 10:08:27]]> GMT</pubDate>
				<author><![CDATA[ sahertian]]></author>
			</item>
			<item>
				<title>Re:All places within one state (ADM1)</title>
				<description><![CDATA[ select * from geoname where admincode1='OH';

If you only want populate places:

select * from geoname where admincode1='OH' and featureClass='P';]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1639.page#6780</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1639.page#6780</link>
				<pubDate><![CDATA[Mon, 30 Nov 2009 20:11:06]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:All places within one state (ADM1)</title>
				<description><![CDATA[ Thanks for your answer Marc!


But, this is sql... can I do that also with xml from geonames.org?

Thanks,
Ron]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1639.page#6790</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1639.page#6790</link>
				<pubDate><![CDATA[Tue, 1 Dec 2009 08:44:30]]> GMT</pubDate>
				<author><![CDATA[ sahertian]]></author>
			</item>
			<item>
				<title>Re:All places within one state (ADM1)</title>
				<description><![CDATA[ Ron

You are writing 'all' places. The xml interface is not meant to get the entire database or huge numbers of records. There are nearly 60000 toponyms in Ohio.
You can get the first of them with the web service:
http://ws.geonames.org/search?q=&maxRows=10&country=US&adminCode1=OH

Documentation:
http://www.geonames.org/export/geonames-search.html

Best

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1639.page#6793</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1639.page#6793</link>
				<pubDate><![CDATA[Wed, 2 Dec 2009 06:50:29]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:All places within one state (ADM1)</title>
				<description><![CDATA[ thanks Marc!]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1639.page#6796</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1639.page#6796</link>
				<pubDate><![CDATA[Wed, 2 Dec 2009 14:17:36]]> GMT</pubDate>
				<author><![CDATA[ sahertian]]></author>
			</item>
	</channel>
</rss>