diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2019-01-21 21:31:55 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2019-01-21 21:31:55 +0100 |
| commit | 6a541b3a3926282ffc2e4bb20d2f6d78549572b5 (patch) | |
| tree | 0985038279bd5f64c1fe6b4cc96345ca069358fb /data | |
| parent | 24018433cf3b0b6600b68b09297e8f49b813fe7c (diff) | |
| download | PROJ-6a541b3a3926282ffc2e4bb20d2f6d78549572b5.tar.gz PROJ-6a541b3a3926282ffc2e4bb20d2f6d78549572b5.zip | |
Update to EPSG 9.5.5
Diffstat (limited to 'data')
| -rw-r--r-- | data/sql/area.sql | 27 | ||||
| -rw-r--r-- | data/sql/geodetic_crs.sql | 6 | ||||
| -rw-r--r-- | data/sql/geodetic_datum.sql | 2 | ||||
| -rw-r--r-- | data/sql/grid_transformation.sql | 1 | ||||
| -rw-r--r-- | data/sql/helmert_transformation.sql | 3 | ||||
| -rw-r--r-- | data/sql/metadata.sql | 4 | ||||
| -rw-r--r-- | data/sql/supersession.sql | 1 |
7 files changed, 24 insertions, 20 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); diff --git a/data/sql/geodetic_crs.sql b/data/sql/geodetic_crs.sql index 0a63fda4..53c78553 100644 --- a/data/sql/geodetic_crs.sql +++ b/data/sql/geodetic_crs.sql @@ -92,7 +92,7 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','4144','Kalianpur 1937',NULL,NULL,'geog INSERT INTO "geodetic_crs" VALUES('EPSG','4145','Kalianpur 1962',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6145','EPSG','1184',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4146','Kalianpur 1975',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6146','EPSG','3341',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4147','Hanoi 1972',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6147','EPSG','3328',NULL,0); -INSERT INTO "geodetic_crs" VALUES('EPSG','4148','Hartebeesthoek94',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6148','EPSG','1215',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','4148','Hartebeesthoek94',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6148','EPSG','4540',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4149','CH1903',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6149','EPSG','1286',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4150','CH1903+',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6150','EPSG','1286',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4151','CHTRF95',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6151','EPSG','1286',NULL,0); @@ -578,8 +578,8 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','4936','ETRS89',NULL,NULL,'geocentric', INSERT INTO "geodetic_crs" VALUES('EPSG','4937','ETRS89',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','6258','EPSG','1298',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4938','GDA94',NULL,NULL,'geocentric','EPSG','6500','EPSG','6283','EPSG','4177',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4939','GDA94',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','6283','EPSG','4177',NULL,0); -INSERT INTO "geodetic_crs" VALUES('EPSG','4940','Hartebeesthoek94',NULL,NULL,'geocentric','EPSG','6500','EPSG','6148','EPSG','1215',NULL,0); -INSERT INTO "geodetic_crs" VALUES('EPSG','4941','Hartebeesthoek94',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','6148','EPSG','1215',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','4940','Hartebeesthoek94',NULL,NULL,'geocentric','EPSG','6500','EPSG','6148','EPSG','4540',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','4941','Hartebeesthoek94',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','6148','EPSG','4540',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4942','IRENET95',NULL,NULL,'geocentric','EPSG','6500','EPSG','6173','EPSG','1305',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4943','IRENET95',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','6173','EPSG','1305',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4944','ISN93',NULL,NULL,'geocentric','EPSG','6500','EPSG','6659','EPSG','1120',NULL,0); diff --git a/data/sql/geodetic_datum.sql b/data/sql/geodetic_datum.sql index be24bfd7..48c219e8 100644 --- a/data/sql/geodetic_datum.sql +++ b/data/sql/geodetic_datum.sql @@ -187,7 +187,7 @@ INSERT INTO "geodetic_datum" VALUES('EPSG','6144','Kalianpur 1937',NULL,NULL,'EP INSERT INTO "geodetic_datum" VALUES('EPSG','6145','Kalianpur 1962',NULL,NULL,'EPSG','7044','EPSG','8901','EPSG','1184',0); INSERT INTO "geodetic_datum" VALUES('EPSG','6146','Kalianpur 1975',NULL,NULL,'EPSG','7045','EPSG','8901','EPSG','3341',0); INSERT INTO "geodetic_datum" VALUES('EPSG','6147','Hanoi 1972',NULL,NULL,'EPSG','7024','EPSG','8901','EPSG','3328',0); -INSERT INTO "geodetic_datum" VALUES('EPSG','6148','Hartebeesthoek94',NULL,NULL,'EPSG','7030','EPSG','8901','EPSG','1215',0); +INSERT INTO "geodetic_datum" VALUES('EPSG','6148','Hartebeesthoek94',NULL,NULL,'EPSG','7030','EPSG','8901','EPSG','4540',0); INSERT INTO "geodetic_datum" VALUES('EPSG','6149','CH1903',NULL,NULL,'EPSG','7004','EPSG','8901','EPSG','1286',0); INSERT INTO "geodetic_datum" VALUES('EPSG','6150','CH1903+',NULL,NULL,'EPSG','7004','EPSG','8901','EPSG','1286',0); INSERT INTO "geodetic_datum" VALUES('EPSG','6151','Swiss Terrestrial Reference Frame 1995',NULL,NULL,'EPSG','7019','EPSG','8901','EPSG','1286',0); diff --git a/data/sql/grid_transformation.sql b/data/sql/grid_transformation.sql index ffecd06d..caa4d8c1 100644 --- a/data/sql/grid_transformation.sql +++ b/data/sql/grid_transformation.sql @@ -262,6 +262,7 @@ INSERT INTO "grid_transformation" VALUES('EPSG','8446','GDA94 to GDA2020 (3)',NU INSERT INTO "grid_transformation" VALUES('EPSG','8447','GDA94 to GDA2020 (2)',NULL,NULL,'EPSG','9615','NTv2','EPSG','4283','EPSG','7844','EPSG','2575',0.05,'EPSG','8656','Latitude and longitude difference file','GDA94_GDA2020_conformal_and_distortion.gsb',NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "grid_transformation" VALUES('EPSG','8451','GDA2020 to AHD height (1)',NULL,NULL,'EPSG','1048','Geographic3D to GravityRelatedHeight (Ausgeoid v2)','EPSG','7843','EPSG','5711','EPSG','4493',0.03,'EPSG','8666','Geoid (height correction) model file','AUSGeoid2020_windows_binary.gsb',NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "grid_transformation" VALUES('EPSG','8676','Canada velocity grid v6',NULL,NULL,'EPSG','1070','Point motion by grid (Canada NTv2_Vel)','EPSG','8251','EPSG','8251','EPSG','1061',0.01,'EPSG','1050','Point motion velocity grid file','cvg60.cvb',NULL,NULL,NULL,NULL,NULL,NULL,0); +INSERT INTO "grid_transformation" VALUES('EPSG','8885','RGF93 to NGF IGN69 height (3)',NULL,NULL,'EPSG','1073','Geographic3D to GravityRelatedHeight (IGN2009)','EPSG','4965','EPSG','5720','EPSG','1326',0.01,'EPSG','8666','Geoid (height correction) model file','RAF18.tac',NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "grid_transformation" VALUES('EPSG','10000','RGF93 to NGF IGN69 height (1)',NULL,NULL,'EPSG','9664','Geographic3D to GravityRelatedHeight (IGN1997)','EPSG','4965','EPSG','5720','EPSG','1326',0.5,'EPSG','8666','Geoid (height correction) model file','ggf97a.txt',NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "grid_transformation" VALUES('EPSG','10001','ETRS89 to NGF IGN69 height (1)',NULL,NULL,'EPSG','9664','Geographic3D to GravityRelatedHeight (IGN1997)','EPSG','4937','EPSG','5720','EPSG','1326',0.5,'EPSG','8666','Geoid (height correction) model file','ggf97a.txt',NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "grid_transformation" VALUES('EPSG','10002','RGF93 to IGN78 Corsica height (1)',NULL,NULL,'EPSG','9664','Geographic3D to GravityRelatedHeight (IGN1997)','EPSG','4965','EPSG','5721','EPSG','1327',0.5,'EPSG','8666','Geoid (height correction) model file','ggf97a_corse.txt',NULL,NULL,NULL,NULL,NULL,NULL,0); diff --git a/data/sql/helmert_transformation.sql b/data/sql/helmert_transformation.sql index 928b19db..c6adb84d 100644 --- a/data/sql/helmert_transformation.sql +++ b/data/sql/helmert_transformation.sql @@ -279,7 +279,7 @@ INSERT INTO "helmert_transformation" VALUES('EPSG','1470','Abidjan 1987 to WGS 8 INSERT INTO "helmert_transformation" VALUES('EPSG','1471','MGI to WGS 84 (2)',NULL,NULL,'EPSG','9606','Position Vector transformation (geog2D domain)','EPSG','4312','EPSG','4326','EPSG','1037',NULL,-577.326,-90.129,-463.919,'EPSG','9001',-15.8537,-4.55,-16.3489,'EPSG','9113',-2.4232,'EPSG','9201',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1); INSERT INTO "helmert_transformation" VALUES('EPSG','1473','NAD83(CSRS98) to WGS 84 (1)',NULL,NULL,'EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4140','EPSG','4326','EPSG','1336',NULL,0.0,0.0,0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1); INSERT INTO "helmert_transformation" VALUES('EPSG','1504','Cape to Hartebeesthoek94 (1)',NULL,NULL,'EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4222','EPSG','4148','EPSG','3309',15.0,-134.73,-110.92,-292.66,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); -INSERT INTO "helmert_transformation" VALUES('EPSG','1505','Hartebeesthoek94 to WGS 84 (1)',NULL,NULL,'EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4148','EPSG','4326','EPSG','1215',1.0,0.0,0.0,0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); +INSERT INTO "helmert_transformation" VALUES('EPSG','1505','Hartebeesthoek94 to WGS 84 (1)',NULL,NULL,'EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4148','EPSG','4326','EPSG','4540',1.0,0.0,0.0,0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "helmert_transformation" VALUES('EPSG','1508','CH1903 to WGS 84 (1)',NULL,NULL,'EPSG','9607','Coordinate Frame rotation (geog2D domain)','EPSG','4149','EPSG','4326','EPSG','1286',NULL,660.077,13.551,369.344,'EPSG','9001',2.484,1.783,2.939,'EPSG','9113',5.66,'EPSG','9201',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1); INSERT INTO "helmert_transformation" VALUES('EPSG','1509','CH1903+ to CHTRF95 (1)',NULL,NULL,'EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4150','EPSG','4151','EPSG','1286',0.1,674.374,15.056,405.346,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "helmert_transformation" VALUES('EPSG','1510','CH1903 to WGS 84 (2)',NULL,NULL,'EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4149','EPSG','4326','EPSG','1286',NULL,674.374,15.056,405.346,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1); @@ -1081,6 +1081,7 @@ INSERT INTO "helmert_transformation" VALUES('EPSG','8877','ITRF91 to ETRF2014 (1 INSERT INTO "helmert_transformation" VALUES('EPSG','8878','ITRF90 to ETRF2014 (1)',NULL,NULL,'EPSG','1053','Time-dependent Position Vector tfm (geocentric)','EPSG','4912','EPSG','8401','EPSG','1298',0.0,-25.4,-11.5,92.8,'EPSG','1025',1.785,11.151,-16.43,'EPSG','1031',-4.79,'EPSG','1028',-0.1,0.5,3.3,'EPSG','1027',0.085,0.531,-0.79,'EPSG','1032',-0.12,'EPSG','1030',2010.0,'EPSG','1029',NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "helmert_transformation" VALUES('EPSG','8879','ITRF89 to ETRF2014 (1)',NULL,NULL,'EPSG','1053','Time-dependent Position Vector tfm (geocentric)','EPSG','4911','EPSG','8401','EPSG','1298',0.0,-30.4,-35.5,130.8,'EPSG','1025',1.785,11.151,-16.43,'EPSG','1031',-8.19,'EPSG','1028',-0.1,0.5,3.3,'EPSG','1027',0.085,0.531,-0.79,'EPSG','1032',-0.12,'EPSG','1030',2010.0,'EPSG','1029',NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "helmert_transformation" VALUES('EPSG','8880','ITRF2014 to ETRF2014 (2)',NULL,NULL,'EPSG','1053','Time-dependent Position Vector tfm (geocentric)','EPSG','7789','EPSG','8401','EPSG','1298',0.0,0.0,0.0,0.0,'EPSG','1025',1.785,11.151,-16.17,'EPSG','1031',0.0,'EPSG','1028',0.0,0.0,0.0,'EPSG','1027',0.085,0.531,-0.77,'EPSG','1032',0.0,'EPSG','1030',2010.0,'EPSG','1029',NULL,NULL,NULL,NULL,NULL,0); +INSERT INTO "helmert_transformation" VALUES('EPSG','8886','SVY21 to WGS 84 (1)',NULL,NULL,'EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4757','EPSG','4326','EPSG','1210',1.0,0.0,0.0,0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "helmert_transformation" VALUES('EPSG','10085','Trinidad 1903 to WGS 84 (2)',NULL,NULL,'EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4302','EPSG','4326','EPSG','1339',3.0,-61.0,285.2,471.6,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "helmert_transformation" VALUES('EPSG','10086','JAD69 to WGS 72 (1)',NULL,NULL,'EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4242','EPSG','4322','EPSG','3342',15.0,48.0,208.0,382.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "helmert_transformation" VALUES('EPSG','10089','Aratu to WGS 84 (5)',NULL,NULL,'EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4208','EPSG','4326','EPSG','2962',7.0,-163.466,317.396,-147.538,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); diff --git a/data/sql/metadata.sql b/data/sql/metadata.sql index b69c0ca9..0ddb2eef 100644 --- a/data/sql/metadata.sql +++ b/data/sql/metadata.sql @@ -1,2 +1,2 @@ -INSERT INTO "metadata" VALUES('EPSG.VERSION', 'v9.5.4'); -INSERT INTO "metadata" VALUES('EPSG.DATE', '2018-10-06'); +INSERT INTO "metadata" VALUES('EPSG.VERSION', 'v9.5.5'); +INSERT INTO "metadata" VALUES('EPSG.DATE', '2019-01-21'); diff --git a/data/sql/supersession.sql b/data/sql/supersession.sql index 83049e11..ebc0726b 100644 --- a/data/sql/supersession.sql +++ b/data/sql/supersession.sql @@ -185,6 +185,7 @@ INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','4829','concat INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','4827','concatenated_operation','EPSG','8443','EPSG'); INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','4827','concatenated_operation','EPSG','8442','EPSG'); INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','4829','concatenated_operation','EPSG','8442','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','8371','grid_transformation','EPSG','8885','EPSG'); INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','3917','helmert_transformation','EPSG','8688','EPSG'); INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','3915','helmert_transformation','EPSG','8688','EPSG'); INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','3916','helmert_transformation','EPSG','8689','EPSG'); |
