openflights icon indicating copy to clipboard operation
openflights copied to clipboard

Published 20 hours ago • verified publisher icon jpatokal

Faroe Islands corrections

Open MarkTownley opened this issue 4 years ago • 1 comments

  • Missing Helipad: EKHI - Hattarvik Heliport 62.330245, -6.276605 (Same timezone as FAO/EKVG)

  • UTC information for EKFA, EKSR and EKSY is wrong (should be 0)

  • "Frooba Heliport (EKFA), Faroe Islands" should be "Frodba Heliport (EKFA), Faroe Islands" [spelling mistake due to interpretation of non-English character)

MarkTownley avatar Jun 16 '20 14:06 MarkTownley

Hi there, I post here since this is an issue related to the Faroe Islands data.

While the airports data includes airports located in the "Faroe Islands" country, there's no reference to "Faroe Islands" in the countries datafile . Instead the ISO 3166-1 code for this country, FO is present as follows: "Faeroe Islands","FO","FO". This makes the two datasets incompatible if using them in the same database/project (eg. with a foreign key from airports pointing to the countries table).

My suggestion is to unify the airports and country entries in the respective datafiles to either "Faroe Islands" or "Faeroe Islands".

EPMatt avatar Aug 26 '20 13:08 EPMatt