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 394 forks source link

Update airport Gara de Nord (BUC/) #914

Open jpatokal opened 5 years ago

jpatokal commented 5 years ago

New airport edit suggestion submitted by nikitology:

UPDATE airports SET name='Gara de Nord', city='Bucharest', country='Romania', iata='BUC', icao=NULL, x=26.0745, y=44.4458, elevation=310, timezone=2, dst='U' WHERE apid=9601;

Existing, potentially conflicting airport information:

Array
(
    [name] => Burketown Airport
    [city] => Burketown
    [country] => Australia
    [iata] => BUC
    [icao] => YBKT
    [x] => 139.53399658203125
    [y] => -17.748600006103516
    [elevation] => 21
    [apid] => 6245
    [uid] => -1
    [timezone] => 10
    [dst] => O
    [tz_id] => Australia/Brisbane
    [type] => airport
    [source] => OurAirports
)

Array
(
    [name] => Gara de Nord
    [city] => Bucharest
    [country] => Romania
    [iata] => 
    [icao] => 
    [x] => 26.0745
    [y] => 44.4458
    [elevation] => 310
    [apid] => 9601
    [uid] => 18121
    [timezone] => 2
    [dst] => U
    [tz_id] => Europe/Bucharest
    [type] => unknown
    [source] => User
)

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

jpatokal commented 5 years ago

New airport edit suggestion submitted by nikitology:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('Gara de Nord', 'Bucuresti', 'Romania', 'BUC', NULL, 26.074208, 44.446367, 90, 2, 'E', 52739);

Existing, potentially conflicting airport information:

Array
(
    [name] => Burketown Airport
    [city] => Burketown
    [country] => Australia
    [iata] => BUC
    [icao] => YBKT
    [x] => 139.53399658203125
    [y] => -17.748600006103516
    [elevation] => 21
    [apid] => 6245
    [uid] => -1
    [timezone] => 10
    [dst] => O
    [tz_id] => Australia/Brisbane
    [type] => airport
    [source] => OurAirports
)

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