forked from nperezg/biosounds
-
Notifications
You must be signed in to change notification settings - Fork 3
/
world_seas.sql
executable file
·126 lines (123 loc) · 17.5 KB
/
world_seas.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
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for world_seas
-- ----------------------------
DROP TABLE IF EXISTS `world_seas`;
CREATE TABLE `world_seas` (
`NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`ID` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`Longitude` double NULL DEFAULT NULL,
`Latitude` double NULL DEFAULT NULL,
`min_X` double NULL DEFAULT NULL,
`min_Y` double NULL DEFAULT NULL,
`max_X` double NULL DEFAULT NULL,
`max_Y` double NULL DEFAULT NULL,
`area` int NULL DEFAULT NULL,
`MRGID` int NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of world_seas
-- ----------------------------
INSERT INTO `world_seas` VALUES ('Rio de La Plata', '33', -56.84247798667, -35.11333788123, -59.76565611324, -36.35885643997, -54.94302365272, -31.52343749974, 31797, 4325);
INSERT INTO `world_seas` VALUES ('Bass Strait', '62A', 146.42429096113, -39.45051980549, 143.53250818354, -41.44027400004, 149.90946832485, -37.46079254144, 112699, 4366);
INSERT INTO `world_seas` VALUES ('Great Australian Bight', '62', 132.7165581317, -36.72591576597, 117.6141982382, -43.56601647135, 146.23115575344, -31.46366941901, 1326209, 4276);
INSERT INTO `world_seas` VALUES ('Tasman Sea', '63', 160.71079785092, -39.70105583435, 146.872614905, -50.86691606772, 175.28698494732, -30, 3344624, 4365);
INSERT INTO `world_seas` VALUES ('Mozambique Channel', '45A', 40.87724446624, -19.30409503319, 32.43062305431, -26.84240232943, 49.24198188587, -10.4988721851, 1394283, 4261);
INSERT INTO `world_seas` VALUES ('Savu Sea', '48o', 122.02723655193, -9.48015051562, 118.50227187567, -10.92259013673, 125.00513064876, -8.21398115161, 106234, 4343);
INSERT INTO `world_seas` VALUES ('Timor Sea', '48i', 128.00156683326, -11.20554251696, 122.85232097697, -15.79601156678, 132.93133914459, -8.18284022819, 434186, 4344);
INSERT INTO `world_seas` VALUES ('Bali Sea', '48l', 115.81207452734, -7.9326611757, 114.34016525782, -8.9986119269, 117.16574347039, -7.01308965696, 39916, 4340);
INSERT INTO `world_seas` VALUES ('Coral Sea', '64', 156.76782488293, -18.22433054841, 141.02158935467, -30.0000000002, 169.86540173121, -6.79288303852, 4125541, 4364);
INSERT INTO `world_seas` VALUES ('Flores Sea', '48j', 119.83979646101, -7.51231030745, 117.13333333333, -8.74396681751, 122.93890571583, -5.50762307604, 102816, 4341);
INSERT INTO `world_seas` VALUES ('Solomon Sea', '65', 154.32237104073, -8.71719340798, 146.94540274174, -11.88246655429, 162.34838012157, -4.83333382143, 744334, 4361);
INSERT INTO `world_seas` VALUES ('Arafura Sea', '48h', 136.95566140056, -10.51841719236, 130.75881290419, -18.00675225281, 142.19929325618, -2.90265762835, 1025736, 4347);
INSERT INTO `world_seas` VALUES ('Gulf of Boni', '48k', 120.88186976307, -4.26689300933, 120.18882274627, -5.61561383439, 121.86666536318, -2.58045268055, 33237, 4350);
INSERT INTO `world_seas` VALUES ('Java Sea', '48n', 112.05131157893, -5.19355809696, 104.52709722516, -7.81091411198, 119.48940670446, -1.54938614386, 566693, 4338);
INSERT INTO `world_seas` VALUES ('Ceram Sea', '48f', 130.26013582936, -2.76943767301, 125.9172686256, -5.27390359335, 134.03155374491, -1.18610954312, 161489, 4351);
INSERT INTO `world_seas` VALUES ('Bismarck Sea', '66', 147.35120078127, -3.55020054059, 141.99288690061, -5.96200334997, 152.87647640746, -1.07457447094, 345053, 4360);
INSERT INTO `world_seas` VALUES ('Banda Sea', '48g', 126.41786957078, -5.46594964819, 120.46672639518, -8.86454367625, 133.15140479912, -0.83590805521, 693842, 4349);
INSERT INTO `world_seas` VALUES ('Gulf of California', '60', -110.9747075795, 26.88455782617, -115.03601205391, 22.87876534474, -106.7850719686, 31.94955372772, 180703, 4314);
INSERT INTO `world_seas` VALUES ('Bay of Fundy', '25', -65.8060155567, 44.97985204212, -67.32397222534, 44.08801043556, -63.30470895745, 46.20259165768, 16034, 4289);
INSERT INTO `world_seas` VALUES ('Strait of Gibraltar', '28a', -5.68521917467, 35.97981274369, -6.03254911565, 35.77597653839, -5.2787053648, 36.18694186248, 1664, 3346);
INSERT INTO `world_seas` VALUES ('Alboran Sea', '28b', -3.32409719195, 35.91213990654, -5.35376381835, 35.07066845868, -1.18826270086, 36.841517806, 54711, 3324);
INSERT INTO `world_seas` VALUES ('Caribbean Sea', '27', -74.67801130419, 15.31030445709, -89.41292977359, 7.70979893208, -59.42160093753, 22.70652472953, 2852792, 4287);
INSERT INTO `world_seas` VALUES ('Gulf of Alaska', '58', -149.05089788877, 57.90710494826, -163.35763296168, 54.29833316814, -136.61806464177, 61.549499631, 415503, 4312);
INSERT INTO `world_seas` VALUES ('Bering Sea', '55', -40.8240373035, 58.2966091583, -156.22572875, 51.3507886089, 161.823778153, 66.56286, 2336912, 4310);
INSERT INTO `world_seas` VALUES ('Chukchi Sea', '12', -156.973001038, 69.3433666405, -156.479905844, 65.9343791651, 177.478756114, 71.7113098691, 346259, 4257);
INSERT INTO `world_seas` VALUES ('Beaufort Sea', '13', -136.82924749189, 72.13923071101, -156.66489112353, 67.59654724626, -122.65277135381, 76.36291547159, 431132, 4256);
INSERT INTO `world_seas` VALUES ('Labrador Sea', '15A', -53.47754799213, 55.87120192359, -64.30595421791, 47.38595855195, -43.67489338154, 60.39875495418, 866470, 4291);
INSERT INTO `world_seas` VALUES ('Hudson Strait', '16A', -71.45006823165, 61.87021735795, -80.95156443318, 55.84477257729, -64.43224079891, 64.9799778462, 200039, 4251);
INSERT INTO `world_seas` VALUES ('Davis Strait', '15', -58.17611330843, 64.71774818317, -70.14320135106, 59.89154183839, -44.46176493201, 70.07213914361, 749737, 4250);
INSERT INTO `world_seas` VALUES ('Baffin Bay', '14A', -67.12170640601, 74.506107604, -82.20379316792, 69.61698794384, -50.52326631539, 82.44975286583, 529960, 4253);
INSERT INTO `world_seas` VALUES ('Lincoln Sea', '17A', -53.19784428158, 82.83077860791, -70.19538038922, 81.49583387353, -37.00547444819, 83.56190926063, 35262, 4254);
INSERT INTO `world_seas` VALUES ('Bristol Channel', '20', -4.01935441169, 51.39222851462, -4.92431735966, 50.98893535109, -2.34539175033, 51.81888794922, 5748, 3141);
INSERT INTO `world_seas` VALUES ('Irish Sea and St. George\'s Channel', '19', -4.79817510558, 53.4459472219, -6.56905257671, 51.90413734476, -2.63917434252, 55.00417602071, 45922, 2357);
INSERT INTO `world_seas` VALUES ('Inner Seas off the West Coast of Scotland', '18', -6.43991071135, 56.40539933626, -8.24960118869, 54.33640234359, -4.45862984669, 58.62454384285, 44260, 4283);
INSERT INTO `world_seas` VALUES ('Gulf of Aden', '38', 47.6527871243, 12.5205639199, 42.51346206652, 10.37809920322, 51.28665992889, 15.21967667014, 263754, 4265);
INSERT INTO `world_seas` VALUES ('Gulf of Oman', '40', 58.91105531904, 24.49666927478, 56.26802194086, 22.4749455453, 61.78247284894, 25.94343067192, 111892, 4267);
INSERT INTO `world_seas` VALUES ('Red Sea', '37', 38.73504211248, 20.3157309608, 33.63937130978, 12.45626235033, 43.50552117856, 28.13954293736, 449811, 4264);
INSERT INTO `world_seas` VALUES ('Gulf of Aqaba', '36', 34.67930528945, 28.67600859434, 34.32734751727, 27.9000855922, 35.00137317153, 29.54945516592, 3555, 4263);
INSERT INTO `world_seas` VALUES ('Persian Gulf', '41', 52.04671763255, 26.80330729914, 47.70244097687, 23.95901381933, 57.3399815557, 31.18585503098, 244657, 4266);
INSERT INTO `world_seas` VALUES ('Ionian Sea', '28f', 18.62902944017, 38.01785115746, 15.0845692161, 36.40896639521, 23.22467541714, 40.52065920816, 171778, 3351);
INSERT INTO `world_seas` VALUES ('Tyrrhenian Sea', '28e', 12.14189540681, 40.11983476086, 8.64848077337, 37.80146145778, 16.22312212029, 44.10945737326, 217465, 3386);
INSERT INTO `world_seas` VALUES ('Adriatic Sea', '28g', 16.03558558981, 42.7293839579, 12.06522584, 39.74309780157, 20.02082765078, 45.8089137081, 139454, 3314);
INSERT INTO `world_seas` VALUES ('Gulf of Suez', '35', 33.21991139699, 28.54056389825, 32.34285390358, 27.45, 34.22776354528, 30.06816749337, 10438, 4262);
INSERT INTO `world_seas` VALUES ('Mediterranean Sea - Eastern Basin', '28B', 23.16774074437, 34.07506909285, 10.01584875592, 30.06808678052, 36.21572947504, 37.80146145778, 1173640, 4280);
INSERT INTO `world_seas` VALUES ('Aegean Sea', '28h', 25.17461340306, 37.85235867512, 22.53159654165, 35.10948944128, 28.33056116127, 41.09132552156, 191305, 3315);
INSERT INTO `world_seas` VALUES ('Sea of Marmara', '29', 28.15292137482, 40.67040224405, 26.17422051992, 39.99890852001, 29.94218587848, 41.23293495342, 11675, 3369);
INSERT INTO `world_seas` VALUES ('Singapore Strait', '46B', 103.95696616966, 1.25050208602, 103.34568774669, 1.07172334236, 104.5826405866, 1.70037245722, 2684, 4336);
INSERT INTO `world_seas` VALUES ('Celebes Sea', '48b', 121.93858111739, 3.71432642228, 116.71834194632, 0.80112254577, 125.61386502511, 7.85156249981, 457342, 4359);
INSERT INTO `world_seas` VALUES ('Malacca Strait', '46A', 99.19387592833, 4.99047865179, 95.44226152409, 0.85731550907, 103.51065042784, 8.45399510899, 195534, 4275);
INSERT INTO `world_seas` VALUES ('Sulu Sea', '48a', 120.16891107028, 8.61459838254, 116.739687204, 5.02009582651, 123.42047393323, 13.44519567329, 337029, 4358);
INSERT INTO `world_seas` VALUES ('Gulf of Thailand', '47', 101.84485132065, 9.71989293434, 99.13274204751, 5.39053523541, 105.36231124397, 13.72708570914, 297927, 4334);
INSERT INTO `world_seas` VALUES ('Eastern China Sea', '50', 125.21708986497, 29.13089135213, 118.47804582106, 24.05760752069, 131.1322036827, 33.37195920955, 761356, 4302);
INSERT INTO `world_seas` VALUES ('Seto Naikai or Inland Sea', '53', 132.98664239386, 34.07045353025, 130.83685406459, 33.19725811487, 135.66974997518, 34.86453080196, 18131, 4306);
INSERT INTO `world_seas` VALUES ('Philippine Sea', '56', 133.33255691183, 18.81115794782, 120.10013221916, 2.49832594399, 146.05334174632, 35.26312375066, 5641996, 4300);
INSERT INTO `world_seas` VALUES ('Yellow Sea', '51', 122.70217134725, 36.69709685735, 117.5162249802, 33.27603387876, 127.45887172195, 41.15916395195, 408198, 4303);
INSERT INTO `world_seas` VALUES ('Gulf of Riga', '1c', 23.38102817126, 57.93519159804, 21.72510475582, 56.80457985408, 24.61678564584, 59.21482083532, 18692, 2409);
INSERT INTO `world_seas` VALUES ('Baltic Sea', '1', 18.07523542985, 56.66584337902, 9.52227815476, 52.65351867675, 23.51168835184, 59.93861675286, 215863, 2401);
INSERT INTO `world_seas` VALUES ('Gulf of Finland', '1b', 29.61939076744, 60.53734872859, 22.91001232057, 59.21459424453, 37.46891355552, 62.91577494176, 57077, 2407);
INSERT INTO `world_seas` VALUES ('Gulf of Bothnia', '1a', 20.77188093442, 62.63224634388, 17.03891694506, 59.72087454752, 25.48657846422, 67.08058834048, 113419, 2402);
INSERT INTO `world_seas` VALUES ('White Sea', '8', 39.3148169263, 66.22301256939, 32.13250935053, 60.95104753991, 45.6715829374, 68.65684270321, 90531, 4248);
INSERT INTO `world_seas` VALUES ('East Siberian Sea', '11', 159.34407191534, 73.11534381183, 139.03176033527, 64.31535971208, 179.99999988165, 77.09713519169, 633057, 4244);
INSERT INTO `world_seas` VALUES ('South Atlantic Ocean', '32', -18.80876715914, -33.73239551445, -69.60083675371, -60, 20.00904913827, 0.07510554798, 40501812, 1914);
INSERT INTO `world_seas` VALUES ('Southern Ocean', '67', -26.63285800737, -68.03981889232, -180, -85.56249999978, 180, -60, 21695157, 1907);
INSERT INTO `world_seas` VALUES ('South Pacific Ocean', '61', -82.4547794492, -30.4571931405, -146.487909061, -60, 130.111292124, 3.39114419316, 76681173, 1910);
INSERT INTO `world_seas` VALUES ('Gulf of Tomini', '48d', 121.60633218528, -0.26655629489, 120.00502955877, -1.44053983684, 123.41022324561, 0.55528843441, 56739, 4355);
INSERT INTO `world_seas` VALUES ('Makassar Strait', '48m', 118.21399092595, -2.1114535648, 115.95454657067, -5.59564114484, 120.82833421185, 1.32499976463, 198117, 4339);
INSERT INTO `world_seas` VALUES ('Halmahera Sea', '48e', 128.98856643083, 0.03285997319, 127.54915278581, -1.68096824379, 130.93169725859, 2.48701016485, 75295, 4353);
INSERT INTO `world_seas` VALUES ('Molukka Sea', '48c', 126.0565172323, 0.67433266753, 123.29315797331, -1.8388217995, 128.56640471932, 4.48598754369, 221671, 4354);
INSERT INTO `world_seas` VALUES ('Indian Ocean', '45', 79.20858601429, -32.72458381046, 20.00261595272, -60, 146.8982192222, 10.44499945636, 58230954, 1904);
INSERT INTO `world_seas` VALUES ('Bay of Bengal', '43', 87.45442549439, 13.17322167025, 78.89822006251, 5.73397101601, 95.04884011645, 24.37766897644, 2207565, 4273);
INSERT INTO `world_seas` VALUES ('South China Sea', '49', 112.30802222078, 11.77674997246, 102.2384721041, -3.22872316783, 122.15129880188, 25.5672843459, 3362904, 4332);
INSERT INTO `world_seas` VALUES ('Arabian Sea', '39', 63.99431793475, 13.33512865951, 51.02230715795, -0.70336914037, 74.335017443, 25.5973770618, 4241184, 4268);
INSERT INTO `world_seas` VALUES ('North Pacific Ocean', '57', -40.1574405109, 23.9623940894, -76.9854403734, 0.00000000002, 128.686531125, 58.211545022, 65154681, 1908);
INSERT INTO `world_seas` VALUES ('The Coastal Waters of Southeast Alaska and British Columbia', '59', -130.27032545934, 53.35057767286, -137.13016986804, 47.02382314232, -122.14991795975, 59.49716317664, 124532, 4313);
INSERT INTO `world_seas` VALUES ('Gulf of Mexico', '26', -90.37958525236, 24.94231562654, -98.05392181844, 17.40680801848, -80.43304073784, 31.46484375034, 1566759, 4288);
INSERT INTO `world_seas` VALUES ('North Atlantic Ocean', '23', -37.62424445723, 29.4800342448, -83.01491415486, -0.00256264235, 6.61996705678, 68.63871574364, 34507128, 1912);
INSERT INTO `world_seas` VALUES ('Gulf of St. Lawrence', '24', -61.5665673821, 48.380716031, -74.86481297044, 44.95849871674, -54.70344650725, 52.22241842777, 290874, 4290);
INSERT INTO `world_seas` VALUES ('Balearic (Iberian Sea)', '28c', 1.94994122114, 40.0832079791, -0.36589491382, 38.64731110912, 4.29021512693, 41.87484551501, 80078, 3322);
INSERT INTO `world_seas` VALUES ('Bay of Biscay', '22', -3.93513546256, 45.2244285966, -7.89681243874, 43.27442812915, -0.14624464477, 47.98778772322, 174437, 2359);
INSERT INTO `world_seas` VALUES ('Celtic Sea', '21A', -7.68357444004, 49.589876844, -11.5, 46.50056578772, -4.1380765434, 52.39568984501, 215080, 2351);
INSERT INTO `world_seas` VALUES ('Mediterranean Sea - Western Basin', '28A', 5.17693940631, 39.310519309, -2.19338870053, 35.57231724235, 12.42424750352, 43.92396748071, 476707, 4279);
INSERT INTO `world_seas` VALUES ('Hudson Bay', '16', -84.88911959576, 59.0358757132, -95.34616911381, 51.14358794663, -75.88437807569, 66.02642986893, 832649, 4252);
INSERT INTO `world_seas` VALUES ('The Northwestern Passages', '14', -98.52384039804, 72.6074820731, -128.00557497745, 63.75735831274, -69.09006786334, 81.70176401866, 1062173, 5698);
INSERT INTO `world_seas` VALUES ('Arctic Ocean', '17', -5.20258346295, 84.8648860275, -180, 71.38751180117, 180, 90, 5120993, 1906);
INSERT INTO `world_seas` VALUES ('English Channel', '21', -2.06339505792, 49.8612179473, -5.70872848068, 48.50002086187, 1.93090510399, 51.16600370667, 81419, 2389);
INSERT INTO `world_seas` VALUES ('Barentsz Sea', '7', 42.11782660718, 74.7239250592, 16.58178101778, 65.88276755848, 68.57826318668, 81.85123443572, 1408430, 4247);
INSERT INTO `world_seas` VALUES ('Greenland Sea', '5', -8.303164223, 74.2502716466, -35.986789942, 65.00696182253, 17.48220300686, 82.78065447116, 1186456, 2356);
INSERT INTO `world_seas` VALUES ('North Sea', '4', 2.73786023593, 56.4239952035, -4.44537067412, 50.99536466555, 12.00594234456, 61.01702284843, 524493, 2350);
INSERT INTO `world_seas` VALUES ('Andaman or Burma Sea', '44', 95.6617315106, 11.2014939692, 92.39042405001, 5.53430876708, 99.1397386786, 17.75390624997, 613099, 4274);
INSERT INTO `world_seas` VALUES ('Black Sea', '30', 34.1751334089, 43.2765240426, 27.44371211572, 40.90875351446, 42.35496044187, 47.31029641635, 423026, 3319);
INSERT INTO `world_seas` VALUES ('Sea of Azov', '31', 36.75425188453, 46.1630494553, 34.51633667909, 45.10090956338, 40.42968749968, 47.37639510645, 39547, 3320);
INSERT INTO `world_seas` VALUES ('Japan Sea', '52', 135.13274500727, 40.5084302428, 125.8013889, 32.57501368363, 142.2638347153, 51.74733316939, 1066307, 4307);
INSERT INTO `world_seas` VALUES ('Sea of Okhotsk', '54', 148.92540464929, 53.2338589852, 135.17187750324, 43.21659433816, 167.16820895628, 62.9154825209, 1613208, 4309);
INSERT INTO `world_seas` VALUES ('Kara Sea', '9', 77.39237760245, 75.4298831796, 54.93053400524, 64.43234801325, 107.60644340504, 81.26815920825, 896938, 4246);
INSERT INTO `world_seas` VALUES ('Laptev Sea', '10', 122.00656599958, 75.4936706147, 93.65715944795, 63.68782293808, 141.22509455677, 81.26895497331, 513667, 4245);
INSERT INTO `world_seas` VALUES ('Kattegat', '2', 11.30411886559, 56.3431976427, 9.36559641892, 54.63373190945, 13.06291067639, 58.07746934863, 35447, 2374);
INSERT INTO `world_seas` VALUES ('Laccadive Sea', '42', 75.18235087717, 6.93369732161, 71.98242, -0.69315814984, 80.58879327819, 14.79267025033, 846351, 4269);
INSERT INTO `world_seas` VALUES ('Skagerrak', '3', 9.64191545629, 58.1397547443, 6.99822115858, 57.09880185142, 11.91655933884, 59.91914391516, 32040, 2379);
INSERT INTO `world_seas` VALUES ('Norwegian Sea', '6', 4.56651077422, 68.2156500845, -13.50065481697, 60.86081802843, 25.78865038513, 76.56454739268, 1437096, 2353);
INSERT INTO `world_seas` VALUES ('Ligurian Sea', '28d', 8.91394655986, 43.7222954377, 7.53899633911, 42.86442416387, 9.85205805284, 44.42720294006, 16949, 3363);
INSERT INTO `world_seas` VALUES ('Gulf of Guinea', '34', 3.0508982376, 3.25469544082, -7.72633564497, -0.93603257151, 10.18268692506, 6.62269365749, 754844, 4286);
SET FOREIGN_KEY_CHECKS = 1;