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.38k stars 388 forks source link

Update airport Athen Helenikon Airport (HEW/LGAT) #491

Open jpatokal opened 8 years ago

jpatokal commented 8 years ago

New airport edit suggestion submitted by MB-one:

UPDATE airports SET name='Athen Helenikon Airport', city='Athens', country='Greece', iata='HEW', icao='LGAT', x=23.7261, y=37.8933, elevation=69, timezone=2, dst='E' WHERE apid=6416;

Existing, potentially conflicting airport information:

Array
(
    [name] => Ellinikon International Airport
    [city] => Athens
    [country] => Greece
    [iata] => 
    [icao] => LGAT
    [x] => 23.4346
    [y] => 37.5354
    [elevation] => 68
    [apid] => 3991
    [uid] => 21
    [timezone] => 2
    [dst] => E
    [tz_id] => Europe/Athens
)

Array
(
    [name] => Athen Helenikon Airport
    [city] => Athens
    [country] => Greece
    [iata] => HEW
    [icao] => 
    [x] => 23.7261
    [y] => 37.8933
    [elevation] => 69
    [apid] => 6416
    [uid] => 914
    [timezone] => 2
    [dst] => E
    [tz_id] => Europe/Athens
)

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

jpatokal commented 8 years ago

New airport edit suggestion submitted by MB-one:

UPDATE airports SET name='Ellinikon International Airport', city='Athens', country='Greece', iata='ATH', icao='LGAT', x=23.725677, y=37.8914341, elevation=68, timezone=2, dst='E' WHERE apid=3991;

Existing, potentially conflicting airport information:

Array
(
    [name] => Eleftherios Venizelos Intl
    [city] => Athens
    [country] => Greece
    [iata] => ATH
    [icao] => LGAV
    [x] => 23.944467
    [y] => 37.936358
    [elevation] => 308
    [apid] => 3941
    [uid] => 
    [timezone] => 2
    [dst] => E
    [tz_id] => Europe/Athens
)

Array
(
    [name] => Ellinikon International Airport
    [city] => Athens
    [country] => Greece
    [iata] => 
    [icao] => LGAT
    [x] => 23.4346
    [y] => 37.5354
    [elevation] => 68
    [apid] => 3991
    [uid] => 21
    [timezone] => 2
    [dst] => E
    [tz_id] => Europe/Athens
)

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

jpatokal commented 8 years ago

New airport edit suggestion submitted by andre.scherpenzeel:

UPDATE airports SET name='Ellinikon International Airport', city='Athens', country='Greece', iata=NULL, icao='LGAT', x=23.729444, y=37.898333, elevation=68, timezone=2, dst='E' WHERE apid=3991;

Existing, potentially conflicting airport information:

Array
(
    [name] => Ellinikon International Airport
    [city] => Athens
    [country] => Greece
    [iata] => 
    [icao] => LGAT
    [x] => 23.4346
    [y] => 37.5354
    [elevation] => 68
    [apid] => 3991
    [uid] => 21
    [timezone] => 2
    [dst] => E
    [tz_id] => Europe/Athens
)

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