<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "ISO-3166-2 Administrative Division Code"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/9.page</link>
		<description><![CDATA[Latest messages posted in the topic "ISO-3166-2 Administrative Division Code"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>ISO-3166-2 Administrative Division Code</title>
				<description><![CDATA[ Where can I get (dump file or web service) the ISO-3166-2 Administrative division code for province/state?

As displayed here http://www.geonames.org/CA/administrative-division-canada.html (QC,BC,ON, etc) ISO-3166-2 column

Thank you.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1178.page#5060</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1178.page#5060</link>
				<pubDate><![CDATA[Wed, 10 Dec 2008 19:23:32]]> GMT</pubDate>
				<author><![CDATA[ chetta]]></author>
			</item>
			<item>
				<title>Re:ISO-3166-2 Administrative Division Code</title>
				<description><![CDATA[ Hi

The ISO codes are not yet in the dump. We are working on it.

Best

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1178.page#5102</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1178.page#5102</link>
				<pubDate><![CDATA[Tue, 23 Dec 2008 17:15:59]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:ISO-3166-2 Administrative Division Code</title>
				<description><![CDATA[ Any chance that this might happen some day soon???]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1178.page#6511</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1178.page#6511</link>
				<pubDate><![CDATA[Wed, 14 Oct 2009 20:07:47]]> GMT</pubDate>
				<author><![CDATA[ aaronchi]]></author>
			</item>
			<item>
				<title>Re:ISO-3166-2 Administrative Division Code</title>
				<description><![CDATA[ not in the next weeks. We simply don't have enough resources. Do you want to help?

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1178.page#6522</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1178.page#6522</link>
				<pubDate><![CDATA[Sun, 18 Oct 2009 22:42:59]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:ISO-3166-2 Administrative Division Code</title>
				<description><![CDATA[ I will help if I can. I'm not sure what the issue is. I just want to have another column in the dump that specifies the ISO-3166-2 code if it exists. Maybe it can be put into the admin1CodesASCII.txt or even a new dump file?

What can I do to help?]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1178.page#6539</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1178.page#6539</link>
				<pubDate><![CDATA[Wed, 21 Oct 2009 05:30:08]]> GMT</pubDate>
				<author><![CDATA[ aaronchi]]></author>
			</item>
			<item>
				<title>Re:ISO-3166-2 Administrative Division Code</title>
				<description><![CDATA[ It should be possible to make it 90% there by cross referencing the information in:

http://www.commondatahub.com/live/geography/state_province_region/fips_states_codes

They have a primary key there.
They also maintain an iso code table (with the same pk).

Files are downloadable separately. I'm going to import a dump of their data and hack the two together into one table that has both fips and iso codes and report back.

]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1178.page#6587</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1178.page#6587</link>
				<pubDate><![CDATA[Tue, 3 Nov 2009 05:12:02]]> GMT</pubDate>
				<author><![CDATA[ bundini]]></author>
			</item>
			<item>
				<title>Re:ISO-3166-2 Administrative Division Code</title>
				<description><![CDATA[ So here's the results of what I've done.

If you know some better data sources let me know. I've included a rapidly strewn together script that I used to generate this data. The CDH data referenced can be found online (not sure what the legality of me including it in the file would be).

The attached file contains "results.txt" which has the cross references between country, and administrative region 1 fips code, and administrative region 1 iso code. It's tab delimited so it should be easy to blow apart with your favorite scripting language to generate the sql required. I'd probably just create a nested associative array(PHP)/dictionary(Python) and use them to look up the iso code from the 2 letter country codes / fips codes we already have.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1178.page#6596</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1178.page#6596</link>
				<pubDate><![CDATA[Tue, 3 Nov 2009 08:08:02]]> GMT</pubDate>
				<author><![CDATA[ bundini]]></author>
			</item>
	</channel>
</rss>