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.41k stars 395 forks source link

Update airport Kunming Wujiaba (KMG/KMGX) #942

Open jpatokal opened 5 years ago

jpatokal commented 5 years ago

New airport edit suggestion submitted by catherine:

Array ( [apid] => [name] => Kunming Wujiaba [city] => Kunming [country] => China [iata] => KMG [icao] => KMGX [x] => 102.744 [y] => 24.995 [elevation] => 1 [timezone] => 8 [dst] => N ) ;

Existing, potentially conflicting airport information:

Array
(
    [name] => Kunming Changshui International Airport
    [city] => Kunming
    [country] => China
    [iata] => KMG
    [icao] => ZPPP
    [x] => 102.9291667
    [y] => 25.1019444
    [elevation] => 6903
    [apid] => 3382
    [uid] => 
    [timezone] => 8
    [dst] => N
    [tz_id] => Asia/Shanghai
    [type] => airport
    [source] => OurAirports
)

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

donshamal commented 5 years ago

To confirm, this will ensure the historic airport is retained on the database? This would be sensible.

In general, what is the approach in the database, when an airport closes and loses both its iata and icao codes?