GeoNames Home | Postal Codes | Download / Webservice | About 

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



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

Hi Marc,

in admin1_codes.txt Palestine has one entry

PS.00 West Bank (general)

I think It should be like this:

PS.GZ Gaza
PS.WE West Bank

I think you can set the admin1_codes of all places with country='PS'
by longitude < 34.6E => GZ else WE

Julian
marc



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

Hi Julian

You are right this is wrong and will be fixed with the next daily dump.

Marc

[WWW]
Julian



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

Hi Marc, thanks for fixing the admin1_codes. Any chance we can get the geonames assigned the right admin1_code?

Here is my SQL for it:

Code:
 update geonames set admin1_code='GZ' 
 where admin1_code='00' and country_code='PS' and longitude < 34.6;
 update geonames set admin1_code='WE'
 where admin1_code='00' and country_code='PS' and longitude >= 34.6;
 
marc



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

Hi Julian

The admincode1 has already been assigned. Check out the latest dump.

Regards

Marc

[WWW]
Julian



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

Hi Marc, thanks yes, what confused me was that the modification dates had not changed.

Julian
marc



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

This is true, for database hacks like this one, the history and daily modification files don't work.

Marc

[WWW]
 
Forum Index -> Administrative Divisions
Go to:   
Powered by JForum 2.1.5 © JForum Team