Update airport Huanghua (CSX/ZGHA)

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 Huanghua (CSX/ZGHA) #512

Open jpatokal opened 8 years ago

jpatokal commented 8 years ago

New airport edit suggestion submitted by Haibara:

UPDATE airports SET name='Huanghua', city='Changsha', country='China', iata='CSX', icao='ZGHA', x=113.219633, y=28.189158, elevation=217, timezone=8, dst='N' WHERE apid=3371;

Existing, potentially conflicting airport information:

Array
(
    [name] => Huanghua
    [city] => Changcha
    [country] => China
    [iata] => CSX
    [icao] => ZGHA
    [x] => 113.219633
    [y] => 28.189158
    [elevation] => 217
    [apid] => 3371
    [uid] => 
    [timezone] => 8
    [dst] => U
    [tz_id] => Asia/Chongqing
)

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

OurAirports: http://ourairports.com/airports/ZGHA/pilot-info.html
Wikipedia: http://www.google.com/search?q=wikipedia%20ZGHA%20airport&btnI

jpatokal commented 8 years ago

New airport edit suggestion submitted by Haibara:

UPDATE airports SET name='Huanghua', city='Changsha', country='China', iata='CSX', icao='ZGHA', x=113.219633, y=28.189158, elevation=217, timezone=8, dst='U' WHERE apid=3371;

Existing, potentially conflicting airport information:

Array
(
    [name] => Huanghua
    [city] => Changcha
    [country] => China
    [iata] => CSX
    [icao] => ZGHA
    [x] => 113.219633
    [y] => 28.189158
    [elevation] => 217
    [apid] => 3371
    [uid] => 
    [timezone] => 8
    [dst] => U
    [tz_id] => Asia/Chongqing
)

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

OurAirports: http://ourairports.com/airports/ZGHA/pilot-info.html
Wikipedia: http://www.google.com/search?q=wikipedia%20ZGHA%20airport&btnI

jpatokal commented 8 years ago

New airport edit suggestion submitted by Haibara:

UPDATE airports SET name='Huanghua', city='Changsha', country='China', iata='CSX', icao='ZGHA', x=113.219633, y=28.189158, elevation=217, timezone=8, dst='U' WHERE apid=3371;

Existing, potentially conflicting airport information:

Array
(
    [name] => Huanghua
    [city] => Changcha
    [country] => China
    [iata] => CSX
    [icao] => ZGHA
    [x] => 113.219633
    [y] => 28.189158
    [elevation] => 217
    [apid] => 3371
    [uid] => 
    [timezone] => 8
    [dst] => U
    [tz_id] => Asia/Chongqing
)

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

OurAirports: http://ourairports.com/airports/ZGHA/pilot-info.html
Wikipedia: http://www.google.com/search?q=wikipedia%20ZGHA%20airport&btnI

jpatokal commented 8 years ago

New airport edit suggestion submitted by Haibara:

UPDATE airports SET name='Huanghua Intl', city='Changsha', country='China', iata='CSX', icao='ZGHA', x=113.219633, y=28.189158, elevation=217, timezone=8, dst='U' WHERE apid=6953;

Existing, potentially conflicting airport information:

Array
(
    [name] => Huanghua
    [city] => Changcha
    [country] => China
    [iata] => CSX
    [icao] => ZGHA
    [x] => 113.219633
    [y] => 28.189158
    [elevation] => 217
    [apid] => 3371
    [uid] => 
    [timezone] => 8
    [dst] => U
    [tz_id] => Asia/Chongqing
)

Array
(
    [name] => Huanghua Intl
    [city] => Changsha
    [country] => China
    [iata] => HHA
    [icao] => 
    [x] => 113.219633
    [y] => 28.189158
    [elevation] => 217
    [apid] => 6953
    [uid] => 292
    [timezone] => 8
    [dst] => U
    [tz_id] => Asia/Chongqing
)

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

OurAirports: http://ourairports.com/airports/ZGHA/pilot-info.html
Wikipedia: http://www.google.com/search?q=wikipedia%20ZGHA%20airport&btnI

jpatokal commented 8 years ago

New airport edit suggestion submitted by Haibara:

UPDATE airports SET name='Huanghua', city='Changsha', country='China', iata='CSX', icao='ZGHA', x=113.219633, y=28.189158, elevation=217, timezone=8, dst='U' WHERE apid=3371;

