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 Algeciras Heliport (/LEAG) #867

Open jpatokal opened 6 years ago

jpatokal commented 6 years ago

New airport edit suggestion submitted by iceman85:

UPDATE airports SET name='Algeciras Heliport', city='Algeciras', country='Spain', iata=NULL, icao='LEAG', x=-5.441111, y=36.128889, elevation=98, timezone=1, dst='E' WHERE apid=8261;

Existing, potentially conflicting airport information:

Array
(
    [name] => Algeciras Heliport
    [city] => Algeciras
    [country] => Spain
    [iata] => 
    [icao] => 
    [x] => -5.441111
    [y] => 36.128889
    [elevation] => 98
    [apid] => 8261
    [uid] => 5785
    [timezone] => 1
    [dst] => E
    [tz_id] => Europe/Madrid
    [type] => airport
    [source] => User
)

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

jpatokal commented 6 years ago

New airport edit suggestion submitted by iceman85:

UPDATE airports SET name='Algeciras Heliport', city='Algeciras', country='Spain', iata=NULL, icao='LEAG', x=-5.441111, y=36.128889, elevation=98, timezone=1, dst='E' WHERE apid=8261;

Existing, potentially conflicting airport information:

Array
(
    [name] => Algeciras Heliport
    [city] => Algeciras
    [country] => Spain
    [iata] => 
    [icao] => 
    [x] => -5.441111
    [y] => 36.128889
    [elevation] => 98
    [apid] => 8261
    [uid] => 5785
    [timezone] => 1
    [dst] => E
    [tz_id] => Europe/Madrid
    [type] => airport
    [source] => User
)

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

jpatokal commented 6 years ago

New airport edit suggestion submitted by iceman85:

UPDATE airports SET name='Algeciras Heliport', city='Algeciras', country='Spain', iata=NULL, icao='LEAG', x=-5.441111, y=36.128889, elevation=98, timezone=1, dst='E' WHERE apid=8261;

Existing, potentially conflicting airport information:

Array
(
    [name] => Algeciras Heliport
    [city] => Algeciras
    [country] => Spain
    [iata] => 
    [icao] => 
    [x] => -5.441111
    [y] => 36.128889
    [elevation] => 98
    [apid] => 8261
    [uid] => 5785
    [timezone] => 1
    [dst] => E
    [tz_id] => Europe/Madrid
    [type] => airport
    [source] => User
)

Array
(
    [name] => Algeciras Heliport
    [city] => Algeciras
    [country] => Spain
    [iata] => 
    [icao] => LEAG
    [x] => -5.441111
    [y] => 36.128889
    [elevation] => 98
    [apid] => 13677
    [uid] => 51261
    [timezone] => -2
    [dst] => E
    [tz_id] => 
    [type] => 
    [source] => 
)

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

iceman85 commented 6 years ago

Jani, please update the ICAO code for this heliport

jpatokal commented 5 years ago

New airport edit suggestion submitted by schischi:

UPDATE airports SET name='Algeciras Heliport', city='Algeciras', country='Spain', iata='AEI', icao='LEAG', x=-5.441111, y=36.128889, elevation=98, timezone=-2, dst='E' WHERE apid=13677;

Existing, potentially conflicting airport information:

Array
(
    [name] => Algeciras Heliport
    [city] => Algeciras
    [country] => Spain
    [iata] => 
    [icao] => LEAG
    [x] => -5.441111
    [y] => 36.128889
    [elevation] => 98
    [apid] => 13677
    [uid] => 51261
    [timezone] => -2
    [dst] => E
    [tz_id] => 
    [type] => 
    [source] => 
)

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