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;