Existing, potentially conflicting airport information:

Array
(
    [name] => Huanghua
    [city] => Changcha
    [country] => China
    [iata] => CSX
    [icao] => ZGHA
    [x] => 113.219633
    [y] => 28.189158
    [elevation] => 217
    [apid] => 3371
    [uid] => 
    [timezone] => 8
    [dst] => U
    [tz_id] => Asia/Chongqing
)

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

OurAirports: http://ourairports.com/airports/ZGHA/pilot-info.html
Wikipedia: http://www.google.com/search?q=wikipedia%20ZGHA%20airport&btnI

jpatokal commented 8 years ago

New airport edit suggestion submitted by Haibara:

UPDATE airports SET name='Huanghua', city='Changsha', country='China', iata='CSX', icao='ZGHA', x=113.219633, y=28.189158, elevation=217, timezone=8, dst='U' WHERE apid=3371;

Existing, potentially conflicting airport information:

Array
(
    [name] => Huanghua
    [city] => Changcha
    [country] => China
    [iata] => CSX
    [icao] => ZGHA
    [x] => 113.219633
    [y] => 28.189158
    [elevation] => 217
    [apid] => 3371
    [uid] => 
    [timezone] => 8
    [dst] => U
    [tz_id] => Asia/Chongqing
)

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

OurAirports: http://ourairports.com/airports/ZGHA/pilot-info.html
Wikipedia: http://www.google.com/search?q=wikipedia%20ZGHA%20airport&btnI

jpatokal commented 8 years ago

New airport edit suggestion submitted by Haibara:

UPDATE airports SET name='Huanghua', city='Changsha', country='China', iata='CSX', icao='ZGHA', x=113.219633, y=28.189158, elevation=217, timezone=8, dst='U' WHERE apid=3371;

Existing, potentially conflicting airport information:

Array
(
    [name] => Huanghua
    [city] => Changcha
    [country] => China
    [iata] => CSX
    [icao] => ZGHA
    [x] => 113.219633
    [y] => 28.189158
    [elevation] => 217
    [apid] => 3371
    [uid] => 
    [timezone] => 8
    [dst] => U
    [tz_id] => Asia/Chongqing
)

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

OurAirports: http://ourairports.com/airports/ZGHA/pilot-info.html
Wikipedia: http://www.google.com/search?q=wikipedia%20ZGHA%20airport&btnI

jpatokal commented 8 years ago

New airport edit suggestion submitted by Haibara:

UPDATE airports SET name='Huanghua', city='Changsha', country='China', iata='CSX', icao='ZGHA', x=113.219633, y=28.189158, elevation=217, timezone=8, dst='U' WHERE apid=3371;

Existing, potentially conflicting airport information:

Array
(
    [name] => Huanghua
    [city] => Changcha
    [country] => China
    [iata] => CSX
    [icao] => ZGHA
    [x] => 113.219633
    [y] => 28.189158
    [elevation] => 217
    [apid] => 3371
    [uid] => 
    [timezone] => 8
    [dst] => U
    [tz_id] => Asia/Chongqing
)

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

OurAirports: http://ourairports.com/airports/ZGHA/pilot-info.html
Wikipedia: http://www.google.com/search?q=wikipedia%20ZGHA%20airport&btnI

jpatokal commented 7 years ago

New airport edit suggestion submitted by Haibara:

UPDATE airports SET name='Changsha Huanghua International Airport', city='Changsha', country='China', iata='CSX', icao='ZGHA', x=113.220001221, y=28.189199447599997, elevation=217, timezone=8, dst='U' WHERE apid=3371;

Existing, potentially conflicting airport information:

Array
(
    [name] => Changsha Huanghua International Airport
    [city] => Changcha
    [country] => China
    [iata] => CSX
    [icao] => ZGHA
    [x] => 113.220001221
    [y] => 28.189199447599997
    [elevation] => 217
    [apid] => 3371
    [uid] => 
    [timezone] => 8
    [dst] => U
    [tz_id] => Asia/Shanghai
    [type] => airport
    [source] => OurAirports
)

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

OurAirports: http://ourairports.com/airports/ZGHA/pilot-info.html
Wikipedia: http://www.google.com/search?q=wikipedia%20ZGHA%20airport&btnI