GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Channel Islands  XML
Forum Index -> Postal Codes
Author Message
Andreas



Joined: 26/09/2007 13:55:11
Messages: 5
Offline

Guernsey/Jersey/Alderley/Sark all have a country code of 'GB', although they should have GG or JE.

This fixes it:
update geoplz set cc='GG' where cc = 'GB' and admin_name2 in
('Guernsey Channel Islands', 'Channel Islands');
update geoplz set cc='JE' where cc = 'GB' and admin_name2 in
('Jersey Channel Islands');
Andreas



Joined: 26/09/2007 13:55:11
Messages: 5
Offline

Isle of Man is wrong either:

update geoplz set cc='GG' where cc = 'GB' and plz like 'GY%';
update geoplz set cc='JE' where cc = 'GB' and plz like 'JE%';
update geoplz set cc='IM' where cc = 'GB' and plz like 'IM%';
is the shortest fix.
marc



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

Hi Andreas

Do you think the search service should find them with UK and GB in addition to their own country codes?

Cheers

Marc

[WWW]
Andreas



Joined: 26/09/2007 13:55:11
Messages: 5
Offline

For search purposes, this might be a good idea. Same with the Aland Islands, which have a FI adm1 code, as well as an own country_code of AX, or Svalbard (cc=SJ) where Longyearbyen is somewhat Norwegian (while Barentsburg is a little Russian too...)

The ultimate solution would be if geoplz contained geonameid, which would allow a GB plz (which would probably be the view of Royal Mail) point towards a GG town (the geopolitical aspect).
marc



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

Hi Andreas

I have changed the country code for the Channel Islands and improved the search to find the codes for all three languages codes, i. e. the respective Channel Island codes and the two codes 'UK' and 'GB'.

Cheers

Marc

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