From e9d6a0b2993c903c8932b68d2812dc02adb26014 Mon Sep 17 00:00:00 2001 From: dalia2 <57895979+dalia2@users.noreply.github.com> Date: Mon, 2 Dec 2019 14:47:57 +0000 Subject: Update grid_transformation_custom.sql --- data/sql/grid_transformation_custom.sql | 36 +++++++++++++++++++++++++++++++++ 1 file changed, 36 insertions(+) (limited to 'data/sql/grid_transformation_custom.sql') diff --git a/data/sql/grid_transformation_custom.sql b/data/sql/grid_transformation_custom.sql index c269983e..5bad5101 100644 --- a/data/sql/grid_transformation_custom.sql +++ b/data/sql/grid_transformation_custom.sql @@ -49,3 +49,39 @@ INSERT INTO "grid_transformation" VALUES( NULL, 'EPSG','8666','Geoid (height correction) model file','SWEN17_RH2000.gtx', NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); + +-- Iceland + +INSERT INTO "grid_transformation" VALUES( + 'PROJ','EPSG_5323_TO_EPSG_8089','ISN2004 height to vertical datum ISH2004', + NULL,NULL, + 'PROJ','HEIGHT_TO_GEOGRAPHIC3D','GravityRelatedHeight to Geographic3D', + 'EPSG','5323', -- source CRS (ISN2004 height) + 'EPSG','8089', -- target CRS (ISH2004) + 'EPSG','1120', -- area of use: Iceland - onshore and offshore + NULL, + 'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN2004.gtx', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); + +INSERT INTO "grid_transformation" VALUES( + 'PROJ','EPSG_4945_TO_EPSG_8089','ISN93 height to vertical datum ISH2004', + NULL,NULL, + 'PROJ','HEIGHT_TO_GEOGRAPHIC3D','GravityRelatedHeight to Geographic3D', + 'EPSG','4945', -- source CRS (ISN93 height) + 'EPSG','8089', -- target CRS (ISH2004) + 'EPSG','1120', -- area of use: Iceland - onshore and offshore + NULL, + 'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN93.gtx', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); + +INSERT INTO "grid_transformation" VALUES( + 'PROJ','EPSG_8085_TO_EPSG_8089','ISN2016 height to vertical datum ISH2004', + NULL,NULL, + 'PROJ','HEIGHT_TO_GEOGRAPHIC3D','GravityRelatedHeight to Geographic3D', + 'EPSG','8085', -- source CRS (ISN2016 height) + 'EPSG','8089', -- target CRS (ISH2004) + 'EPSG','1120', -- area of use: Iceland - onshore and offshore + NULL, + 'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN2016.gtx', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); + -- cgit v1.2.3 From 216492df4358c552875d834365857ed3a3dd8d8c Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Tue, 17 Dec 2019 16:54:16 +0100 Subject: Database: register SeTa2016.gsb for DHDN to ETRS89 in Saarland (refs https://github.com/OSGeo/proj-datumgrid/pull/89) (#1791) --- data/sql/grid_transformation_custom.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'data/sql/grid_transformation_custom.sql') diff --git a/data/sql/grid_transformation_custom.sql b/data/sql/grid_transformation_custom.sql index 189b9e50..97434ad8 100644 --- a/data/sql/grid_transformation_custom.sql +++ b/data/sql/grid_transformation_custom.sql @@ -56,6 +56,12 @@ INSERT INTO "area" VALUES('PROJ','BWTA2017','Germany - Baden-Wurtemberg','German -- Advertize a 0.8 accuracy slightly better than the 0.9 of BETA2007 for sort purposes INSERT INTO "grid_transformation" VALUES('PROJ','BWTA2017','DHDN to ETRS89 (BWTA2017)','DHDN to ETRS89 for Baden-Wurtemberg for ALKIS 2017. Using official BWTA2017 grid but this transformation entry has been created temporarily by PROJ. Accuracy indication not to be considered as authoritative','For applications requiring an accuracy of better than 1 metre.','EPSG','9615','NTv2','EPSG','4314','EPSG','4258','PROJ','BWTA2017',0.89,'EPSG','8656','Latitude and longitude difference file','BWTA2017.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'-',0); +----- Hopefully temporary entry for SeTa2016.gsb grid ----- + +INSERT INTO "area" VALUES('PROJ','SETA2016','Germany - Saarland','Germany - Saarland',49.10,49.64,6.345,7.45,0); +-- Advertize a 0.8 accuracy slightly better than the 0.9 of BETA2007 for sort purposes +INSERT INTO "grid_transformation" VALUES('PROJ','SETA2016','DHDN to ETRS89 (SETA2016)','DHDN to ETRS89 for Saarland. Using official SETA2016 grid but this transformation entry has been created temporarily by PROJ. Accuracy indication not to be considered as authoritative','For applications requiring an accuracy of better than 1 metre.','EPSG','9615','NTv2','EPSG','4314','EPSG','4258','PROJ','SETA2016',0.89,'EPSG','8656','Latitude and longitude difference file','SeTa2016.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'-',0); + -- Iceland INSERT INTO "grid_transformation" VALUES( @@ -89,4 +95,4 @@ INSERT INTO "grid_transformation" VALUES( 'EPSG','1120', -- area of use: Iceland - onshore and offshore NULL, 'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN2016.gtx', - NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); \ No newline at end of file + NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); -- cgit v1.2.3 From e7ef9b626ecabfe6bc5ff3793a9565426470a4a3 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Sat, 21 Dec 2019 02:13:07 +0100 Subject: Database: fix registration of Icegeoid_xxx.gtx files, and add corresponding entries in grid_alternatives.sql --- data/sql/grid_transformation_custom.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) (limited to 'data/sql/grid_transformation_custom.sql') diff --git a/data/sql/grid_transformation_custom.sql b/data/sql/grid_transformation_custom.sql index 97434ad8..05916a39 100644 --- a/data/sql/grid_transformation_custom.sql +++ b/data/sql/grid_transformation_custom.sql @@ -65,33 +65,33 @@ INSERT INTO "grid_transformation" VALUES('PROJ','SETA2016','DHDN to ETRS89 (SETA -- Iceland INSERT INTO "grid_transformation" VALUES( - 'PROJ','EPSG_5323_TO_EPSG_8089','ISN2004 height to vertical datum ISH2004', + 'PROJ','EPSG_8089_TO_EPSG_5323','ISH2004 height to ISN2004', NULL,NULL, 'PROJ','HEIGHT_TO_GEOGRAPHIC3D','GravityRelatedHeight to Geographic3D', - 'EPSG','5323', -- source CRS (ISN2004 height) - 'EPSG','8089', -- target CRS (ISH2004) + 'EPSG','8089', -- source CRS (ISH2004 height) + 'EPSG','5323', -- target CRS (ISN2004 geographic 3D) 'EPSG','1120', -- area of use: Iceland - onshore and offshore NULL, 'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN2004.gtx', NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "grid_transformation" VALUES( - 'PROJ','EPSG_4945_TO_EPSG_8089','ISN93 height to vertical datum ISH2004', + 'PROJ','EPSG_8089_TO_EPSG_4945','ISH2004 height to ISN93', NULL,NULL, 'PROJ','HEIGHT_TO_GEOGRAPHIC3D','GravityRelatedHeight to Geographic3D', - 'EPSG','4945', -- source CRS (ISN93 height) - 'EPSG','8089', -- target CRS (ISH2004) + 'EPSG','8089', -- source CRS (ISH2004 height) + 'EPSG','4945', -- target CRS (ISN93 geographic 3D) 'EPSG','1120', -- area of use: Iceland - onshore and offshore NULL, 'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN93.gtx', NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "grid_transformation" VALUES( - 'PROJ','EPSG_8085_TO_EPSG_8089','ISN2016 height to vertical datum ISH2004', + 'PROJ','EPSG_8089_TO_EPSG_8085','ISH2004 height to ISN2016', NULL,NULL, 'PROJ','HEIGHT_TO_GEOGRAPHIC3D','GravityRelatedHeight to Geographic3D', - 'EPSG','8085', -- source CRS (ISN2016 height) - 'EPSG','8089', -- target CRS (ISH2004) + 'EPSG','8089', -- source CRS (ISH2004 height) + 'EPSG','8085', -- target CRS (ISN2016 geographic 3D) 'EPSG','1120', -- area of use: Iceland - onshore and offshore NULL, 'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN2016.gtx', -- cgit v1.2.3