search

jpatokal / openflights

Website for storing flight information, rendering paths on a zoomable world map and calculating statistics, with plenty of free airline, airport and route data.
http://openflights.org
GNU Affero General Public License v3.0
1.4k stars 393 forks source link

Update airport St Helena Airport (HLE/FHSH) #836

Open jpatokal opened 6 years ago

jpatokal commented 6 years ago

New airport edit suggestion submitted by notnd:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('St Helena Airport', 'St Helena', 'United Kingdom', 'HLE', 'FHSH', 5.3845, 15.5733, 310, 0, 'U', 22051);

Existing, potentially conflicting airport information:

Array
(
    [name] => Saint Helena Airport
    [city] => Longwood
    [country] => United Kingdom
    [iata] => HLE
    [icao] => FHSH
    [x] => -5.645833333333333
    [y] => -15.959166666666667
    [elevation] => 1017
    [apid] => 13180
    [uid] => 45559
    [timezone] => 0
    [dst] => U
    [tz_id] => 
    [type] => 
    [source] => 
)

Cross-check this edit on other sites with compatible licensing:

Guymer commented 6 years ago

Saint Helena Airport actually has its own Wikipedia page: https://en.wikipedia.org/wiki/Saint_Helena_Airport

As well as its own website: http://sthelenaairport.com/

Country should not be "United Kingdom" as it is not in the United Kingdom. The drop-down menu for Country on the airport search page lists "Saint Helena" as a country, which it is (it is actually a territory, but the drop-down menu contains lots of territories so I assume calling the field Country is the mistake rather than the drop-down menu incorrectly containing lots of territories). That is what this airport should be part of. All the other information in the existing block (above) appears fine. The elevation difference between the existing information and the (supposedly) corrected information is just the difference between feet and metres (I believe the database uses feet, so the existing information is correct).

As an aside, it would be great if the data/airports.dat file could be updated as it was last updated on GitHub on "Feb 2, 2017" and doesn't even contain this airport yet.