<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Query limitations - Airport"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Query limitations - Airport"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Query limitations - Airport</title>
				<description><![CDATA[ Although I could download all the files, import them into a relational database, link up FKs to PKs, and extract the data I need, I tried using the webservice to return airport data based on IATA codes.

Here's my query:

http://ws.geonames.org/search?fcode=AIRP&formatted=tr&lang=iata&style=full

I got the following totalResultsCount:
<totalResultsCount>23148</totalResultsCount> 

... though the data is limited to 2548 XML elements, roughly ~100 results.  I assume this is because of a result set limitation I cannot find.  

The data returned to me in this query is perfect for my purposes, but incomplete.  Can someone help me understand what can / cant be done or how I could page through the dataset with multiple requests?  Any help would be appreciated.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1283.page#5451</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1283.page#5451</link>
				<pubDate><![CDATA[Thu, 19 Feb 2009 02:17:21]]> GMT</pubDate>
				<author><![CDATA[ AFKYBD]]></author>
			</item>
			<item>
				<title>Re:Query limitations - Airport</title>
				<description><![CDATA[ I found a forum post for paging (http://forum.geonames.org/gforum/posts/list/582.page) 
and using maxRows=1000 [the maximum at a time]

The idea was that I'd have 24 files to merge, and that would be ok... 

now I am getting the error message:
  <?xml version="1.0" encoding="UTF-8" standalone="no" ?> 
- <geonames>
  <status message="requested startRow too big" value="12" /> 
  </geonames>

startRow was 5001.  Can a request to run a big query be granted on request for a certain user?  If not, I guess IU'll have to download all the data and modify it to separate it into logical, individual tables with a different schema.  

Don't get me wrong, this service is great... but I feel like I need to do everything to get a tiny piece of the project.  I'm sure your bandwidth is pretty high already.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1283.page#5453</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1283.page#5453</link>
				<pubDate><![CDATA[Thu, 19 Feb 2009 04:16:08]]> GMT</pubDate>
				<author><![CDATA[ AFKYBD]]></author>
			</item>
			<item>
				<title>Re:Query limitations - Airport</title>
				<description><![CDATA[ You will have to download the dump files.

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1283.page#5454</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1283.page#5454</link>
				<pubDate><![CDATA[Thu, 19 Feb 2009 06:29:33]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:Query limitations - Airport</title>
				<description><![CDATA[ Thanks for the response.  I have already started down the full import route.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1283.page#5456</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1283.page#5456</link>
				<pubDate><![CDATA[Thu, 19 Feb 2009 07:20:38]]> GMT</pubDate>
				<author><![CDATA[ AFKYBD]]></author>
			</item>
	</channel>
</rss>