<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Administrative divisions' geographic area"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/9.page</link>
		<description><![CDATA[Latest messages posted in the topic "Administrative divisions' geographic area"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Administrative divisions' geographic area</title>
				<description><![CDATA[ Hello,

Is there available a mapping from geonameid to area (in sq km) for the administrative divisions?  I know the country table contains area - I am more interested in areas of things like states, counties, and so on.  My eventual aim is to have average population density for at least countries and adm1/adm2.

Thanks for running a great site.

Best,
Mike
]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1411.page#5892</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1411.page#5892</link>
				<pubDate><![CDATA[Sun, 24 May 2009 02:51:56]]> GMT</pubDate>
				<author><![CDATA[ codepoet]]></author>
			</item>
			<item>
				<title>Re:Administrative divisions' geographic area</title>
				<description><![CDATA[ Mike

For countries it is available in the countryinfo file:
http://download.geonames.org/export/dump/countryInfo.txt

For admin divisions it is not yet available. It would be possible to add it to the admin info files or adding a new column to the main toponym record. The later has the advantage that it would be easy to make the field editable. The disadvantage would be that is requires a change in the table structure (new column) and thus break compatibility of existing load scripts.

Best

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1411.page#5894</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1411.page#5894</link>
				<pubDate><![CDATA[Sun, 24 May 2009 08:46:08]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:Administrative divisions' geographic area</title>
				<description><![CDATA[ Marc, thanks so much for your prompt reply.  I understand the complexity and problems with breaking existing scripts.  If it exists in some text or csv format, could you post a link or otherwise make available this area data so I can download it and import into my database in a custom table?

Best,
Mike]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1411.page#5895</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1411.page#5895</link>
				<pubDate><![CDATA[Sun, 24 May 2009 09:25:43]]> GMT</pubDate>
				<author><![CDATA[ codepoet]]></author>
			</item>
			<item>
				<title>Re:Administrative divisions' geographic area</title>
				<description><![CDATA[ Mike 

I have found something:
download.geonames.org/adm1-area.csv
It is not complete, but maybe helpful nevertheless.

BEst

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1411.page#5943</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1411.page#5943</link>
				<pubDate><![CDATA[Sat, 6 Jun 2009 18:44:16]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:Administrative divisions' geographic area</title>
				<description><![CDATA[ Marc, thanks! This was exactly what I needed.  I have been playing with some shape files so if I generate some area data that isn't in the above CSV I'll post it.
Cheers,
Mike]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1411.page#5965</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1411.page#5965</link>
				<pubDate><![CDATA[Tue, 9 Jun 2009 06:26:02]]> GMT</pubDate>
				<author><![CDATA[ codepoet]]></author>
			</item>
	</channel>
</rss>