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.39k stars 390 forks source link

Update airport Leigh Creek (LGH/YLEC) #625

Open jpatokal opened 7 years ago

jpatokal commented 7 years ago

New airport edit suggestion submitted by SydneyOperaHouse:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('Leigh Creek', 'Leigh Creek', 'Australia', 'LGH', 'YLEC', 138.425, -30.598, 856, 9.5, 'U', 34299);

Existing, potentially conflicting airport information:

Array
(
    [name] => Leigh Creek
    [city] => Leigh Creek
    [country] => Australia
    [iata] => 
    [icao] => YLEC
    [x] => 138.425833
    [y] => -30.598333
    [elevation] => 856
    [apid] => 8349
    [uid] => 12157
    [timezone] => 9.5
    [dst] => O
    [tz_id] => Australia/Adelaide
)

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

jpatokal commented 7 years ago

New airport edit suggestion submitted by SydneyOperaHouse:

UPDATE airports SET name='Leigh Creek', city='Leigh Creek', country='Australia', iata='LGH', icao=NULL, x=138.425833, y=-30.598333, elevation=856, timezone=9.5, dst='O' WHERE apid=8349;

Existing, potentially conflicting airport information:

Array
(
    [name] => Leigh Creek
    [city] => Leigh Creek
    [country] => Australia
    [iata] => 
    [icao] => YLEC
    [x] => 138.425833
    [y] => -30.598333
    [elevation] => 856
    [apid] => 8349
    [uid] => 12157
    [timezone] => 9.5
    [dst] => O
    [tz_id] => Australia/Adelaide
)

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

jpatokal commented 7 years ago

New airport edit suggestion submitted by SydneyOperaHouse:

UPDATE airports SET name='Leigh Creek', city='Leigh Creek', country='Australia', iata='LGH', icao=NULL, x=138.425833, y=-30.598333, elevation=856, timezone=9.5, dst='O' WHERE apid=8349;

Existing, potentially conflicting airport information:

Array
(
    [name] => Leigh Creek
    [city] => Leigh Creek
    [country] => Australia
    [iata] => 
    [icao] => YLEC
    [x] => 138.425833
    [y] => -30.598333
    [elevation] => 856
    [apid] => 8349
    [uid] => 12157
    [timezone] => 9.5
    [dst] => O
    [tz_id] => Australia/Adelaide
)

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

jpatokal commented 7 years ago

New airport edit suggestion submitted by SydneyOperaHouse:

UPDATE airports SET name='Martins Bay', city='Martins Bay', country='New Zealand', iata=NULL, icao=NULL, x=167.590, y=-44.220, elevation=100, timezone=12, dst='U' WHERE apid=1;

Existing, potentially conflicting airport information:

Array
(
    [name] => Goroka
    [city] => Goroka
    [country] => Papua New Guinea
    [iata] => GKA
    [icao] => AYGA
    [x] => 145.391881
    [y] => -6.081689
    [elevation] => 5282
    [apid] => 1
    [uid] => 
    [timezone] => 10
    [dst] => U
    [tz_id] => Pacific/Port_Moresby
)

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

jpatokal commented 7 years ago

New airport edit suggestion submitted by SydneyOperaHouse:

UPDATE airports SET name='Martins Bay', city='Martins Bay', country='New Zealand', iata=NULL, icao=NULL, x=167.590, y=-44.220, elevation=100, timezone=12, dst='U' WHERE apid=1;

Existing, potentially conflicting airport information:

Array
(
    [name] => Goroka
    [city] => Goroka
    [country] => Papua New Guinea
    [iata] => GKA
    [icao] => AYGA
    [x] => 145.391881
    [y] => -6.081689
    [elevation] => 5282
    [apid] => 1
    [uid] => 
    [timezone] => 10
    [dst] => U
    [tz_id] => Pacific/Port_Moresby
)

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