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

Update airport Teniente Rodolfo Marsh Martin (TNM/SCRM) #463

Open jpatokal opened 8 years ago

jpatokal commented 8 years ago

New airport edit suggestion submitted by JGPH1A:

UPDATE airports SET name='Teniente Rodolfo Marsh Martin', city='King George Island', country='Antarctica', iata='TNM', icao='SCRM', x=-58.986667, y=-62.190833, elevation=147, timezone=12, dst='U' WHERE apid=2661;

Existing, potentially conflicting airport information:

Array
(
    [name] => Teniente Rodolfo Marsh Martin
    [city] => Isla Rey Jorge
    [country] => Antarctica
    [iata] => 
    [icao] => SCRM
    [x] => -58.986667
    [y] => -62.190833
    [elevation] => 147
    [apid] => 2661
    [uid] => 
    [timezone] => 12
    [dst] => U
    [tz_id] => Antarctica/South_Pole
)

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

jpatokal commented 8 years ago

New airport edit suggestion submitted by terencefung:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('Teniente R. Marsh Airport', 'King George Island', 'Antarctica', 'TNM', 'SCRM', -58.986600, -62.190800, 147, -4, 'U', 39053);

Existing, potentially conflicting airport information:

Array
(
    [name] => Teniente Rodolfo Marsh Martin
    [city] => Isla Rey Jorge
    [country] => Antarctica
    [iata] => 
    [icao] => SCRM
    [x] => -58.986667
    [y] => -62.190833
    [elevation] => 147
    [apid] => 2661
    [uid] => 
    [timezone] => 12
    [dst] => U
    [tz_id] => Antarctica/South_Pole
)

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

jpatokal commented 8 years ago

New airport edit suggestion submitted by terencefung:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('King George Island-Teniente R Marsh Airport', 'King George Island', 'Antarctica', 'TNM', 'SCRM', -58.591074, -62.112793, 147, -4, 'U', 39053);

Existing, potentially conflicting airport information:

Array
(
    [name] => Teniente Rodolfo Marsh Martin
    [city] => Isla Rey Jorge
    [country] => Antarctica
    [iata] => 
    [icao] => SCRM
    [x] => -58.986667
    [y] => -62.190833
    [elevation] => 147
    [apid] => 2661
    [uid] => 
    [timezone] => 12
    [dst] => U
    [tz_id] => Antarctica/South_Pole
)

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

jpatokal commented 7 years ago

New airport edit suggestion submitted by zig:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('Teniente R. Marsh Airport', 'King George Island', 'Chile', 'TNM', 'SCRM', -58.986317, -62.191092, 147, -5, 'U', 5506);

Existing, potentially conflicting airport information:

Array
(
    [name] => Teniente Rodolfo Marsh Martin
    [city] => Isla Rey Jorge
    [country] => Antarctica
    [iata] => 
    [icao] => SCRM
    [x] => -58.986667
    [y] => -62.190833
    [elevation] => 147
    [apid] => 2661
    [uid] => 
    [timezone] => 12
    [dst] => U
    [tz_id] => Antarctica/South_Pole
)

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

jpatokal commented 7 years ago

New airport edit suggestion submitted by jacobrosenberg:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('Teniente R. Marsh Airport', 'King George Island', 'Antarctica', 'TNM', 'SCRM', -58.986317, -62.191092, 147, -4, 'N', 41607);

Existing, potentially conflicting airport information:

Array
(
    [name] => Teniente Rodolfo Marsh Martin
    [city] => Isla Rey Jorge
    [country] => Antarctica
    [iata] => 
    [icao] => SCRM
    [x] => -58.986667
    [y] => -62.190833
    [elevation] => 147
    [apid] => 2661
    [uid] => 
    [timezone] => 12
    [dst] => U
    [tz_id] => Antarctica/South_Pole
)

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

jpatokal commented 6 years ago

New airport edit suggestion submitted by Kollyann:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('Teniente R Marsh Martin', 'Isla Rey Jorge', 'Antarctica', 'TNM', 'SCRM', -58.98626, -62.19106, 147, -4, 'U', 45689);

