<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Channel Islands"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/7.page</link>
		<description><![CDATA[Latest messages posted in the topic "Channel Islands"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Channel Islands</title>
				<description><![CDATA[ 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');]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/657.page#2975</guid>
				<link>http://forum.geonames.org/gforum/posts/list/657.page#2975</link>
				<pubDate><![CDATA[Tue, 30 Oct 2007 13:15:15]]> GMT</pubDate>
				<author><![CDATA[ Andreas]]></author>
			</item>
			<item>
				<title>Re:Channel Islands</title>
				<description><![CDATA[ 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.
]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/657.page#2977</guid>
				<link>http://forum.geonames.org/gforum/posts/list/657.page#2977</link>
				<pubDate><![CDATA[Tue, 30 Oct 2007 18:46:41]]> GMT</pubDate>
				<author><![CDATA[ Andreas]]></author>
			</item>
			<item>
				<title>Re:Channel Islands</title>
				<description><![CDATA[ Hi Andreas

Do you think the search service should find them with UK and GB in addition to their own country codes?

Cheers

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/657.page#3020</guid>
				<link>http://forum.geonames.org/gforum/posts/list/657.page#3020</link>
				<pubDate><![CDATA[Mon, 12 Nov 2007 18:53:22]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Channel Islands</title>
				<description><![CDATA[ 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).]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/657.page#3021</guid>
				<link>http://forum.geonames.org/gforum/posts/list/657.page#3021</link>
				<pubDate><![CDATA[Mon, 12 Nov 2007 19:23:14]]> GMT</pubDate>
				<author><![CDATA[ Andreas]]></author>
			</item>
			<item>
				<title>Re:Channel Islands</title>
				<description><![CDATA[ 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]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/657.page#3168</guid>
				<link>http://forum.geonames.org/gforum/posts/list/657.page#3168</link>
				<pubDate><![CDATA[Thu, 27 Dec 2007 09:38:47]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>