<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Brazil with more two division"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Brazil with more two division"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Brazil with more two division</title>
				<description><![CDATA[ Brazil has 27 division,

in admin1codes Brazil has 30.

two duplicate state

BR.19  	Pernambuco
BR.30  	Pernambuco
BR.10  	Goias
BR.29  	GoiÃ¡s

i.e with Pernambuco:

i think that the geonameid 3392268 with admin1_code = 30 is incorrect,
the correct admin1_code is 19. because your cities is refence from 19 e not 30.

debtor for the attention

Nei]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/550.page#2553</guid>
				<link>http://forum.geonames.org/gforum/posts/list/550.page#2553</link>
				<pubDate><![CDATA[Thu, 2 Aug 2007 21:00:04]]> GMT</pubDate>
				<author><![CDATA[ nrauni]]></author>
			</item>
			<item>
				<title>Re:Brazil with more two division</title>
				<description><![CDATA[ to catch the results i need to make 2 updates

//original 30
UPDATE `geoname` SET `admin1_code` = '19' WHERE `geoname`.`geonameid` =3392268 LIMIT 1 ;


//original 29
UPDATE `geoname` SET `admin1_code` = '10' WHERE `geoname`.`geonameid` =3462372 LIMIT 1 ;



]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/550.page#2554</guid>
				<link>http://forum.geonames.org/gforum/posts/list/550.page#2554</link>
				<pubDate><![CDATA[Thu, 2 Aug 2007 21:25:13]]> GMT</pubDate>
				<author><![CDATA[ nrauni]]></author>
			</item>
			<item>
				<title>Re:Brazil with more two division</title>
				<description><![CDATA[ Hi Nei

The file admin1codes .txt also includes obsolete names. Some users have asked for this information.
You can join the table with the main geoname table with the where clause featurecode = 'ADM1' to get the current admincodes.

Cheers

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/550.page#2562</guid>
				<link>http://forum.geonames.org/gforum/posts/list/550.page#2562</link>
				<pubDate><![CDATA[Fri, 3 Aug 2007 07:53:30]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>