GeoNames Home
|
Postal Codes
|
Download / Webservice
|
About
GeoNames Forum
Search
Recent Topics
Back to home page
Register
/
Login
wrong admin1_code for some PCLI records
Forum Index
->
Administrative Divisions
Author
Message
10/03/2008 21:29:26
Subject:
wrong admin1_code for some PCLI records
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 ;
10/03/2008 21:35:54
Subject:
Re:wrong admin1_code for some PCLI records
marc
Joined: 08/12/2005 07:39:47
Messages: 4412
Offline
you are right. I will change it.
Marc
10/03/2008 21:38:36
Subject:
wrong admin1_code for some PCLI records
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:
Select a forum
Forum in English
-------------
General
Administrative Divisions
FAQ - frequently asked questions
Postal Codes
Discussion of GeoNames Toponyms
Forum in other language
-------------
Forum in Deutsch
Powered by
JForum 2.1.5
©
JForum Team
info@geonames.org
GeoNames Home
Postal Codes
Download / Webservice
Forum
About