GeoNames Forum

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.

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.

You will have to download the dump files.

Marc

Thanks for the response. I have already started down the full import route.