GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
wrong admin1_code for some PCLI records  XML
Forum Index -> Administrative Divisions
Author Message
Light Lord



Joined: 29/10/2007 23:13:22
Messages: 7
Offline

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

Please change it for admin1_code='00'!


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 ;
marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

you are right. I will change it.

Marc

[WWW]
Light Lord



Joined: 29/10/2007 23:13:22
Messages: 7
Offline

thank for quick reply.

Have a good day
 
Forum Index -> Administrative Divisions
Go to:   
Powered by JForum 2.1.5 © JForum Team