aboutsummaryrefslogtreecommitdiff
path: root/data/sql/area.sql
diff options
context:
space:
mode:
authorEven Rouault <even.rouault@spatialys.com>2019-01-21 21:31:55 +0100
committerEven Rouault <even.rouault@spatialys.com>2019-01-21 21:31:55 +0100
commit6a541b3a3926282ffc2e4bb20d2f6d78549572b5 (patch)
tree0985038279bd5f64c1fe6b4cc96345ca069358fb /data/sql/area.sql
parent24018433cf3b0b6600b68b09297e8f49b813fe7c (diff)
downloadPROJ-6a541b3a3926282ffc2e4bb20d2f6d78549572b5.tar.gz
PROJ-6a541b3a3926282ffc2e4bb20d2f6d78549572b5.zip
Update to EPSG 9.5.5
Diffstat (limited to 'data/sql/area.sql')
-rw-r--r--data/sql/area.sql27
1 files changed, 14 insertions, 13 deletions
diff --git a/data/sql/area.sql b/data/sql/area.sql
index 6de6cdbb..fba3c302 100644
--- a/data/sql/area.sql
+++ b/data/sql/area.sql
@@ -200,7 +200,7 @@ INSERT INTO "area" VALUES('EPSG','1220','St Pierre and Miquelon','St Pierre and
INSERT INTO "area" VALUES('EPSG','1221','Sudan','Sudan - onshore and offshore.',8.64,22.24,21.82,39.76,0);
INSERT INTO "area" VALUES('EPSG','1222','Suriname','Suriname - onshore and offshore.',1.83,9.35,-58.08,-52.66,0);
INSERT INTO "area" VALUES('EPSG','1223','Svalbard and Jan Mayen','Svalbard and Jan Mayen - onshore and offshore. Includes Bear Island.',66.24,85.05,-16.22,35.02,1);
-INSERT INTO "area" VALUES('EPSG','1224','Swaziland','Swaziland',-27.32,-25.72,30.79,32.14,0);
+INSERT INTO "area" VALUES('EPSG','1224','Eswatini','Eswatini (Swaziland).',-27.32,-25.72,30.79,32.14,0);
INSERT INTO "area" VALUES('EPSG','1225','Sweden','Sweden - onshore and offshore.',54.96,69.07,10.03,24.17,0);
INSERT INTO "area" VALUES('EPSG','1226','Switzerland','Switzerland.',45.82,47.81,5.96,10.49,0);
INSERT INTO "area" VALUES('EPSG','1227','Syria','Syria - onshore and offshore.',32.31,37.3,34.96,42.38,0);
@@ -266,7 +266,7 @@ INSERT INTO "area" VALUES('EPSG','1286','Europe - Liechtenstein and Switzerland'
INSERT INTO "area" VALUES('EPSG','1287','Indonesia - Banga & Belitung Islands','Indonesia - Banga and Belitung Islands.',-3.3,-1.44,105.07,108.35,0);
INSERT INTO "area" VALUES('EPSG','1288','Angola - Angola proper','Angola - Angola proper - onshore and offshore.',-18.02,-5.82,8.2,24.09,0);
INSERT INTO "area" VALUES('EPSG','1289','Canada - CGVD28','Canada - onshore - Alberta; British Columbia; Manitoba south of 57°N; New Brunswick; Northwest Territories south west of a line between 60°N, 110°W and the coast at 132°W; Nova Scotia; Ontario south of 52°N; Prince Edward Island; Quebec - mainland west of 66°W and south of 55°N; Saskatchewan south of 55°N; Yukon.',41.67,69.8,-141.01,-59.73,0);
-INSERT INTO "area" VALUES('EPSG','1290','Africa - Botswana, Lesotho, South Africa and Swaziland','Botswana; Lesotho; South Africa - mainland; Swaziland.',-34.88,-17.78,16.45,32.95,0);
+INSERT INTO "area" VALUES('EPSG','1290','Africa - Botswana, Eswatini, Lesotho and South Africa','Botswana; Eswatini (Swaziland); Lesotho; South Africa - mainland.',-34.88,-17.78,16.45,32.95,0);
INSERT INTO "area" VALUES('EPSG','1291','Asia - FSU - Caspian Sea','Azerbaijan - offshore; Kazakhstan - offshore; Russian Federation - Caspian Sea; Turkmenistan - offshore.',37.35,46.97,46.95,53.93,0);
INSERT INTO "area" VALUES('EPSG','1292','Argentina - Neuquen province','Argentina - Neuquen province.',-41.1,-36.14,-71.96,-68.01,0);
INSERT INTO "area" VALUES('EPSG','1293','Brazil - Corrego Alegre 1970-1972','Brazil - onshore - west of 54°W and south of 18°S; also south of 15°S between 54°W and 42°W; also east of 42°W.',-33.78,-2.68,-58.16,-34.74,0);
@@ -438,7 +438,7 @@ INSERT INTO "area" VALUES('EPSG','1458','South Africa - 22°E to 24°E','South A
INSERT INTO "area" VALUES('EPSG','1459','South Africa - 24°E to 26°E','South Africa - onshore between 24°E and 26°E.',-34.26,-24.71,24.0,26.01,0);
INSERT INTO "area" VALUES('EPSG','1460','South Africa - 26°E to 28°E','Lesotho - west of 28°E. South Africa - onshore between 26°E and 28°E.',-33.83,-22.92,26.0,28.0,0);
INSERT INTO "area" VALUES('EPSG','1461','South Africa - 28°E to 30°E','Lesotho - east of 28°E. South Africa - onshore between 28°E and 30°E.',-33.03,-22.13,27.99,30.0,0);
-INSERT INTO "area" VALUES('EPSG','1462','South Africa - 30°E to 32°E','South Africa - onshore between 30°E and 32°E. Swaziland.',-31.38,-22.22,29.99,32.02,0);
+INSERT INTO "area" VALUES('EPSG','1462','South Africa - 30°E to 32°E','South Africa - onshore between 30°E and 32°E. Eswatini (Swaziland).',-31.38,-22.22,29.99,32.02,0);
INSERT INTO "area" VALUES('EPSG','1463','South Africa - east of 32°E','South Africa - east of 32°E.',-28.94,-26.8,31.95,32.95,0);
INSERT INTO "area" VALUES('EPSG','1464','Iran - west of 48°E','Iran - west of 48°E.',30.99,39.78,44.03,48.0,0);
INSERT INTO "area" VALUES('EPSG','1465','Iran - 48°E to 54°E','Iran - onshore and offshore between 48°E and 54°E.',25.47,39.71,48.0,54.0,0);
@@ -457,7 +457,7 @@ INSERT INTO "area" VALUES('EPSG','1477','Libya - 22°E to 24°E onshore','Libya
INSERT INTO "area" VALUES('EPSG','1478','Libya - east of 24°E onshore','Libya - onshore east of 24°E.',19.99,32.15,24.0,25.21,0);
INSERT INTO "area" VALUES('EPSG','1479','Libya - west of 12°E onshore','Libya - onshore west of 12°E.',23.51,33.23,9.31,12.0,0);
INSERT INTO "area" VALUES('EPSG','1480','Libya - 12°E to 18°E onshore','Libya - onshore between 12°E and 18°E.',22.51,33.06,12.0,18.01,0);
-INSERT INTO "area" VALUES('EPSG','1481','Libya - 18°E to 24°E onshore','Libya - onshore between 18°E and 24°E.',19.5,33.0,18.0,24.0,0);
+INSERT INTO "area" VALUES('EPSG','1481','Libya - 18°E to 24°E onshore','Libya - onshore between 18°E and 24°E.',19.5,33.0,17.99,24.0,0);
INSERT INTO "area" VALUES('EPSG','1482','Libya - west of 15°E onshore','Libya - onshore west of 15°E.',22.61,33.23,9.31,15.0,0);
INSERT INTO "area" VALUES('EPSG','1483','Argentina - Neuquen province east of 70.5°W','Argentina - Neuquen province east of 70°30''W.',-40.54,-36.14,-70.51,-68.01,0);
INSERT INTO "area" VALUES('EPSG','1484','Argentina - Comodoro Rivadavia - west of 67.5°W','Argentina - Comodoro Rivadavia area west of 67°30''W.',-46.7,-45.19,-69.5,-67.5,0);
@@ -1047,7 +1047,7 @@ INSERT INTO "area" VALUES('EPSG','2067','World - S hemisphere - 18°E to 24°E -
INSERT INTO "area" VALUES('EPSG','2068','World - N hemisphere - 24°E to 30°E - by country','Between 24°E and 30°E, northern hemisphere between equator and 84°N, onshore and offshore. Belarus. Bulgaria. Central African Republic. Democratic Republic of the Congo (Zaire). Egypt. Estonia. Finland. Greece. Latvia. Lesotho. Libya. Lithuania. Moldova. Norway. Poland. Romania. Russian Federation. Sudan. Svalbard. Turkey. Uganda. Ukraine.',0.0,84.0,24.0,30.0,0);
INSERT INTO "area" VALUES('EPSG','2069','World - S hemisphere - 24°E to 30°E - by country','Between 24°E and 30°E, southern hemisphere between 80°S and equator, onshore and offshore. Botswana. Burundi. Democratic Republic of the Congo (Zaire). Rwanda. South Africa. Tanzania. Uganda. Zambia. Zimbabwe.',-80.0,0.0,24.0,30.0,0);
INSERT INTO "area" VALUES('EPSG','2070','World - N hemisphere - 30°E to 36°E - by country','Between 30°E and 36°E, northern hemisphere between equator and 84°N, onshore and offshore. Belarus. Cyprus. Egypt. Ethiopia. Finland. Israel. Jordan. Kenya. Lebanon. Moldova. Norway. Russian Federation. Saudi Arabia. Sudan. Syria. Turkey. Uganda. Ukraine.',0.0,84.0,30.0,36.0,0);
-INSERT INTO "area" VALUES('EPSG','2071','World - S hemisphere - 30°E to 36°E - by country','Between 30°E and 36°E, southern hemisphere between 80°S and equator, onshore and offshore. Burundi. Kenya. Malawi. Mozambique. Rwanda. South Africa. Swaziland. Tanzania. Uganda. Zambia. Zimbabwe.',-80.0,0.0,30.0,36.0,0);
+INSERT INTO "area" VALUES('EPSG','2071','World - S hemisphere - 30°E to 36°E - by country','Between 30°E and 36°E, southern hemisphere between 80°S and equator, onshore and offshore. Burundi. Eswatini (Swaziland). Kenya. Malawi. Mozambique. Rwanda. South Africa. Tanzania. Uganda. Zambia. Zimbabwe.',-80.0,0.0,30.0,36.0,0);
INSERT INTO "area" VALUES('EPSG','2072','World - N hemisphere - 36°E to 42°E - by country','Between 36°E and 42°E, northern hemisphere between equator and 84°N, onshore and offshore. Djibouti. Egypt. Eritrea. Ethiopia. Georgia. Iraq. Jordan. Kenya. Lebanon. Russian Federation. Saudi Arabia. Somalia. Sudan. Syria. Turkey. Ukraine.',0.0,84.0,36.0,42.0,0);
INSERT INTO "area" VALUES('EPSG','2073','World - S hemisphere - 36°E to 42°E - by country','Between 36°E and 42°E, southern hemisphere between 80°S and equator, onshore and offshore. Kenya. Mozambique. Tanzania.',-80.0,0.0,36.0,42.0,0);
INSERT INTO "area" VALUES('EPSG','2074','World - N hemisphere - 42°E to 48°E - by country','Between 42°E and 48°E, northern hemisphere between equator and 84°N, onshore and offshore. Armenia. Azerbaijan. Djibouti. Eritrea. Ethiopia. Georgia. Islamic Republic of Iran. Iraq. kazakhstan. Kuwait. Russian Federation. Saudi Arabia. Somalia. Turkey. Yemen.',0.0,84.0,42.0,48.0,0);
@@ -1288,7 +1288,7 @@ INSERT INTO "area" VALUES('EPSG','2308','Brazil - Tucano basin north','Brazil -
INSERT INTO "area" VALUES('EPSG','2309','Brazil - Tucano basin central','Brazil - Tucano basin central.',-10.61,-9.79,-39.14,-37.99,0);
INSERT INTO "area" VALUES('EPSG','2310','Brazil - Tucano basin south','Brazil - Tucano basin south.',-12.27,-10.6,-39.07,-37.98,0);
INSERT INTO "area" VALUES('EPSG','2311','Africa - Kenya and Tanzania','Kenya; Tanzania.',-11.75,4.63,29.34,41.91,0);
-INSERT INTO "area" VALUES('EPSG','2312','Africa - Botswana, Lesotho, Malawi, Swaziland, Zambia, Zimbabwe','Botswana; Lesotho; Malawi; Swaziland; Zambia; Zimbabwe.',-30.66,-8.19,19.99,35.93,0);
+INSERT INTO "area" VALUES('EPSG','2312','Africa - Botswana, Eswatini, Lesotho, Malawi, Zambia, Zimbabwe','Botswana; Eswatini (Swaziland); Lesotho; Malawi; Zambia; Zimbabwe.',-30.66,-8.19,19.99,35.93,0);
INSERT INTO "area" VALUES('EPSG','2313','Canada - Nova Scotia','Canada - Nova Scotia onshore.',43.41,47.08,-66.28,-59.73,0);
INSERT INTO "area" VALUES('EPSG','2314','Asia - FSU - Caspian states','Azerbaijan; Kazakhstan; Russian Federation; Turkmenistan - Caspian Sea.',35.15,81.85,26.0,90.0,1);
INSERT INTO "area" VALUES('EPSG','2315','Colombia - Cusiana','Colombia - Casanare province BP Cusiana/Cupiagua field areas. Also used by Total in Rivera and Gatanas blocks.',4.75,5.68,-73.0,-72.25,0);
@@ -1803,10 +1803,10 @@ INSERT INTO "area" VALUES('EPSG','2823','New Caledonia - Grande Terre - Noumea',
INSERT INTO "area" VALUES('EPSG','2824','Caribbean - French Antilles','French Antilles onshore and offshore - Guadeloupe (including Grande Terre, Basse Terre, Marie Galante, Les Saintes, Iles de la Petite Terre, La Desirade, St Barthélemy, and northern St Martin) and Martinique.',14.08,18.54,-63.66,-57.52,0);
INSERT INTO "area" VALUES('EPSG','2825','Africa - Ethiopia and Sudan - 30°E to 36°E','Ethiopia - west of 36°E. South Sudan - east of 30°E. Sudan - between 30°E and 36°E.',3.49,22.24,29.99,36.0,0);
INSERT INTO "area" VALUES('EPSG','2826','Africa - South Sudan and Sudan - west of 24°E','South Sudan and Sudan - west of 24°E.',8.7,15.76,21.82,24.01,0);
-INSERT INTO "area" VALUES('EPSG','2827','Africa - South Sudan and Sudan - 24°E to 30°E','South Sudan and Sudan - between 24°E and 30°E.',4.21,22.01,23.99,30.0,0);
+INSERT INTO "area" VALUES('EPSG','2827','Africa - South Sudan and Sudan - 24°E to 30°E','South Sudan and Sudan - between 24°E and 30°E.',4.21,22.01,23.99,30.01,0);
INSERT INTO "area" VALUES('EPSG','2828','Guadeloupe - St Martin and St Barthelemy - onshore','Guadeloupe - onshore - St Martin and St Barthélemy islands.',17.82,18.17,-63.21,-62.73,0);
INSERT INTO "area" VALUES('EPSG','2829','Guadeloupe - Grande-Terre and surrounding islands - onshore','Guadeloupe - onshore - Basse-Terre, Grande-Terre, La Desirade, Marie-Galante, Les Saintes.',15.8,16.55,-61.85,-60.97,0);
-INSERT INTO "area" VALUES('EPSG','2830','World (by country)','World: Afghanistan, Albania, Algeria, American Samoa, Andorra, Angola, Anguilla, Antarctica, Antigua and Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Barbados, Belgium, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bonaire, Saint Eustasius and Saba, Bosnia and Herzegovina, Botswana, Bouvet Island, Brazil, British Indian Ocean Territory, British Virgin Islands, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde, Cayman Islands, Central African Republic, Chad, Chile, China, Christmas Island, Cocos (Keeling) Islands, Comoros, Congo, Cook Islands, Costa Rica, Côte d''Ivoire (Ivory Coast), Croatia, Cuba, Curacao, Cyprus, Czech Republic, Denmark, Djibouti, Dominica, Dominican Republic, East Timor, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Falkland Islands (Malvinas), Faroe Islands, Fiji, Finland, France, French Guiana, French Polynesia, French Southern Territories, Gabon, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guadeloupe, Guam, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Heard Island and McDonald Islands, Holy See (Vatican City State), Honduras, China - Hong Kong, Hungary, Iceland, India, Indonesia, Islamic Republic of Iran, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jordan, Kazakhstan, Kenya, Kiribati, Democratic People''s Republic of Korea (North Korea), Republic of Korea (South Korea), Kuwait, Kyrgyzstan, Lao People''s Democratic Republic (Laos), Latvia, Lebanon, Lesotho, Liberia, Libyan Arab Jamahiriya, Liechtenstein, Lithuania, Luxembourg, China - Macao, The Former Yugoslav Republic of Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Martinique, Mauritania, Mauritius, Mayotte, Mexico, Federated States of Micronesia, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Myanmar (Burma), Namibia, Nauru, Nepal, Netherlands, New Caledonia, New Zealand, Nicaragua, Niger, Nigeria, Niue, Norfolk Island, Northern Mariana Islands, Norway, Oman, Pakistan, Palau, Panama, Papua New Guinea (PNG), Paraguay, Peru, Philippines, Pitcairn, Poland, Portugal, Puerto Rico, Qatar, Reunion, Romania, Russian Federation, Rwanda, Saint Kitts and Nevis, Saint Helena, Ascension and Tristan da Cunha, Saint Lucia, Saint Pierre and Miquelon, Saint Vincent and the Grenadines, Samoa, San Marino, Sao Tome and Principe, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia (Slovak Republic), Slovenia, Sint Maarten, Solomon Islands, Somalia, South Africa, South Georgia and the South Sandwich Islands, South Sudan, Spain, Sri Lanka, Sudan, Suriname, Svalbard and Jan Mayen, Swaziland, Sweden, Switzerland, Syrian Arab Republic, Taiwan, Tajikistan, United Republic of Tanzania, Thailand, The Democratic Republic of the Congo (Zaire), Togo, Tokelau, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, Tuvalu, Uganda, Ukraine, United Arab Emirates (UAE), United Kingdom (UK), United States (USA), United States Minor Outlying Islands, Uruguay, Uzbekistan, Vanuatu, Venezuela, Vietnam, US Virgin Islands, Wallis and Futuna, Western Sahara, Yemen, Zambia, Zimbabwe.',-90.0,90.0,-180.0,180.0,0);
+INSERT INTO "area" VALUES('EPSG','2830','World (by country)','World: Afghanistan, Albania, Algeria, American Samoa, Andorra, Angola, Anguilla, Antarctica, Antigua and Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Barbados, Belgium, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bonaire, Saint Eustasius and Saba, Bosnia and Herzegovina, Botswana, Bouvet Island, Brazil, British Indian Ocean Territory, British Virgin Islands, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde, Cayman Islands, Central African Republic, Chad, Chile, China, Christmas Island, Cocos (Keeling) Islands, Comoros, Congo, Cook Islands, Costa Rica, Côte d''Ivoire (Ivory Coast), Croatia, Cuba, Curacao, Cyprus, Czech Republic, Denmark, Djibouti, Dominica, Dominican Republic, East Timor, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Eswatini (Swaziland), Ethiopia, Falkland Islands (Malvinas), Faroe Islands, Fiji, Finland, France, French Guiana, French Polynesia, French Southern Territories, Gabon, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guadeloupe, Guam, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Heard Island and McDonald Islands, Holy See (Vatican City State), Honduras, China - Hong Kong, Hungary, Iceland, India, Indonesia, Islamic Republic of Iran, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jordan, Kazakhstan, Kenya, Kiribati, Democratic People''s Republic of Korea (North Korea), Republic of Korea (South Korea), Kuwait, Kyrgyzstan, Lao People''s Democratic Republic (Laos), Latvia, Lebanon, Lesotho, Liberia, Libyan Arab Jamahiriya, Liechtenstein, Lithuania, Luxembourg, China - Macao, The Former Yugoslav Republic of Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Martinique, Mauritania, Mauritius, Mayotte, Mexico, Federated States of Micronesia, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Myanmar (Burma), Namibia, Nauru, Nepal, Netherlands, New Caledonia, New Zealand, Nicaragua, Niger, Nigeria, Niue, Norfolk Island, Northern Mariana Islands, Norway, Oman, Pakistan, Palau, Panama, Papua New Guinea (PNG), Paraguay, Peru, Philippines, Pitcairn, Poland, Portugal, Puerto Rico, Qatar, Reunion, Romania, Russian Federation, Rwanda, Saint Kitts and Nevis, Saint Helena, Ascension and Tristan da Cunha, Saint Lucia, Saint Pierre and Miquelon, Saint Vincent and the Grenadines, Samoa, San Marino, Sao Tome and Principe, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia (Slovak Republic), Slovenia, Sint Maarten, Solomon Islands, Somalia, South Africa, South Georgia and the South Sandwich Islands, South Sudan, Spain, Sri Lanka, Sudan, Suriname, Svalbard and Jan Mayen, Sweden, Switzerland, Syrian Arab Republic, Taiwan, Tajikistan, United Republic of Tanzania, Thailand, The Democratic Republic of the Congo (Zaire), Togo, Tokelau, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, Tuvalu, Uganda, Ukraine, United Arab Emirates (UAE), United Kingdom (UK), United States (USA), United States Minor Outlying Islands, Uruguay, Uzbekistan, Vanuatu, Venezuela, Vietnam, US Virgin Islands, Wallis and Futuna, Western Sahara, Yemen, Zambia, Zimbabwe.',-90.0,90.0,-180.0,180.0,0);
INSERT INTO "area" VALUES('EPSG','2831','Canada - Atlantic offshore','Canada - offshore Newfoundland and Labrador, New Brunswick and Nova Scotia.',40.04,64.21,-67.75,-47.74,0);
INSERT INTO "area" VALUES('EPSG','2832','Canada - British Columbia','Canada - British Columbia.',48.25,60.01,-139.04,-114.08,0);
INSERT INTO "area" VALUES('EPSG','2833','Sweden - 12 00','Sweden - communes west of approximately 12°45''E and south of approximately 60°N. See information source for map.',56.74,60.13,10.93,13.11,0);
@@ -2247,7 +2247,7 @@ INSERT INTO "area" VALUES('EPSG','3267','Kuwait - onshore','Kuwait - onshore.',2
INSERT INTO "area" VALUES('EPSG','3268','Latvia - onshore','Latvia - onshore.',55.67,58.09,20.87,28.24,0);
INSERT INTO "area" VALUES('EPSG','3269','Lebanon - onshore','Lebanon - onshore.',33.06,34.65,35.04,36.63,0);
INSERT INTO "area" VALUES('EPSG','3270','Liberia - onshore','Liberia - onshore.',4.29,8.52,-11.52,-7.36,0);
-INSERT INTO "area" VALUES('EPSG','3271','Libya - onshore','Libya - onshore.',19.49,33.23,9.31,25.21,0);
+INSERT INTO "area" VALUES('EPSG','3271','Libya - onshore','Libya - onshore.',19.5,33.23,9.31,25.21,0);
INSERT INTO "area" VALUES('EPSG','3272','Lithuania - onshore','Lithuania - onshore.',53.89,56.45,20.86,26.82,0);
INSERT INTO "area" VALUES('EPSG','3273','Madagascar - onshore','Madagascar - onshore.',-25.64,-11.89,43.18,50.56,0);
INSERT INTO "area" VALUES('EPSG','3274','Maldives - onshore','Maldives - onshore.',-0.69,7.08,72.81,73.69,0);
@@ -2927,7 +2927,7 @@ INSERT INTO "area" VALUES('EPSG','3947','China - 120°E to 126°E','China - onsh
INSERT INTO "area" VALUES('EPSG','3948','China - 126°E to 132°E','China - onshore and offshore between 126°E and 132°E.',29.7,52.79,126.0,132.0,0);
INSERT INTO "area" VALUES('EPSG','3949','Libya - west of 12°E','Libya - west of 12°E, onshore and offshore.',23.51,33.92,9.31,12.0,0);
INSERT INTO "area" VALUES('EPSG','3950','Libya - 12°E to 18°E','Libya - between 12°E and 18°E, onshore and offshore.',22.51,35.23,12.0,18.0,0);
-INSERT INTO "area" VALUES('EPSG','3951','Libya - 18°E to 24°E','Libya - between 18°E and 24°E, onshore and offshore.',19.5,35.03,18.0,24.01,0);
+INSERT INTO "area" VALUES('EPSG','3951','Libya - 18°E to 24°E','Libya - between 18°E and 24°E, onshore and offshore.',19.5,35.03,17.99,24.01,0);
INSERT INTO "area" VALUES('EPSG','3952','Algeria - 6°W to 0°W','Algeria - between 6°W and 0°W (of Greenwich), onshore and offshore.',21.82,37.01,-6.0,0.0,0);
INSERT INTO "area" VALUES('EPSG','3953','Algeria - 0°E to 6°E','Algeria - between 0°E and 6°E (of Greenwich), onshore and offshore.',18.97,38.77,0.0,6.01,0);
INSERT INTO "area" VALUES('EPSG','3954','Algeria - east of 6°E','Algeria - east of 6°E (of Greenwich), onshore and offshore.',19.6,38.8,6.0,11.99,0);
@@ -3453,7 +3453,7 @@ INSERT INTO "area" VALUES('EPSG','4473','USA - Arizona - Pima county Mt. Lemmon'
INSERT INTO "area" VALUES('EPSG','4474','USA - Oregon - Dayville-Prairie City','United States (USA) - Oregon - Dayville-Prairie City area.',44.24,44.94,-119.89,-118.61,0);
INSERT INTO "area" VALUES('EPSG','4475','USA - Oregon - Denio-Burns','United States (USA) - Oregon - Denio-Burns area.',41.88,43.54,-119.41,-117.67,0);
INSERT INTO "area" VALUES('EPSG','4476','USA - Oregon - Halfway','United States (USA) - Oregon - Halfway area.',44.61,45.28,-117.61,-116.63,0);
-INSERT INTO "area" VALUES('EPSG','4477','USA - Oregon - Medford-Diamond Lake','United States (USA) - Oregon - Medford-Diamond Lake area.',42.53,42.53,-122.73,-121.71,0);
+INSERT INTO "area" VALUES('EPSG','4477','USA - Oregon - Medford-Diamond Lake','United States (USA) - Oregon - Medford-Diamond Lake area.',42.53,43.34,-122.73,-121.71,0);
INSERT INTO "area" VALUES('EPSG','4478','USA - Oregon - Mitchell','United States (USA) - Oregon - Mitchell area.',44.38,44.78,-120.56,-119.82,0);
INSERT INTO "area" VALUES('EPSG','4479','USA - Oregon - North Central','United States (USA) - Oregon - North Central area.',44.89,45.95,-121.79,-119.03,0);
INSERT INTO "area" VALUES('EPSG','4480','USA - Oregon - Wallowa','United States (USA) - Oregon - Wallowa area.',45.27,46.05,-118.16,-116.42,0);
@@ -3461,9 +3461,9 @@ INSERT INTO "area" VALUES('EPSG','4481','USA - Oregon - Ochoco Summit','United S
INSERT INTO "area" VALUES('EPSG','4482','USA - Oregon - Owyhee','United States (USA) - Oregon - Owyhee area.',41.88,43.54,-118.14,-116.85,0);
INSERT INTO "area" VALUES('EPSG','4483','USA - Oregon - Pilot Rock-Ukiah','United States (USA) - Oregon - Pilot Rock-Ukiah area.',44.99,46.04,-119.65,-118.11,0);
INSERT INTO "area" VALUES('EPSG','4484','USA - Oregon - Prairie City-Brogan','United States (USA) - Oregon - Prairie City-Brogan area.',44.16,45.02,-118.77,-117.48,0);
-INSERT INTO "area" VALUES('EPSG','4485','USA - Nevada - Las Vegas','United States (USA) - Nevada - Las Vegas area below approximately 3000 feet.',35.89,36.42,-115.5,-114.72,0);
+INSERT INTO "area" VALUES('EPSG','4485','USA - Nevada - Las Vegas','United States (USA) - Nevada - Las Vegas area below approximately 3000 feet.',35.88,36.43,-115.5,-114.71,0);
INSERT INTO "area" VALUES('EPSG','4486','USA - Oregon - Warner Highway','United States (USA) - Oregon - Warner Highway area.',41.95,42.43,-120.42,-119.3,0);
-INSERT INTO "area" VALUES('EPSG','4487','USA - Nevada - Las Vegas high elevation','United States (USA) - Nevada - Las Vegas area above approximately 2850 feet.',35.89,36.42,-115.5,-114.72,0);
+INSERT INTO "area" VALUES('EPSG','4487','USA - Nevada - Las Vegas high elevation','United States (USA) - Nevada - Las Vegas area above approximately 2850 feet.',35.88,36.43,-115.5,-114.71,0);
INSERT INTO "area" VALUES('EPSG','4488','USA - Oregon - Willamette Pass','United States (USA) - Oregon - Willamette Pass area.',42.99,44.18,-122.26,-121.48,0);
INSERT INTO "area" VALUES('EPSG','4489','Antarctica - Adelie Land coastal area west of 138°E','Antarctica - Adelie Land - coastal area between 136°E and 138°E.',-66.73,-65.61,136.0,138.01,0);
INSERT INTO "area" VALUES('EPSG','4490','Germany - Hamburg','Germany - Hamburg, including Neuwerk, Nigehörn, Scharhörn and surrounding maritime area.',53.36,53.99,8.33,10.41,0);
@@ -3505,3 +3505,4 @@ INSERT INTO "area" VALUES('EPSG','4525','Pacific - Guam and NMI - onshore','Guam
INSERT INTO "area" VALUES('EPSG','4526','Saudi Arabia - 36°E to 42°E','Saudi Arabia - onshore and offshore - between 36°E and 42°E.',16.29,32.16,36.0,42.0,0);
INSERT INTO "area" VALUES('EPSG','4527','Saudi Arabia - 42°E to 48°E','Saudi Arabia - onshore and offshore - between of 42°E and 48°E.',15.61,31.15,41.99,48.0,0);
INSERT INTO "area" VALUES('EPSG','4528','Saudi Arabia - 48°E to 54°E','Saudi Arabia - onshore and offshore - between 48°E and 54°E.',17.43,28.94,48.0,54.01,0);
+INSERT INTO "area" VALUES('EPSG','4540','Africa - South Africa, Lesotho and Eswatini.','Eswatini (Swaziland); Lesotho; South Africa - onshore and offshore.',-50.32,-22.13,13.33,42.85,0);