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