search

davidmegginson / ourairports-data

Open-data downloads for OurAirports.com
The Unlicense
279 stars 38 forks source link

A few missing airports that are in IATA #3

Open alexprengere opened 2 years ago

alexprengere commented 2 years ago

Hello! I am currently maintaining OpenTravelData, a data source of travel related points of reference, that aims to be compliant with IATA. We publish mainly two files, one containing all airports, past and present, and another one for airlines. I wrote a script to compare the IATA data from their website. The idea is to extract all valid IATA codes, and see what we are missing. I often double check with OurAirports data to make sure no mistakes are made. This time it looks like those entries are missing from OurAirports:

Note that some of those airports might be obsolete, as sometimes we can find entries that refer to airports that are no longer active.

kontrarie commented 2 years ago

Well, nobody keeps you from adding them to ourairports. Surf to www.ourairports.com, set up your account, and off you go! I checked the Itzehoe one and you seem to have it right, at least for that one.

alexprengere commented 2 years ago

Yes, that is exactly what I did, except I added them to GeoNames (you can check the geonames IDs linked in the original issue). The time to research all airports and add them took me probably way more than 10 hours (this is actually only a subset of the airports I added, I can list more if you are interested). So indeed, when I have a bit more time I could also add those to OurAirports. Also maybe something more automatic could be done so that OurAirports automatically pulls the dumps from GeoNames, as to benefit from the community effort there.

kontrarie commented 2 years ago

Be aware that you're likely to find those aerodromes already present in OurAirports, only the IATA codes will be missing, like as not. Such was certainly the case for Itzehoe, the only one I checked (I only look at aerodromes in Europe).

davidmegginson commented 2 years ago

So far, it seems about 50:50 new airports vs airports already in OA. Thanks for running the query, @alexprengere

I'm working my way through them. I noticed that HSF is not in GeoNames and FlightAware doesn't recognise the code, though it does show up in a search on the IATA website. Do you know anything more about that one?

davidmegginson commented 2 years ago

There is an Indonesian-language Wikipedia article for TBX, but nothing is visible in the satellite imagery at the coordinates supplied.

davidmegginson commented 2 years ago

That's as far as I can manage (see checklist at the top). Let me know if anyone can find info about the remaining airports.

alexprengere commented 2 years ago

Since I did similar research work to fix the issue referenced in OpenTravelData here, I hope you could benefit from that (I linked the GeoNames entries I created for each airport & city there). An issue that could be useful too is that one, where I list the differences with IATA: basically indeed HSF, RSI and ZFL are airports that have not yet opened. Concerning RDL and TBX, here is the relevant extract:

If you are interested, I could write a script that compare OA with IATA, and tell which airports are missing, after filtering the not-yet-opened like HSF, and clearly-closed-but-still-in-IATA like BVF.

Edit: after running the script, I find about 300 entries missing from OA, and if I filter that to only airports with commercial flights scheduled, we are down to about 80

davidmegginson commented 2 years ago

For RDL, there's already an airport at that location with a different name, which Wikipedia supports. Before I rename it to "Bardawil International" and add the IATA code, can you confirm that it's the correct location?

https://ourairports.com/airports/HE36/

For TBX, I can't see any airstrip visible in the satellite imagery at those coordinates.

Thanks again for the help.

kontrarie commented 2 years ago

Hoi David,

Thanks for your trust and confidence, much appreciated!

However I am afraid I am not your intended addressee, seeing that I deliberately limit my sphere of interest to Europe.

Feel free to insist if you want my contribution, but I do not think it would be of great value.

Kindly yours!

Karel

On 2/21/22 17:33, David Megginson wrote:

For RDL, there's already an airport at that location with a different name, which Wikipedia supports. Before I rename it to "Bardawil International" and add the IATA code, can you confirm that it's the correct location?

https://ourairports.com/airports/HE36/

For TBX, I can't see any airstrip visible in the satellite imagery at those coordinates.

Thanks again for the help.

— Reply to this email directly, view it on GitHub https://github.com/davidmegginson/ourairports-data/issues/3#issuecomment-1047103295, or unsubscribe https://github.com/notifications/unsubscribe-auth/AC5HCBXDPHS4QO7SWPCAAKDU4JZN5ANCNFSM5MHD7XPQ. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you commented.Message ID: @.***>

alexprengere commented 2 years ago

For TBX I see the airstrip at that location: 0.98043, 107.56501. This is the location referenced in GeoNames. For RDL, the IATA website assigns RDL airport to Bardawil International, New Ismalia. It looks like Google agrees with GeoNames here. I found other references pointing to the same location (here). It looks like the former airstrip has been reused and renamed.