GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
admin5codes for features that don't have admin5 codes  XML
Forum Index -> General
Author Message
zcw100



Joined: 28/09/2019 15:28:16
Messages: 18
Offline

I mostly get the admincode5 table there are some strange entries in there. There are a few that have codes for geonameid's that dont' have adm5 entries. They mostly seem to be entries that don't go down to adm4. What I'm wondering is why they are even there. Do I need to check that admin4 is empy when joining on the admincode5 table?
zcw100



Joined: 28/09/2019 15:28:16
Messages: 18
Offline

Ok, reply to myself.I figured it out. Like you had mentioned previously just join it in (it just has to be an outer join) and and then do the same thing you do for admin1, 2, 3, and 4.
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team