Add geoNameId

[dejurin]

http://www.geonames.org/6300952/kyiv-boryspil-international-airport.html

Are you considering adding a geoNameId?
If so, I could bind the database CSV, and you could add the API.

Sometimes need to bind to an identifier.

[mborsetti]

Hi Yurii,

Thanks. I was not familiar with GeoNames so had to do a bit of research.

If I understand it correctly, you would like to add geoNameId to all the entries to the database? And I would build a Python API to call the Geonames API and return additional information?

Yeah, sounds extremely interesting!! 👍 🙏

P.S. hope to push a new release with all your UA changes within 24 hours.

[dejurin]

If I understand it correctly, you would like to add geoNameId to all the entries to the database? And I would build a Python API to call the Geonames API and return additional information?

Yes it is.

Geonames - is a fairly popular database of geographic objects. I use it in my projects. But since your database has more detailed information about airports, I combined your data. And there is still a problem: the names of airports are not accurate (this is a normal situation), so it would be great to specify the identifier.

[mborsetti]

If I understand it correctly, you would like to add geoNameId to all the entries to the database? And I would build a Python API to call the Geonames API and return additional information?

Yes it is.

Awesome! That would be a wonderful contribution, thanks!!

[samj]

Related to this would be the name and/or ID for the associated/serviced city (e.g. "Paris" in "Ile-de-France" for CDG and ORY which is already the case, but also BVA which is considered a Paris airport but is listed as Beauvais/Tille in Hauts-de-France).

I'm trying to use your database for popular travel cities as well, but I'm finding the city is sometimes missing even where there's an airport with an iata code:
"YGEL","GET","Geraldton Airport","","Western Australia","AU",121,-28.7961006165,114.7070007324,"Australia/Perth",""

I set up a unique constraint on my database spanning city, subd, and country too, but found I had duplicated Berlin at least (TXL should be in Berlin, which is in Brandenburg like BER as I understand it)... I suspect there's more like this:

"EDDT","TXL","Berlin-Tegel International Airport","Berlin","Berlin","DE",122,52.5597000122,13.2876996994,"Europe/Berlin",""
"EDDB","BER","Berlin Brandenburg Airport","Berlin","Brandenburg","DE",156,52.362167,13.500667,"Europe/Berlin",""

Appreciate this is a tangential use case, but there doesn't seem to be a lot that's accessible and Geonames is a bit unwieldy. I suspect the IATA City Code Directory (CCD) could go close to what I need, but it almost certainly won't be compatible with open source licensing.

[mborsetti]

Hi Sam,

Thanks for your comments.

Related to this would be the name and/or ID for the associated/serviced city (e.g. "Paris" in "Ile-de-France" for CDG and ORY which is already the case, but also BVA which is considered a Paris airport but is listed as Beauvais/Tille in Hauts-de-France).

The only standard I know for this is IATA's Multi Airport Cities (used in pricing), which are provided in this repo and documented here. Any other definitions must be custom-made, and personally I don't think BVA to be a Paris airport (i.e. not one I'd book myself to go to Paris), rather a deception, but others, such as the airport authority and the airlines that fly there, do.

I'm trying to use your database for popular travel cities as well, but I'm finding the city is sometimes missing even where there's an airport with an iata code: "YGEL","GET","Geraldton Airport","","Western Australia","AU",121,-28.7961006165,114.7070007324,"Australia/Perth",""

I set up a unique constraint on my database spanning city, subd, and country too, but found I had duplicated Berlin at least (TXL should be in Berlin, which is in Brandenburg like BER as I understand it)... I suspect there's more like this:

"EDDT","TXL","Berlin-Tegel International Airport","Berlin","Berlin","DE",122,52.5597000122,13.2876996994,"Europe/Berlin",""
"EDDB","BER","Berlin Brandenburg Airport","Berlin","Brandenburg","DE",156,52.362167,13.500667,"Europe/Berlin",""

Data quality is always a huge issue, and much has already been made to improve the raw data forked in 2020; all contributions are welcome!

I suspect the IATA City Code Directory (CCD) could go close to what I need, but it almost certainly won't be compatible with open source licensing.

Spot on. IATA's business model is curiously an antithesis to its airline owners' interests, and instead of making this data free and pushing for its adoption everywhere, not only it's not open sourced, but they're charging a whopping USD $1,000 for individual use (and only via their IATA Digital Publications reader) 😂!