Existing, potentially conflicting airport information:

Array
(
    [name] => Teniente Rodolfo Marsh Martin Base
    [city] => Isla Rey Jorge
    [country] => Antarctica
    [iata] => 
    [icao] => SCRM
    [x] => -58.9866981506
    [y] => -62.1907997131
    [elevation] => 147
    [apid] => 2661
    [uid] => 
    [timezone] => 12
    [dst] => U
    [tz_id] => Antarctica/South_Pole
    [type] => airport
    [source] => OurAirports
)

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

jpatokal commented 6 years ago

New airport edit suggestion submitted by kwloo:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('Teniente R. Marsh Martin', 'King George Island', 'Antarctica', 'TNM', 'SCRM', -58.985989, -62.191151, 147, -3, 'U', 19923);

Existing, potentially conflicting airport information:

Array
(
    [name] => Teniente Rodolfo Marsh Martin Base
    [city] => Isla Rey Jorge
    [country] => Antarctica
    [iata] => 
    [icao] => SCRM
    [x] => -58.9866981506
    [y] => -62.1907997131
    [elevation] => 147
    [apid] => 2661
    [uid] => 
    [timezone] => 12
    [dst] => U
    [tz_id] => Antarctica/South_Pole
    [type] => airport
    [source] => OurAirports
)

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

jpatokal commented 6 years ago

New airport edit suggestion submitted by TravelerJase:

UPDATE airports SET name='Teniente Rodolfo Marsh Martin Base', city='Isla Rey Jorge', country='Antarctica', iata='TNM', icao='SCRM', x=-58.9866981506, y=-62.1907997131, elevation=147, timezone=12, dst='U' WHERE apid=2661;

Existing, potentially conflicting airport information:

Array
(
    [name] => Teniente Rodolfo Marsh Martin Base
    [city] => Isla Rey Jorge
    [country] => Antarctica
    [iata] => 
    [icao] => SCRM
    [x] => -58.9866981506
    [y] => -62.1907997131
    [elevation] => 147
    [apid] => 2661
    [uid] => 
    [timezone] => 12
    [dst] => U
    [tz_id] => Antarctica/South_Pole
    [type] => airport
    [source] => OurAirports
)

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

jpatokal commented 5 years ago

New airport edit suggestion submitted by thedane:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('Teniente R. Marsh Airport', 'King George Island', 'Antarctica', 'TNM', 'SCRM', -58.986111111111114, -62.191111111111105, 147, -4, 'U', 52193);

Existing, potentially conflicting airport information:

Array
(
    [name] => Teniente Rodolfo Marsh Martin Base
    [city] => Isla Rey Jorge
    [country] => Antarctica
    [iata] => 
    [icao] => SCRM
    [x] => -58.9866981506
    [y] => -62.1907997131
    [elevation] => 147
    [apid] => 2661
    [uid] => 
    [timezone] => 12
    [dst] => U
    [tz_id] => Antarctica/South_Pole
    [type] => airport
    [source] => OurAirports
)

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

jpatokal commented 1 year ago

New airport edit suggestion submitted by onlymarch:

Array ( [apid] => 2661 [name] => Teniente Rodolfo Marsh Martin Base [city] => King George island [country] => Antarctica [iata] => TNM [icao] => SCRM [x] => -58.9866981506 [y] => -62.1907997131 [elevation] => 147 [timezone] => 12 [dst] => U ) ;

Existing, potentially conflicting airport information:

Array
(
    [name] => Teniente Rodolfo Marsh Martin Base
    [city] => Isla Rey Jorge
    [country] => Antarctica
    [country_code] => 
    [iata] => TNM
    [icao] => SCRM
    [x] => -58.9866981506
    [y] => -62.1907997131
    [elevation] => 147
    [apid] => 2661
    [uid] => 
    [timezone] => 12
    [dst] => U
    [tz_id] => Antarctica/South_Pole
    [type] => airport
    [source] => OurAirports
)

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