davidmegginson / ourairports-data

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

Erroneous records #12

Open Fareplay1 opened 2 years ago

Fareplay1 commented 2 years ago

Hi,

I did a cross-check of the database against other sources (Openflights, Google Maps and IATA) and found a few discrepancies. Could you please take a look at this file?

Moreover, the following airports have duplicate IATA entries: RTI PCO MPT LPE LMC IZA DZI ARQ

Thanks for looking into this!

Airports data comparison - OurAirportsGitHubFeedback.csv

davidmegginson commented 2 years ago

Thank you for doing that comparison! I will look into this as soon as possible.

kontrarie commented 2 years ago

@Fareplay1: thanks indeed! I perform similar checks on a regular basis, checking for duplicate iata, icao, local_ref - but only for my self-limited territory of Europe.

@all: a few thoughts about IATA codes. For one, the official source for this information is at https://www.iata.org/en/publications/directories/code-search/ . Further, IATA seem to be in the process of cleaning them up, very many fields had IATA codes assigned without any reason, there never being or having been or having been intended any commercial air transport. QRA was one example, it stood for EBZR Zoersel, a NATO reserve field created in the early Cold War years.

My last point might raise controverse: as some of you may have observed, I have renamed quite a few fields from "XXX airport" to "XXX airfield". I know that especially in North America it is common to call every aviation terrain an "airport", however in other places the term is limited to the big places, where airliners fly. I find support on WP: "An airport is an aerodrome https://en.wikipedia.org/wiki/Aerodrome with extended facilities, mostly for commercial air transport." So I do check for inappropriate use of the "airport" naming, and the presence or not of an IATA code is a strong indicator. Again, limiting myself to my European hunting grounds.

Greetings to all, and keep up the good work!

Karel A.J. ADAMS

On 10/27/22 12:06, Fareplay1 wrote:

Hi,

I did a cross-check of the database against other sources (Openflights, Google Maps and IATA) and found a few discrepancies. Could you please take a look at this file?

Moreover, the following airports have duplicate IATA entries: RTI PCO MPT LPE LMC IZA DZI ARQ

Thanks for looking into this!

Airports data comparison - OurAirportsGitHubFeedback.csv https://github.com/davidmegginson/ourairports-data/files/9879199/Airports.data.comparison.-.OurAirportsGitHubFeedback.csv

— Reply to this email directly, view it on GitHub https://github.com/davidmegginson/ourairports-data/issues/12, or unsubscribe https://github.com/notifications/unsubscribe-auth/AC5HCBVNGBRKSHAMKPX2BQDWFJV57ANCNFSM6AAAAAARP7RQUA. You are receiving this because you are subscribed to this thread.Message ID: @.***>