forked from delight-im/FreeGeoDB
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ports.sql
1090 lines (1089 loc) · 56.5 KB
/
ports.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
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
CREATE TABLE IF NOT EXISTS `ports` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`coordinates_wkt` varchar(46) NOT NULL,
`name` varchar(29) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `ports` (`id`, `coordinates_wkt`, `name`) VALUES
(1, 'POINT (-69.92355713 12.4375)', 'Sint Nicolaas'),
(2, 'POINT (-58.95141343 -34.15333333)', 'Campana'),
(3, 'POINT (-59.004947 -34.09888889)', 'Zarate'),
(4, 'POINT (-62.10088339 -38.89444444)', 'Puerto Belgrano/Bahia Blanca'),
(5, 'POINT (-62.30053004 -38.78305556)', 'Puerto Galvan/Bahia Blanca'),
(6, 'POINT (-62.25989399 -38.79194444)', 'Ingeniero White/Bahia Blanca'),
(7, 'POINT (-61.85229682 17.12277778)', 'Saint John''s'),
(8, 'POINT (115.7381037 -32.0475)', 'Fremantle'),
(9, 'POINT (151.2095406 -33.97305556)', 'Botany Bay'),
(10, 'POINT (151.2842167 -23.85111111)', 'Rockhampton'),
(11, 'POINT (2.93368669 51.23)', 'Oostende (Ostend)'),
(12, 'POINT (3.20459364 51.33638889)', 'Zeebrugge'),
(13, 'POINT (27.45830389 42.47)', 'Burgas'),
(14, 'POINT (50.60759717 26.19861111)', 'Mina Sulman Port'),
(15, 'POINT (50.65883392 26.15861111)', 'Sitrah'),
(16, 'POINT (-64.67302709 32.37944444)', 'Saint George'),
(17, 'POINT (-38.47320377 -3.7075)', 'Mucuripe'),
(18, 'POINT (-43.1246172 -22.87916667)', 'Niteroi'),
(19, 'POINT (-48.63545347 -26.23805556)', 'Sao Francisco do Sul'),
(20, 'POINT (-65.46772674 47.03444444)', 'Chatham'),
(21, 'POINT (-53.95689046 48.16333333)', 'Clarenville'),
(22, 'POINT (-124.9244405 49.67083333)', 'Comox'),
(23, 'POINT (-123.4343934 48.43638889)', 'Esquimalt'),
(24, 'POINT (-55.75106007 47.10027778)', 'Grand Bank'),
(25, 'POINT (-60.2393404 46.20888889)', 'North Sydney'),
(26, 'POINT (-64.9246172 47.79638889)', 'Caraquet'),
(27, 'POINT (-71.05265018 48.43)', 'Chicoutimi'),
(28, 'POINT (-57.93633687 48.96055556)', 'Corner Brook'),
(29, 'POINT (-65.75229682 44.62527778)', 'Digby'),
(30, 'POINT (-53.21702002 47.69027778)', 'Harbour Grace'),
(31, 'POINT (-62.70441696 45.67472222)', 'Pictou'),
(32, 'POINT (-65.31772674 43.74972222)', 'Shelburne'),
(33, 'POINT (-73.11808009 46.04111111)', 'Sorel'),
(34, 'POINT (-56.05989399 49.49972222)', 'Springdale'),
(35, 'POINT (-52.69234393 47.5625)', 'Saint-John''s'),
(36, 'POINT (-73.15335689 -37.02833333)', 'Coronel'),
(37, 'POINT (-73.15848057 -37.09805556)', 'Lota'),
(38, 'POINT (-73.10229682 -36.70527778)', 'Talcahuano'),
(39, 'POINT (-71.61808009 -33.5875)', 'San Antonio'),
(40, 'POINT (121.4418139 28.69027778)', 'Haimen'),
(41, 'POINT (119.5859835 39.90666667)', 'Qinhuangdao'),
(42, 'POINT (114.26702 22.57416667)', 'Yantian'),
(43, 'POINT (122.2351001 40.69583333)', 'Yingkou'),
(44, 'POINT (-83.07408716 10.00555556)', 'Moin'),
(45, 'POINT (-75.70335689 20.91916667)', 'Banes'),
(46, 'POINT (-79.46931684 22.52916667)', 'Caibarien'),
(47, 'POINT (-80.00759717 22.94027778)', 'Isabela de Sagua'),
(48, 'POINT (-77.23951708 21.56305556)', 'Nuevitas'),
(49, 'POINT (33.94004711 35.12777778)', 'Famagusta'),
(50, 'POINT (8.707243816 53.86472222)', 'Cuxhaven'),
(51, 'POINT (9.835806832 54.47361111)', 'Eckernforde'),
(52, 'POINT (8.489517079 53.4875)', 'Nordenham'),
(53, 'POINT (7.368963486 53.09638889)', 'Papenburg'),
(54, 'POINT (11.43916372 53.90638889)', 'Wismar'),
(55, 'POINT (10.80689046 55.29888889)', 'Nyborg'),
(56, 'POINT (12.61702002 56.03444444)', 'Helsingor'),
(57, 'POINT (10.52497055 55.46638889)', 'Odense'),
(58, 'POINT (10.78810365 55.30694444)', 'Nyborg'),
(59, 'POINT (10.54146054 57.43777778)', 'Frederikshavn'),
(60, 'POINT (9.504416961 55.25111111)', 'Haderslev'),
(61, 'POINT (9.868433451 55.85416667)', 'Horsens'),
(62, 'POINT (11.08598351 55.66944444)', 'Kalundborg'),
(63, 'POINT (9.493404005 55.49277778)', 'Kolding'),
(64, 'POINT (11.12108363 54.83222222)', 'Nakskov'),
(65, 'POINT (11.85706714 54.77083333)', 'Nykobing Falster'),
(66, 'POINT (10.05265018 56.46027778)', 'Randers'),
(67, 'POINT (10.704947 54.93972222)', 'Rudkobing'),
(68, 'POINT (10.61702002 55.05861111)', 'Svendborg'),
(69, 'POINT (9.551943463 55.70555556)', 'Vejle'),
(70, 'POINT (10.58881037 57.71861111)', 'Skagen'),
(71, 'POINT (-70.70053004 19.80361111)', 'Puerto Plata'),
(72, 'POINT (-70.01808009 18.42027778)', 'Rio Haina'),
(73, 'POINT (0.071260306 35.93444444)', 'Mostaganem'),
(74, 'POINT (31.75918728 31.46666667)', 'Damietta'),
(75, 'POINT (33.94128386 26.74222222)', 'Safaga'),
(76, 'POINT (-5.400353357 36.14777778)', 'Algeciras'),
(77, 'POINT (-5.920023557 43.57861111)', 'Aviles'),
(78, 'POINT (-8.250883392 43.47972222)', 'Ferrol'),
(79, 'POINT (-6.935806832 37.19277778)', 'Huelva'),
(80, 'POINT (-1.918786808 43.32333333)', 'Pasajes'),
(81, 'POINT (-6.334570082 36.61944444)', 'Rota'),
(82, 'POINT (-6.258833922 36.52)', 'Cadiz'),
(83, 'POINT (26.9418139 60.46111111)', 'Kotka'),
(84, 'POINT (24.61666667 65.68305556)', 'Veitsiluoto'),
(85, 'POINT (-1.142343934 44.65916667)', 'Arcachon'),
(86, 'POINT (0.073380448 49.36583333)', 'Deauville'),
(87, 'POINT (0.369493522 49.76194444)', 'Fecamp'),
(88, 'POINT (-1.223910483 46.15722222)', 'La Pallice'),
(89, 'POINT (-2.022850412 48.64444444)', 'Saint-Malo'),
(90, 'POINT (3.71024735 43.40472222)', 'Sete'),
(91, 'POINT (-4.756713781 55.95472222)', 'Greenock'),
(92, 'POINT (-1.986513545 50.71444444)', 'Poole'),
(93, 'POINT (-5.053533569 50.15277778)', 'Falmouth'),
(94, 'POINT (-3.171790342 55.9825)', 'Leith'),
(95, 'POINT (-2.467903416 56.70444444)', 'Montrose'),
(96, 'POINT (-2.984746761 51.55888889)', 'Newport'),
(97, 'POINT (-1.356183746 54.90694444)', 'Sunderland'),
(98, 'POINT (-1.157067138 54.60805556)', 'Teesport'),
(99, 'POINT (41.65282686 42.155)', 'Poti'),
(100, 'POINT (23.6565371 37.93722222)', 'Piraeus'),
(101, 'POINT (23.63368669 37.94111111)', 'Piraeus'),
(102, 'POINT (23.64305065 37.93444444)', 'Piraeus'),
(103, 'POINT (-61.75053004 12.04722222)', 'Saint George''s'),
(104, 'POINT (-52.27196702 4.853055556)', 'Cayenne'),
(105, 'POINT (14.54075383 45.29972222)', 'Bakar'),
(106, 'POINT (13.63492344 45.08055556)', 'Rovinj'),
(107, 'POINT (15.89163722 43.72638889)', 'Sibenik'),
(108, 'POINT (-72.70371025 19.44833333)', 'Gonaives'),
(109, 'POINT (131.2425206 -0.876944444)', 'Sorong'),
(110, 'POINT (76.31042403 9.491944444)', 'Alleppey'),
(111, 'POINT (82.2746172 16.97777778)', 'Kakinada'),
(112, 'POINT (78.18704358 8.758333333)', 'Tuticorin'),
(113, 'POINT (-8.471260306 54.27166667)', 'Sligo'),
(114, 'POINT (13.93828033 37.09027778)', 'Licata'),
(115, 'POINT (8.30795053 40.56277778)', 'Alghero'),
(116, 'POINT (14.16007067 40.80333333)', 'Bagnoli'),
(117, 'POINT (16.28775029 41.32555556)', 'Barletta'),
(118, 'POINT (17.95600707 40.64638889)', 'Brindisi'),
(119, 'POINT (17.12338045 39.08611111)', 'Crotone'),
(120, 'POINT (17.97567727 40.05583333)', 'Gallipoli'),
(121, 'POINT (8.026914016 43.88277778)', 'Imperia'),
(122, 'POINT (9.409363958 41.21333333)', 'La Maddalena'),
(123, 'POINT (9.850353357 44.08722222)', 'La Spezia'),
(124, 'POINT (12.43545347 37.78972222)', 'Marsala'),
(125, 'POINT (15.55918728 38.20027778)', 'Messina'),
(126, 'POINT (16.58775029 41.20833333)', 'Molfetta'),
(127, 'POINT (13.55265018 45.78861111)', 'Monfalcone'),
(128, 'POINT (17.30035336 40.95611111)', 'Monopoli'),
(129, 'POINT (12.9024735 43.92083333)', 'Pesaro'),
(130, 'POINT (8.392167256 40.84361111)', 'Porto Torres'),
(131, 'POINT (12.25035336 44.46222222)', 'Ravenna'),
(132, 'POINT (15.28757362 37.06611111)', 'Siracusa'),
(133, 'POINT (17.18898704 40.48805556)', 'Taranto'),
(134, 'POINT (14.44287397 40.75)', 'Torre Annunziata'),
(135, 'POINT (129.9503534 32.90166667)', 'Omura'),
(136, 'POINT (135.3833333 34.69138889)', 'Amagasaki'),
(137, 'POINT (137.1084806 36.77583333)', 'Fushiki'),
(138, 'POINT (133.0061837 34.06805556)', 'Imabari'),
(139, 'POINT (132.2352768 34.17694444)', 'Iwakuni'),
(140, 'POINT (135.188457 34.15305556)', 'Kainan'),
(141, 'POINT (136.6065371 36.61694444)', 'Kanazawa'),
(142, 'POINT (139.7437574 35.50638889)', 'Kawasaki'),
(143, 'POINT (130.8735571 33.90833333)', 'Kokura'),
(144, 'POINT (135.3852768 35.48166667)', 'Maizuru'),
(145, 'POINT (136.5533569 34.60805556)', 'Matsusaka'),
(146, 'POINT (135.193404 35.54333333)', 'Miyazu'),
(147, 'POINT (140.9540636 42.33583333)', 'Muroran'),
(148, 'POINT (139.1247939 37.955)', 'Niigata'),
(149, 'POINT (131.8693168 33.25138889)', 'Saganoseki'),
(150, 'POINT (129.7077739 33.15694444)', 'Sasebo'),
(151, 'POINT (138.509894 35.01444444)', 'Shimizu'),
(152, 'POINT (135.1333333 34.11638889)', 'Shimotsu'),
(153, 'POINT (135.1270907 34.22305556)', 'Wakayama'),
(154, 'POINT (139.654417 35.30444444)', 'Yokosuka'),
(155, 'POINT (80.22497055 6.033333333)', 'Galle'),
(156, 'POINT (21.53704358 57.40305556)', 'Ventspils'),
(157, 'POINT (-92.65212014 18.53027778)', 'Frontera'),
(158, 'POINT (-94.53457008 17.97583333)', 'Minatitlan'),
(159, 'POINT (-94.40053004 18.1275)', 'Pajaritos'),
(160, 'POINT (-112.2584806 27.33916667)', 'Santa Rosalia'),
(161, 'POINT (-89.67055359 21.31361111)', 'Progreso'),
(162, 'POINT (-97.37055359 20.94055556)', 'Tuxpan'),
(163, 'POINT (103.4591873 4.249444444)', 'Kemaman'),
(164, 'POINT (4.78368669 52.95805556)', 'Den Helder'),
(165, 'POINT (4.651413428 51.80583333)', 'Dordrecht'),
(166, 'POINT (6.955477032 53.32055556)', 'Delfzijl'),
(167, 'POINT (8.757420495 58.45416667)', 'Arendal'),
(168, 'POINT (10.22497055 59.73666667)', 'Drammen'),
(169, 'POINT (11.37532391 59.11805556)', 'Halden'),
(170, 'POINT (16.54163722 68.78916667)', 'Harstad'),
(171, 'POINT (10.02550059 59.04527778)', 'Larvik'),
(172, 'POINT (10.65282686 59.43222222)', 'Moss'),
(173, 'POINT (10.22497055 59.12361111)', 'Sandefjord'),
(174, 'POINT (10.404947 59.265)', 'Tonsberg'),
(175, 'POINT (172.7102473 -43.60611111)', 'Lyttelton'),
(176, 'POINT (59.42055359 22.65666667)', 'Qalhat'),
(177, 'POINT (56.73792697 24.37833333)', 'Sohar'),
(178, 'POINT (-79.56878681 8.955555556)', 'Balboa'),
(179, 'POINT (-79.90477032 9.350277778)', 'Cristobal'),
(180, 'POINT (-82.43457008 8.365)', 'Pedregal'),
(181, 'POINT (-77.1418139 -12.04527778)', 'Callao'),
(182, 'POINT (-72.10424028 -16.99777778)', 'Matarani'),
(183, 'POINT (14.26861013 53.905)', 'Swinoujscie'),
(184, 'POINT (-8.692873969 41.185)', 'Leixoes'),
(185, 'POINT (-8.821436985 38.48972222)', 'Setubal'),
(186, 'POINT (-8.7196702 40.64361111)', 'Aveiro'),
(187, 'POINT (-8.823027091 41.68638889)', 'Viana do Castelo'),
(188, 'POINT (28.08386337 45.44166667)', 'Galati'),
(189, 'POINT (132.9075972 42.80472222)', 'Nakhodka'),
(190, 'POINT (32.404947 67.135)', 'Kandalaksha'),
(191, 'POINT (142.0400471 47.05055556)', 'Kholmsk'),
(192, 'POINT (142.7584806 46.62666667)', 'Korsakov'),
(193, 'POINT (29.76737338 59.98694444)', 'Kronshtadt'),
(194, 'POINT (132.8861602 42.8)', 'Nakhodka'),
(195, 'POINT (37.80441696 44.715)', 'Novorossiysk'),
(196, 'POINT (39.06666667 44.09194444)', 'Tuapse'),
(197, 'POINT (49.67090695 27.02861111)', 'Jubail'),
(198, 'POINT (49.67302709 27.08777778)', 'Jubail'),
(199, 'POINT (48.52249706 28.415)', 'Ras al Khafji'),
(200, 'POINT (12.47638398 56.88944444)', 'Falkenberg'),
(201, 'POINT (14.30547703 55.92555556)', 'Ahus'),
(202, 'POINT (17.93881037 62.64083333)', 'Harnosand'),
(203, 'POINT (12.54146054 56.19861111)', 'Hoganas'),
(204, 'POINT (14.85830389 56.1625)', 'Karlshamn'),
(205, 'POINT (15.58598351 56.16)', 'Karlskrona'),
(206, 'POINT (17.95812721 58.91333333)', 'Nynashamn'),
(207, 'POINT (16.47073027 57.265)', 'Oskarshamn'),
(208, 'POINT (17.10795053 58.66166667)', 'Oxelosund'),
(209, 'POINT (21.47037691 65.30888889)', 'Pitea'),
(210, 'POINT (17.65918728 59.16972222)', 'Sodertalje'),
(211, 'POINT (13.15159011 55.36805556)', 'Trelleborg'),
(212, 'POINT (11.90477032 58.34805556)', 'Uddevalla'),
(213, 'POINT (13.82073027 55.42138889)', 'Ystad'),
(214, 'POINT (100.5849234 13.69583333)', 'Bangkok'),
(215, 'POINT (100.8909305 13.07388889)', 'Laem Chabang'),
(216, 'POINT (100.9186101 13.17138889)', 'Sriracha'),
(217, 'POINT (-61.48951708 10.38833333)', 'Point Lisas'),
(218, 'POINT (34.64057715 36.79694444)', 'Mersin'),
(219, 'POINT (36.77320377 46.75138889)', 'Berdyansk'),
(220, 'POINT (36.48563015 45.355)', 'Kerch'),
(221, 'POINT (-122.3590106 37.91388889)', 'Richmond'),
(222, 'POINT (-75.51984688 39.71666667)', 'Wilmington'),
(223, 'POINT (-70.96896349 42.24138889)', 'Quincy'),
(224, 'POINT (-159.3530035 21.95388889)', 'Nawiliwili'),
(225, 'POINT (-121.888987 36.60555556)', 'Monterey'),
(226, 'POINT (-77.95265018 34.19194444)', 'Wilmington'),
(227, 'POINT (-75.12267373 39.90361111)', 'Gloucester City'),
(228, 'POINT (-74.1024735 40.6625)', 'Bayonne'),
(229, 'POINT (-76.55565371 39.2325)', 'Baltimore'),
(230, 'POINT (-81.55918728 30.38083333)', 'Jacksonville'),
(231, 'POINT (-76.4262073 36.98055556)', 'Newport News'),
(232, 'POINT (-93.95706714 29.84305556)', 'Port Arthur'),
(233, 'POINT (-76.28828033 36.81666667)', 'Portsmouth'),
(234, 'POINT (-77.95265018 34.19194444)', 'Wilmington'),
(235, 'POINT (-93.95706714 29.84305556)', 'Port Arthur'),
(236, 'POINT (-77.03722026 38.80111111)', 'Alexandria'),
(237, 'POINT (-76.4262073 36.98055556)', 'Newport News'),
(238, 'POINT (-122.6086572 47.65138889)', 'Brownsville'),
(239, 'POINT (-122.7038869 45.63472222)', 'Vancouver'),
(240, 'POINT (-64.59040047 10.24916667)', 'Guanta'),
(241, 'POINT (121.72583696694346 25.220760141757456)', 'Keelung'),
(242, 'POINT (-13.623954376704255 28.948964844057482)', 'Arrecife'),
(243, 'POINT (-64.92841530036452 18.332123222010704)', 'St Thomas'),
(244, 'POINT (-62.750002499299285 17.27882702118545)', 'Basseterre'),
(245, 'POINT (-90.05637124381114 29.93419996813862)', 'New Orleans'),
(246, 'POINT (-78.72766361581795 26.5384106344139)', 'Freeport'),
(247, 'POINT (-77.56 44.1)', 'Trenton'),
(248, 'POINT (-81.73 43.75)', 'Goderich'),
(249, 'POINT (-79.91 44.75)', 'Midland'),
(250, 'POINT (-86.48 42.11)', 'St Joseph'),
(251, 'POINT (-87.78 42.73)', 'Racine'),
(252, 'POINT (-87.6 45.1)', 'Menominee'),
(253, 'POINT (-87.05 45.76)', 'Escanaba'),
(254, 'POINT (-121.5 38.58)', 'Sacramento'),
(255, 'POINT (1.73 52.61)', 'Great Yarmouth'),
(256, 'POINT (-2.96 56.46)', 'Dundee'),
(257, 'POINT (-3.83 57.83)', 'Portmahomack Harbor'),
(258, 'POINT (-3.08 58.43)', 'Wick'),
(259, 'POINT (-5.46 56.41)', 'Oban'),
(260, 'POINT (-4.46 54.15)', 'Douglas'),
(261, 'POINT (-7.31 55)', 'Londonderry'),
(262, 'POINT (-3.4 54.86)', 'Silloth'),
(263, 'POINT (13.09375736 -7.833055556)', 'Ambriz'),
(264, 'POINT (12.19022379 -5.55)', 'Cabinda'),
(265, 'POINT (12.32037691 -6.121388889)', 'Soyo'),
(266, 'POINT (19.45300353 41.30777778)', 'Durres'),
(267, 'POINT (-68.91825677 12.11916667)', 'Curacao'),
(268, 'POINT (56.3565371 25.17833333)', 'Al Fujayrah'),
(269, 'POINT (-67.50848057 -46.43305556)', 'Caleta Olivia'),
(270, 'POINT (-65.9040636 -47.75555556)', 'Puerto Deseado'),
(271, 'POINT (-69.21825677 -51.61166667)', 'Rio Gallegos'),
(272, 'POINT (-67.7024735 -53.79444444)', 'Rio Grande'),
(273, 'POINT (-67.71896349 -49.29972222)', 'San Julian'),
(274, 'POINT (153.1414605 -30.3075)', 'Coffs Harbour'),
(275, 'POINT (121.893404 -33.87194444)', 'Esperance'),
(276, 'POINT (137.7567138 -32.48861111)', 'Port Augusta'),
(277, 'POINT (148.25053 -20.02083333)', 'Bowen'),
(278, 'POINT (152.388457 -24.76722222)', 'Bundaberg'),
(279, 'POINT (139.737927 -17.55361111)', 'Burketown'),
(280, 'POINT (113.642874 -24.895)', 'Carnarvon'),
(281, 'POINT (145.2437574 -15.45972222)', 'Cooktown'),
(282, 'POINT (123.6051237 -17.29222222)', 'Derby'),
(283, 'POINT (149.9053004 -37.07194444)', 'Eden'),
(284, 'POINT (146.8202002 -41.10972222)', 'George Town'),
(285, 'POINT (114.6007067 -28.77277778)', 'Geraldton'),
(286, 'POINT (140.8333333 -17.48944444)', 'Karumba'),
(287, 'POINT (137.6395171 -35.655)', 'Kingscote'),
(288, 'POINT (152.9060071 -25.295)', 'Maryborough'),
(289, 'POINT (145.3205536 -42.15833333)', 'Strahan'),
(290, 'POINT (89.58598351 22.48694444)', 'Mongla'),
(291, 'POINT (-37.03951708 -10.92527778)', 'Aracaju'),
(292, 'POINT (-38.52143698 -3.7175)', 'Fortaleza'),
(293, 'POINT (-51.04269729 0.032222222)', 'Macapa'),
(294, 'POINT (-48.65424028 -26.89888889)', 'Navegantes'),
(295, 'POINT (-52.3237338 -31.78194444)', 'Pelotas'),
(296, 'POINT (-125.2386337 50.03194444)', 'Campbell River'),
(297, 'POINT (-60.34234393 53.38444444)', 'Goose Bay'),
(298, 'POINT (-132.1411072 54.00666667)', 'Masset'),
(299, 'POINT (-67.57126031 48.84194444)', 'Matane'),
(300, 'POINT (-84.54305065 73.06861111)', 'Nanisivik'),
(301, 'POINT (-65.83492344 48.13861111)', 'New Richmond'),
(302, 'POINT (-127.4836867 50.72111111)', 'Port Hardy'),
(303, 'POINT (-61.35565371 45.61)', 'Port Hawkesbury'),
(304, 'POINT (-123.1666667 49.68305556)', 'Squamish'),
(305, 'POINT (-58.54075383 48.53527778)', 'Stephenville'),
(306, 'POINT (-129.9895171 55.92861111)', 'Stewart'),
(307, 'POINT (-126.6540636 49.9175)', 'Tahsis'),
(308, 'POINT (-131.8196702 53.25527778)', 'Sandspit'),
(309, 'POINT (-132.9858068 69.43138889)', 'Tuktoyaktuk'),
(310, 'POINT (-73.82567727 -41.86861111)', 'Ancud'),
(311, 'POINT (-73.76684335 -42.48277778)', 'Castro'),
(312, 'POINT (-70.6343934 -26.35055556)', 'Chanaral'),
(313, 'POINT (-72.50936396 -51.73111111)', 'Puerto Natales'),
(314, 'POINT (-70.48457008 -25.39722222)', 'Taltal'),
(315, 'POINT (113.6710836 22.64027778)', 'Guangzhou'),
(316, 'POINT (120.2212603 31.93194444)', 'Jiangyin'),
(317, 'POINT (119.4084806 34.74527778)', 'Lianyungang'),
(318, 'POINT (109.50053 18.23972222)', 'Sanya'),
(319, 'POINT (110.4063604 21.16972222)', 'Zhanjiang'),
(320, 'POINT (122.1026502 30.00333333)', 'Zhoushan'),
(321, 'POINT (-6.617020024 4.743055556)', 'San-Pedro'),
(322, 'POINT (-75.52567727 10.40333333)', 'Cartagena'),
(323, 'POINT (-75.5852768 9.520277778)', 'Tolu'),
(324, 'POINT (-78.75954064 1.813055556)', 'Tumaco'),
(325, 'POINT (-76.73386337 8.087777778)', 'Turbo'),
(326, 'POINT (-74.50229682 20.35305556)', 'Baracoa'),
(327, 'POINT (-75.55088339 20.71333333)', 'Nicaro'),
(328, 'POINT (-82.79322733 21.90333333)', 'Nueva Gerona'),
(329, 'POINT (7.891283863 54.1775)', 'Helgoland'),
(330, 'POINT (10.86825677 53.95222222)', 'Travemunde'),
(331, 'POINT (8.692167256 56.95277778)', 'Thisted'),
(332, 'POINT (-80.72090695 -0.935555556)', 'Manta'),
(333, 'POINT (-79.64269729 0.989444444)', 'Esmeraldas'),
(334, 'POINT (-13.85883392 28.74138889)', 'Corralejo'),
(335, 'POINT (-5.310424028 35.89027778)', 'Ceuta'),
(336, 'POINT (-2.922850412 35.28)', 'Melilla'),
(337, 'POINT (-17.10512367 28.08805556)', 'San Sebastian de la Gomera'),
(338, 'POINT (-17.76666667 28.67583333)', 'Santa Cruz de La Palma'),
(339, 'POINT (24.4746172 58.38111111)', 'Parnu'),
(340, 'POINT (27.68987044 62.88833333)', 'Kuopio'),
(341, 'POINT (29.77709069 62.60444444)', 'Joensuu'),
(342, 'POINT (27.87479388 62.3125)', 'Varkaus'),
(343, 'POINT (179.309364 -16.81777778)', 'Savusavu'),
(344, 'POINT (-1.620376914 49.64638889)', 'Cherbourg'),
(345, 'POINT (-0.326383981 49.19055556)', 'Caen'),
(346, 'POINT (8.755300353 42.56583333)', 'Calvi'),
(347, 'POINT (8.900353357 41.67694444)', 'Propriano'),
(348, 'POINT (-4.108127208 47.98944444)', 'Quimper'),
(349, 'POINT (-2.756360424 47.64388889)', 'Vannes'),
(350, 'POINT (138.1194935 9.513333333)', 'Yap'),
(351, 'POINT (-2.707773852 51.49888889)', 'Bristol'),
(352, 'POINT (-0.285100118 53.74361111)', 'Hull'),
(353, 'POINT (-1.590930506 54.965)', 'Newcastle upon Tyne'),
(354, 'POINT (-1.440930506 54.99444444)', 'Tyne'),
(355, 'POINT (0.685806832 51.43472222)', 'Rochester'),
(356, 'POINT (0.007420495 5.631944444)', 'Tema'),
(357, 'POINT (25.88916372 40.84138889)', 'Alexandroupolis'),
(358, 'POINT (27.28987044 36.89444444)', 'Kos'),
(359, 'POINT (25.15070671 37.08777778)', 'Paros'),
(360, 'POINT (26.96666667 37.75444444)', 'Samos'),
(361, 'POINT (-45.23810365 60.13972222)', 'Nanortalik'),
(362, 'POINT (-69.23510012 77.46694444)', 'Qaanaaq'),
(363, 'POINT (-57.52179034 6.237777778)', 'New Amsterdam'),
(364, 'POINT (-86.75689046 15.79388889)', 'La Ceiba'),
(365, 'POINT (-87.45583039 15.78388889)', 'Tela'),
(366, 'POINT (14.45759717 44.53833333)', 'Mali Losinj'),
(367, 'POINT (-72.53598351 18.23166667)', 'Jacmel'),
(368, 'POINT (-74.10706714 18.64361111)', 'Jeremie'),
(369, 'POINT (131.0203769 -1.3075)', 'Sorong'),
(370, 'POINT (97.14287397 5.166666667)', 'Lhokseumawe'),
(371, 'POINT (117.654947 4.145555556)', 'Nunukan'),
(372, 'POINT (105.3070671 -5.460277778)', 'Panjang'),
(373, 'POINT (106.8904005 -6.101388889)', 'Tanjung Priok'),
(374, 'POINT (74.80742049 12.92694444)', 'Mangalore'),
(375, 'POINT (69.58739694 21.63944444)', 'Porbandar'),
(376, 'POINT (73.27179034 17.00194444)', 'Ratnagiri'),
(377, 'POINT (-9.456183746 51.68055556)', 'Bantry'),
(378, 'POINT (-6.456183746 52.34111111)', 'Wexford'),
(379, 'POINT (48.18545347 30.4325)', 'Khorramshahr'),
(380, 'POINT (-14.28651355 64.66055556)', 'Djupivogur'),
(381, 'POINT (-14.00883392 64.92972222)', 'Faskrudsfjordur'),
(382, 'POINT (-15.94146054 66.45638889)', 'Raufarhofn'),
(383, 'POINT (11.93792697 36.83333333)', 'Pantelleria'),
(384, 'POINT (15.09093051 37.49583333)', 'Catania'),
(385, 'POINT (12.23545347 41.75583333)', 'Fiumicino'),
(386, 'POINT (12.6024735 35.49916667)', 'Lampedusa'),
(387, 'POINT (15.92532391 41.62416667)', 'Manfredonia'),
(388, 'POINT (-77.10671378 18.41027778)', 'Ocho Rios'),
(389, 'POINT (-76.45176678 18.18111111)', 'Port Antonio'),
(390, 'POINT (130.9856302 30.73166667)', 'Nishinoomote'),
(391, 'POINT (140.0398704 39.76222222)', 'Akita'),
(392, 'POINT (141.5235571 40.54583333)', 'Hachinohe'),
(393, 'POINT (124.1512367 24.33555556)', 'Ishigaki'),
(394, 'POINT (132.693404 33.85527778)', 'Matsuyama'),
(395, 'POINT (139.8035336 38.93944444)', 'Sakata'),
(396, 'POINT (134.0533569 34.35527778)', 'Takamatsu'),
(397, 'POINT (141.6891637 45.41055556)', 'Wakkanai'),
(398, 'POINT (134.187927 35.54027778)', 'Tottori'),
(399, 'POINT (40.90159011 -2.268055556)', 'Lamu'),
(400, 'POINT (126.5881037 35.95972222)', 'Gunsan'),
(401, 'POINT (129.4028269 36.01972222)', 'Pohang'),
(402, 'POINT (129.1882803 37.43361111)', 'Samcheok'),
(403, 'POINT (128.5923439 38.20694444)', 'Sokcho'),
(404, 'POINT (129.3856302 35.48777778)', 'Ulsan'),
(405, 'POINT (35.81914016 34.45527778)', 'Tripoli'),
(406, 'POINT (-10.05265018 5.858055556)', 'Buchanan'),
(407, 'POINT (13.19358068 32.9075)', 'Tripoli'),
(408, 'POINT (-9.634923439 30.42388889)', 'Agadir'),
(409, 'POINT (-3.919846879 35.24777778)', 'Al Hoceima'),
(410, 'POINT (-15.93386337 23.68222222)', 'Dakhla'),
(411, 'POINT (50.2762073 -14.9)', 'Antalaha'),
(412, 'POINT (48.01878681 -22.1425)', 'Manakara'),
(413, 'POINT (48.3262073 -21.24916667)', 'Mananjary'),
(414, 'POINT (44.27196702 -20.28861111)', 'Morondava'),
(415, 'POINT (49.42196702 -18.15722222)', 'Toamasina'),
(416, 'POINT (-111.3368669 26.01472222)', 'Loreto'),
(417, 'POINT (-90.59040047 19.8125)', 'Campeche'),
(418, 'POINT (-86.95742049 20.495)', 'Cozumel'),
(419, 'POINT (-110.310424 24.16944444)', 'La Paz'),
(420, 'POINT (-87.06772674 20.62444444)', 'Playa del Carmen'),
(421, 'POINT (-113.5423439 31.30611111)', 'Puerto Penasco'),
(422, 'POINT (-105.2409305 20.65916667)', 'Puerto Vallarta'),
(423, 'POINT (-94.41896349 18.12972222)', 'Coatzacoalcos'),
(424, 'POINT (94.72338045 16.77972222)', 'Bassein'),
(425, 'POINT (40.6671967 -14.54138889)', 'Nacala'),
(426, 'POINT (40.48492344 -12.96666667)', 'Pemba'),
(427, 'POINT (36.87709069 -17.88166667)', 'Quelimane'),
(428, 'POINT (57.48987044 -20.14805556)', 'Port Louis'),
(429, 'POINT (102.1233804 2.248888889)', 'Malacca'),
(430, 'POINT (101.7886337 2.536111111)', 'Port Dickson'),
(431, 'POINT (14.50053004 -22.94055556)', 'Walvis Bay'),
(432, 'POINT (8.316843345 4.986388889)', 'Calabar'),
(433, 'POINT (6.586866902 53.21833333)', 'Groningen'),
(434, 'POINT (23.23704358 69.96777778)', 'Alta'),
(435, 'POINT (16.1237338 69.32416667)', 'Andenes'),
(436, 'POINT (12.20194346 65.4725)', 'Bronnoysund'),
(437, 'POINT (6.789870436 58.08861111)', 'Farsund'),
(438, 'POINT (5.002826855 61.59777778)', 'Floro'),
(439, 'POINT (7.986336867 58.14194444)', 'Kristiansand'),
(440, 'POINT (11.49004711 64.46416667)', 'Namsos'),
(441, 'POINT (11.22691402 64.86055556)', 'Rorvik'),
(442, 'POINT (12.61878681 66.02166667)', 'Sandnessjoen'),
(443, 'POINT (14.90989399 68.56833333)', 'Stokmarknes'),
(444, 'POINT (5.501413428 59.78)', 'Stord'),
(445, 'POINT (174.004417 -41.28555556)', 'Picton'),
(446, 'POINT (170.5193168 -45.87583333)', 'Dunedin'),
(447, 'POINT (54.00318021 16.94166667)', 'Salalah'),
(448, 'POINT (62.33863369 25.11222222)', 'Gwadar'),
(449, 'POINT (-82.23757362 9.34)', 'Bocas del Toro'),
(450, 'POINT (-78.15106007 8.413611111)', 'La Palma'),
(451, 'POINT (-78.60777385 -9.076666667)', 'Chimbote'),
(452, 'POINT (-71.34375736 -17.64694444)', 'Ilo'),
(453, 'POINT (-72.01024735 -17.03111111)', 'Mollendo'),
(454, 'POINT (-76.22196702 -13.73305556)', 'Pisco'),
(455, 'POINT (123.3081272 9.311944444)', 'Dumaguete'),
(456, 'POINT (125.1542403 6.086111111)', 'General Santos'),
(457, 'POINT (154.671967 -5.431944444)', 'Buka'),
(458, 'POINT (143.2065371 -9.068333333)', 'Daru'),
(459, 'POINT (146.9847468 -6.741111111)', 'Lae'),
(460, 'POINT (145.8003534 -5.213333333)', 'Madang'),
(461, 'POINT (18.66878681 54.39333333)', 'Gdansk'),
(462, 'POINT (18.53845701 54.53333333)', 'Gdynia'),
(463, 'POINT (-67.15706714 18.42944444)', 'Aguadilla'),
(464, 'POINT (-66.70035336 18.48138889)', 'Arecibo'),
(465, 'POINT (-67.15689046 18.21388889)', 'Mayaguez'),
(466, 'POINT (-7.926030624 37.01055556)', 'Faro'),
(467, 'POINT (-151.75 -16.51666667)', 'Bora-Bora'),
(468, 'POINT (28.81684335 45.19111111)', 'Tulcea'),
(469, 'POINT (61.55918728 69.75611111)', 'Amderma'),
(470, 'POINT (177.5386337 64.74416667)', 'Anadyr'),
(471, 'POINT (170.2770907 69.70166667)', 'Pevek'),
(472, 'POINT (-16.07196702 14.12944444)', 'Kaolack'),
(473, 'POINT (-16.26808009 12.58972222)', 'Ziguinchor'),
(474, 'POINT (15.6237338 78.22611111)', 'Longyearbyen'),
(475, 'POINT (156.8388104 -8.101388889)', 'Gizo'),
(476, 'POINT (157.7260306 -8.499722222)', 'Viru Harbour'),
(477, 'POINT (42.54110718 -0.374166667)', 'Kismayu'),
(478, 'POINT (13.52020024 59.37527778)', 'Karlstad'),
(479, 'POINT (13.15936396 58.50916667)', 'Lidkoping'),
(480, 'POINT (21.25176678 64.67833333)', 'Skelleftea'),
(481, 'POINT (20.26772674 63.81666667)', 'Umea'),
(482, 'POINT (-72.25600707 21.76277778)', 'Providenciales'),
(483, 'POINT (100.5696702 7.228611111)', 'Songkhla'),
(484, 'POINT (27.95724382 40.35416667)', 'Bandirma'),
(485, 'POINT (36.34040047 41.29972222)', 'Samsun'),
(486, 'POINT (35.14287397 42.02333333)', 'Sinop'),
(487, 'POINT (39.73651355 41.00555556)', 'Trabzon'),
(488, 'POINT (33.54146054 44.61888889)', 'Sevastopol'),
(489, 'POINT (-135.3223204 59.45083333)', 'Skagway'),
(490, 'POINT (-146.3570671 61.10361111)', 'Valdez'),
(491, 'POINT (-84.98669022 29.7275)', 'Apalachicola'),
(492, 'POINT (-76.47426384 38.965)', 'Annapolis'),
(493, 'POINT (-76.07108363 38.57416667)', 'Cambridge'),
(494, 'POINT (-122.7836867 45.60583333)', 'Portland'),
(495, 'POINT (-122.6377503 47.5625)', 'Bremerton'),
(496, 'POINT (-69.10212014 44.10305556)', 'Rockland'),
(497, 'POINT (-122.0014134 36.96638889)', 'Santa Cruz'),
(498, 'POINT (-76.23951708 36.7225)', 'Chesapeake'),
(499, 'POINT (-64.18775029 10.47416667)', 'Cumana'),
(500, 'POINT (106.6751472 20.86722222)', 'Hai Phong'),
(501, 'POINT (19.910572060487087 39.621950140387334)', 'Corfu'),
(502, 'POINT (30.16765718634613 31.334923292880035)', 'Alexandria'),
(503, 'POINT (-5.824954241841614 35.79611353569427)', 'Tangier'),
(504, 'POINT (-79.85 43.25)', 'Hamilton'),
(505, 'POINT (-83.03 42.31)', 'Windsor'),
(506, 'POINT (-83.11 42.28)', 'Rouge River'),
(507, 'POINT (-80.93 44.58)', 'Owen Sound'),
(508, 'POINT (-84.35 46.51)', 'Sault Ste Marie'),
(509, 'POINT (-83.93 43.43)', 'Saginaw'),
(510, 'POINT (-84.46 45.65)', 'Cheboygan'),
(511, 'POINT (-84.35 46.5)', 'Sault Ste Marie'),
(512, 'POINT (-86.26 43.23)', 'Muskegon'),
(513, 'POINT (-87.33 41.61)', 'Gary'),
(514, 'POINT (-87.81 42.36)', 'Waukegan'),
(515, 'POINT (-88.56 47.11)', 'Houghton'),
(516, 'POINT (-132.38 56.46)', 'Wrangell'),
(517, 'POINT (-132.95 56.81)', 'Petersburg'),
(518, 'POINT (24.56 65.73)', 'Kemi'),
(519, 'POINT (21.58 63.1)', 'Vaasa'),
(520, 'POINT (22.23 60.45)', 'Turku'),
(521, 'POINT (21.01 56.51)', 'Liepaja'),
(522, 'POINT (4.11 51.95)', 'Europoort'),
(523, 'POINT (-6.36 58.18)', 'Stornoway Harbor'),
(524, 'POINT (-9.16 38.7)', 'Lisboa'),
(525, 'POINT (-6.33 36.8)', 'Bonanza'),
(526, 'POINT (1.45 38.9)', 'Ibiza'),
(527, 'POINT (39.71 47.16)', 'Rostov-Na-Donu'),
(528, 'POINT (34.76 32.06)', 'Tel Aviv Yafo'),
(529, 'POINT (10.25 36.8)', 'Tunis'),
(530, 'POINT (5.08 36.75)', 'Bejaia'),
(531, 'POINT (3.06 36.76)', 'Alger'),
(532, 'POINT (-16.51 16.01)', 'St Louis'),
(533, 'POINT (3.3 6.41)', 'Tin Can Island'),
(534, 'POINT (40.73 -15.03)', 'Mocambique'),
(535, 'POINT (42.75 13)', 'Assab'),
(536, 'POINT (39.46 15.61)', 'Massawa'),
(537, 'POINT (34.95 29.55)', 'Elat'),
(538, 'POINT (47.96 29.38)', 'Al Kuwayt'),
(539, 'POINT (72.83 18.83)', 'Bombay'),
(540, 'POINT (72.93 18.95)', 'Jawaharlal Nehru Port'),
(541, 'POINT (76.23 9.96)', 'Cochin'),
(542, 'POINT (80.3 13.1)', 'Madras'),
(543, 'POINT (88.31 22.55)', 'Calcutta'),
(544, 'POINT (98.4 7.83)', 'Phuket'),
(545, 'POINT (100.35 5.41)', 'Pulau Pinang'),
(546, 'POINT (98.68 3.78)', 'Belawan'),
(547, 'POINT (110.41 -6.95)', 'Semarang'),
(548, 'POINT (123.58 -10.16)', 'Kupang'),
(549, 'POINT (110.35 1.56)', 'Kuching'),
(550, 'POINT (113.96 4.38)', 'Miri'),
(551, 'POINT (116.06 5.98)', 'Kota Kinabalu'),
(552, 'POINT (118.11 5.83)', 'Pelabuhan Sandakan'),
(553, 'POINT (119.4 -5.13)', 'Ujungpandang'),
(554, 'POINT (125.61 7.06)', 'Davao'),
(555, 'POINT (118.75 32.08)', 'Nanjing'),
(556, 'POINT (114.28 30.58)', 'Hankow'),
(557, 'POINT (112.98 28.2)', 'Chang Sha'),
(558, 'POINT (135.16 48.5)', 'Khabarovsk'),
(559, 'POINT (158.65 53.05)', 'Petropavlovsk'),
(560, 'POINT (12.13545347 -15.19361111)', 'Namibe'),
(561, 'POINT (-62.27090695 -38.79138889)', 'Bahia Blanca'),
(562, 'POINT (-57.89022379 -34.85527778)', 'La Plata'),
(563, 'POINT (-68.30088339 -54.80944444)', 'Ushuaia'),
(564, 'POINT (-65.03333333 -42.73611111)', 'Puerto Madryn'),
(565, 'POINT (-170.687927 -14.27416667)', 'Pago Pago'),
(566, 'POINT (149.2237338 -21.10833333)', 'Mackay'),
(567, 'POINT (135.8694935 -34.71833333)', 'Port Lincoln'),
(568, 'POINT (138.0072438 -33.17694444)', 'Port Pirie'),
(569, 'POINT (117.8866902 -35.03166667)', 'Albany'),
(570, 'POINT (115.4709069 -20.72583333)', 'Barrow Island'),
(571, 'POINT (115.6512367 -33.31527778)', 'Bunbury'),
(572, 'POINT (145.9081272 -41.05277778)', 'Burnie'),
(573, 'POINT (144.3873969 -38.12666667)', 'Geelong'),
(574, 'POINT (151.2517668 -23.83)', 'Gladstone'),
(575, 'POINT (151.7691402 -32.9075)', 'Newcastle'),
(576, 'POINT (150.8935807 -34.4625)', 'Port Kembla'),
(577, 'POINT (141.609364 -38.34916667)', 'Portland'),
(578, 'POINT (142.2189635 -10.58555556)', 'Thursday Island'),
(579, 'POINT (146.8247939 -19.25083333)', 'Townsville'),
(580, 'POINT (141.8666667 -12.67)', 'Weipa'),
(581, 'POINT (137.5907538 -33.03833333)', 'Whyalla'),
(582, 'POINT (128.1008834 -15.45138889)', 'Wyndham'),
(583, 'POINT (4.386160188 50.88611111)', 'Brussel (Bruxelles)'),
(584, 'POINT (3.76737338 51.11444444)', 'Gent (Ghent)'),
(585, 'POINT (-39.02567727 -14.78027778)', 'Ilheus'),
(586, 'POINT (-35.72232038 -9.678888889)', 'Maceio'),
(587, 'POINT (-35.2 -5.783055556)', 'Natal'),
(588, 'POINT (-52.0762073 -32.05611111)', 'Rio Grande'),
(589, 'POINT (-40.33510012 -20.32333333)', 'Vitoria'),
(590, 'POINT (-127.6888104 52.35083333)', 'Ocean Falls'),
(591, 'POINT (-53.9868669 47.29305556)', 'Argentia'),
(592, 'POINT (-65.65 47.61666667)', 'Bathurst'),
(593, 'POINT (-64.43722026 48.82444444)', 'Gaspe'),
(594, 'POINT (-124.8193168 49.23)', 'Port Alberni'),
(595, 'POINT (-124.5247939 49.835)', 'Powell River'),
(596, 'POINT (-66.38386337 50.20638889)', 'Sept-Iles'),
(597, 'POINT (-60.20300353 46.14194444)', 'Sydney'),
(598, 'POINT (-72.53898704 46.33583333)', 'Trois-Rivieres (Three Rivers)'),
(599, 'POINT (-66.12090695 43.83555556)', 'Yarmouth'),
(600, 'POINT (-68.50812721 48.47777778)', 'Rimouski'),
(601, 'POINT (-69.56808009 47.84666667)', 'Riviere-du-Loup'),
(602, 'POINT (-55.57709069 51.36666667)', 'Saint-Anthony'),
(603, 'POINT (-63.78704358 46.38861111)', 'Summerside'),
(604, 'POINT (-70.32196702 -18.47305556)', 'Arica'),
(605, 'POINT (-70.20565371 -22.08611111)', 'Tocopilla'),
(606, 'POINT (109.0705536 21.45861111)', 'Beihai'),
(607, 'POINT (113.0019435 22.5025)', 'Jiangmen'),
(608, 'POINT (120.8847468 27.99833333)', 'Wenzhou'),
(609, 'POINT (121.388987 37.57111111)', 'Yantai'),
(610, 'POINT (113.5842167 22.23972222)', 'Zhuhai'),
(611, 'POINT (-74.21702002 11.25194444)', 'Santa Marta'),
(612, 'POINT (-77.05335689 3.883055556)', 'Buenaventura'),
(613, 'POINT (-23.50318021 14.94472222)', 'Praia'),
(614, 'POINT (-83.16666667 8.637777778)', 'Golfito'),
(615, 'POINT (-80.45371025 22.14)', 'Cienfuegos'),
(616, 'POINT (-77.13351001 20.3375)', 'Manzanillo'),
(617, 'POINT (-81.53704358 23.05138889)', 'Matanzas'),
(618, 'POINT (-75.85671378 20.00166667)', 'Santiago de Cuba'),
(619, 'POINT (7.192873969 53.34611111)', 'Emden'),
(620, 'POINT (9.436866902 54.80333333)', 'Flensburg'),
(621, 'POINT (8.122143698 53.53)', 'Wilhelmshaven'),
(622, 'POINT (8.433863369 55.46555556)', 'Esbjerg'),
(623, 'POINT (10.3868669 55.4175)', 'Odense'),
(624, 'POINT (9.776737338 54.90694444)', 'Sonderborg'),
(625, 'POINT (14.68775029 55.09611111)', 'Ronne'),
(626, 'POINT (-71.08651355 18.21222222)', 'Barahona'),
(627, 'POINT (-71.654947 17.92527778)', 'Cabo Rojo'),
(628, 'POINT (-0.636690224 35.7125)', 'Oran'),
(629, 'POINT (-8.387926973 43.36305556)', 'A Coruna'),
(630, 'POINT (-2.471260306 36.83222222)', 'Almeria'),
(631, 'POINT (-5.688633687 43.55861111)', 'Gijon'),
(632, 'POINT (-1.986866902 43.32277778)', 'San Sebastian'),
(633, 'POINT (-3.804946996 43.44222222)', 'Santander'),
(634, 'POINT (1.220200236 41.09611111)', 'Tarragona'),
(635, 'POINT (25.45459364 65.01583333)', 'Oulu'),
(636, 'POINT (-1.493757362 43.51972222)', 'Bayonne'),
(637, 'POINT (1.575500589 50.72361111)', 'Boulogne-sur-Mer'),
(638, 'POINT (-4.471436985 48.38055556)', 'Brest'),
(639, 'POINT (7.009187279 43.54805556)', 'Cannes'),
(640, 'POINT (-1.617550059 49.65222222)', 'Cherbourg'),
(641, 'POINT (1.08598351 49.92638889)', 'Dieppe'),
(642, 'POINT (-1.601060071 48.83472222)', 'Granville'),
(643, 'POINT (-1.157773852 46.14666667)', 'La Rochelle'),
(644, 'POINT (-3.352120141 47.73416667)', 'Lorient'),
(645, 'POINT (-3.834923439 48.58527778)', 'Morlaix'),
(646, 'POINT (-0.953003534 45.94916667)', 'Rochefort'),
(647, 'POINT (5.904770318 43.11055556)', 'Toulon'),
(648, 'POINT (9.500883392 0.288333333)', 'Owendo'),
(649, 'POINT (-2.074617197 57.14222222)', 'Aberdeen'),
(650, 'POINT (-3.007243816 53.43638889)', 'Liverpool'),
(651, 'POINT (-4.154063604 50.36472222)', 'Plymouth'),
(652, 'POINT (-1.1 50.8075)', 'Portsmouth'),
(653, 'POINT (41.65053004 41.64888889)', 'Batumi'),
(654, 'POINT (24.40194346 40.93138889)', 'Kavala'),
(655, 'POINT (26.13775029 38.37722222)', 'Chios'),
(656, 'POINT (22.10812721 37.02277778)', 'Kalamata'),
(657, 'POINT (21.73492344 38.25444444)', 'Patras'),
(658, 'POINT (22.93669022 39.35277778)', 'Volos'),
(659, 'POINT (-52.11914016 70.67472222)', 'Uummannaq'),
(660, 'POINT (-88.6040636 15.72833333)', 'Puerto Barrios'),
(661, 'POINT (13.83474676 44.87166667)', 'Pula'),
(662, 'POINT (14.42232038 45.3275)', 'Rijeka'),
(663, 'POINT (16.42550059 43.515)', 'Split'),
(664, 'POINT (114.5553004 -3.321944444)', 'Banjarmasin'),
(665, 'POINT (107.6270907 -2.75)', 'Tanjung Pandan'),
(666, 'POINT (92.72391048 11.67222222)', 'Port Blair'),
(667, 'POINT (70.22232038 23.01361111)', 'Kandla'),
(668, 'POINT (79.82232038 11.91416667)', 'Pondicherry'),
(669, 'POINT (-8.424440518 51.90111111)', 'Cork'),
(670, 'POINT (-9.043757362 53.27)', 'Galway'),
(671, 'POINT (50.8368669 28.98472222)', 'Bushehr'),
(672, 'POINT (13.49234393 43.61833333)', 'Ancona'),
(673, 'POINT (16.85530035 41.13694444)', 'Bari'),
(674, 'POINT (9.107597173 39.20416667)', 'Cagliari'),
(675, 'POINT (9.517903416 40.92277778)', 'Olbia'),
(676, 'POINT (14.2237338 42.46777778)', 'Pescara'),
(677, 'POINT (15.64375736 38.12444444)', 'Reggio Calabria'),
(678, 'POINT (12.50388693 38.01361111)', 'Trapani'),
(679, 'POINT (140.742874 40.83138889)', 'Aomori'),
(680, 'POINT (140.7090106 41.78777778)', 'Hakodate'),
(681, 'POINT (130.5687868 31.5925)', 'Kagoshima'),
(682, 'POINT (133.5570671 33.52416667)', 'Kochi'),
(683, 'POINT (144.3522968 42.98861111)', 'Kushiro'),
(684, 'POINT (133.2595406 33.97083333)', 'Niihama'),
(685, 'POINT (131.6760306 33.27222222)', 'Oita'),
(686, 'POINT (130.9010601 33.93444444)', 'Shimonoseki'),
(687, 'POINT (141.6533569 42.6375)', 'Tomakomai'),
(688, 'POINT (137.2226737 36.75722222)', 'Toyama'),
(689, 'POINT (131.2377503 33.93833333)', 'Ube'),
(690, 'POINT (40.12302709 -3.213611111)', 'Malindi'),
(691, 'POINT (81.20388693 8.558333333)', 'Trincomalee'),
(692, 'POINT (21.13421673 55.68722222)', 'Klaipeda'),
(693, 'POINT (-9.242697291 32.3075)', 'Safi'),
(694, 'POINT (-116.6228504 31.85083333)', 'Ensenada'),
(695, 'POINT (-110.8687868 27.91916667)', 'Guaymas'),
(696, 'POINT (-104.3008834 19.07055556)', 'Manzanillo'),
(697, 'POINT (-95.20194346 16.15722222)', 'Salina Cruz'),
(698, 'POINT (145.7349234 15.22583333)', 'Saipan'),
(699, 'POINT (-17.0418139 20.9075)', 'Nouadhibou'),
(700, 'POINT (15.15371025 -26.63777778)', 'Luderitz'),
(701, 'POINT (-83.75689046 12.01194444)', 'Bluefields'),
(702, 'POINT (6.171613663 62.4725)', 'Alesund'),
(703, 'POINT (29.71772674 70.63416667)', 'Batsfjord'),
(704, 'POINT (14.37267373 67.28888889)', 'Bodo'),
(705, 'POINT (23.67108363 70.66722222)', 'Hammerfest'),
(706, 'POINT (5.25565371 59.41222222)', 'Haugesund'),
(707, 'POINT (30.05565371 69.72833333)', 'Kirkenes'),
(708, 'POINT (7.733333333 63.115)', 'Kristiansund'),
(709, 'POINT (14.1237338 66.315)', 'Mo i Rana'),
(710, 'POINT (7.157420495 62.73638889)', 'Molde'),
(711, 'POINT (13.1868669 65.85194444)', 'Mosjoen'),
(712, 'POINT (17.41861013 68.43861111)', 'Narvik'),
(713, 'POINT (5.737220259 58.97888889)', 'Stavanger'),
(714, 'POINT (29.73757362 70.07111111)', 'Vadso'),
(715, 'POINT (31.10388693 70.37333333)', 'Vardo'),
(716, 'POINT (174.0377503 -39.05722222)', 'New Plymouth'),
(717, 'POINT (178.0224971 -38.6725)', 'Gisborne'),
(718, 'POINT (171.20053 -42.44472222)', 'Greymouth'),
(719, 'POINT (176.9180801 -39.475)', 'Napier'),
(720, 'POINT (176.1740872 -37.65944444)', 'Tauranga'),
(721, 'POINT (174.9895171 -39.94416667)', 'Wanganui'),
(722, 'POINT (171.5912839 -41.75027778)', 'Westport'),
(723, 'POINT (174.3426973 -35.75111111)', 'Whangarei'),
(724, 'POINT (171.2542403 -44.38916667)', 'Timaru'),
(725, 'POINT (-81.2746172 -4.573055556)', 'Talara'),
(726, 'POINT (123.6198469 12.36805556)', 'Masbate'),
(727, 'POINT (120.2747939 14.80833333)', 'Subic Bay'),
(728, 'POINT (150.4510601 -10.31277778)', 'Alotau'),
(729, 'POINT (150.7866902 -2.584722222)', 'Kavieng'),
(730, 'POINT (155.626914 -6.215277778)', 'Kieta'),
(731, 'POINT (152.1851001 -4.241111111)', 'Rabaul'),
(732, 'POINT (141.2923439 -2.683611111)', 'Vanimo'),
(733, 'POINT (-66.61024735 17.96805556)', 'Ponce'),
(734, 'POINT (-8.867020024 37.94277778)', 'Sines'),
(735, 'POINT (-28.62196702 38.53)', 'Horta'),
(736, 'POINT (40.55636042 64.5425)', 'Arkhangelsk'),
(737, 'POINT (33.04146054 68.9725)', 'Murmansk'),
(738, 'POINT (128.8728504 71.64305556)', 'Tiksi'),
(739, 'POINT (42.5352768 16.89027778)', 'Jizan'),
(740, 'POINT (45 10.44083333)', 'Berbera'),
(741, 'POINT (-57.00176678 5.951666667)', 'Nieuw Nickerie'),
(742, 'POINT (13.00159011 55.62555556)', 'Malmo'),
(743, 'POINT (17.19269729 60.68444444)', 'Gavle'),
(744, 'POINT (12.85 56.655)', 'Halmstad'),
(745, 'POINT (12.68757362 56.03333333)', 'Helsingborg'),
(746, 'POINT (17.11861013 61.72166667)', 'Hudiksvall'),
(747, 'POINT (16.36914016 56.65916667)', 'Kalmar'),
(748, 'POINT (18.72585395 63.27611111)', 'Ornskoldsvik'),
(749, 'POINT (15.3 56.17472222)', 'Ronneby'),
(750, 'POINT (17.0893404 61.30833333)', 'Soderhamn'),
(751, 'POINT (16.65194346 57.75583333)', 'Vastervik'),
(752, 'POINT (18.2746172 57.63555556)', 'Visby'),
(753, 'POINT (27.50795053 40.9675)', 'Tekirdag'),
(754, 'POINT (39.10318021 -5.065555556)', 'Tanga'),
(755, 'POINT (32.60742049 46.61861111)', 'Kherson'),
(756, 'POINT (-57.84216726 -34.47166667)', 'Colonia'),
(757, 'POINT (-145.7563604 60.55)', 'Cordova'),
(758, 'POINT (-131.6712603 55.34694444)', 'Ketchikan'),
(759, 'POINT (-68.76984688 44.79194444)', 'Bangor'),
(760, 'POINT (-121.3230271 37.95055556)', 'Stockton'),
(761, 'POINT (-73.17638398 41.1725)', 'Bridgeport'),
(762, 'POINT (-72.90954064 41.28638889)', 'New Haven'),
(763, 'POINT (-80.10865724 26.08444444)', 'Port Everglades'),
(764, 'POINT (-81.12249706 32.11083333)', 'Savannah'),
(765, 'POINT (-70.23951708 43.65333333)', 'Portland'),
(766, 'POINT (-89.08845701 30.35861111)', 'Gulfport'),
(767, 'POINT (-70.76861013 43.0875)', 'Portsmouth'),
(768, 'POINT (-74.13722026 40.7)', 'Newark'),
(769, 'POINT (-123.8262073 46.18944444)', 'Astoria'),
(770, 'POINT (-80.10865724 26.08444444)', 'Port Everglades'),
(771, 'POINT (-97.40459364 27.81277778)', 'Corpus Christi'),
(772, 'POINT (-88.53722026 30.35138889)', 'Pascagoula'),
(773, 'POINT (-122.4042403 47.26722222)', 'Tacoma'),
(774, 'POINT (-94.08421673 30.07777778)', 'Beaumont'),
(775, 'POINT (-122.9007067 47.05333333)', 'Olympia'),
(776, 'POINT (-123.4351001 48.13083333)', 'Port Angeles'),
(777, 'POINT (-122.7531802 48.11444444)', 'Port Townsend'),
(778, 'POINT (-67.99305065 10.47722222)', 'Puerto Cabello'),
(779, 'POINT (49.14375736 14.52222222)', 'Mukalla'),
(780, 'POINT (27.90477032 -33.02527778)', 'East London'),
(781, 'POINT (21.41825677 -34.37527778)', 'Mossel Bay'),
(782, 'POINT (32.05618375 -28.80472222)', 'Richards Bay'),
(783, 'POINT (-80.1 42.15)', 'Erie'),
(784, 'POINT (-83.86 43.6)', 'Bay City'),
(785, 'POINT (-87.88 43.03)', 'Milwaukee'),
(786, 'POINT (-124.21 43.36)', 'Coos Bay'),
(787, 'POINT (-135.33 57.05)', 'Sitka'),
(788, 'POINT (-152.4 57.78)', 'Kodiak'),
(789, 'POINT (13.56931684 -12.33694444)', 'Lobito'),
(790, 'POINT (54.37267373 24.525)', 'Abu Dhabi'),
(791, 'POINT (-67.45989399 -45.85583333)', 'Comodoro Rivadavia'),
(792, 'POINT (-57.53333333 -38.04277778)', 'Mar del Plata'),
(793, 'POINT (145.7755006 -16.92972222)', 'Cairns'),
(794, 'POINT (122.2091873 -18.0025)', 'Broome'),
(795, 'POINT (146.3675501 -41.16777778)', 'Devonport'),
(796, 'POINT (147.3358068 -42.88027778)', 'Hobart'),
(797, 'POINT (4.293757362 51.29777778)', 'Antwerpen'),
(798, 'POINT (27.88863369 43.19444444)', 'Varna'),
(799, 'POINT (-88.20194346 17.47972222)', 'Belize City'),
(800, 'POINT (-64.77638398 32.29111111)', 'Hamilton'),
(801, 'POINT (-48.48474676 -1.451666667)', 'Belem'),
(802, 'POINT (-48.51914016 -25.50083333)', 'Paranagua'),
(803, 'POINT (-51.22408716 -30.0175)', 'Porto Alegre'),
(804, 'POINT (-34.86896349 -8.053611111)', 'Recife'),
(805, 'POINT (-38.50477032 -12.95861111)', 'Salvador'),
(806, 'POINT (-46.30053004 -23.96888889)', 'Santos'),
(807, 'POINT (-63.11896349 46.23166667)', 'Charlottetown'),
(808, 'POINT (-63.57444052 44.65694444)', 'Halifax'),
(809, 'POINT (-123.926384 49.16944444)', 'Nanaimo'),
(810, 'POINT (-71.2090106 46.80583333)', 'Quebec'),
(811, 'POINT (-123.4065371 48.43111111)', 'Victoria'),
(812, 'POINT (-130.3370436 54.30972222)', 'Prince Rupert'),
(813, 'POINT (-66.05989399 45.26777778)', 'Saint-John'),
(814, 'POINT (-70.40371025 -23.65027778)', 'Antofagasta'),
(815, 'POINT (-70.15176678 -20.20277778)', 'Iquique'),
(816, 'POINT (-72.95441696 -41.48361111)', 'Puerto Montt'),
(817, 'POINT (110.2749706 20.02777778)', 'Haikou'),
(818, 'POINT (121.5533569 29.86666667)', 'Ningbo'),
(819, 'POINT (118.0200236 24.45)', 'Xiamen'),
(820, 'POINT (-3.966666667 5.233055556)', 'Abidjan'),
(821, 'POINT (9.685630153 4.055)', 'Douala'),
(822, 'POINT (11.82691402 -4.784444444)', 'Pointe Noire'),
(823, 'POINT (-74.75618375 10.96722222)', 'Barranquilla'),
(824, 'POINT (43.24322733 -11.70138889)', 'Moroni'),
(825, 'POINT (-82.75600707 23.00638889)', 'Mariel'),
(826, 'POINT (33.6393404 34.92416667)', 'Larnaca'),
(827, 'POINT (33.01772674 34.65)', 'Limassol'),
(828, 'POINT (8.751060071 53.0975)', 'Bremen'),
(829, 'POINT (9.958480565 53.52472222)', 'Hamburg'),
(830, 'POINT (43.13563015 11.60194444)', 'Djibouti'),
(831, 'POINT (10.00530035 57.06111111)', 'Aalborg'),
(832, 'POINT (9.74057715 55.55805556)', 'Fredericia'),
(833, 'POINT (-0.48828033 38.33527778)', 'Alicante'),
(834, 'POINT (-3.026914016 43.3425)', 'Bilbao'),
(835, 'POINT (-0.318433451 39.44416667)', 'Valencia'),
(836, 'POINT (-60.07073027 -51.95555556)', 'Fox Bay'),
(837, 'POINT (8.738810365 41.92)', 'Ajaccio'),
(838, 'POINT (9.451943463 42.7)', 'Bastia'),
(839, 'POINT (-0.553180212 44.86527778)', 'Bordeaux'),
(840, 'POINT (1.850176678 50.96583333)', 'Calais'),
(841, 'POINT (2.170906949 51.02166667)', 'Dunkerque'),
(842, 'POINT (0.235100118 49.42222222)', 'Honfleur'),
(843, 'POINT (9.43368669 0.400833333)', 'Libreville'),
(844, 'POINT (8.785276796 -0.711944444)', 'Port Gentil'),
(845, 'POINT (-5.891107185 54.62055556)', 'Belfast'),
(846, 'POINT (1.322143698 51.12083333)', 'Dover'),
(847, 'POINT (-4.234746761 57.48666667)', 'Inverness'),
(848, 'POINT (-1.738457008 4.884166667)', 'Takoradi'),
(849, 'POINT (-61.72709069 15.99638889)', 'Basse-Terre'),
(850, 'POINT (-61.53845701 16.23388889)', 'Pointe-a-Pitre'),
(851, 'POINT (-16.57037691 13.44444444)', 'Banjul'),
(852, 'POINT (9.738103651 1.824166667)', 'Bata'),
(853, 'POINT (25.14110718 35.34555556)', 'Iraklion'),
(854, 'POINT (22.91772674 40.635)', 'Thessaloniki'),
(855, 'POINT (-52.33616019 4.935277778)', 'Cayenne'),
(856, 'POINT (-52.62426384 5.158888889)', 'Kourou'),
(857, 'POINT (-58.1671967 6.819444444)', 'Georgetown'),
(858, 'POINT (-87.94022379 15.83333333)', 'Puerto Cortes'),
(859, 'POINT (15.21931684 44.1175)', 'Zadar'),
(860, 'POINT (113.9166667 -7.616666667)', 'Surabaya'),
(861, 'POINT (124.8258539 1.481944444)', 'Manado'),
(862, 'POINT (117.2166667 -1.05)', 'Senipah'),
(863, 'POINT (72.20600707 21.77)', 'Bhavnagar'),
(864, 'POINT (83.28722026 17.69333333)', 'Visakhapatnam'),
(865, 'POINT (-8.633333333 52.66277778)', 'Limerick'),
(866, 'POINT (56.20424028 27.14083333)', 'Bandar Abbas'),
(867, 'POINT (-21.83792697 64.14833333)', 'Reykjavik'),
(868, 'POINT (-14.00424028 65.26277778)', 'Seydisfjordur'),
(869, 'POINT (13.75424028 45.645)', 'Trieste'),
(870, 'POINT (132.421437 34.36527778)', 'Hiroshima'),
(871, 'POINT (135.2381037 34.68416667)', 'Kobe'),
(872, 'POINT (129.8595406 32.74027778)', 'Nagasaki'),
(873, 'POINT (141.0166667 43.19694444)', 'Otaru'),
(874, 'POINT (139.788457 35.62472222)', 'Tokyo'),
(875, 'POINT (-10.79375736 6.345555556)', 'Monrovia'),
(876, 'POINT (79.85017668 6.951388889)', 'Colombo'),
(877, 'POINT (-7.600176678 33.60888889)', 'Casablanca'),
(878, 'POINT (7.420906949 43.73194444)', 'Monaco'),
(879, 'POINT (-99.9024735 16.84444444)', 'Acapulco'),
(880, 'POINT (-106.393404 23.19222222)', 'Mazatlan'),
(881, 'POINT (-97.83368669 22.23694444)', 'Tampico'),
(882, 'POINT (34.83351001 -19.81916667)', 'Beira'),
(883, 'POINT (32.55706714 -25.97277778)', 'Maputo'),
(884, 'POINT (-16.02143698 18.03527778)', 'Nouakchott'),
(885, 'POINT (-62.21984688 16.70333333)', 'Plymouth'),
(886, 'POINT (-61.05689046 14.59916667)', 'Fort-de-France'),
(887, 'POINT (166.4258539 -22.25972222)', 'Noumea'),
(888, 'POINT (7.003180212 4.769166667)', 'Port Harcourt'),
(889, 'POINT (-87.16914016 12.48194444)', 'Corinto'),
(890, 'POINT (4.292873969 51.92722222)', 'Rotterdam'),
(891, 'POINT (5.3196702 60.39694444)', 'Bergen'),
(892, 'POINT (18.96878681 69.65583333)', 'Tromso'),
(893, 'POINT (10.38898704 63.43777778)', 'Trondheim'),
(894, 'POINT (173.271967 -41.25972222)', 'Nelson'),
(895, 'POINT (58.4090106 23.60666667)', 'Muscat'),
(896, 'POINT (123.9226737 10.30638889)', 'Cebu'),
(897, 'POINT (122.071437 6.902777778)', 'Zamboanga'),
(898, 'POINT (147.1510601 -9.467222222)', 'Port Moresby'),
(899, 'POINT (143.65053 -3.57)', 'Wewak'),
(900, 'POINT (-8.61861013 41.14111111)', 'Porto'),
(901, 'POINT (-25.65883392 37.73694444)', 'Ponta Delgada'),
(902, 'POINT (-149.5696702 -17.53111111)', 'Papeete'),
(903, 'POINT (51.55565371 25.29805556)', 'Doha'),
(904, 'POINT (20.45547703 54.7)', 'Kaliningrad'),
(905, 'POINT (131.8877503 43.09444444)', 'Vladivostok'),
(906, 'POINT (28.72638398 60.705)', 'Vyborg'),
(907, 'POINT (37.22161366 19.61583333)', 'Port Sudan'),
(908, 'POINT (45.34093051 2.028888889)', 'Mogadishu'),
(909, 'POINT (-55.13898704 5.82)', 'Paramaribo'),
(910, 'POINT (11.87002356 57.68916667)', 'Goteborg'),
(911, 'POINT (22.15830389 65.57888889)', 'Lulea'),
(912, 'POINT (16.22567727 58.61027778)', 'Norrkoping'),
(913, 'POINT (1.284923439 6.139166667)', 'Lome'),
(914, 'POINT (27.15388693 38.44388889)', 'Izmir'),
(915, 'POINT (120.3070671 22.56527778)', 'Kaohsiung'),
(916, 'POINT (120.5038869 24.25833333)', 'Taichung'),
(917, 'POINT (30.73704358 46.50111111)', 'Odessa'),
(918, 'POINT (-56.20424028 -34.90055556)', 'Montevideo'),
(919, 'POINT (-134.6700236 58.37916667)', 'Juneau'),
(920, 'POINT (-165.4251472 64.49833333)', 'Nome'),
(921, 'POINT (-155.0686101 19.73333333)', 'Hilo'),
(922, 'POINT (-122.5003534 48.74055556)', 'Bellingham'),
(923, 'POINT (-95.20212014 29.73916667)', 'Houston'),
(924, 'POINT (-97.38457008 25.95722222)', 'Brownsville'),
(925, 'POINT (-122.96702 46.11277778)', 'Longview'),
(926, 'POINT (-61.24287397 13.16916667)', 'Kingstown'),
(927, 'POINT (-66.94022379 10.60277778)', 'La Guaira'),
(928, 'POINT (-71.58828033 10.68361111)', 'Maracaibo'),
(929, 'POINT (108.2232038 16.08222222)', 'Da Nang'),
(930, 'POINT (168.3058304 -17.74722222)', 'Port Vila'),
(931, 'POINT (-171.7579505 -13.82833333)', 'Apia'),
(932, 'POINT (42.9352768 14.83361111)', 'Hodeidah'),
(933, 'POINT (-75.7 45.43)', 'Ottawa'),
(934, 'POINT (-78.88 42.88)', 'Buffalo'),
(935, 'POINT (-81.71 41.5)', 'Cleveland'),
(936, 'POINT (-88.01 44.51)', 'Green Bay'),
(937, 'POINT (-92.1 46.76)', 'Duluth'),
(938, 'POINT (-124.18 40.8)', 'Eureka'),
(939, 'POINT (13.25088339 -8.783888889)', 'Luanda'),
(940, 'POINT (-68.27355713 12.14833333)', 'Kralendijk, Bonaire'),
(941, 'POINT (-63.04375736 18.01444444)', 'Philipsburg'),
(942, 'POINT (138.5079505 -34.79916667)', 'Adelaide'),
(943, 'POINT (153.1684335 -27.3825)', 'Brisbane'),
(944, 'POINT (118.5732038 -20.3175)', 'Port Hedland'),
(945, 'POINT (91.82585395 22.26888889)', 'Chittagong'),
(946, 'POINT (-59.62408716 13.10694444)', 'Bridgetown'),
(947, 'POINT (-73.5246172 45.54361111)', 'Montreal'),
(948, 'POINT (-70.90477032 -53.16833333)', 'Punta Arenas'),
(949, 'POINT (-73.22656066 -39.81666667)', 'Valdivia'),
(950, 'POINT (121.6503534 38.93361111)', 'Dalian'),
(951, 'POINT (119.30053 26.0475)', 'Fuzhou'),
(952, 'POINT (120.31702 36.09583333)', 'Qingdao'),
(953, 'POINT (121.4872203 31.22194444)', 'Shanghai'),
(954, 'POINT (116.7040636 23.35472222)', 'Shantou'),
(955, 'POINT (-84.80424028 9.981666667)', 'Puntarenas'),
(956, 'POINT (10.15689046 54.33083333)', 'Kiel'),
(957, 'POINT (-61.38598351 15.29638889)', 'Roseau'),
(958, 'POINT (-69.87585395 18.47527778)', 'Santo Domingo'),
(959, 'POINT (-0.98598351 37.58944444)', 'Cartagena'),
(960, 'POINT (-8.726207303 42.2425)', 'Vigo'),
(961, 'POINT (-16.22656066 28.47472222)', 'Santa Cruz de Tenerife'),
(962, 'POINT (24.69075383 59.46)', 'Tallinn'),
(963, 'POINT (178.4210836 -18.1325)', 'Suva'),
(964, 'POINT (6.633333333 43.27055556)', 'Saint-Tropez'),
(965, 'POINT (-4.303180212 55.86305556)', 'Glasgow'),
(966, 'POINT (-1.424440518 50.9025)', 'Southampton'),
(967, 'POINT (-5.357243816 36.13694444)', 'Gibraltar'),
(968, 'POINT (-13.70989399 9.516388889)', 'Conakry'),
(969, 'POINT (-15.57267373 11.85833333)', 'Bissau'),
(970, 'POINT (24.00971731 35.51805556)', 'Canea'),
(971, 'POINT (21.31861013 37.64638889)', 'Katakolon'),
(972, 'POINT (-90.84128386 13.91555556)', 'San Jose'),
(973, 'POINT (114.1561837 22.32111111)', 'Hong Kong'),
(974, 'POINT (-72.33969376 18.56583333)', 'Port-au-Prince'),
(975, 'POINT (112.7239105 -7.206388889)', 'Surabaya'),
(976, 'POINT (-6.206007067 53.34444444)', 'Dublin');
INSERT INTO `ports` (`id`, `coordinates_wkt`, `name`) VALUES
(977, 'POINT (-7.118786808 52.26638889)', 'Waterford'),
(978, 'POINT (35.01825677 32.8225)', 'Haifa'),
(979, 'POINT (10.30194346 43.55583333)', 'Livorno'),
(980, 'POINT (13.93810365 40.74527778)', 'Ischia'),
(981, 'POINT (-76.82479388 17.98166667)', 'Kingston'),
(982, 'POINT (130.8542403 33.9225)', 'Kitakyushu'),
(983, 'POINT (39.6221437 -4.053055556)', 'Mombasa'),
(984, 'POINT (104.9209069 11.58305556)', 'Phnom Penh'),
(985, 'POINT (35.51949352 33.905)', 'Beirut'),
(986, 'POINT (73.50706714 4.175)', 'Male'),
(987, 'POINT (-96.13368669 19.20833333)', 'Veracruz'),
(988, 'POINT (96.16878681 16.76583333)', 'Yangon'),
(989, 'POINT (174.7898704 -41.2775)', 'Wellington'),
(990, 'POINT (14.58580683 53.43055556)', 'Szczecin'),
(991, 'POINT (39.1590106 21.45861111)', 'Jeddah'),