<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Cities Extraction from data dump."]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Cities Extraction from data dump."]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Cities Extraction from data dump.</title>
				<description><![CDATA[ I am trying to extract just the cities from the data dump.

Does anyone know which admin codes I should be using.

Currently on column 7, i am looking for "P",

and Column 8 Is where I get confused. Do i use PPL PPLL? or both..
Or is what im doing completely wrong and there is something else available?

It is working, but it is including some historical city names, and quite few that dont make sense.
]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1249.page#5352</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1249.page#5352</link>
				<pubDate><![CDATA[Thu, 5 Feb 2009 07:29:40]]> GMT</pubDate>
				<author><![CDATA[ pcottrell81]]></author>
			</item>
			<item>
				<title>Re:Cities Extraction from data dump.</title>
				<description><![CDATA[ hi

i used this : 

P_PPL, P_PPLA, P_PPLC, P_PPLG, P_PPLL, P_PPLR, P_PPLS, P_STLMT, P_PPLQ, P_PPLW;

i choose to not include historical cities.

http://www.gisgraphy.com/xref/com/gisgraphy/helper/FeatureClassCodeHelper.html#38]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1249.page#5356</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1249.page#5356</link>
				<pubDate><![CDATA[Thu, 5 Feb 2009 13:32:31]]> GMT</pubDate>
				<author><![CDATA[ david masclet]]></author>
			</item>
			<item>
				<title>Re:Cities Extraction from data dump.</title>
				<description><![CDATA[ Well last time I heard there were 20K max cities in the united states, and there about 43k including towns and municipalities.

After importing about 25 mb's of the 300mb'ish file i am sitting at about 10,000 unique records.

Column 8 i am just looking for "PPL" and making sure the label of the field doesnt include '(historical)' 

Any insight would be greatly appreciated.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1249.page#5361</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1249.page#5361</link>
				<pubDate><![CDATA[Fri, 6 Feb 2009 06:50:44]]> GMT</pubDate>
				<author><![CDATA[ pcottrell81]]></author>
			</item>
	</channel>
</rss>