<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic ""Special" Countries missing from geonames table"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic ""Special" Countries missing from geonames table"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>"Special" Countries missing from geonames table</title>
				<description><![CDATA[ Hi,

For example French Polynesia is not present in the geonames table, even though it comes up in the hierarchical query as a country:

http://ws.geonames.org/hierarchy?geonameId=4033247

Same goes for Svalbard and Jan Mayen

http://ws.geonames.org/hierarchy?geonameId=2731990

French Polynesia can also be found in the countries table.

Any ideas why it is not in the main geonames table?

]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/941.page#4199</guid>
				<link>http://forum.geonames.org/gforum/posts/list/941.page#4199</link>
				<pubDate><![CDATA[Fri, 20 Jun 2008 00:00:35]]> GMT</pubDate>
				<author><![CDATA[ giorgio79]]></author>
			</item>
			<item>
				<title>Re:"Special" Countries missing from geonames table</title>
				<description><![CDATA[ Giorgio

French Polynesia and the others ARE present in the database, but not all dependent  countries have the PCLI feature code. See list below

Marc

<span class="genmed"><b>Code:</b></span><br>
		<div style="overflow: auto; width: 100%;">
		<pre>
AN	Netherlands Antilles / Curaçao	NL	PCLIX	?	
AQ	Antarctica	12 countries	ADM1	-	
AS	American Samoa	US	ADMD	ADMD	
AW	Aruba	NL	PCLIX	-	
AX	Åland Islands	FI	ISLS	-	
BL	Saint-Barthélemy	FR	PCLIX	-	Collectivité d'outre-mer
BV	Bouvet Island	NO	PCLD	-	
CK	Cook Islands	NZ	PCLS	ADMD	
FK	Falklands Islands	GB	PCLD	-	
FM	Federated States of Micronesia	US	PCLF	ADM1	
FO	Faroe Islands	DK	ADM1	ADM2	
GF	French Guiana	FR	PCLD	ADM1	département d'outre-mer &#40;DOM&#41;
GG	Guernsey	GB	PCLD	ADM1	
GI	Gibraltar	GB	PCLD	-	
GL	Greenland	DK	PCLD	ADM2	
GP	Guadeloupe	FR	PCLD	ADM1	département d'outre-mer &#40;DOM&#41;
GU 	Guam	US	ISL	ADMD	
HK	Hong Kong	CN	PCLS	ADMD	
HM	Heard and McDonald Islands	AU	PCLD	-	
IM	Isle Of Man	GB	PCLD	&#40;ADM1&#41;	
IO	British Indian Ocean Territory	GB	PCLD	&#40;ADM1&#41;	
JE	Jersey	GB	PCLD	ADM1	
MF	Saint-Martin	FR/NL	PCLIX	ADM2	Collectivité d'outre-mer
MH	Marshall Islands	US	PCLF	ADMD	
MO	Macau	CN	PCLS	ADM1	
MP	Northern Mariana Islands	US	ADMD	ADMD	
MQ	Martinique	FR	PCLD	ADM1	département d'outre-mer &#40;DOM&#41;
MS	Montserrat	GB	PCLD	ADM1	
NU	Niue	NZ	PCLS	-	free association
PF	French Polynesia	FR	PCLD	TERR / ADMD	Collectivité d'outre-mer
PM	Saint Pierre and Miquelon	FR	PCLD	ADM1	Collectivité d'outre-mer
PN	Pitcairn	GB	PCLD		British overseas territory
PR	Puerto Rico	US	PCLD	ADMD	Associated Free State of Puerto Rico
RE	Réunion	FR	PCLD	ADM1	département d'outre-mer &#40;DOM&#41;
SH	Saint Helena	GB	PCLD	PCLD ?	British overseas territory
SJ	Svalbard	NO	TERR	-	
TC	Turks and Caicos	GB	PCLD	-	British overseas territory
TF	French Southern Territories	FR	PCLIX	ADM1	
TK	Tokelau	NZ	PCLD	-	
UM	United States Minor Outlying Islands	US	ADMD	?	
VG	Virgin Islands, British	GB	PCLD	-	British overseas territory
VI	Virgin Islands of the United States	US	ADMD	?	
WF	Wallis and Futuna	FR	PCLD	ADM2	Collectivité d'outre-mer
YT	Mayotte	FR	PCLD	-	Collectivité d'outre-mer

</pre>
		</div>]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/941.page#4210</guid>
				<link>http://forum.geonames.org/gforum/posts/list/941.page#4210</link>
				<pubDate><![CDATA[Sat, 21 Jun 2008 18:09:41]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:"Special" Countries missing from geonames table</title>
				<description><![CDATA[ Thanks Mark!

Yes I saw that, it is just that the hierarchy query does not return a country for them, perhaps for the reason you explained about the feature code :)]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/941.page#4249</guid>
				<link>http://forum.geonames.org/gforum/posts/list/941.page#4249</link>
				<pubDate><![CDATA[Mon, 30 Jun 2008 10:58:27]]> GMT</pubDate>
				<author><![CDATA[ giorgio79]]></author>
			</item>
			<item>
				<title>Re:"Special" Countries missing from geonames table</title>
				<description><![CDATA[ Yes, exactly. The world is not as simple as we have modeled it. It is not always a real tree. From some points of view dependent countries are full countries for others they should be attached to an ancestor country.

See also the thread here:
http://forum.geonames.org/gforum/posts/list/948.page]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/941.page#4251</guid>
				<link>http://forum.geonames.org/gforum/posts/list/941.page#4251</link>
				<pubDate><![CDATA[Mon, 30 Jun 2008 20:48:37]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>