GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
Brazil with more two division  XML
Forum Index -> General
Author Message
[Post New]02/08/2007 21:00:04
    Subject: Brazil with more two division
[Up]
nrauni



Joined: 12/07/2007 15:45:50
Messages: 13
Offline
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
Nei Rauni Santos
[Email] [Yahoo!] [MSN]
[Post New]02/08/2007 21:25:13
    Subject: Re:Brazil with more two division
[Up]
nrauni



Joined: 12/07/2007 15:45:50
Messages: 13
Offline
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 ;



Nei Rauni Santos
[Email] [Yahoo!] [MSN]
[Post New]03/08/2007 07:53:30
    Subject: Re:Brazil with more two division
[Up]
marc



Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
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
[WWW]
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team