airports.sql

CREATE TABLE IF NOT EXISTS `airports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `coordinates_wkt` varchar(47) NOT NULL,
  `type` varchar(18) DEFAULT NULL,
  `name` varchar(44) DEFAULT NULL,
  `icao_code` varchar(5) DEFAULT NULL,
  `iata_code` varchar(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `airports` (`id`, `coordinates_wkt`, `type`, `name`, `icao_code`, `iata_code`) VALUES
(1, 'POINT (75.95707224036518 30.850359856170176)', 'small', 'Sahnewal', 'VILD', 'LUH'),
(2, 'POINT (75.93305977107549 17.625415183635024)', 'mid', 'Solapur', 'VASL', 'SSE'),
(3, 'POINT (85.3235970368767 23.317724598996193)', 'mid', 'Birsa Munda', 'VERC', 'IXR'),
(4, 'POINT (48.74710654359313 31.343158556075725)', 'mid', 'Ahwaz', 'OIAW', 'AWZ'),
(5, 'POINT (78.21721865463483 26.28548769793701)', 'mid and military', 'Gwalior', 'VIGR', 'GWL'),
(6, 'POINT (42.97109630194003 14.755253441372462)', 'mid', 'Hodeidah Int''l', 'OYHD', 'HOD'),
(7, 'POINT (75.8092915005895 22.72774918757095)', 'mid', 'Devi Ahilyabai Holkar Int''l', 'VAID', 'IDR'),
(8, 'POINT (73.81056749246886 19.966020567280626)', 'mid', 'Gandhinagar', 'VANR', 'ISK'),
(9, 'POINT (76.80172611052417 30.670724894966725)', 'major and military', 'Chandigarh Int''l', 'VICG', 'IXC'),
(10, 'POINT (75.39584329220051 19.867296962108234)', 'mid', 'Aurangabad', 'VAAU', 'IXU'),
(11, 'POINT (72.9878190922305 31.362743548086222)', 'mid and military', 'Faisalabad Int''l', 'OPFA', 'LYP'),
(12, 'POINT (73.3163595376585 54.95764829340594)', 'mid', 'Omsk Tsentralny', 'UNOO', 'OMS'),
(13, 'POINT (82.66715245258652 55.00958471362636)', 'mid', 'Novosibirsk Tolmachev', 'UNNT', 'OVB'),
(14, 'POINT (35.30187285752786 47.873263557902284)', 'mid and military', 'Zaporozhye Int''l', 'UKDE', 'OZH'),
(15, 'POINT (101.44656929844086 0.4646008729985052)', 'mid', 'Simpang Tiga', 'WIBB', 'PKU'),
(16, 'POINT (145.24398029858185 14.171771297121616)', 'mid', 'Rota Int''l', 'PGRO', 'ROP'),
(17, 'POINT (73.40849647643748 61.340167219448126)', 'mid', 'Surgut', 'USRR', 'SGC'),
(18, 'POINT (78.7089578747476 10.76035713065535)', 'mid', 'Tiruchirappalli', 'VOTR', 'TRZ'),
(19, 'POINT (63.027933351918136 25.988794590011004)', 'mid', 'Turbat Int''l', 'OPTU', 'TUK'),
(20, 'POINT (66.94873114809494 30.249043186181034)', 'mid', 'Quetta Int''l', 'OPQT', 'UET'),
(21, 'POINT (60.90070856491495 29.475294195657344)', 'mid', 'Zahedan Int''l', 'OIZH', 'ZAH'),
(22, 'POINT (112.71141861725775 -7.929980028405668)', 'mid and military', 'Abdul Rachman Saleh', 'WARA', 'MLG'),
(23, 'POINT (83.55045321240377 53.3633850813046)', 'mid', 'Barnaul', 'UNBB', 'BAX'),
(24, 'POINT (75.75848284560045 31.43294223977149)', 'military mid', 'Adampur', 'VIAX', ''),
(25, 'POINT (79.45200268765704 28.421808716114356)', 'military', 'Bareilly', 'VIBY', ''),
(26, 'POINT (73.03204983920023 33.56141462788605)', 'small', 'Dhamial', 'OPQS', ''),
(27, 'POINT (127.49591612468085 36.72202277666726)', 'major', 'Cheongju Int''l', 'RKTU', 'CJJ'),
(28, 'POINT (126.81083948122644 35.14000513901977)', 'mid and military', 'Gwangju', 'RKJJ', 'KWJ'),
(29, 'POINT (128.63753769993312 35.89992779690866)', 'mid', 'Daegu Int''l', 'RKTN', 'TAE'),
(30, 'POINT (129.35573104752825 35.59289575271069)', 'mid', 'Ulsan', 'RKPU', 'USN'),
(31, 'POINT (105.17606041916142 -5.242566777131995)', 'mid', 'Radin Inten II', 'WIAT', 'TKG'),
(32, 'POINT (81.73172714621872 25.443522027820965)', 'military', 'Allahabad', 'VIAL', 'IXD'),
(33, 'POINT (61.51225897402009 55.29779194960553)', 'mid', 'Chelyabinsk', 'USCC', 'CEK'),
(34, 'POINT (120.20973331809326 22.950667918346994)', 'military mid', 'Tainan', 'RCNN', 'TNN'),
(35, 'POINT (120.63070354758395 24.26665555671146)', 'military mid', 'Taichung', 'RCMQ', 'RMQ'),
(36, 'POINT (4.433844349628765 51.94913018993815)', 'mid', 'Rotterdam The Hague', 'EHRD', 'RTM'),
(37, 'POINT (39.22544964479734 51.81261712683441)', 'mid', 'Voronezh-Chertovitskoye', 'UUOO', 'VOZ'),
(38, 'POINT (-2.858620657849379 53.336375105442215)', 'major', 'Liverpool John Lennon', 'EGGP', 'LPL'),
(39, 'POINT (83.2235216387465 17.7279577384364)', 'mid', 'Vishakapatnam', 'VEVZ', 'VTZ'),
(40, 'POINT (119.54569134215063 -5.058936894557788)', 'major', 'Sultan Hasanuddin Int''l', 'WAAA', 'UPG'),
(41, 'POINT (-173.96809394415877 -18.586005855065373)', 'mid', 'Vava''u Int''l', 'NFTV', 'VAV'),
(42, 'POINT (-1.71034578407216 55.037084860801954)', 'major', 'Newcastle Int''l', 'EGNT', 'NCL'),
(43, 'POINT (-86.8514685020011 15.74515966591258)', 'mid', 'Goloson Int''l', 'MHLC', 'LCE'),
(44, 'POINT (39.69913595604174 24.54423396056608)', 'major', 'Madinah Int''l', 'OEMA', 'MED'),
(45, 'POINT (-74.02873829848139 45.68322509792671)', 'mid', 'Mirabel Int''l', 'CYMX', 'YMX'),
(46, 'POINT (21.09744639862514 55.971342623535804)', 'mid', 'Palanga Int''l', 'EYPA', 'PLQ'),
(47, 'POINT (75.80101041926682 26.821179810060464)', 'mid', 'Jaipur Int''l', 'VIJP', 'JAI'),
(48, 'POINT (86.17246623637757 22.815414511024233)', 'mid', 'Sonari', 'VEJS', 'IXW'),
(49, 'POINT (29.54492 40.255539500747304)', 'mid', 'Yenisehir', 'LTBR', 'YEI'),
(50, 'POINT (35.29696142683381 36.9852090641795)', 'major', 'Sakirpasa', 'LTAF', 'ADA'),
(51, 'POINT (-152.4856385152345 57.74859210704827)', 'mid', 'Kodiak', 'PADQ', 'ADQ'),
(52, 'POINT (-101.70535277269678 35.218403191939814)', 'major', 'Amarillo Int''l', 'KAMA', 'AMA'),
(53, 'POINT (133.902918 -23.801968)', 'mid', 'Alice Springs', 'YBAS', 'ASP'),
(54, 'POINT (74.80715597198244 31.706822025888847)', 'mid and military', 'Raja Sansi Int''l', 'VIAR', 'ATQ'),
(55, 'POINT (85.81688995444293 20.252665975473413)', 'mid', 'Biju Patnaik', 'VEBS', 'BBI'),
(56, 'POINT (-161.8389869594397 60.77873798340883)', 'mid', 'Bethel', 'PABE', 'BET'),
(57, 'POINT (-73.18092077253607 7.127709154026846)', 'mid', 'Palonegro', 'SKBG', 'BGA'),
(58, 'POINT (-86.75237736154624 33.56186728280577)', 'major', 'Birmingham Int''l', 'KBHM', 'BHM'),
(59, 'POINT (141.47040730309726 -31.998996737463017)', 'mid', 'Broken Hill', 'YBHI', 'BHQ'),
(60, 'POINT (-108.53692938812462 45.803685571527836)', 'major', 'Logan Int''l', 'KBIL', 'BIL'),
(61, 'POINT (-100.75747130371745 46.77510666616138)', 'mid', 'Bismarck Muni.', 'KBIS', 'BIS'),
(62, 'POINT (-101.47875338246688 20.98588712119381)', 'mid', 'Del Bajio Int''l', 'MMLO', 'BJX'),
(63, 'POINT (5.6036825600670035 6.317166892078184)', 'mid', 'Benin', 'DNBE', 'BNI'),
(64, 'POINT (27.51640936629526 42.56708354877019)', 'major', 'Bourgas', 'LBBG', 'BOJ'),
(65, 'POINT (8.7858617703132 53.052287104156015)', 'major', 'Bremen', 'EDDW', 'BRE'),
(66, 'POINT (-69.356102 10.0453)', 'mid', 'Jacinto Lara Int''l', 'SVBM', 'BRM'),
(67, 'POINT (-97.43176534023202 25.906274354534673)', 'mid', 'Brownsville-South Padre Island Int''l', 'KBRO', 'BRO'),
(68, 'POINT (-2.7108646913430845 51.38629341891484)', 'major', 'Bristol Int''l', 'EGGD', 'BRS'),
(69, 'POINT (-91.15675440481048 30.532613804058556)', 'major', 'Baton Rouge Metro', 'KBTR', 'BTR'),
(70, 'POINT (17.19998500222079 48.16983790625349)', 'major', 'Bratislava-M.R. Stefanik', 'LZIB', 'BTS'),
(71, 'POINT (-73.15507877906677 44.469206604073214)', 'mid', 'Burlington Int''l', 'KBTV', 'BTV'),
(72, 'POINT (-81.10933524293772 33.934205458427535)', 'major', 'Columbia Metro', 'KCAE', 'CAE'),
(73, 'POINT (75.95099306305104 11.1395520526064)', 'major', 'Calicut Int''l', 'VOCL', 'CCJ'),
(74, 'POINT (96.82874721442073 -12.185158595329305)', 'mid', 'Cocos (Keeling) Islands', 'YPCC', 'CCK'),
(75, 'POINT (19.914756164166214 39.60675545052586)', 'mid', 'Corfu Int''l (Ioannis Kapodistrias)', 'LGKR', 'CFU'),
(76, 'POINT (125.69045681299836 43.99301147957697)', 'major', 'Changchun Longjia Int''l', 'ZYCC', 'CGQ'),
(77, 'POINT (-80.03693374382624 32.884530156296464)', 'major and military', 'Charleston Int''l', 'KCHS', 'CHS'),
(78, 'POINT (77.03889377226204 11.030141512598268)', 'mid', 'Coimbatore', 'VOCB', 'CJB'),
(79, 'POINT (23.68698126804856 46.78266263402428)', 'mid', 'Someseni', 'LRCL', 'CLJ'),
(80, 'POINT (-77.84510399351666 21.424703728196057)', 'mid', 'Ignacio Agramonte', 'MUCM', 'CMW'),
(81, 'POINT (-106.46444480969178 42.89719004830057)', 'major', 'Casper/Natrona County Int''l', 'KCPR', 'CPR'),
(82, 'POINT (120.55077022391397 15.187642242388833)', 'major', 'Clark Int''l', 'RPLC', 'CRK'),
(83, 'POINT (-81.5964164667526 38.37059143728646)', 'major and military', 'Yeager', 'KCRW', 'CRW'),
(84, 'POINT (15.067460500705343 37.470072800341015)', 'major', 'Catania Fontanarossa', 'LICC', 'CTA'),
(85, 'POINT (-88.3242600415365 18.506434233376005)', 'mid', 'Chetumal Int''l', 'MMCM', 'CTM'),
(86, 'POINT (-3.339568764291176 51.39862209110174)', 'major', 'Cardiff', 'EGFF', 'CWL'),
(87, 'POINT (-79.87946163800297 19.68986539628435)', 'mid', 'Gerrard Smith', 'MWCB', 'CYB'),
(88, 'POINT (-86.93040640704362 20.51155437716472)', 'mid', 'Cozumel Int''l', 'MMCZ', 'CZM'),
(89, 'POINT (-84.22045942381024 39.8990402865362)', 'major', 'James M. Cox Dayton Int''l', 'KDAY', 'DAY'),
(90, 'POINT (148.569717 -32.218681)', 'mid', 'Dubbo', 'YSDU', 'DBO'),
(91, 'POINT (-77.04333739256312 38.853716201212265)', 'major', 'Washington Nat''l', 'KDCA', 'DCA'),
(92, 'POINT (-104.53384602496385 24.12619483261825)', 'mid', 'Durango Int''l', 'MMDO', 'DGO'),
(93, 'POINT (35.09390602249747 48.36757180211169)', 'mid', 'Voloskoye', 'UKDD', 'DNK'),
(94, 'POINT (37.744808557210334 48.06916712855819)', 'major', 'Donetsk', 'UKCC', 'DOK'),
(95, 'POINT (-56.49926362137442 -33.35910844755007)', 'mid', 'Santa Bernardina Int''l', 'SUDU', 'DZO'),
(96, 'POINT (-3.3642846851355452 55.9485540113639)', 'major', 'Edinburgh Int''l', 'EGPH', 'EDI'),
(97, 'POINT (-64.53715143657945 18.444361855798306)', 'mid', 'Terrance B. Lettsome Int''l', 'TUPJ', 'EIS'),
(98, 'POINT (-115.78647923224912 40.82760588152249)', 'mid', 'Elko Reg.', 'KEKO', 'EKO'),
(99, 'POINT (-116.59572440041782 31.797713976056865)', 'mid', 'Ensenada', 'MMES', 'ESE'),
(100, 'POINT (-7.2708 62.0625)', 'mid', 'Vagar', 'EKVG', 'FAE'),
(101, 'POINT (-96.8254561269675 46.919817881132275)', 'mid and military', 'Hector Int''l', 'KFAR', 'FAR'),
(102, 'POINT (-119.72000132357581 36.76981283739594)', 'mid', 'Fresno Yosemite Int''l', 'KFAT', 'FAT'),
(103, 'POINT (-111.6746561716751 35.13891167579759)', 'mid', 'Flagstaff Pulliam', 'KFLG', 'FLG'),
(104, 'POINT (-89.87784042265082 16.914974164222567)', 'mid', 'Mundo Maya Int''l', 'MGTK', 'FRS'),
(105, 'POINT (-96.73138310175408 43.58019349727632)', 'mid', 'Sioux Falls Reg.', 'KFSD', 'FSD'),
(106, 'POINT (-117.53683662858516 47.62547812783678)', 'major', 'Spokane Int''l', 'KGEG', 'GEG'),
(107, 'POINT (-75.87261308530395 23.56388290692585)', 'mid', 'Exuma Int''l', 'MYEF', 'GGT'),
(108, 'POINT (-5.346771800333878 36.15127475041734)', 'mid', 'Gibraltar', 'LXGB', 'GIB'),
(109, 'POINT (-85.52957320727401 42.88477760209079)', 'mid', 'Gerald R. Ford Int''l', 'KGRR', 'GRR'),
(110, 'POINT (-79.93648675774836 36.105378199893245)', 'major', 'Triad Int''l', 'KGSO', 'GSO'),
(111, 'POINT (-111.35668472784 47.482270729263035)', 'mid', 'Great Falls Int''l', 'KGTF', 'GTF'),
(112, 'POINT (37.473803252189995 36.945363344687536)', 'major', 'Gaziantep Oguzeli Int''l', 'LTAJ', 'GZT'),
(113, 'POINT (75.08631556802813 15.359183338622918)', 'mid', 'Hubli', 'VAHB', 'HBX'),
(114, 'POINT (100.39375127467132 6.93634231940664)', 'mid', 'Hat Yai Int''l', 'VTSS', 'HDY'),
(115, 'POINT (117.30419701588772 31.77985767957784)', 'mid', 'Hefei-Luogang', 'ZSOF', 'HFE'),
(116, 'POINT (33.807160641411784 27.18042609181859)', 'major', 'Hurghada Int''l', 'HEGN', 'HRG'),
(117, 'POINT (36.28220107735029 49.92153606315507)', 'major', 'Kharkov Int''l', 'UKHH', 'HRK'),
(118, 'POINT (-86.77494305633734 34.648334460931935)', 'major', 'Huntsville Int''l', 'KHSV', 'HSV'),
(119, 'POINT (3.973813343322902 7.360343972693927)', 'mid', 'Ibadan', 'DNIB', 'IBA'),
(120, 'POINT (-97.4287387683976 37.6529279603903)', 'major', 'Kansas City Int''l', 'KICT', 'ICT'),
(121, 'POINT (-77.91037565604692 34.266784067199566)', 'mid', 'Wilmington Int''l', 'KILM', 'ILM'),
(122, 'POINT (4.494840388199345 8.435376519352406)', 'mid', 'Ilorin Int''l', 'DNIL', 'ILR'),
(123, 'POINT (-93.39800275527939 48.56599308484143)', 'mid', 'Falls Int''l', 'KINL', 'INL'),
(124, 'POINT (-4.063591755871405 57.53950029234238)', 'mid', 'Inverness', 'EGPE', 'INV'),
(125, 'POINT (-115.57199556657955 32.8339586685524)', 'mid', 'Imperial Cty.', 'KIPL', 'IPL'),
(126, 'POINT (74.8423077638915 32.68104288862249)', 'mid', 'Jammu', 'VIJU', 'IXJ'),
(127, 'POINT (78.09113949371941 9.837186278775658)', 'mid', 'Madurai', 'VOMD', 'IXM'),
(128, 'POINT (73.05054918956712 26.26376234583514)', 'major and military', 'Jodhpur', 'VIJO', 'JDH'),
(129, 'POINT (80.0587438885277 23.1845328746465)', 'mid', 'Jabalpur', 'VAJB', 'JLR'),
(130, 'POINT (37.06518960677478 -3.4244449599817792)', 'mid', 'Kilimanjaro Int''l', 'HTKJ', 'JRO'),
(131, 'POINT (7.3252534740743425 10.694619286239067)', 'mid', 'Kaduna', 'DNKA', 'KAD'),
(132, 'POINT (22.47833324826895 -5.9001665622704085)', 'mid', 'Kananga', 'FZUA', 'KGA'),
(133, 'POINT (-1.5925752658236147 6.714606387503645)', 'mid', 'Kumasi', 'DGSI', 'KMS'),
(134, 'POINT (-71.4806025354969 -32.94839176513599)', 'mid', 'Vina del Mar', 'SCVM', 'KNA'),
(135, 'POINT (80.36753387720022 26.43883344670418)', 'mid', 'Kanpur', 'VIKA', 'KNU'),
(136, 'POINT (-156.04088947105768 19.737099139944235)', 'mid', 'Kona Int''l at Keahole', 'PHKO', 'KOA'),
(137, 'POINT (-2.9013784952450767 58.95442887883035)', 'mid', 'Kirkwall', 'EGPA', 'KOI'),
(138, 'POINT (75.85049779445515 25.16341871667427)', 'mid', 'Kota', 'VIKO', 'KTU'),
(139, 'POINT (32.575673266968714 37.98399455316949)', 'major and military', 'Konya', 'LTAN', 'KYA'),
(140, 'POINT (-84.59826819187857 38.03742731813716)', 'major', 'Blue Grass', 'KLEX', 'LEX'),
(141, 'POINT (-159.34908429052206 21.978124316208824)', 'mid', 'Lihue', 'PHLI', 'LIH'),
(142, 'POINT (-92.22058813192886 34.728430041517875)', 'major', 'Little Rock National', 'KLIT', 'LIT'),
(143, 'POINT (-109.08269464526103 25.68850882609902)', 'mid', 'Los Mochis', 'MMLM', 'LMM'),
(144, 'POINT (-101.46496003175058 26.955392716069884)', 'mid', 'Venustiano Carranza Int''l', 'MMMV', 'LOV'),
(145, 'POINT (-99.45566039765133 27.54366571758247)', 'mid', 'Laredo Int''l', 'KLRD', 'LRD'),
(146, 'POINT (-1.2880606883875354 59.87668995989993)', 'mid', 'Sumburgh', 'EGPB', 'LSI'),
(147, 'POINT (35.944240709666296 35.407311459674354)', 'major', 'Bassel Al-Assad Int''l', 'OSLK', 'LTK'),
(148, 'POINT (-0.3762272673974393 51.8802952570969)', 'major', 'London Luton', 'EGGW', 'LTN'),
(149, 'POINT (15.495229 78.246717)', 'mid', 'Svalbard Longyear', 'ENSB', 'LYR'),
(150, 'POINT (-77.91839076357516 18.501154929824885)', 'mid', 'Sangster Int''l', 'MKJS', 'MBJ'),
(151, 'POINT (95.97065359502169 21.705549068027405)', 'mid', 'Mandalay Int''l', 'VYMD', 'MDL'),
(152, 'POINT (-87.74212668856121 41.78834925974092)', 'major', 'Chicago Midway Int''l', 'KMDW', 'MDW'),
(153, 'POINT (-80.68338459957742 -0.9495570021128831)', 'mid and military', 'Eloy Alfaro Int''l', 'SEMT', 'MEC'),
(154, 'POINT (-86.39030746026862 32.304587990963064)', 'major', 'Montgomery Reg.', 'KMGM', 'MGM'),
(155, 'POINT (-71.43752390918567 42.92791399458855)', 'major', 'Manchester-Boston Reg.', 'KMHT', 'MHT'),
(156, 'POINT (13.085139016247085 11.853471318852687)', 'mid', 'Maiduguri Int''l', 'DNMA', 'MIU'),
(157, 'POINT (23.572109198905228 -6.1248454134881145)', 'mid', 'Mbuji Mayi', 'FZWA', 'MJM'),
(158, 'POINT (-101.29138553129988 48.25560492128391)', 'mid', 'Minot Int''l', 'KMOT', 'MOT'),
(159, 'POINT (-114.08369492365063 46.91876047688307)', 'mid', 'Missoula Int''l', 'KMSO', 'MSO'),
(160, 'POINT (-115.24787404784124 32.628564332460684)', 'mid', 'Gen R.S. Taboada Int''l', 'MMML', 'MXL'),
(161, 'POINT (8.712959535024368 45.62744051403809)', 'major', 'Malpensa', 'LIMC', 'MXP'),
(162, 'POINT (167.94339411620473 -29.035159255527493)', 'mid', 'Norfolk Island', 'YSNF', 'NLK'),
(163, 'POINT (11.077417973909556 49.49450521703445)', 'major', 'Nurnberg', 'EDDN', 'NUE'),
(164, 'POINT (30.676830831020588 46.44062687591064)', 'major', 'Odessa Int''l', 'UKOO', 'ODS'),
(165, 'POINT (153.5128762643033 -28.166516854020163)', 'mid', 'Gold Coast', 'YBCG', 'OOL'),
(166, 'POINT (-0.6067969644311196 35.62027473127345)', 'mid', 'Oran Es Senia', 'DAOO', 'ORN'),
(167, 'POINT (85.09090213146632 25.594443429560453)', 'mid', 'Lok Nayak Jaiprakash', 'VEPT', 'PAT'),
(168, 'POINT (-58.0685346825257 -32.36145452927226)', 'mid', 'Paysandu', 'SUPU', 'PDU'),
(169, 'POINT (32.483232206492644 34.71340128173351)', 'major', 'Paphos Int''l', 'LCPH', 'PFO'),
(170, 'POINT (104.69912832676162 -2.899993450059967)', 'mid', 'Sultan Mahmud Badaruddin II', 'WIPP', 'PLM'),
(171, 'POINT (29.45334036456435 -23.858986270165953)', 'mid', 'Polokwane Int''l', 'FAPP', 'PTG'),
(172, 'POINT (-68.3632351074649 18.56303903398704)', 'mid', 'Punta Cana', 'MDPC', 'PUJ'),
(173, 'POINT (-100.18735943002979 20.62246607127796)', 'mid', 'Queretaro Int''l', 'MMQT', 'QRO'),
(174, 'POINT (70.7799548311565 22.309281698836052)', 'mid', 'Rajkot', 'VARK', 'RAJ'),
(175, 'POINT (-77.33311963811302 37.50828997509012)', 'major', 'Richmond Int''l', 'KRIC', 'RIC'),
(176, 'POINT (88.61380457044305 24.44480686230351)', 'mid', 'Shah Makhdum', 'VGRJ', 'RJH'),
(177, 'POINT (-77.66524450621966 43.127551982648235)', 'major', 'Greater Rochester Int''l', 'KROC', 'ROC'),
(178, 'POINT (150.478897 -23.378599)', 'mid', 'Rockhampton', 'YBRK', 'ROK'),
(179, 'POINT (39.80351444453908 47.255111951975394)', 'mid', 'Rostov-on-Don', 'URRR', 'ROV'),
(180, 'POINT (46.03502324989101 51.560645650884204)', 'mid', 'Saratov', 'UWSS', 'RTW'),
(181, 'POINT (-87.92723651254093 15.455863052488276)', 'mid', 'Ramon Villeda Morales Int''l', 'MHLM', 'SAP'),
(182, 'POINT (-119.83660158079981 34.42573129787832)', 'mid', 'Santa Barbara Muni.', 'KSBA', 'SBA'),
(183, 'POINT (-148.457855 70.19751)', 'mid', 'Deadhorse', 'PASC', 'SCC'),
(184, 'POINT (-50.694199 67.018097)', 'mid', 'Kangerlussuaq', 'BGSF', 'SFJ'),
(185, 'POINT (-93.3826379012003 37.24214449030243)', 'major', 'Springfield Reg.', 'KSGF', 'SGF'),
(186, 'POINT (-93.82852222295027 32.45457988665127)', 'major', 'Shreveport Reg.', 'KSHV', 'SHV'),
(187, 'POINT (33.99605292445367 45.020217397816495)', 'major', 'Simferopol Int''l', 'UKFF', 'SIP'),
(188, 'POINT (-135.365692 57.05349)', 'mid', 'Sitka Rocky Gutierrez', 'PASI', 'SIT'),
(189, 'POINT (-109.71785838690921 23.162657448359653)', 'major', 'Los Cabos Int''l', 'MMSD', 'SJD'),
(190, 'POINT (-123.00787147940393 44.91051384521425)', 'major', 'McNary Field', 'KSLE', 'SLE'),
(191, 'POINT (-100.93226054858748 25.54799764199738)', 'mid', 'Plan de Guadalupe', 'MMIO', 'SLW'),
(192, 'POINT (-8.922428855576857 52.693453710253166)', 'major', 'Shannon', 'EINN', 'SNN'),
(193, 'POINT (167.22089491937467 -15.505538737085832)', 'mid', 'Santo Pekoa Int''l', 'NVSS', 'SON'),
(194, 'POINT (110.37855625566573 -6.978734849569817)', 'mid', 'Achmad Yani', 'WARS', 'SRG'),
(195, 'POINT (74.78262436723114 33.98309094316232)', 'military mid', 'Srinagar', 'VISR', 'SXR'),
(196, 'POINT (-92.370003 14.791128133877267)', 'mid', 'Tapachula Int''l', 'MMTP', 'TAP'),
(197, 'POINT (19.246686861887266 42.367933519542824)', 'major', 'Podgorica', 'LYPG', 'TGD'),
(198, 'POINT (-84.34499539848576 30.395557617693783)', 'major', 'Tallahassee Reg.', 'KTLH', 'TLH'),
(199, 'POINT (7.644162303621328 45.19166007346417)', 'major', 'Turin Int''l', 'LIMF', 'TRN'),
(200, 'POINT (112.62589153931525 37.754511779151215)', 'major', 'Taiyuan Wusu Int''l', 'ZBYN', 'TYN'),
(201, 'POINT (-45.41640089231083 61.16259683373283)', 'mid', 'Narsarsuaq', 'BGBW', 'UAK'),
(202, 'POINT (101.00020929048034 12.685293091266386)', 'military mid', 'Rayong', 'VTBU', 'UTP'),
(203, 'POINT (25.846767720882564 -18.099015598368197)', 'mid', 'Victoria Falls', 'FVFA', 'VFA'),
(204, 'POINT (80.7973080000675 16.528642778235014)', 'mid', 'Vijaywada', 'VOBZ', 'VGA'),
(205, 'POINT (82.85387419135274 25.449907732982243)', 'mid', 'Varanasi', 'VIBN', 'VNS'),
(206, 'POINT (-81.43671038506231 23.039542233963147)', 'major', 'Juan Gualberto Gomez', 'MUVR', 'VRA'),
(207, 'POINT (-92.81906758362618 17.993066011311075)', 'mid', 'Villahermosa', 'MMVA', 'VSA'),
(208, 'POINT (-99.94589590024634 49.904727941027694)', 'mid', 'Brandon', 'CYBR', 'YBR'),
(209, 'POINT (-113.47883905449686 53.67491566186677)', 'military major', 'CFB Edmonton', 'CYED', 'YED'),
(210, 'POINT (-68.53672924418116 63.751152353780704)', 'mid', 'Iqaluit', 'CYFB', 'YFB'),
(211, 'POINT (-79.92642309599673 43.16336053050961)', 'mid', 'John C. Munro Hamilton Int''l', 'CYHM', 'YHM'),
(212, 'POINT (-111.22384004661691 56.65631713909619)', 'mid', 'Fort McMurray', 'CYMM', 'YMM'),
(213, 'POINT (121.37204741777312 37.407704472692394)', 'major and military', 'Yantai', 'ZSYT', 'YNT'),
(214, 'POINT (-117.4436632080815 56.231924036744985)', 'mid', 'Peace River', 'CYPE', 'YPE'),
(215, 'POINT (-64.68866968073613 46.11620596392595)', 'mid', 'Greater Moncton Int''l', 'CYQM', 'YQM'),
(216, 'POINT (-60.04693721170264 46.16734058905036)', 'mid', 'Sydney/J.A. Douglas McCurdy', 'CYQY', 'YQY'),
(217, 'POINT (-94.97080232440061 74.71818609875942)', 'mid', 'Resolute Bay', 'CYRB', 'YRB'),
(218, 'POINT (-111.96105993815773 60.01987496024426)', 'mid', 'Fort Smith', 'CYSM', 'YSM'),
(219, 'POINT (-97.860733 55.797482)', 'mid', 'Thompson', 'CYTH', 'YTH'),
(220, 'POINT (-81.372047 48.566158)', 'mid', 'Timmins', 'CYTS', 'YTS'),
(221, 'POINT (-86.25 66.533302)', 'mid', 'Repulse Bay', 'CYUT', 'YUT'),
(222, 'POINT (-68.433342 58.101959)', 'mid', 'Kuujjuaq', 'CYVP', 'YVP'),
(223, 'POINT (-66.873009 52.926071)', 'mid', 'Wabush', 'CYWK', 'YWK'),
(224, 'POINT (-113.52297368858079 53.57094365828116)', 'mid', 'Edmonton City Centre', 'CYXD', 'YXD'),
(225, 'POINT (-120.736439 56.246035)', 'mid', 'Fort St. John (N. Peace)', 'CYXJ', 'YXJ'),
(226, 'POINT (-79.42491 46.358711)', 'mid', 'North Bay/Jack Garland', 'CYYB', 'YYB'),
(227, 'POINT (7.687267643105769 11.135295860107082)', 'mid', 'Zaria', 'DNZA', 'ZAR'),
(228, 'POINT (21.62819718582291 41.95645460815443)', 'mid', 'Skopje', 'LWSK', 'SKP'),
(229, 'POINT (86.97454677657299 23.631217910776442)', 'mid', 'Burnpur', 'VE23', ''),
(230, 'POINT (77.35078887791173 28.70779686010708)', 'mid', 'Hindon Air Force Station', 'VIDX', ''),
(231, 'POINT (125.89082505748561 39.411965971056546)', 'major', 'Sunchon', '', ''),
(232, 'POINT (19.403214874403695 51.727207045169955)', 'mid', 'Lodz Wladyslaw Reymont', 'EPLL', 'LCJ'),
(233, 'POINT (76.87826400966476 43.355419083791865)', 'mid and military', 'Alma Ata N.W.', 'UAAR', 'BXJ'),
(234, 'POINT (130.4562047044068 46.843015022337944)', 'mid', 'Jiamusi Dongjiao', 'ZYJM', 'JMU'),
(235, 'POINT (129.5801515322203 44.53429362999352)', 'major', 'Mudanjiang Hailang', 'ZYMD', 'MDG'),
(236, 'POINT (33.29035276162853 69.0168711826804)', 'military major', 'Severomorsk-3 (Murmansk N.E.)', 'ULMM', ''),
(237, 'POINT (43.145802 36.308601)', 'mid', 'Mosul Int''l', 'ORBM', 'OSB'),
(238, 'POINT (39.635399634366465 47.277420920286694)', 'military mid', 'Rostov N.', '', ''),
(239, 'POINT (39.797221534514875 47.1158577255835)', 'mid', 'Rostov S.W.', '', ''),
(240, 'POINT (25.372837470430696 64.92879923588488)', 'mid', 'Oulu', 'EFOU', 'OUL'),
(241, 'POINT (-0.7017934490752431 44.832110866267385)', 'major', 'Bordeaux', 'LFBD', 'BOD'),
(242, 'POINT (6.954316120289373 43.54609798704497)', 'mid', 'Mandelieu', 'LFMD', 'CEQ'),
(243, 'POINT (0.158653528230218 49.361660998660916)', 'mid', 'St Gatien', 'LFRG', 'DOL'),
(244, 'POINT (3.1059649979981345 50.57164239295806)', 'mid', 'Lille-Lesquin', 'LFQQ', 'LIL'),
(245, 'POINT (1.3735091855115267 43.63046256616009)', 'major', 'Toulouse-Blagnac', 'LFBO', 'TLS'),
(246, 'POINT (130.44418954188373 33.58481643325734)', 'major', 'Fukuoka', 'RJFF', 'FUK'),
(247, 'POINT (132.419372741681 34.37138156288289)', 'mid', 'Hiroshima-Nishi', 'RJBH', 'HIW'),
(248, 'POINT (136.9196283841399 35.254053205286695)', 'mid', 'Nagoya', 'RJNA', 'NKM'),
(249, 'POINT (140.93024738136907 38.138207561528674)', 'mid', 'Sendai', 'RJSS', 'SDJ'),
(250, 'POINT (29.891348950040616 69.72383181136918)', 'mid', 'Kirkenes Hoybuktmoen', 'ENKR', 'KKN'),
(251, 'POINT (-56.120177475472424 -15.651147019195495)', 'mid', 'Marechal Rondon Int''l', 'SBCY', 'CGB'),
(252, 'POINT (-48.544812204959904 -27.664627694163833)', 'major', 'Hercilio Luz Int''l', 'SBFL', 'FLN'),
(253, 'POINT (-48.80164981656161 -26.224294137478456)', 'mid', 'Joinville-Lauro C. de Loyola', 'SBJV', 'JOI'),
(254, 'POINT (-34.9488925911125 -7.146174624020474)', 'mid', 'Presidente Castro Pinto Int''l', 'SBJP', 'JPA'),
(255, 'POINT (-35.24884101653892 -5.899120544771162)', 'major', 'Augusto Severo Int''l', 'SJJQ', 'NAT'),
(256, 'POINT (-8.671272407196472 41.23687089204524)', 'major', 'Francisco Sa Carneiro', 'LPPR', 'OPO'),
(257, 'POINT (-44.236234470049205 -2.5835092104301847)', 'mid', 'Marechal Cunha Machado Int''l', 'SBSL', 'SLZ'),
(258, 'POINT (-46.30527049310029 -23.9237590410637)', 'military mid', 'Santos Air Force Base', 'SBST', 'SSZ'),
(259, 'POINT (-42.82124023178447 -5.06346299167191)', 'mid', 'Teresina-Senador Petronio Portella', 'SBTE', 'THE'),
(260, 'POINT (-47.141079191101426 -23.00962390853391)', 'mid', 'Viracopos-Campinas Int''l', 'SBKP', 'VCP'),
(261, 'POINT (-40.28853687599133 -20.25741627594185)', 'mid', 'Eurico de Aguiar Salles', 'SBVT', 'VIX'),
(262, 'POINT (-0.5572304403635879 38.286640899392886)', 'major', 'Alicante', 'LEAL', 'ALC'),
(263, 'POINT (-2.371601440591205 36.84776727096432)', 'mid', 'Almeria', 'LEAM', 'LEI'),
(264, 'POINT (-0.4734749307716761 39.49145978844889)', 'mid', 'Valencia', 'LEVC', 'VLC'),
(265, 'POINT (20.335152295489802 67.8256066056432)', 'mid', 'Kiruna_Airport', 'ESNQ', 'KRN'),
(266, 'POINT (16.23394076958144 58.583380501754064)', 'major', 'Norrkoping Airport', 'ESSP', 'NRK'),
(267, 'POINT (107.57561185220892 -6.900424083534088)', 'mid', 'Husein Sastranegara Int''l', 'WICC', 'BDO'),
(268, 'POINT (-60.78007872165863 -32.91622697438119)', 'mid', 'Rosario ? Islas Malvinas Int''l', 'SAAR', 'ROS'),
(269, 'POINT (-35.79249512158329 -9.514941185401165)', 'mid', 'Maceio/Zumbi dos Palmares Int''l', 'SBMO', 'MCZ'),
(270, 'POINT (34.39011892672875 27.980404419916844)', 'mid', 'Sharm el-Sheikh Int''l', 'HESH', 'SSH'),
(271, 'POINT (34.775837899677896 29.594499056801894)', 'mid', 'Taba Int''l', 'HETB', 'TCP'),
(272, 'POINT (77.96090917650903 27.157727734749972)', 'major and military', 'Agra', 'VIAG', 'AGR'),
(273, 'POINT (73.2262889533239 22.33616400211708)', 'mid', 'Vadodara', 'VABO', 'BDQ'),
(274, 'POINT (47.156583516563856 34.34641677391081)', 'mid', 'Shahid Ashrafi Esfahani', 'OICC', 'KSH'),
(275, 'POINT (20.268039801851568 32.08727746065531)', 'mid', 'Benina Int''l', 'HLLB', 'BEN'),
(276, 'POINT (50.1477245727844 26.270368085476772)', 'military major', 'King Abdulaziz Ab', 'OEDR', 'DHA'),
(277, 'POINT (-57.98408211764924 -31.437388338779797)', 'mid', 'Nueva Hesperides Int''l', 'SUSO', 'STY'),
(278, 'POINT (63.30735442387505 45.963573940312365)', 'spaceport', 'Baikonur Cosmodrome', '', ''),
(279, 'POINT (-80.6369680911892 28.516370477202706)', 'spaceport', 'Kennedy Space Center', '', ''),
(280, 'POINT (-52.76842968934524 5.239410012580352)', 'spaceport', 'Centre Spatial Guyanais', '', ''),
(281, 'POINT (-70.00762285634964 12.503464363029721)', 'mid', 'Queen Beatrix Int''l', 'TNCA', 'AUA'),
(282, 'POINT (43.149712785995575 11.552101823017216)', 'mid', 'Djibouti-Ambouli Int''l', 'HDAM', 'JIB'),
(283, 'POINT (-70.17863539553298 -20.547840087830867)', 'mid and military', 'Diego Aracena Int''l', 'SCDA', 'IQQ'),
(284, 'POINT (29.309599142388944 40.90430035539573)', 'major', 'Sabiha Gokcen Havaalani', 'LTFJ', 'SAW'),
(285, 'POINT (162.95704122507613 5.352009857182798)', 'mid', 'Kosrae Island', 'PTSA', 'KSA'),
(286, 'POINT (179.19544202302 -8.52485415059424)', 'mid', 'Funafuti Int''l', 'NGFU', 'FUN'),
(287, 'POINT (79.0537976421986 21.089931763008746)', 'mid', 'Dr. Babasaheb Ambedkar Int''l', 'VANP', 'NAG'),
(288, 'POINT (98.30603849005591 8.107684759527347)', 'mid', 'Phuket Int''l', 'VTSP', 'HKT'),
(289, 'POINT (177.45115119805948 -17.752912947979222)', 'mid', 'Nadi Int''l', 'NFFN', 'NAN'),
(290, 'POINT (-102.3140937400579 21.701339032920746)', 'mid', 'Lic. Jesus Teran Peredo Int''l', 'MMAS', 'AGU'),
(291, 'POINT (8.12314535436409 44.04587735981584)', 'mid', 'Albenga', 'LIMG', 'ALL'),
(292, 'POINT (35.989707162192985 31.722662160043214)', 'major', 'Queen Alia Int''l', 'OJAI', 'AMM'),
(293, 'POINT (-70.3357301410959 -18.349206163957913)', 'mid', 'Chacalluta Int''l', 'SCAR', 'ARI'),
(294, 'POINT (-13.05117043233154 20.498270610156464)', 'mid', 'Atar Int''l', 'GQPA', 'ATR'),
(295, 'POINT (-74.77655597826495 10.886677595941366)', 'mid', 'Ernesto Cortissoz Int''l', 'SKBQ', 'BAQ'),
(296, 'POINT (-71.16143008697632 -41.14599769581051)', 'mid', 'Teniente Luis Candelaria Int''l', 'SAZS', 'BRC'),
(297, 'POINT (-5.0689422227531145 7.736104955550318)', 'mid', 'Bouake', 'DIBK', 'BYK'),
(298, 'POINT (-88.30820640330747 17.536068657552093)', 'major', 'Philip S. W. Goldson Int''l', 'MZBZ', 'BZE'),
(299, 'POINT (-97.50226787102976 27.77445607008226)', 'major', 'Corpus Christi Int''l', 'KCRP', 'CRP'),
(300, 'POINT (-68.95687880727611 12.184834605201921)', 'mid', 'Hato Int''l', 'TNCC', 'CUR'),
(301, 'POINT (-71.94366414497216 -13.538218699263911)', 'major', 'Velazco Astete Int''l', 'SPZO', 'CUZ'),
(302, 'POINT (39.207471503916466 -6.866720042491186)', 'mid', 'Julius Nyerere Int''l', 'HTDA', 'DAR'),
(303, 'POINT (-83.00396814177334 42.40909384319068)', 'mid', 'Detroit City', 'KDET', 'DET'),
(304, 'POINT (125.52485420918208 -8.549311574145644)', 'mid', 'Presidente Nicolau Lobato Int''l', 'WPDL', 'DIL'),
(305, 'POINT (37.90025312894517 55.41415282230229)', 'major', 'Moscow Domodedovo Int''l', 'UUDD', 'DME'),
(306, 'POINT (170.200027 -45.923431)', 'mid', 'Dunedin Int''l', 'NZDN', 'DUD'),
(307, 'POINT (45.281786419789874 -12.80494743816432)', 'mid', 'Dzaoudzi Pamanzi Int''l', 'FMCZ', 'DZA'),
(308, 'POINT (-106.39571467936567 31.799086027258937)', 'mid', 'El Paso Int''l', 'KELP', 'ELP'),
(309, 'POINT (44.40006305369384 40.15236794518844)', 'major', 'Zvartnots Int''l', 'UDYZ', 'EVN'),
(310, 'POINT (-97.35513485615866 32.82075290479723)', 'major', 'Fort Worth Meacham Field', 'KFTW', 'FTW'),
(311, 'POINT (-71.14613374488756 21.442123743906283)', 'mid', 'JAGS McCartney Int''l', 'MBGT', 'GDT'),
(312, 'POINT (-94.85540138762639 29.2671239212096)', 'mid', 'Scholes Int''l', 'KGLS', 'GLS'),
(313, 'POINT (29.240053495222842 -1.6583179500206946)', 'mid', 'Goma Int''l', 'FZNA', 'GOM'),
(314, 'POINT (13.372430937787765 9.33068867678854)', 'mid', 'Garoua Int''l', 'FKKR', 'GOU'),
(315, 'POINT (144.8058503570926 13.492646235946513)', 'major', 'Antonio B. Won Pat Int''l', 'PGUM', 'GUM'),
(316, 'POINT (-87.40835962474056 41.617793001516596)', 'mid', 'Gary/Chicago Int''l', 'KGYY', 'GYY'),
(317, 'POINT (43.274561217961576 -11.536639382912684)', 'mid', 'Prince Said Ibrahim Int''l', 'FMCH', 'HAH'),
(318, 'POINT (147.50599619040787 -42.83760836948221)', 'mid', 'Hobart Int''l', 'YMHB', 'HBA'),
(319, 'POINT (160.04585512992452 -9.427575664001457)', 'mid', 'Honiara Int''l', 'AGGH', 'HIR'),
(320, 'POINT (30.445130518210362 50.412808165984956)', 'mid', 'Kiev Zhuliany Int''l', 'UKKK', 'IEV'),
(321, 'POINT (104.35585974800242 52.272889388224414)', 'mid and military', 'Irkutsk S.E.', 'UIII', 'IKT'),
(322, 'POINT (-86.27340036508855 39.730204370396905)', 'major', 'Indianapolis Int''l', 'KIND', 'IND'),
(323, 'POINT (166.91613965881993 -0.5450372268563837)', 'mid', 'Nauru Int''l', 'ANYN', 'INU'),
(324, 'POINT (-109.4300644100096 -27.158773838853794)', 'mid', 'Mataveri Int''l', 'SCIP', 'IPC'),
(325, 'POINT (-65.09376654588122 -24.386101077584634)', 'mid', 'Gob. Horacio Guzman Int''l', 'SASJ', 'JUJ'),
(326, 'POINT (115.91197991860221 28.862489120066552)', 'mid', 'Nanchang Changbei Int''l', 'ZSCN', 'KHN'),
(327, 'POINT (102.74211757882347 24.99999611008102)', 'major', 'Kunming Wujiaba Int''l', 'ZPPP', 'KMG'),
(328, 'POINT (-1.6598310673474594 53.86908194744343)', 'major', 'Leeds Bradford', 'EGNM', 'LBA'),
(329, 'POINT (9.410223378207123 0.4571392295037592)', 'mid', 'Libreville Leon M''ba Int''l', 'FOOL', 'LBV'),
(330, 'POINT (1.25093205640014 6.16687362722297)', 'mid', 'Lome Tokoin', 'DXXX', 'LFW'),
(331, 'POINT (23.946126959894446 49.817850605000466)', 'mid and military', 'Lviv Danylo Halytskyi Int''l', 'UKLL', 'LWO'),
(332, 'POINT (171.28191937064796 7.0681184855709125)', 'mid', 'Marshall Islands Int''l', 'PKMJ', 'MAJ'),
(333, 'POINT (113.57451294861951 22.15765725296336)', 'major', 'Macau Int''l', 'VMMC', 'MFM'),
(334, 'POINT (45.30363741862018 2.016353112149878)', 'mid', 'Aden Adde Int''l', 'HCMM', 'MGQ'),
(335, 'POINT (32.57419151947824 -25.924276711787034)', 'mid', 'Maputo Int''l', 'FQMA', 'MPM'),
(336, 'POINT (57.67698600766355 -20.431756779321564)', 'mid', 'Sir Seewoosagur Ramgoolam Int''l', 'FIMP', 'MRU'),
(337, 'POINT (14.282844434020328 40.87807288436389)', 'major', 'Naples Int''l', 'LIRN', 'NAP'),
(338, 'POINT (-17.03343986915384 20.92905230643873)', 'mid', 'Nouadhibou Int''l', 'GQPP', 'NDB'),
(339, 'POINT (121.46181938848366 29.820823190686056)', 'major', 'Ningbo Lishe Int''l', 'ZSNB', 'NGB'),
(340, 'POINT (-15.95192592522014 18.09792317181745)', 'mid', 'Nouakchott Int''l', 'GQNN', 'NKC'),
(341, 'POINT (166.21723211869872 -22.013638624898107)', 'mid', 'La Tontouta Int''l', 'NWWW', 'NOU'),
(342, 'POINT (-122.21326125786332 37.71230369516912)', 'major', 'Oakland Int''l', 'KOAK', 'OAK'),
(343, 'POINT (-117.5923276516506 34.06019110206596)', 'major', 'Ontario Int''l', 'KONT', 'ONT'),
(344, 'POINT (-8.490141999838173 51.84854054199235)', 'major', 'Cork', 'EICK', 'ORK'),
(345, 'POINT (100.28545585179133 -0.7860457140262733)', 'mid', 'Minangkabau Int''l', 'WIMG', 'PDG'),
(346, 'POINT (-25.696988219871116 37.743331647293275)', 'mid', 'Joao Paulo II', 'LPPD', 'PDL'),
(347, 'POINT (71.51881499126668 33.99140278895964)', 'mid', 'Bacha Khan Int''l', 'OPPS', 'PEW'),
(348, 'POINT (-4.610971639010682 55.50889181051421)', 'mid', 'Glasgow Prestwick', 'EGPK', 'PIK'),
(349, 'POINT (-55.70607937485728 -22.551786560876014)', 'mid', 'Ponta Pora Int''l', 'SBPP', 'PMG'),
(350, 'POINT (175.62128328195985 -40.32331788520548)', 'mid', 'Palmerston N. Int''l', 'NZPM', 'PMR'),
(351, 'POINT (158.2033044909644 6.981306765121233)', 'mid', 'Pohnpei Int''l', 'PTPN', 'PNI'),
(352, 'POINT (-149.60975793242872 -17.55945776599425)', 'mid', 'Tahiti Faa''a Int''l', 'NTAA', 'PPT'),
(353, 'POINT (10.400134371805603 43.69832241576641)', 'major and military', 'Pisa Galileo Galilei Int''l', 'LIRP', 'PSA'),
(354, 'POINT (37.216065757541976 19.576063653196776)', 'mid and military', 'Port Sudan', 'HSSP', 'PZU'),
(355, 'POINT (-23.486201988358683 14.944988935283243)', 'mid', 'Praia Int''l', 'GVNP', 'RAI'),
(356, 'POINT (-8.024605359079887 31.60229465977643)', 'mid', 'Marrakech-Menara', 'GMMX', 'RAK'),
(357, 'POINT (-159.7981563083873 -21.20098217246316)', 'mid', 'Rarotonga Int''l', 'NCRG', 'RAR'),
(358, 'POINT (103.81578052811155 13.408796969353801)', 'major', 'Siem Reap Int''l', 'VDSR', 'REP'),
(359, 'POINT (-67.75302684626753 -53.7814746058316)', 'mid', 'Hermes Quijada Int''l', 'SAWE', 'RGA'),
(360, 'POINT (-69.30647117767309 -51.61169808554019)', 'mid', 'Piloto Civil Norberto Fernandez Int''l', 'SAWG', 'RGL'),
(361, 'POINT (-119.77528330810486 39.505849901470334)', 'major', 'Reno-Tahoe Int''l', 'KRNO', 'RNO'),
(362, 'POINT (134.5329534661587 7.364495536129204)', 'mid', 'Roman Tmetuchl Int''l', 'PTRO', 'ROR'),
(363, 'POINT (-22.9440574079648 16.734793269338514)', 'mid', 'Amilcar Cabral Int''l', 'GVAC', 'SID'),
(364, 'POINT (18.336618545712724 43.825887224679725)', 'major', 'Sarajevo', 'LQSA', 'SJJ'),
(365, 'POINT (-62.714212504731584 17.311125840442042)', 'mid', 'Robert L. Bradshaw Int''l', 'TKPK', 'SKB'),
(366, 'POINT (-65.47847604377958 -24.84437427133154)', 'mid', 'Mart?n Miguel de G?emes Int', 'SASA', 'SLA'),
(367, 'POINT (145.7236946586376 15.121516719766413)', 'mid', 'Saipan Int''l', 'PGSN', 'SPN'),
(368, 'POINT (-65.29286313878465 -19.01391579246574)', 'mid', 'Juana Azurduy de Padilla Int''l', 'SLSU', 'SRE'),
(369, 'POINT (-63.1122760858602 18.042244021474033)', 'major', 'Princess Juliana Int''l', 'TNCM', 'SXM'),
(370, 'POINT (44.134782731062046 13.685497002557412)', 'mid', 'Ta''izz Int''l', 'OYTZ', 'TAI'),
(371, 'POINT (120.3806859490605 36.267757808103866)', 'mid', 'Qingdao Liuting Int''l', 'ZSQD', 'TAO'),
(372, 'POINT (151.84204603740326 7.457617802884429)', 'mid', 'Chuuk Int''l', 'PTKK', 'TKK'),
(373, 'POINT (-5.912880876559137 35.725765640927385)', 'mid', 'Tangier Ibn Battouta', 'GMTT', 'TNG'),
(374, 'POINT (173.14599079530137 1.3806686975383045)', 'mid', 'Bonriki Int''l', 'NGTA', 'TRW'),
(375, 'POINT (71.46094413999357 51.0269352907712)', 'major', 'Astana Int''l', 'UACC', 'TSE'),
(376, 'POINT (117.35272315991853 39.12946099090075)', 'major', 'Tianjin Binhai Int''l', 'ZBTJ', 'TSN'),
(377, 'POINT (146.77067890477002 -19.256181437621244)', 'major and military', 'Townsville', 'YBTL', 'TSV'),
(378, 'POINT (-65.10812462362482 -26.835731005071423)', 'mid', 'Teniente Gen. Benjamin Matienzo Int''l', 'SANT', 'TUC'),
(379, 'POINT (10.21769924471112 36.84744821772193)', 'major', 'Aeroport Tunis', 'DTTA', 'TUN'),
(380, 'POINT (-110.93771323213196 32.12035234418979)', 'major', 'Tucson Int''l', 'KTUS', 'TUS'),
(381, 'POINT (106.76287399492858 47.852526096668434)', 'mid', 'Chinggis Khaan Int''l', 'ZMUB', 'ULN'),
(382, 'POINT (87.46712984878084 43.898338219365286)', 'major', 'Urumqi Diwopu Int''l', 'ZWWW', 'URC'),
(383, 'POINT (168.3196227396616 -17.701699068178094)', 'mid', 'Bauerfield Int''l', 'NVVV', 'VLI'),
(384, 'POINT (143.66910229969758 -3.5802268944474442)', 'mid', 'Wewak Int''l', 'AYWK', 'WWK'),
(385, 'POINT (4.19111982574289 48.78039461385664)', 'military mid', 'Chalons Vatry', 'LFOK', 'XCR'),
(386, 'POINT (118.12696884672026 24.537192570557004)', 'major', 'Xiamen Gaoqi Int''l', 'ZSAM', 'XMN'),
(387, 'POINT (138.08643028361917 9.497917333613481)', 'mid', 'Yap Int''l', 'PTYA', 'YAP'),
(388, 'POINT (-104.56009520009748 19.148086028585354)', 'mid', 'Playa de Oro Int''l', 'MMZO', 'ZLO'),
(389, 'POINT (-52.363806857235694 4.821267143089237)', 'mid', 'Cayenne ? Rochambeau', 'SOCA', 'CAY'),
(390, 'POINT (104.19735928449404 52.36164767001315)', 'mid', 'Irkutsk N.W.', 'UIIR', 'UIIR'),
(391, 'POINT (114.6922665989016 38.27814091311202)', 'major', 'Shijiazhuang Zhengding Int''l', 'ZBSJ', 'SJW'),
(392, 'POINT (50.04983948674051 40.46274688390803)', 'major', 'Heydar Aliyev Int''l', 'UBBB', 'GYD'),
(393, 'POINT (33.322201334898956 35.10634480673619)', 'military mid', 'Lakatamia Airbase', 'LCRO', 'LAK'),
(394, 'POINT (-42.079251752018415 -22.925631709132773)', 'mid', 'Cabo Frio Int''l', 'SBCB', 'CFB'),
(395, 'POINT (25.045535369831455 60.24937784995868)', 'mid', 'Helsinki-Malmi', 'EFHF', 'HEM'),
(396, 'POINT (6.216421217287305 49.63430409251016)', 'major', 'Luxembourg-Findel', 'ELLX', 'LUX'),
(397, 'POINT (12.341067300436913 45.504847758845486)', 'major', 'Venice Marco Polo', 'LIPZ', 'VCE'),
(398, 'POINT (128.66298866883957 38.058782416258545)', 'mid', 'Yangyang Int''l', 'RKNY', 'YNY'),
(399, 'POINT (-69.93947393390899 -4.250324694933793)', 'mid', 'Tabatinga Int''l', 'SBTT', 'TBT'),
(400, 'POINT (-60.69222063386823 2.84119534121157)', 'mid', 'Boa Vista Int''l', 'SBBV', 'BVB'),
(401, 'POINT (-15.389924515846113 27.936889971657408)', 'major', 'Gran Canaria', 'GCLP', 'LPA'),
(402, 'POINT (-72.05385691012962 -50.283900869003766)', 'mid', 'Com. Armando Tola Int''l', 'SAWA', 'ING'),
(403, 'POINT (16.92160555842542 58.785104130344784)', 'mid', 'Stockholm-Skavsta', 'ESKN', 'NYO'),
(404, 'POINT (98.67619257146407 3.5665917999089403)', 'mid', 'Polonia Int''l', 'WIMM', 'MES'),
(405, 'POINT (18.524123630208024 4.398851536959572)', 'mid', 'Bangui M''Poko Int''l', 'FEFF', 'BGF'),
(406, 'POINT (120.43209737631294 30.235186279041436)', 'major', 'Hangzhou Xiaoshan Int''l', 'ZSHC', 'HGH'),
(407, 'POINT (-157.34977789343037 1.9861611979240215)', 'mid', 'Cassidy Int''l', 'PLCH', 'CXI'),
(408, 'POINT (23.383188573869113 55.90376945403999)', 'mid', 'Siauliai Int''l', 'EYSA', 'SQQ'),
(409, 'POINT (-169.92612977421672 -19.076712935451056)', 'mid', 'Niue Int''l', 'NIUE', 'IUE'),
(410, 'POINT (-54.83939952960621 -25.456857071581247)', 'mid', 'Guarani Int''l', 'SGES', 'AGT'),
(411, 'POINT (-71.56793353852852 -16.344552065351998)', 'mid', 'Rodriguez Ballon Int''l', 'SPQU', 'AQP'),
(412, 'POINT (132.13984172071468 43.377649253388505)', 'mid and military', 'Vladivostok Int''l', 'UHWW', 'VVO'),
(413, 'POINT (21.03026901247459 42.58503311534483)', 'major', 'Pristina', 'BKPR', 'PRN'),
(414, 'POINT (4.450922773999088 51.18912850638064)', 'mid', 'Deurne', 'EBAW', 'ANR'),
(415, 'POINT (-110.36719785980947 24.076090352180334)', 'mid', 'Gen. Marquez de Leon Int''l', 'MMLP', 'LAP'),
(416, 'POINT (126.2369830308627 45.62060117232452)', 'major', 'Harbin Taiping', 'ZYHB', 'HRB'),
(417, 'POINT (76.91890256129132 8.476509938945144)', 'mid', 'Trivandrum Int''l', 'VOTV', 'TRV'),
(418, 'POINT (27.149297595266408 38.29123476451746)', 'major', 'Adnan Menderes', 'LTBJ', 'ADB'),
(419, 'POINT (118.86610214690592 31.73532492961766)', 'major', 'Nanjing Lukou Int''l', 'ZSNJ', 'NKG'),
(420, 'POINT (-78.70393431144967 26.548246747188983)', 'mid', 'Freeport Int''l', 'MYGF', 'FPO'),
(421, 'POINT (13.144258981071262 32.66916955049933)', 'major', 'Tripoli Int''l', 'HLLT', 'TIP'),
(422, 'POINT (-54.57557190935781 48.946598006073565)', 'mid', 'Gander Int''l', 'CYQX', 'YQX'),
(423, 'POINT (51.558548787654715 25.268246131050645)', 'major and military', 'Doha Int''l', 'OTBD', 'DOH'),
(424, 'POINT (-106.6166851616002 35.04915780182765)', 'major', 'Albuquerque Int''l', 'KABQ', 'ABQ'),
(425, 'POINT (-61.792367669835826 17.140359937161683)', 'mid', 'V.C. Bird Int''l', 'TAPA', 'ANU'),
(426, 'POINT (-171.99732221833983 -13.832501332395603)', 'mid', 'Faleolo', 'NSFA', 'APW'),
(427, 'POINT (31.016249043801107 27.05081584069781)', 'mid', 'Asyut', 'HEAT', 'ATZ'),
(428, 'POINT (50.62600287575336 26.269697149949714)', 'major', 'Bahrain Int''l', 'OBBI', 'BAH'),
(429, 'POINT (-72.68539474333903 41.93031600583518)', 'major', 'Bradley Int''l', 'KBDL', 'BDL'),
(430, 'POINT (-59.48741889531585 13.079661104553033)', 'mid', 'Grantley Adams Int''l', 'TBPB', 'BGI'),
(431, 'POINT (-16.652313269807472 13.343860478894186)', 'mid', 'Yundum Int''l', 'GBYD', 'BJL'),
(432, 'POINT (29.32098401699387 -3.322044349131131)', 'mid', 'Bujumbura Int''l', 'HBBA', 'BJM'),
(433, 'POINT (34.971944183793276 -15.68138447932725)', 'mid', 'Chileka Int''l', 'FWCL', 'BLZ'),
(434, 'POINT (122.23385051502184 -17.95257612926801)', 'mid', 'Broome Int''l', 'YBRM', 'BME'),
(435, 'POINT (56.368886456411 27.210325845514543)', 'mid', 'Bandar Abbass Int''l', 'OIKB', 'BND'),
(436, 'POINT (47.668376663351836 30.552799016106043)', 'major', 'Basrah Int''l', 'ORMM', 'BSR'),
(437, 'POINT (-106.4358466310554 31.635756620195146)', 'mid', 'Ciudad Juarez Int''l', 'MMCS', 'CJS'),
(438, 'POINT (79.88525734215062 7.1780771054422114)', 'major', 'Katunayake Int''l', 'VCBI', 'CMB'),
(439, 'POINT (145.75358484439977 -16.876742155406177)', 'mid', 'Cairns Int''l', 'YBCS', 'CNS'),
(440, 'POINT (98.96811812415933 18.768847391967526)', 'major', 'Chiang Mai Int''l', 'VTCC', 'CNX'),
(441, 'POINT (-104.70088027411134 38.79742487791252)', 'major', 'City of Colorado Springs', 'KCOS', 'COS'),
(442, 'POINT (-90.50362837340384 19.81422479920744)', 'mid', 'Ign. Alberto Ongay Int''l', 'MMCP', 'CPE'),
(443, 'POINT (113.21405420325205 28.189921861945066)', 'major', 'Changsha Huanghua Int''l', 'ZGHA', 'CSX'),
(444, 'POINT (-84.65616991533919 39.05541890478304)', 'major', 'Greater Cincinnati Int''l', 'KCVG', 'CVG'),
(445, 'POINT (108.20270625793569 16.05314414516696)', 'major', 'Da Nang', 'VVDN', 'DAD'),
(446, 'POINT (-96.84986377097995 32.84442537327384)', 'major', 'Dallas Love Field', 'KDAL', 'DAL'),
(447, 'POINT (36.51289547181257 33.41143667027319)', 'major', 'Damascus Int''l', 'OSDI', 'DAM'),
(448, 'POINT (-82.43175833693866 8.391261061169175)', 'mid', 'Enrique Malek Int''l', 'MPDA', 'DAV'),
(449, 'POINT (41.857756722253 9.61267784753569)', 'mid', 'Aba Tenna D. Yilma Int''l', 'HADR', 'DIR'),
(450, 'POINT (115.16232296110661 -8.744757315956518)', 'major', 'Bali Int''l', 'WADD', 'DPS'),
(451, 'POINT (-93.64846125637362 41.5327904242113)', 'major', 'Des Moines Int''l', 'KDSM', 'DSM'),
(452, 'POINT (32.4427573135214 0.0449409493886721)', 'mid', 'Entebbe Int''l', 'HUEN', 'EBB'),
(453, 'POINT (25.330271489621154 0.4922251369175005)', 'mid', 'Kisangani Bangoka Int''l', 'FZIC', 'FKI'),
(454, 'POINT (119.6680438209992 25.931823314814313)', 'mid', 'Fuzhou Changle Int''l', 'ZSFZ', 'FOC'),
(455, 'POINT (91.58822905818697 26.105247592425503)', 'mid', 'Lokpriya G. Bordoloi Int''l', 'VEGT', 'GAU'),
(456, 'POINT (18.468442216591136 54.380702535292464)', 'major', 'Gdansk Lech Walesa', 'EPGD', 'GDN'),
(457, 'POINT (-61.78585299092849 12.007268305428271)', 'mid', 'Point Salines Int''l', 'TGPY', 'GND'),
(458, 'POINT (43.789633706293515 56.21855259106556)', 'mid', 'Nizhny Novgorod Int''l', 'UWGG', 'GOJ'),
(459, 'POINT (-110.9216512704022 27.969455396282893)', 'mid', 'Gen. Jose M. Yanez Int''l', 'MMGM', 'GYM'),
(460, 'POINT (111.81468182162591 40.85406009065522)', 'mid', 'Hohhot Baita Int''l', 'ZBHH', 'HET'),
(461, 'POINT (-111.9898968960076 46.61020435289996)', 'mid', 'Helena Reg.', 'KHLN', 'HLN'),
(462, 'POINT (-111.0519017118191 29.090077252344535)', 'mid', 'Gen. Ignacio P. Garcia Int''l', 'MMHO', 'HMO'),
(463, 'POINT (-77.44779257692062 38.95277403795302)', 'major', 'Dulles Int''l', 'KIAD', 'IAD'),
(464, 'POINT (-155.0396297334349 19.714797686866262)', 'mid', 'Hilo Int''l', 'PHTO', 'ITO'),
(465, 'POINT (-90.07509862769238 32.31006002736351)', 'major', 'Jackson Int''l', 'KJAN', 'JAN'),
(466, 'POINT (-81.68357672783112 30.491352730947966)', 'major', 'Jacksonville Int''l', 'KJAX', 'JAX'),
(467, 'POINT (110.3418370543153 1.487207937790097)', 'mid', 'Kuching Int''l', 'WBGG', 'KCH'),
(468, 'POINT (30.13487681878561 -1.9636544366413797)', 'mid', 'Kigali Int''l', 'HRYR', 'KGL'),
(469, 'POINT (19.800977284450408 50.07226306483314)', 'major', 'Balice', 'EPKK', 'KRK'),
(470, 'POINT (50.14726552101905 53.50838481909353)', 'major', 'Kurumoch', 'UWWW', 'KUF'),
(471, 'POINT (110.04689349777009 25.217605525229324)', 'major', 'Guilin Liangjiang Int''l', 'ZGKL', 'KWL'),
(472, 'POINT (120.53387619612701 18.182418086637874)', 'mid', 'Laoag Int''l', 'RPLI', 'LAO'),
(473, 'POINT (-73.8719858204814 40.77455393988576)', 'major', 'LaGuardia', 'KLGA', 'LGA'),
(474, 'POINT (-0.1629616391394559 51.155756751927456)', 'major', 'London Gatwick', 'EGKK', 'LGW'),
(475, 'POINT (14.454812628326566 46.230544555448624)', 'major', 'Ljubljana', 'LJLJ', 'LJU'),
(476, 'POINT (80.88417197324722 26.763932870091633)', 'mid', 'Amausi Int''l', 'VILK', 'LKO'),
(477, 'POINT (-57.89538206365101 -34.9655441559234)', 'mid', 'La Plata', 'SADL', 'LPG'),
(478, 'POINT (-97.53082171211871 25.770841264061858)', 'mid', 'Gen. Sevando Canales', 'MMMA', 'MAM'),
(479, 'POINT (-2.2733715906942735 53.36248960665181)', 'major', 'Manchester Int''l', 'EGCC', 'MAN'),
(480, 'POINT (-94.71591485791544 39.297895826365945)', 'major', 'Kansas City Int''l', 'KMCI', 'MCI'),
(481, 'POINT (58.2904804753493 23.588570417585636)', 'major', 'Seeb Int''l', 'OOMS', 'MCT'),
(482, 'POINT (10.75336818505404 35.76071044217803)', 'mid', 'Habib Bourguiba Int''l', 'DTMB', 'MIR'),
(483, 'POINT (5.221379177203373 43.44106000164679)', 'major', 'Marseille Provence Airport', 'LFML', 'MRS'),
(484, 'POINT (-99.5680081930063 27.449689650831623)', 'mid', 'Quetzalcoatl Int''l', 'MMNL', 'NLD'),
(485, 'POINT (108.16801227333096 22.612037054178508)', 'major', 'Nanning Wuwu Int''l', 'ZGNN', 'NNG'),
(486, 'POINT (-96.72179593849754 17.000559256974505)', 'mid', 'Xoxocotlan Int''l', 'MMOX', 'OAX'),
(487, 'POINT (-156.4374295813534 20.89328851511117)', 'mid', 'Kahului', 'PHOG', 'OGG'),
(488, 'POINT (-97.59611775420922 35.39527749117442)', 'major', 'Will Rogers', 'KOKC', 'OKC'),
(489, 'POINT (-76.2044231712327 36.89823946736742)', 'major', 'Norfolk Int''l', 'KORF', 'ORF'),
(490, 'POINT (-80.09018933833873 26.688441666432965)', 'major', 'Palm Beach Int''l', 'KPBI', 'PBI'),
(491, 'POINT (-55.199911389290236 5.455999677974393)', 'mid', 'Pengel Int''l', 'SMJP', 'PBM'),
(492, 'POINT (56.019560282029694 57.919771123169134)', 'mid', 'Bolshesavino', 'USPP', 'PEE'),
(493, 'POINT (100.26578638095476 5.292656277904887)', 'mid', 'Penang Int''l', 'WMKP', 'PEN'),
(494, 'POINT (6.9498974272319085 5.007003476739435)', 'mid', 'Port Harcourt Int''l', 'DNPO', 'PHC'),
(495, 'POINT (118.63179781561529 -20.378127296072336)', 'mid', 'Port Hedland Int''l', 'YPPD', 'PHE'),
(496, 'POINT (-100.29264198170532 44.38015346687622)', 'mid', 'Pierre Regional', 'KPIR', 'PIR'),
(497, 'POINT (-80.2561290571918 40.496051891528495)', 'major', 'Greater Pittsburgh Int''l', 'KPIT', 'PIT'),
(498, 'POINT (-170.71330705373444 -14.329064185030566)', 'mid', 'Pago Pago Int''l', 'NSTU', 'PPG'),
(499, 'POINT (-1.7337317043445242 52.45290855428381)', 'major', 'Birmingham Int''l', 'EGBB', 'BHX'),
(500, 'POINT (-10.353085186793352 6.241834565545255)', 'mid', 'Roberts Int''l', 'GLRB', 'ROB'),
(501, 'POINT (81.74037759152014 21.18598685614469)', 'mid', 'Raipur', 'VARP', 'RPR'),
(502, 'POINT (-89.0572035692743 13.444748122861604)', 'mid', 'El Salvador Int''l', 'MSLP', 'SAL'),
(503, 'POINT (-117.19751102573103 32.73226455701319)', 'major', 'San Diego Int''l', 'KSAN', 'SAN'),
(504, 'POINT (-98.4719699991559 29.526620339131505)', 'major', 'San Antonio Int''l', 'KSAT', 'SAT'),
(505, 'POINT (-81.20996477509134 32.13564155229021)', 'major', 'Savannah Int''l', 'KSAV', 'SAV'),
(506, 'POINT (-75.83988776397909 19.972428871762215)', 'mid', 'Antonio Maceo', 'MUCU', 'SCU'),
(507, 'POINT (-100.93647781626697 22.255713049590337)', 'mid', 'Ponciano Arriaga Int''l', 'MMSP', 'SLP'),
(508, 'POINT (-121.58789487772277 38.6927238925554)', 'major', 'Sacramento Int''l', 'KSMF', 'SMF'),
(509, 'POINT (-70.69417832244676 19.46592191528884)', 'mid', 'Cibao Int''l', 'MDST', 'STI'),
(510, 'POINT (60.80580334321738 56.73224561204597)', 'major', 'Koltsovo', 'USSS', 'SVX'),
(511, 'POINT (-76.1130789991049 43.13178449437413)', 'major', 'Syracuse Hancock Int''l', 'KSYR', 'SYR'),
(512, 'POINT (46.244713373574 38.131110768817514)', 'mid', 'Tabriz', 'OITT', 'TBZ'),
(513, 'POINT (-103.39878782857888 25.56321643998958)', 'mid', 'Torreon Int''l', 'MMTC', 'TRC'),
(514, 'POINT (-95.88988227154202 36.19012756519499)', 'major', 'Tulsa Int''l', 'KTUL', 'TUL'),
(515, 'POINT (-83.98993783275846 35.80574480270883)', 'major', 'Mcghee Tyson', 'KTYS', 'TYS'),
(516, 'POINT (55.884077341183726 54.56513235789718)', 'major', 'Ufa Int''l', 'UWUU', 'UFA'),
(517, 'POINT (-60.949973772346056 13.736523805048892)', 'mid', 'Hewanorra Int''l', 'TLPL', 'UVF'),
(518, 'POINT (17.463225902813253 -22.486953120204117)', 'mid', 'Windhoek Hosea Kutako Int''l', 'FYWH', 'WDH'),
(519, 'POINT (-84.50060899997175 46.485417510192555)', 'mid', 'Sault Ste Marie', 'CYAM', 'YAM'),
(520, 'POINT (-120.18559561910142 55.7394117074557)', 'mid', 'Dawson Cr.', 'CYDQ', 'YDQ'),
(521, 'POINT (-113.5844925644056 53.307200161918324)', 'major', 'Edmonton Int''l', 'CYEG', 'YEG'),
(522, 'POINT (-63.514965250167336 44.886545450100954)', 'major', 'Halifax Int''l', 'CYHZ', 'YHZ');
INSERT INTO `airports` (`id`, `coordinates_wkt`, `type`, `name`, `icao_code`, `iata_code`) VALUES
(523, 'POINT (-120.44173476396232 50.70519551845913)', 'mid', 'Kamloops', 'CYKA', 'YKA'),
(524, 'POINT (-80.79577478171052 46.622750820489316)', 'mid', 'Sudbury', 'CYSB', 'YSB'),
(525, 'POINT (-65.89055736811677 45.329230595501656)', 'mid', 'Saint John', 'CYSJ', 'YSJ'),
(526, 'POINT (-122.67401474398616 53.884248575113766)', 'mid', 'Prince George', 'CYXS', 'YXS'),
(527, 'POINT (-123.43062453952774 48.64052948217902)', 'major', 'Victoria Int''l', 'CYYJ', 'YYJ'),
(528, 'POINT (122.06243232163732 6.919757748058303)', 'mid', 'Zamboanga Int''l', 'RPMZ', 'ZAM'),
(529, 'POINT (103.61541536304331 36.50788424612367)', 'mid', 'Lanzhou Zhongchuan', 'ZLLL', 'ZGC'),
(530, 'POINT (-73.80935188431725 42.745661980172905)', 'mid', 'Albany Int''l', 'KALB', 'ALB'),
(531, 'POINT (-87.90210562507438 42.94791987295855)', 'major', 'General Mitchell Int''l', 'KMKE', 'MKE'),
(532, 'POINT (114.24694737615044 30.60171411967017)', 'military mid', 'Wang-Chia Tun Airbase', '', ''),
(533, 'POINT (109.40823949107957 18.309095990859316)', 'major', 'Sanya Phoenix Int''l', 'ZJSY', 'SYX'),
(534, 'POINT (90.9005610194027 29.29369361231842)', 'mid', 'Lhasa Gonggar', 'ZULS', 'LXA'),
(535, 'POINT (79.87230052121915 37.04003635097652)', 'mid', 'Hotan', 'ZWTN', 'HTN'),
(536, 'POINT (13.764967144004661 51.125091242887116)', 'major', 'Dresden', 'EDDC', 'DRS'),
(537, 'POINT (-6.5977536281159965 34.298667363822325)', 'military major', 'Kenitra Air Base', 'GMMY', 'NNA'),
(538, 'POINT (6.264910853641591 46.19572832862606)', 'mid', 'Annemasse', 'LFLI', 'QNJ'),
(539, 'POINT (-110.97272130167508 31.225537174115924)', 'mid', 'Nogales Int''l', 'MMNG', 'NOG'),
(540, 'POINT (7.627841966889242 48.54469617217594)', 'mid', 'Strasbourg', 'LFST', 'SXB'),
(541, 'POINT (7.122359755245386 50.87825966294709)', 'major', 'Cologne/Bonn', 'EDDK', 'CGN'),
(542, 'POINT (128.9488013790388 35.17028406368295)', 'major', 'Kimhae Int''l', 'RKPK', 'PUS'),
(543, 'POINT (126.49162940197242 33.52471731503988)', 'major', 'Jeju Int''l', 'RKPC', 'CJU'),
(544, 'POINT (5.629810329721799 58.88215648421848)', 'major', 'Stavanger Sola', 'ENZV', 'SVG'),
(545, 'POINT (10.916809524144515 63.472029381716986)', 'major', 'Trondheim Vaernes', 'ENVA', 'TRD'),
(546, 'POINT (-57.663607892554346 -19.01416628855335)', 'mid', 'Corumba Int''l', 'SBCR', 'CMG'),
(547, 'POINT (-16.775637453121334 32.69336428474887)', 'mid', 'Madeira', 'LPMA', 'FNC'),
(548, 'POINT (-54.48859227356332 -25.597683216210232)', 'mid', 'Foz do Igua?u Int''l', 'SBFI', 'IGU'),
(549, 'POINT (-63.89846250042134 -8.714424828592882)', 'mid', 'Gov. Jorge Teixeira de Oliveira Int''l', 'SBPV', 'PVH'),
(550, 'POINT (-2.9060901167980533 43.30508298111947)', 'mid', 'Bilbao', 'LEBB', 'BIO'),
(551, 'POINT (2.729976602006474 39.56577585862541)', 'major', 'Palma de Mallorca', 'LEPA', 'PMI'),
(552, 'POINT (-16.346317567926352 28.487577026773145)', 'major', 'Tenerife N.', 'GCXO', 'TFN'),
(553, 'POINT (12.29382690925731 57.685749353487864)', 'major', 'Gothenburg', 'ESGG', 'GOT'),
(554, 'POINT (22.123027124394543 65.54903624776163)', 'major', 'Lulea', 'ESPA', 'LLA'),
(555, 'POINT (54.646329322555786 24.42722715297642)', 'major', 'Abu Dhabi Int''l', 'OMAA', 'AUH'),
(556, 'POINT (6.621946651812188 36.28344094416007)', 'mid', 'Mohamed Boudiaf Int''l', 'DABC', 'CZL'),
(557, 'POINT (32.82443724629733 23.968276544177797)', 'mid', 'Aswan Int''l', 'HESN', 'ASW'),
(558, 'POINT (25.829440976045195 66.55955641685094)', 'mid', 'Rovaniemi', 'EFRO', 'RVN'),
(559, 'POINT (-58.25411919258886 6.498552908135722)', 'mid', 'Cheddi Jagan Int''l', 'SYCJ', 'GEO'),
(560, 'POINT (76.39051985020242 10.155118762811767)', 'major', 'Cochin Int''l', 'VOCI', 'COK'),
(561, 'POINT (35.223693065830126 0.4050714754603605)', 'mid', 'Eldoret Int''l', 'HKEL', 'EDL'),
(562, 'POINT (126.45087598079584 37.449208862434624)', 'major', 'Incheon Int''l', 'RKSI', 'ICN'),
(563, 'POINT (-107.46986379289618 24.766804039046114)', 'mid', 'Federal de Bachigualato Int''l', 'MMCL', 'CUL'),
(564, 'POINT (73.10079364718818 33.607445750752625)', 'major and military', 'Benazir Bhutto Int''l', 'OPRN', 'ISB'),
(565, 'POINT (4.484640324082722 50.89729496415108)', 'major', 'Brussels', 'EBBR', 'BRU'),
(566, 'POINT (7.2702599397435606 9.00437659781094)', 'major', 'Abuja Int''l', 'DNAA', 'ABV'),
(567, 'POINT (-124.10706552013855 40.97192453813144)', 'mid', 'Arcata-Eureka', 'KACV', 'ACV'),
(568, 'POINT (-97.66683676460543 30.202108192074945)', 'major', 'Austin-Bergstrom Int''l', 'KAUS', 'AUS'),
(569, 'POINT (30.80255264394152 36.915323305186774)', 'major', 'Antalya', 'LTAI', 'AYT'),
(570, 'POINT (-6.2161694373495795 54.66155754701032)', 'major', 'Belfast Int''l', 'EGAA', 'BFS'),
(571, 'POINT (9.698917693997402 45.66549805606945)', 'major', 'Orio Al Serio', 'LIME', 'BGY'),
(572, 'POINT (116.05108787336903 5.922894454748071)', 'mid', 'Kota Kinabalu Int''l', 'WBKK', 'BKI'),
(573, 'POINT (77.70955798895749 13.200610806960903)', 'major', 'Bengaluru Int''l', 'VOBL', 'BLR'),
(574, 'POINT (149.19076053967132 -35.3071855902909)', 'major', 'Canberra Int''l', 'YSCB', 'CBR'),
(575, 'POINT (-82.8840306426634 39.9981181922432)', 'major', 'Port Columbus Int''l', 'KCMH', 'CMH'),
(576, 'POINT (-7.581455990257197 33.374727481539615)', 'major', 'Mohamed V Int''l', 'GMMN', 'CMN'),
(577, 'POINT (6.76494446612174 51.2781820420774)', 'major', 'Dusseldorf Int''l', 'EDDL', 'DUS'),
(578, 'POINT (32.99301007720143 40.11512782732336)', 'major', 'Esenboga Int''l', 'LTAC', 'ESB'),
(579, 'POINT (175.33622143270816 -37.865841148482694)', 'mid', 'Hamilton Int''l', 'NZHN', 'HLZ'),
(580, 'POINT (78.42953613451998 17.235983150747067)', 'major', 'Rajiv Gandhi Int''l', 'VOHS', 'HYD'),
(581, 'POINT (-73.78632686092955 40.645959558408144)', 'major', 'John F Kennedy Int''l', 'KJFK', 'JFK'),
(582, 'POINT (30.89516216155281 50.34090233887696)', 'major', 'Boryspil Int''l', 'UKBB', 'KBP'),
(583, 'POINT (32.550153296632956 15.59222265308578)', 'major', 'Khartoum', 'HSSS', 'KRT'),
(584, 'POINT (-89.34578478944866 43.13630823858675)', 'major', 'Dane Cty. Reg. (Truax Field)', 'KMSN', 'MSN'),
(585, 'POINT (28.034193334637767 53.88937923980054)', 'major', 'Minsk Int''l', 'UMMS', 'MSQ'),
(586, 'POINT (13.105530988863753 38.186335108489494)', 'major', 'Palermo', 'LICJ', 'PMO'),
(587, 'POINT (-71.4357841445789 41.726001984718906)', 'mid', 'T.F. Green', 'KPVD', 'PVD'),
(588, 'POINT (-81.75512314093055 26.527928806765104)', 'major', 'Southwest Florida Int''l', 'KRSW', 'RSW'),
(589, 'POINT (123.4879744303385 41.634789133958215)', 'major', 'Shenyang Taoxian Int''l', 'ZYTX', 'SHE'),
(590, 'POINT (55.52050719488528 25.321196401906818)', 'major', 'Sharjah Int''l', 'OMSJ', 'SHJ'),
(591, 'POINT (-121.92942898353154 37.36949059089655)', 'major', 'San Jose Int''l', 'KSJC', 'SJC'),
(592, 'POINT (-117.8614892203934 33.6794857329549)', 'major', 'John Wayne', 'KSNA', 'SNA'),
(593, 'POINT (9.193951089455357 48.69010513589129)', 'major', 'Stuttgart', 'EDDS', 'STR'),
(594, 'POINT (-84.13860919715941 9.958278519196229)', 'mid', 'Nacional Tobias Bolanos', 'MRPV', 'SYQ'),
(595, 'POINT (113.81585275108512 22.64650771478675)', 'major', 'Shenzhen Bao''an Int''l', 'ZGSZ', 'SZX'),
(596, 'POINT (-85.74170275973673 38.18602071526992)', 'major', 'Louisville Int''l', 'KSDF', 'SDF'),
(597, 'POINT (6.107945774236034 46.23100951015795)', 'major', 'Geneva', 'LSGG', 'GVA'),
(598, 'POINT (5.075944318134586 45.72101868346691)', 'mid', 'Lyon-Saint Exupery', 'LFLL', 'LYS'),
(599, 'POINT (135.24445977247638 34.43479416292695)', 'major', 'Kansai Int''l', 'RJBB', 'KIX'),
(600, 'POINT (-9.130694409310712 38.770762342751425)', 'major', 'Lisbon Portela', 'LPPT', 'LIS'),
(601, 'POINT (-43.96358152099491 -19.63278212187474)', 'major', 'Tancredo Neves Int''l', 'SBCF', 'CNF'),
(602, 'POINT (17.945617540614503 59.35559020651122)', 'mid', 'Bromma', 'ESSB', 'BMA'),
(603, 'POINT (112.77703459493297 -7.383578985275999)', 'major', 'Juanda Int''l', 'WARR', 'SUB'),
(604, 'POINT (-57.581615093239215 -37.93321612044816)', 'mid', 'Astor Piazzolla Int''l', 'SAZM', 'MDQ'),
(605, 'POINT (-81.35767061622893 19.29591074371222)', 'major', 'Owen Roberts Int''l', 'MWCR', 'GCM'),
(606, 'POINT (113.84183130284451 34.52630271989567)', 'major', 'Zhengzhou Xinzheng Int''l', 'ZHCC', 'CGO'),
(607, 'POINT (121.53891378010117 38.96157023002216)', 'major', 'Dalian Zhoushuizi Int''l', 'ZYTL', 'DLC'),
(608, 'POINT (25.17405582432718 35.33690241010455)', 'major', 'Heraklion Int''l', 'LGIR', 'HER'),
(609, 'POINT (44.964614614166365 41.66944201872605)', 'major', 'Tbilisi Int''l', 'UGTB', 'TBS'),
(610, 'POINT (-9.354582402639275 38.72353532083235)', 'mid', 'Cascais', 'LPCS', 'XXC'),
(611, 'POINT (120.34515634215063 22.57170610544221)', 'major', 'Kaohsiung Int''l', 'RCKH', 'KHH'),
(612, 'POINT (5.200226160326513 12.917482416618078)', 'mid', 'Sadiq Abubakar III', 'DNSO', 'SKO'),
(613, 'POINT (-78.48999255457005 -0.1455524084668824)', 'mid', 'Mariscal Sucre Int''l', 'SEQU', 'UIO'),
(614, 'POINT (67.15212835929466 24.898524368959485)', 'mid', 'Karachi Civil', 'OPKC', 'KHI'),
(615, 'POINT (28.93604875622555 46.93416199003912)', 'mid', 'Kishinev S.E.', 'LUKK', 'KIV'),
(616, 'POINT (-77.10756569313422 -12.0237161502221)', 'major', 'Jorge Chavez', 'SPIM', 'LIM'),
(617, 'POINT (-89.31214212381362 48.37188114925079)', 'mid', 'Thunder Bay Int''l', 'CYQT', 'YQT'),
(618, 'POINT (25.28071644972846 54.64305493075424)', 'major', 'Vilnius', 'EYVI', 'VNO'),
(619, 'POINT (108.75581134215064 34.442939105442214)', 'major', 'Hsien Yang', 'ZLXY', 'XIY'),
(620, 'POINT (-100.2383941865767 25.859873767729045)', 'mid', 'Del Norte Int''l', 'MMAN', 'NTR'),
(621, 'POINT (-175.135635 -21.24861)', 'mid', 'Fua''amotu Int''l', 'NFTF', 'TBU'),
(622, 'POINT (51.87639168126809 32.74608053443211)', 'mid', 'Esfahan Int''l', 'OIFM', 'IFN'),
(623, 'POINT (31.1014 -17.9228)', 'mid', 'Harare Int''l', 'FVHA', 'HRE'),
(624, 'POINT (47.97148255933165 29.239680058158292)', 'major', 'Kuwait Int''l', 'OKBK', 'KWI'),
(625, 'POINT (-75.66489338702053 45.3201348196531)', 'major', 'Macdonald-Cartier Int''l', 'CYOW', 'YOW'),
(626, 'POINT (69.21007362708741 34.56339788641491)', 'mid', 'Kabul Int''l', 'OAKB', 'KBL'),
(627, 'POINT (-3.9322192916763594 5.254398445149204)', 'mid', 'Abidjan Port Bouet', 'DIAP', 'ABJ'),
(628, 'POINT (-99.75450856196812 16.761967352779976)', 'major', 'General Juan N Alvarez Int''l', 'MMAA', 'ACA'),
(629, 'POINT (-0.1714028556608167 5.606981523811933)', 'major', 'Kotoka Int''l', 'DGAA', 'ACC'),
(630, 'POINT (38.7931904366343 8.981730275810992)', 'mid', 'Bole Int''l', 'HAAB', 'ADD'),
(631, 'POINT (45.030602 12.8278)', 'mid', 'Aden Int''l', 'OYAA', 'ADE'),
(632, 'POINT (138.5321014576991 -34.9405860275154)', 'mid', 'Adelaide Int''l', 'YPAD', 'ADL'),
(633, 'POINT (77.01204587711747 43.34649431447929)', 'major', 'Almaty Int''l', 'UAAA', 'ALA'),
(634, 'POINT (3.212073535165055 36.69972066635346)', 'major', 'Houari Boumediene', 'DAAG', 'ALG'),
(635, 'POINT (37.22734140578282 36.18462373143136)', 'major', 'Aleppo Int''l', 'OSAP', 'ALP'),
(636, 'POINT (72.62090008843316 23.070745463588118)', 'mid', 'Sardar Vallabhbhai Patel Int''l', 'VAAH', 'AMD'),
(637, 'POINT (-70.44099085094066 -23.448954524831667)', 'mid', 'Cerro Moreno Int''l', 'SCFA', 'ANF'),
(638, 'POINT (58.363965920824604 37.98485343895699)', 'mid', 'Ashkhabad Northwest', 'UTAA', 'ASB'),
(639, 'POINT (38.90635401363214 15.29361596964986)', 'mid', 'Yohannes Iv Int''l', 'HHAS', 'ASM'),
(640, 'POINT (-57.51390782471363 -25.241659253381577)', 'mid', 'Silvio Pettirossi Int''l', 'SGAS', 'ASU'),
(641, 'POINT (-64.70277406865142 32.359173960158074)', 'mid', 'Bermuda Int''l', 'TXKF', 'BDA'),
(642, 'POINT (20.291284594662077 44.81907666544326)', 'major', 'Surcin', 'LYBE', 'BEG'),
(643, 'POINT (35.4930853618161 33.825440061866765)', 'major', 'Beirut Int''l', 'OLBA', 'BEY'),
(644, 'POINT (77.34087147135794 23.285568486980882)', 'mid', 'Bairagarh', 'VABP', 'BHO'),
(645, 'POINT (-7.947272269708012 12.539336342586719)', 'mid', 'Bamako Senou', 'GABS', 'BKO'),
(646, 'POINT (-86.66928673563747 36.13148763616973)', 'major', 'Nashville Int''l', 'KBNA', 'BNA'),
(647, 'POINT (153.1202564188439 -27.38539659390988)', 'major', 'Brisbane Int''l', 'YBBN', 'BNE'),
(648, 'POINT (-116.2218410705487 43.5689592234704)', 'major', 'Boise Air Terminal', 'KBOI', 'BOI'),
(649, 'POINT (-156.771835 71.289299)', 'mid', 'Wiley Post Will Rogers Mem.', 'PABR', 'BRW'),
(650, 'POINT (-78.73199655233083 42.93403374935259)', 'major', 'Greater Buffalo Int''l', 'KBUF', 'BUF'),
(651, 'POINT (28.622552042904037 -20.015568409490825)', 'mid', 'Bulawayo', 'FVBU', 'BUQ'),
(652, 'POINT (114.93311902920937 4.945475282276854)', 'major', 'Brunei Int''l', 'WBSB', 'BWN'),
(653, 'POINT (113.29751655217066 23.3891511573243)', 'major', 'Guangzhou Baiyun Int''l', 'ZGGG', 'CAN'),
(654, 'POINT (-73.06210617462139 -36.7763727437881)', 'mid', 'Carriel Sur Int''l', 'SCIE', 'CCP'),
(655, 'POINT (88.44000101301965 22.645389378506415)', 'major', 'Netaji Subhash Chandra Bose Int''l', 'VECC', 'CCU'),
(656, 'POINT (91.81471071623834 22.24556585857375)', 'mid', 'Chittagong', 'VGEG', 'CGP'),
(657, 'POINT (172.53867556522317 -43.48854867841038)', 'major', 'Christchurch Int''l', 'NZCH', 'CHC'),
(658, 'POINT (-13.621065625167132 9.574181158500823)', 'mid', 'Conakry', 'GUCY', 'CKY'),
(659, 'POINT (-81.83844060640457 41.41119161249661)', 'major', 'Hopkins Int''l', 'KCLE', 'CLE'),
(660, 'POINT (-76.38507147280909 3.5432863512321924)', 'mid', 'Alfonso Bonilla Aragon Int''l', 'SKCL', 'CLO'),
(661, 'POINT (2.383800072435198 6.3582465034691)', 'mid', 'Cotonou Cadjehon', 'DBBB', 'COO'),
(662, 'POINT (-64.21231576708007 -31.31568116848888)', 'mid', 'Ingeniero Ambrosio L.V. Taravella Int''l', 'SACO', 'COR'),
(663, 'POINT (-75.51233495596824 10.444938176491519)', 'mid', 'Rafael Nunez', 'SKCG', 'CTG'),
(664, 'POINT (-86.87441725066944 21.04019667144003)', 'major', 'Cancun', 'MMUN', 'CUN'),
(665, 'POINT (-105.969204692629 28.70399849976794)', 'mid', 'General R F Villalobos Int''l', 'MMCU', 'CUU'),
(666, 'POINT (90.40492415992367 23.84812432181269)', 'mid', 'Zia Int''l Dhaka', 'VGHS', 'DAC'),
(667, 'POINT (130.8775014367739 -12.40805599665558)', 'major and military', 'Darwin Int''l', 'YPDN', 'DRW'),
(668, 'POINT (30.945708194088084 -29.965914250828032)', 'mid', 'Louis Botha', 'FADN', 'DUR'),
(669, 'POINT (27.5292 -11.5908)', 'mid', 'Lubumbashi Luano Int''l', 'FZQA', 'FBM'),
(670, 'POINT (-4.982146376783026 33.930525184467264)', 'mid', 'Saiss', 'GMFF', 'FEZ'),
(671, 'POINT (15.446516207456082 -4.389168821975817)', 'mid', 'Kinshasa N Djili Int''l', 'FZAA', 'FIH'),
(672, 'POINT (-13.200229678648256 8.615423617263689)', 'mid', 'Freetown Lungi', 'GFLL', 'FNA'),
(673, 'POINT (125.67532157120056 39.200177166765556)', 'mid', 'Sunan', 'ZKPY', 'FNJ'),
(674, 'POINT (74.46880033990898 43.055452723330326)', 'major', 'Vasilyevka', 'UAFM', 'FRU'),
(675, 'POINT (25.92438082641467 -24.558071808944057)', 'mid', 'Sir Seretse Khama Int''l', 'FBSK', 'GBE'),
(676, 'POINT (-103.30076622275178 20.524686348517278)', 'major', 'Don Miguel Hidalgo Int''l', 'MMGL', 'GDL'),
(677, 'POINT (-4.431677969951069 55.86418285703546)', 'major', 'Glasgow Int''l', 'EGPF', 'GLA'),
(678, 'POINT (-90.53018111137798 14.588160829005092)', 'mid', 'La Aurora', 'MGGT', 'GUA'),
(679, 'POINT (-79.88700964393296 -2.1583379069913615)', 'mid', 'Simon Bolivar Int''l', 'SEGU', 'GYE'),
(680, 'POINT (105.80375943680576 21.214559670724526)', 'major', 'Noi Bai', 'VVNB', 'HAN'),
(681, 'POINT (-82.4074206289499 22.99735333644277)', 'major', 'Jose Marti Int''l', 'MUHA', 'HAV'),
(682, 'POINT (29.692666015230046 30.91837127862389)', 'mid', 'Borg El Arab Int''l', 'HEBA', 'HBE'),
(683, 'POINT (39.150499678044795 21.670685787812808)', 'major', 'King Abdul Aziz Int''l', 'OEJN', 'JED'),
(684, 'POINT (8.522137183957666 12.045707160174642)', 'mid', 'Kano Mallam Aminu Int''l', 'DNKN', 'KAN'),
(685, 'POINT (76.01301480600748 39.537968630625755)', 'mid', 'Kashi', 'ZWSH', 'KHG'),
(686, 'POINT (-76.77868976165765 17.937575155275226)', 'major', 'Norman Manley Int''l', 'MKJP', 'KIN'),
(687, 'POINT (85.357139531668 27.700281675160912)', 'mid', 'Tribhuvan Int''l', 'VNKT', 'KTM'),
(688, 'POINT (13.234795750269944 -8.84831327917379)', 'mid', 'Luanda 4 de Fevereiro', 'FNLU', 'LAD'),
(689, 'POINT (30.30709764546479 59.805406160189726)', 'major', 'Pulkovo 2', 'ULLI', 'LED'),
(690, 'POINT (74.41088101817482 31.520629651820634)', 'mid', 'Allama Iqbal Int''l', 'OPLA', 'LHE'),
(691, 'POINT (33.78278850197883 -13.788622823745978)', 'mid', 'Kamuzu Int''l', 'FWKI', 'LLW'),
(692, 'POINT (3.3211243528133374 6.5782594454046714)', 'major', 'Lagos Murtala Muhammed', 'DNMM', 'LOS'),
(693, 'POINT (-68.17800552779448 -16.509879221397668)', 'mid', 'El Alto Int''l', 'SLLP', 'LPB'),
(694, 'POINT (28.44554432110191 -15.326852250944736)', 'mid', 'Lusaka Int''l', 'FLLS', 'LUN'),
(695, 'POINT (32.70329708486226 25.673034778602332)', 'mid', 'Luxor', 'HELX', 'LXR'),
(696, 'POINT (80.16377597315451 12.982530166915435)', 'major', 'Chennai Int''l', 'VOMM', 'MAA'),
(697, 'POINT (-71.72376880946867 10.555759468497213)', 'mid', 'La Chinita Int''l', 'SVMC', 'MAR'),
(698, 'POINT (-75.4269557399772 6.171001614358001)', 'mid', 'Jose Maria Cordova', 'SKRG', 'MDE'),
(699, 'POINT (-89.98162803532371 35.04441012400894)', 'major', 'Memphis Int''l', 'KMEM', 'MEM'),
(700, 'POINT (-86.1712846229543 12.144635873435028)', 'mid', 'Augusto Cesar Sandino Int''l', 'MNMG', 'MGA'),
(701, 'POINT (59.64219435740293 36.22755031349836)', 'major', 'Mashhad', 'OIMM', 'MHD'),
(702, 'POINT (-80.2789718277441 25.79494072124062)', 'major', 'Miami Int''l', 'KMIA', 'MIA'),
(703, 'POINT (-89.66302357364343 20.933860386429597)', 'mid', 'Lic M Crecencio Rejon Int''l', 'MMMD', 'MID'),
(704, 'POINT (14.495264455505483 35.848930794350125)', 'major', 'Luqa', 'LMML', 'MLA'),
(705, 'POINT (39.60266318703833 -4.032652625796572)', 'major', 'Moi Int''l', 'HKMO', 'MBA'),
(706, 'POINT (27.559216033361427 -29.45557400461012)', 'mid', 'Moshoeshoe I Int''l', 'FXMM', 'MSU'),
(707, 'POINT (-90.25669394805942 29.985114146062223)', 'major', 'New Orleans Int''l', 'KMSY', 'MSY'),
(708, 'POINT (71.41899543293198 30.195078090496487)', 'major and military', 'Multan', 'OPMT', 'MUX'),
(709, 'POINT (-56.026636146282 -34.84104859885686)', 'major', 'Carrasco Int''l', 'SUMU', 'MVD'),
(710, 'POINT (-106.27001661788533 23.16659609713445)', 'mid', 'General Rafael Buelna Int''l', 'MMMZ', 'MZT'),
(711, 'POINT (-77.46484722909442 25.048691060086554)', 'major', 'Nassau Int''l', 'MYNN', 'NAS'),
(712, 'POINT (15.03304463855593 12.129540018411483)', 'mid', 'Ndjamena', 'FTTJ', 'NDJ'),
(713, 'POINT (2.1773067118412497 13.476757280794157)', 'mid', 'Niamey', 'DRRN', 'NIM'),
(714, 'POINT (123.97913450866376 10.315875672729177)', 'major', 'Mactan-Cebu Int''l', 'RPVM', 'CEB'),
(715, 'POINT (15.749761845959533 -12.802541457591508)', 'mid', 'Nova Lisboa', 'FNHU', 'NOV'),
(716, 'POINT (-95.89941579531211 41.29971114530123)', 'mid', 'Eppley Airfield', 'KOMA', 'OMA'),
(717, 'POINT (-165.44164171228104 64.50722070266309)', 'mid', 'Nome', 'PAOM', 'OME'),
(718, 'POINT (-1.5138053616511347 12.353580026047329)', 'mid', 'Ouagadougou', 'DFFD', 'OUA'),
(719, 'POINT (-72.29447802604733 18.57568290542864)', 'mid', 'Mais Gate Int''l', 'MTPP', 'PAP'),
(720, 'POINT (-98.37575979042302 19.16379354658405)', 'mid', 'Puebla', 'MMPB', 'PBC'),
(721, 'POINT (-122.5927388812541 45.58895693153053)', 'major', 'Portland Int''l', 'KPDX', 'PDX'),
(722, 'POINT (115.9742249422326 -31.941129794578288)', 'major', 'Perth Int''l', 'YPPH', 'PER'),
(723, 'POINT (25.611777756760176 -33.98408774313735)', 'mid', 'H F Verwoerd', 'FAPE', 'PLZ'),
(724, 'POINT (-73.09838413364236 -41.433382070226884)', 'mid', 'El Tepual Int''l', 'SCTE', 'PMC'),
(725, 'POINT (104.84502761245697 11.552644917651318)', 'major', 'Pochentong', 'VDPP', 'PNH'),
(726, 'POINT (73.90898381100165 18.579176611532837)', 'major and military', 'Pune', 'VAPO', 'PNQ'),
(727, 'POINT (147.21125085597714 -9.43865269316142)', 'major', 'Port Moresby Int''l', 'AYPY', 'POM'),
(728, 'POINT (-79.38713482154378 9.066872422658388)', 'major', 'Tocumen Int''l', 'MPTO', 'PTY'),
(729, 'POINT (-70.84312378513243 -53.005069825517666)', 'mid', 'Carlos Ibanez de Campo Int''l', 'SCCI', 'PUQ'),
(730, 'POINT (-78.79138140067508 35.8752323452255)', 'major', 'Durham Int''l', 'KRDU', 'RDU'),
(731, 'POINT (96.13419461149468 16.90115428182508)', 'major', 'Mingaladon', 'VYYY', 'RGN'),
(732, 'POINT (23.979379111699508 56.922003878609694)', 'major', 'Riga', 'EVRA', 'RIX'),
(733, 'POINT (44.22464679025606 15.47390277557374)', 'mid', 'Sanaa Int''l', 'OYSN', 'SAH'),
(734, 'POINT (44.22891253529416 33.26816298637704)', 'major', 'Baghdad Int''l', 'ORBI', 'SDA'),
(735, 'POINT (-69.67647267546673 18.430219694817325)', 'major', 'De Las Americas Int''l', 'MDSD', 'SDQ'),
(736, 'POINT (106.66424614137476 10.816300557187912)', 'major', 'Tan Son Nhat', 'VVTS', 'SGN'),
(737, 'POINT (22.976435361061277 40.52387368877751)', 'major', 'Thessaloniki', 'LGTS', 'SKG'),
(738, 'POINT (23.402452135770766 42.6891841273195)', 'major', 'Vrazhdebna', 'LBSF', 'SOF'),
(739, 'POINT (72.74243843725891 21.120450329717173)', 'major', 'Surat', 'VASU', 'STV'),
(740, 'POINT (178.5600483699593 -18.045899692285367)', 'mid', 'Nausori Int''l', 'NFNA', 'SUV'),
(741, 'POINT (52.58977127452107 29.545801384287437)', 'major', 'Shiraz Int''l', 'OISS', 'SYZ'),
(742, 'POINT (-97.8698137568394 22.289331952506398)', 'mid', 'Gen Francisco J Mina Int''l', 'MMTM', 'TAM'),
(743, 'POINT (-87.21921163489864 14.0599852192071)', 'mid', 'Toncontin Int''l', 'MHTG', 'TGU'),
(744, 'POINT (51.32080697175721 35.69137433049459)', 'major', 'Mehrabad Int''l', 'OIII', 'THR'),
(745, 'POINT (19.71503240497222 41.4208514680567)', 'major', 'Tirane Rinas', 'LATI', 'TIA'),
(746, 'POINT (-116.97547609559751 32.54604991350133)', 'major', 'General Abelardo L Rodriguez Int''l', 'MMTJ', 'TIJ'),
(747, 'POINT (-99.5706494463542 19.338688042303197)', 'mid', 'Jose Maria Morelos Y Pavon', 'MMTO', 'TLC'),
(748, 'POINT (24.798964869982985 59.41650146974512)', 'major', 'Ulemiste', 'EETN', 'TLL'),
(749, 'POINT (34.87084991809952 32.000746850184434)', 'major', 'Ben Gurion', 'LLBG', 'TLV'),
(750, 'POINT (6.712821930056672 0.374744213699427)', 'mid', 'Sao Tome Salazar', 'FPST', 'TMS'),
(751, 'POINT (47.47535400095789 -18.799334876308173)', 'mid', 'Antananarivo Ivato', 'FMMI', 'TNR'),
(752, 'POINT (-82.534824252055 27.980040085218384)', 'major', 'Tampa Int''l', 'KTPA', 'TPA'),
(753, 'POINT (-67.9223617121873 10.15400568839794)', 'mid', 'Zim Valencia', 'SVVA', 'VLN'),
(754, 'POINT (44.354767968489014 48.79167646576109)', 'mid', 'Gumrak', 'URWW', 'VOG'),
(755, 'POINT (102.5682381957277 17.975459594832063)', 'mid', 'Vientiane', 'VLVT', 'VTE'),
(756, 'POINT (-63.14038882182134 -17.647946825783897)', 'mid', 'Viru Viru Int''l', 'SLVR', 'VVI'),
(757, 'POINT (174.81166526823756 -41.32898918446593)', 'major', 'Wellington Int''l', 'NZWN', 'WLG'),
(758, 'POINT (-130.445587 54.292)', 'mid', 'Prince Rupert', 'CYPR', 'YPR'),
(759, 'POINT (-82.96008773894485 42.265878472719756)', 'mid', 'Windsor', 'CYQG', 'YQG'),
(760, 'POINT (-104.65543397537115 50.433219286718334)', 'mid', 'Regina', 'CYQR', 'YQR'),
(761, 'POINT (-123.18086700381177 49.19355903957153)', 'major', 'Vancouver Int''l', 'CYVR', 'YVR'),
(762, 'POINT (-97.22676948095848 49.90333024716708)', 'major', 'Winnipeg Int''l', 'CYWG', 'YWG'),
(763, 'POINT (-106.69018196755394 52.170143944738115)', 'mid', 'John G Diefenbaker Int''l', 'CYXE', 'YXE'),
(764, 'POINT (-135.07621008940154 60.714152148139725)', 'mid', 'Whitehorse Int''l', 'CYXY', 'YXY'),
(765, 'POINT (-114.01056050023648 51.130857256754865)', 'major', 'Calgary Int''l', 'CYYC', 'YYC'),
(766, 'POINT (-63.131234133323375 46.28581313675246)', 'mid', 'Charlottetown', 'CYYG', 'YYG'),
(767, 'POINT (-94.0813639506318 58.7497237849788)', 'mid', 'Churchill', 'CYYQ', 'YYQ'),
(768, 'POINT (-52.743333742863804 47.61311790079545)', 'mid', 'St John''s Int''l', 'CYYT', 'YYT'),
(769, 'POINT (-114.43784633504919 62.470737361020184)', 'mid', 'Yellowknife', 'CYZF', 'YZF'),
(770, 'POINT (16.061513800901448 45.73332667309836)', 'major', 'Zagreb', 'LDZA', 'ZAG'),
(771, 'POINT (39.22233198415581 -6.218570346202824)', 'mid', 'Zanzibar', 'HTZA', 'ZNZ'),
(772, 'POINT (-21.94663440313274 64.13187286099006)', 'mid', 'Reykjavik Air Terminal', 'BIRK', 'REK'),
(773, 'POINT (40.71334656945939 64.59674377304546)', 'mid', 'Arkhangelsk-Talagi', 'ULAA', 'ARH'),
(774, 'POINT (49.29844580364066 55.60806014297645)', 'major', 'Kazan Int''l', 'UWKD', 'KZN'),
(775, 'POINT (2.367379127837731 48.73130304580517)', 'major', 'Paris Orly', 'LFPO', 'ORY'),
(776, 'POINT (-71.38392807117314 46.79156843633076)', 'major', 'Quebec', 'CYQB', 'YQB'),
(777, 'POINT (-73.74931626504166 45.45835122945313)', 'major', 'Montreal-Trudeau', 'CYUL', 'YUL'),
(778, 'POINT (140.3844017091791 35.764056072782786)', 'major', 'Narita Int''l', 'RJAA', 'NRT'),
(779, 'POINT (136.81477128682428 34.85902969581623)', 'major', 'Chubu Centrair Int''l', 'RJGG', 'NGO'),
(780, 'POINT (141.38210045007517 43.11064959909785)', 'mid', 'Okadama', 'RJCO', 'OKD'),
(781, 'POINT (5.227253115623363 60.28906105029659)', 'major', 'Bergen Flesland', 'ENBR', 'BGO'),
(782, 'POINT (18.907262429213173 69.67967904734776)', 'major', 'Tromso Langnes', 'ENTC', 'TOS'),
(783, 'POINT (-48.479560289379336 -1.3897462879554638)', 'mid', 'Val de Caes Int''l', 'SBBE', 'BEL'),
(784, 'POINT (-54.66894987813051 -20.45727173603113)', 'mid', 'Campo Grande Int''l', 'SBCG', 'CGR'),
(785, 'POINT (-49.173709366346884 -25.536000143055837)', 'mid', 'Afonso Pena Int''l', 'SBCT', 'CWB'),
(786, 'POINT (-38.540747249833416 -3.7785949623309087)', 'mid', 'Pinto Martins Int''l', 'SBFZ', 'FOR'),
(787, 'POINT (-46.48175360884203 -23.42611557704206)', 'major', 'Sao Paulo-Guarulhos Int''l', 'SBGR', 'GRU'),
(788, 'POINT (-49.22664649059936 -16.632366572163658)', 'mid', 'Santa Genoveva', 'SBGO', 'GYN'),
(789, 'POINT (-51.17704094881724 -29.990193017060918)', 'mid', 'Salgado Filho Int''l', 'SBPA', 'POA'),
(790, 'POINT (-34.91826671748514 -8.131625530762387)', 'mid', 'Gilberto Freyre Int''l', 'SBRF', 'REC'),
(791, 'POINT (-38.3347989911732 -12.914361497032587)', 'mid', 'Deputado Luis Eduardo Magalhaes Int''l', 'SBSV', 'SSA'),
(792, 'POINT (-68.79848383944727 -32.82780016927193)', 'mid', 'El Plumerillo', 'SAME', 'MDZ'),
(793, 'POINT (-60.04606458988538 -3.0321390062590967)', 'mid', 'Eduardo Gomes Int''l', 'SBEG', 'MAO'),
(794, 'POINT (11.547994139680723 3.7148452070812583)', 'mid', 'Yaounde Nsimalen Int''l', 'FKYS', 'NSI'),
(795, 'POINT (121.80151876057847 31.152309029553294)', 'major', 'Shanghai Pudong Int''l', 'ZSPD', 'PVG'),
(796, 'POINT (35.984105236244915 31.97419940154417)', 'mid', 'Marka Int''l', 'OJAM', 'ADJ'),
(797, 'POINT (73.52739028368441 4.188700903233721)', 'major', 'Male Int''l', 'VRMM', 'MLE'),
(798, 'POINT (-96.18357021436948 19.142423702501713)', 'mid', 'Gen. Heriberto Jara Int''l', 'MMVR', 'VER'),
(799, 'POINT (-15.651185561666004 11.888923145485485)', 'mid', 'Osvaldo Vieira Int''l', 'GGOV', 'OXB'),
(800, 'POINT (125.64506660943381 7.130537461630729)', 'major', 'Francisco Bangoy Int''l', 'RPMD', 'DVO'),
(801, 'POINT (55.51155192467932 -4.671069141785209)', 'mid', 'Seychelles Int''l', 'FSIA', 'SEZ'),
(802, 'POINT (-17.490407907719003 14.745630614674791)', 'major', 'Leopold Sedar Senghor Int''l', 'GOOY', 'DKR'),
(803, 'POINT (37.23874759810247 19.434105238523106)', 'mid', 'Port Sudan New Int''l', 'HSPN', 'PZU'),
(804, 'POINT (69.26661372411293 41.26223387673829)', 'major', 'Tashkent Int''l', 'UTTT', 'TAS'),
(805, 'POINT (12.64935086845077 55.628501722152784)', 'major', 'Copenhagen', 'EKCH', 'CPH'),
(806, 'POINT (26.085725158776373 44.49704145597203)', 'mid', 'Aeroportul National Bucuresti-Baneasa', 'LRBS', 'BBU'),
(807, 'POINT (19.26223016778808 47.43327426924795)', 'major', 'Ferihegy', 'LHBP', 'BUD'),
(808, 'POINT (106.63801970481096 29.724042224168777)', 'major', 'Chongqing Jiangbei Int''l', 'ZUCK', 'CKG'),
(809, 'POINT (-80.94392773427626 35.220428168559714)', 'major', 'Douglas Int''l', 'KCLT', 'CLT'),
(810, 'POINT (-83.3478935065615 42.22572045080041)', 'major', 'Detroit Metro', 'KDTW', 'DTW'),
(811, 'POINT (-6.243884910371394 53.42700828497004)', 'major', 'Dublin', 'EIDW', 'DUB'),
(812, 'POINT (-147.86572112079517 64.81809811173692)', 'major', 'Fairbanks Int''l', 'PAFA', 'FAI'),
(813, 'POINT (10.005647830925001 53.63200116408658)', 'major', 'Hamburg', 'EDDH', 'HAM'),
(814, 'POINT (101.71388632574273 2.7475129579181066)', 'major', 'Kuala Lumpur Int''l', 'WMKK', 'KUL'),
(815, 'POINT (-115.15132395128332 36.08496023833674)', 'major', 'Mccarran Int''l', 'KLAS', 'LAS'),
(816, 'POINT (-81.30737133079849 28.431150679113763)', 'major', 'Orlando Int''l', 'KMCO', 'MCO'),
(817, 'POINT (-93.20810037183008 44.882026363196815)', 'major', 'Minneapolis St. Paul Int''l', 'KMSP', 'MSP'),
(818, 'POINT (11.788062719243687 48.35383739616085)', 'major', 'Franz-Josef-Strauss', 'EDDM', 'MUC'),
(819, 'POINT (-75.2429857676998 39.876087236427)', 'major', 'Philadelphia Int''l', 'KPHL', 'PHL'),
(820, 'POINT (-112.01363529772982 33.43586076394977)', 'major', 'Sky Harbor Int''l', 'KPHX', 'PHX'),
(821, 'POINT (-111.98198487999271 40.786729005370844)', 'major', 'Salt Lake City Int''l', 'KSLC', 'SLC'),
(822, 'POINT (-90.36595453506747 38.742716315520354)', 'major', 'Lambert St Louis Int''l', 'KSTL', 'STL'),
(823, 'POINT (20.97272633835865 52.171026749259035)', 'major', 'Okecie Int''l', 'EPWA', 'WAW'),
(824, 'POINT (8.562212795347646 47.45238950649155)', 'major', 'Zurich Int''l', 'LSZH', 'ZRH'),
(825, 'POINT (4.454373629816502 50.45712965495668)', 'mid', 'Gosselies', 'EBCI', 'CRL'),
(826, 'POINT (11.769482859365427 48.349796407837665)', 'major', 'Munich Freight Terminal', 'EDDMf', 'MUCf'),
(827, 'POINT (2.078003349812917 41.30315527974634)', 'major', 'Barcelona', 'LEBL', 'BCN'),
(828, 'POINT (14.267484985407632 50.10765117036714)', 'major', 'Ruzyn', 'LKPR', 'PRG'),
(829, 'POINT (113.93501638737635 22.315332828086753)', 'major', 'Hong Kong Int''l', 'VHHH', 'HKG'),
(830, 'POINT (121.23137045332327 25.076741104334637)', 'major', 'Taoyuan', 'RCTP', 'TPE'),
(831, 'POINT (4.764376932328117 52.30893238898217)', 'major', 'Schiphol', 'EHAM', 'AMS'),
(832, 'POINT (103.98641388099333 1.3561608352812635)', 'major', 'Singapore Changi', 'WSSS', 'SIN'),
(833, 'POINT (-0.4531566520633094 51.47099587999384)', 'major', 'London Heathrow', 'EGLL', 'LHR'),
(834, 'POINT (174.79171943371517 -37.00635511428146)', 'major', 'Auckland Int''l', 'NZAA', 'AKL'),
(835, 'POINT (-149.9817251006328 61.17289367453669)', 'major', 'Anchorage Int''l', 'PALH', 'ANC'),
(836, 'POINT (-84.42539743360473 33.64052908073521)', 'major', 'Hartsfield-Jackson Atlanta Int''l', 'KATL', 'ATL'),
(837, 'POINT (116.58817400466103 40.07876633633102)', 'major', 'Beijing Capital', 'ZBAA', 'PEK'),
(838, 'POINT (-74.14337180010278 4.69883276192097)', 'major', 'Eldorado Int''l', 'SKBO', 'BOG'),
(839, 'POINT (72.87456395000508 19.095101948840245)', 'major', 'Chhatrapati Shivaji Int''l', 'VABB', 'BOM'),
(840, 'POINT (-71.01640661729584 42.366565819850564)', 'major', 'Gen E L Logan Int''l', 'KBOS', 'BOS'),
(841, 'POINT (-76.66864283524481 39.17939435835678)', 'major', 'Baltimore-Washington Int''l Thurgood Marshall', 'KBWI', 'BWI'),
(842, 'POINT (31.39974300671137 30.11199043855749)', 'major', 'Cairo Int''l', 'HECA', 'CAI'),
(843, 'POINT (-7.663218807711428 33.56278838510788)', 'mid', 'Casablanca-Anfa', 'GMMC', 'CAS'),
(844, 'POINT (-67.00574880763165 10.597354914606406)', 'mid', 'Simon Bolivar Int''l', 'SVMI', 'CCS'),
(845, 'POINT (18.597656508313793 -33.97044661203954)', 'major', 'Cape Town Int''l', 'FACT', 'CPT'),
(846, 'POINT (103.95613648169501 30.581071264746427)', 'major', 'Chengdushuang Liu', 'ZUUU', 'CTU'),
(847, 'POINT (77.0878362565332 28.559203976058605)', 'major', 'Indira Gandhi Int''l', 'VIDP', 'DEL'),
(848, 'POINT (-104.67379733854197 39.84946138815095)', 'major', 'Denver Int''l', 'KDEN', 'DEN'),
(849, 'POINT (-97.04037107411442 32.90015055948155)', 'major', 'Dallas-Ft. Worth Int''l', 'KDFW', 'DFW'),
(850, 'POINT (100.60257862650514 13.920276601034733)', 'major', 'Don Muang Int''l', 'VTBD', 'DMK'),
(851, 'POINT (55.35407691722429 25.25256559381816)', 'major', 'Dubai Int''l', 'OMDB', 'DXB'),
(852, 'POINT (-74.1771472796706 40.69047982789292)', 'major', 'Newark Int''l', 'KEWR', 'EWR'),
(853, 'POINT (-58.54124569393822 -34.81364693803232)', 'major', 'Ministro Pistarini Int''l', 'SAEZ', 'EZE'),
(854, 'POINT (-80.14525884651891 26.07170957468273)', 'major', 'Fort Lauderdale Hollywood Int''l', 'KFLL', 'FLL'),
(855, 'POINT (-95.33370479129466 29.9865909034907)', 'major', 'George Bush Intercontinental', 'KIAH', 'IAH'),
(856, 'POINT (28.8195493087893 40.977838817779705)', 'major', 'Ataturk Hava Limani', 'LTBA', 'IST'),
(857, 'POINT (28.23198856487408 -26.13209539948872)', 'major', 'OR Tambo Int''l', 'FAJS', 'JNB'),
(858, 'POINT (-134.5835730378724 58.358944104595075)', 'mid', 'Juneau Int''l', 'PAJN', 'JNU'),
(859, 'POINT (-118.40246854852198 33.94417425435857)', 'major', 'Los Angeles Int''l', 'KLAX', 'LAX'),
(860, 'POINT (9.279966296910612 45.46039384562522)', 'major', 'Linate', 'LIML', 'LIN'),
(861, 'POINT (144.84899809113125 -37.66994119678927)', 'major', 'Melbourne Int''l', 'YMML', 'MEL'),
(862, 'POINT (-99.08260795142392 19.435469572049442)', 'major', 'Lic Benito Juarez Int''l', 'MMMX', 'MEX'),
(863, 'POINT (121.00412208343747 14.506832376296721)', 'major', 'Ninoy Aquino Int''l', 'RPLL', 'MNL'),
(864, 'POINT (36.92508874903655 -1.330529643506341)', 'major', 'Jomo Kenyatta Int''l', 'HKJK', 'NBO'),
(865, 'POINT (-157.91978317375475 21.33202231502399)', 'major', 'Honolulu Int''l', 'PHNL', 'HNL'),
(866, 'POINT (-87.90513439065003 41.97652910238031)', 'major', 'Chicago O''Hare Int''l', 'KORD', 'ORD'),
(867, 'POINT (46.701829023464015 24.959031743651174)', 'major', 'King Khalid Int''l', 'OERK', 'RUH'),
(868, 'POINT (-70.79368601629741 -33.396833634259714)', 'major', 'Arturo Merino Benitez Int''l', 'SCEL', 'SCL'),
(869, 'POINT (-122.30228972292387 47.44358191272591)', 'major', 'Tacoma Int''l', 'KSEA', 'SEA'),
(870, 'POINT (-122.38347034444935 37.61702508680535)', 'major', 'San Francisco Int''l', 'KSFO', 'SFO'),
(871, 'POINT (121.34118378856714 31.187257431407843)', 'major', 'Hongqiao', 'ZSSS', 'SHA'),
(872, 'POINT (37.41596903484135 55.96644717251199)', 'major', 'Sheremtyevo', 'UUEE', 'SVO'),
(873, 'POINT (-79.61141932474486 43.68095951863564)', 'major', 'Toronto-Pearson Int''l', 'CYYZ', 'YYZ'),
(874, 'POINT (151.16606730560102 -33.936583205771655)', 'major', 'Kingsford Smith', 'YSSY', 'SYD'),
(875, 'POINT (24.968207866591406 60.31871589129821)', 'major', 'Helsinki Vantaa', 'EFHK', 'HEL'),
(876, 'POINT (2.5418677673945727 49.01442009693855)', 'major', 'Charles de Gaulle Int''l', 'LFPG', 'CDG'),
(877, 'POINT (13.2903090925074 52.55442870441009)', 'major', 'Berlin-Tegel Int''l', 'EDDT', 'TXL'),
(878, 'POINT (16.560767964212864 48.119756305253766)', 'major', 'Vienna Schwechat Int''l', 'LOWW', 'VIE'),
(879, 'POINT (8.571822869076076 50.05067708952074)', 'major', 'Frankfurt Int''l', 'EDDF', 'FRA'),
(880, 'POINT (12.250100897363827 41.795078630739425)', 'major', 'Leonardo da Vinci Int''l', 'LIRF', 'FCO'),
(881, 'POINT (135.4424752562494 34.790198084874866)', 'major', 'Osaka Int''l', 'RJOO', 'ITM'),
(882, 'POINT (126.80239286027584 37.55730053995078)', 'major', 'Gimpo Int''l', 'RKSS', 'GMP'),
(883, 'POINT (11.099103276258118 60.193578317138616)', 'major', 'Oslo Gardermoen', 'ENGM', 'OSL'),
(884, 'POINT (-47.92078851336254 -15.869998500282428)', 'major', 'Juscelino Kubitschek Int''l', 'SBBR', 'BSB'),
(885, 'POINT (-46.659115530219566 -23.626858827009997)', 'major', 'Congonhas Int''l', 'SBSP', 'CGH'),
(886, 'POINT (-43.248381379068306 -22.812343712500642)', 'major', 'Rio de Janeiro-Antonio Carlos Jobim Int''l', 'SBGL', 'GIG'),
(887, 'POINT (-3.569026654588628 40.46812827339225)', 'major', 'Madrid Barajas', 'LEMD', 'MAD'),
(888, 'POINT (-66.00422997575475 18.43807707349493)', 'major', 'Luis Munoz Marin', 'TJSJ', 'SJU'),
(889, 'POINT (17.930729901691585 59.65112033973721)', 'major', 'Arlanda', 'ESSA', 'ARN'),
(890, 'POINT (106.65429615117164 -6.126602955972902)', 'major', 'Soekarno-Hatta Int''l', 'WIII', 'CGK'),
(891, 'POINT (23.94711605540731 37.93623312992537)', 'major', 'Eleftherios Venizelos Int''l', 'LGAV', 'ATH');