GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
'00' in geonames dumps  XML
Forum Index -> FAQ - frequently asked questions
Author Message
presquevu



Joined: 13/06/2012 18:41:24
Messages: 1
Offline

Hiya,

I see that some admin codes have the value "00", I am just wondering if this is at all significant or whether I can treat it as a NULL value?

Code:
 select count(*) from geonames where admin1_code = '00'; 
  count 
 -------
    571
 
 select count(*) from geonames where admin2_code = '00';
  count 
 -------
   5268
 



It's interfering with some algorithms I am writing so would be great to ignore it or understand it better!

Any help gratefully received!


saphir



Joined: 05/06/2010 22:44:39
Messages: 130
Offline

Hi presquevu

As ADM1 code >>
"0" means not attributed, unknown... the creator of the feature omitted or did not know the ADM1.
"00" means general or countrywide... the feature cannot be attributed to a single ADM1.
The feature refers to a region (e.g. Mariana Islands) or a countrywide phenomenon (desert, rain forest...)

As ADM2 code >>
...under an ADM1 it is not meaningful, without ADM1 it is false.
It is not possible to create a single ADM2 as "00".
These "00" were probably introduced from another data base...

Regards
Urs
 
Forum Index -> FAQ - frequently asked questions
Go to:   
Powered by JForum 2.1.5 © JForum Team