<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "wrong admin1_code for some PCLI records"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/9.page</link>
		<description><![CDATA[Latest messages posted in the topic "wrong admin1_code for some PCLI records"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>wrong admin1_code for some PCLI records</title>
				<description><![CDATA[ Marc, Hello!


Can you fix 6 PCLI records with corrected admin1_codes?

Most of PCLI records have admin1_code='00', but 

1. 732800  	Republic of Bulgaria
2. 6251999  	Canada
3. 2658434  	Swiss Confederation
4. 3202326  	Republic of Croatia
5. 3175395  	Italian Republic
6. 6254930  	Palestine
7. 6252001  	United States

have different values.

Is it wrong? Yes, i think :)

<b>Please change it for  admin1_code='00'!</b>


Thank,
K.K

p.s. sql code for quick fix

UPDATE geonames SET admin1_code = '00' WHERE geonameid =732800  ;

UPDATE geonames SET admin1_code = '00' WHERE geonameid =2658434  ;

UPDATE geonames SET admin1_code = '00' WHERE geonameid =3202326  ;

UPDATE geonames SET admin1_code = '00' WHERE geonameid =3175395  ;

UPDATE geonames SET admin1_code = '00' WHERE geonameid =6254930  ;

UPDATE geonames SET admin1_code = '00' WHERE geonameid =6252001  ;

UPDATE geonames SET admin1_code = '00' WHERE geonameid =6251999  ;]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/815.page#3676</guid>
				<link>http://forum.geonames.org/gforum/posts/list/815.page#3676</link>
				<pubDate><![CDATA[Mon, 10 Mar 2008 21:29:26]]> GMT</pubDate>
				<author><![CDATA[ Light Lord]]></author>
			</item>
			<item>
				<title>Re:wrong admin1_code for some PCLI records</title>
				<description><![CDATA[ you are right. I will change it.

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/815.page#3677</guid>
				<link>http://forum.geonames.org/gforum/posts/list/815.page#3677</link>
				<pubDate><![CDATA[Mon, 10 Mar 2008 21:35:54]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>wrong admin1_code for some PCLI records</title>
				<description><![CDATA[ thank for quick reply.

Have a good day ;)]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/815.page#3678</guid>
				<link>http://forum.geonames.org/gforum/posts/list/815.page#3678</link>
				<pubDate><![CDATA[Mon, 10 Mar 2008 21:38:36]]> GMT</pubDate>
				<author><![CDATA[ Light Lord]]></author>
			</item>
	</channel>
</rss>