GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Unlinked admin1_codes  XML
Forum Index -> Administrative Divisions
Author Message
Julian



Joined: 26/04/2007 18:25:11
Messages: 40
Location: UK
Offline

Hi, we are importing the database export and finding that there are places with admin1_codes where the admin1_code is not in the admin1_codes table. Can we get this fixed?

I've attached a file of the missing ones.

Julian
 Description mysql dump of country codes and admin1 codes not in admin1_code database. [Disk] Download
 Filesize 4 Kbytes
 Downloaded:  536 time(s)

marc



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

Hi Julian

The empty codes '' mean we don't have information about the admin code. The problem is somehow related to this posting about superseded admin codes :
http://forum.geonames.org/gforum/posts/list/398.page

As as quick fix I could implement a check in the dump procedure to set all not-existant admin codes to the empty code ''. This obviously is not a real fix but rather a workaround. The only thing we can do to try to fix it is use admin boundaries where they are available to determine the admin code.

Marc

[WWW]
Julian



Joined: 26/04/2007 18:25:11
Messages: 40
Location: UK
Offline

Hi Marc,

very closely related - Alan & I are working together , but the posts were not coordinated.

Lets continue this there http://forum.geonames.org/gforum/posts/list/398.page

Julian
 
Forum Index -> Administrative Divisions
Go to:   
Powered by JForum 2.1.5 © JForum Team