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 Berlin Schonefeld Airport (SFX/EDDB) #921

Open jpatokal opened 5 years ago

jpatokal commented 5 years ago

New airport edit suggestion submitted by fredrik98a:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('Berlin Schonefeld Airport', 'Berlin', 'Germany', 'SFX', 'EDDB', 13.520556, 52.378611, 157, 1, 'E', 53088);

Existing, potentially conflicting airport information:

Array
(
    [name] => Berlin-Schönefeld Airport
    [city] => Berlin
    [country] => Germany
    [iata] => SXF
    [icao] => EDDB
    [x] => 13.5225
    [y] => 52.380001
    [elevation] => 157
    [apid] => 337
    [uid] => 
    [timezone] => 1
    [dst] => E
    [tz_id] => Europe/Berlin
    [type] => airport
    [source] => OurAirports
)

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

donshamal commented 5 years ago

The proposed new iata code is incorrect. It's also not clear why the umlaut in Schönefeld has been proposed for removal. Unclear why the co-ordinates are being proposed for change (is this based on the new yet-to-be-opened airport?).