<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Alternate names for Airports"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Alternate names for Airports"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Alternate names for Airports</title>
				<description><![CDATA[ Hi*,
 first of all thanks for the great work!

Is there any documentation about sql queries for reproduce webservices output with local dump? (joins, where and so on?)
Is there a way to find alternate names for IATA coded airports?

Thanks again! :) ]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/978.page#4339</guid>
				<link>http://forum.geonames.org/gforum/posts/list/978.page#4339</link>
				<pubDate><![CDATA[Wed, 16 Jul 2008 10:22:16]]> GMT</pubDate>
				<author><![CDATA[ apaella]]></author>
			</item>
			<item>
				<title>Re:Alternate names for Airports</title>
				<description><![CDATA[ The IATA codes for airports are in the alternatename table with a pseudo language code 'iata'.

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/978.page#4374</guid>
				<link>http://forum.geonames.org/gforum/posts/list/978.page#4374</link>
				<pubDate><![CDATA[Sun, 20 Jul 2008 22:35:27]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:Alternate names for Airports</title>
				<description><![CDATA[ Yes I've also stuck over alternate names for airports, in some cases the colloquial name, which everyone uses, isn't the IATA name or the name in the geoname table. For example, Gatwick airport, is simple known as Gatwick or maybe Gatwick airport. No one would use the name London Gatwick except on official documents. Likewise with Stansted airport. But Stansted airport has an entry in the alternate names table as simply "Stansted", while "London/Gatwick Airport" doesn't. So searching for "Gatwick' in the geonames or alternate names tables won't return anything (unless you use 'containing'). Irritating little inconsistency which makes it that much harder to link stuff from other sources, such as hotels databases which just use the colloquial names. ]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/978.page#4419</guid>
				<link>http://forum.geonames.org/gforum/posts/list/978.page#4419</link>
				<pubDate><![CDATA[Sun, 27 Jul 2008 22:52:22]]> GMT</pubDate>
				<author><![CDATA[ John Small]]></author>
			</item>
			<item>
				<title>Re:Alternate names for Airports</title>
				<description><![CDATA[ Hi John

Please feel free to add missing alternate names with the wiki- edit interface: http://www.geonames.org/manual.html

Best

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/978.page#4423</guid>
				<link>http://forum.geonames.org/gforum/posts/list/978.page#4423</link>
				<pubDate><![CDATA[Mon, 28 Jul 2008 07:04:05]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>