From 2620701a4bb51a20d49e869acddce2167ba791d0 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Wed, 20 Feb 2019 22:16:13 +0100 Subject: proj.db: add custom entry for 'RH2000 height to SWEREF99' --- data/sql/grid_transformation_custom.sql | 15 +++++++++++++++ 1 file changed, 15 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 a43312fe..89234ef7 100644 --- a/data/sql/grid_transformation_custom.sql +++ b/data/sql/grid_transformation_custom.sql @@ -1,5 +1,7 @@ -- This file is hand generated. +-- Denmark + INSERT INTO "grid_transformation" VALUES( 'PROJ','EPSG_5799_TO_EPSG_4937','DVR90 height to ETRS89', NULL,NULL, @@ -21,3 +23,16 @@ INSERT INTO "grid_transformation" VALUES( NULL, 'EPSG','8666','Geoid (height correction) model file','dnn.gtx', NULL,NULL,NULL,NULL,NULL,NULL,0); + +-- Sweden + +INSERT INTO "grid_transformation" VALUES( + 'PROJ','EPSG_5613_TO_EPSG_4377','RH2000 height to SWEREF99', + NULL,NULL, + 'PROJ','HEIGHT_TO_GEOGRAPHIC3D','GravityRelatedHeight to Geographic3D', + 'EPSG','5613', -- source CRS (RH2000 height) + 'EPSG','4377', -- target CRS (SWEREF99) + 'EPSG','3313', -- area of use: Sweden onshore + NULL, + 'EPSG','8666','Geoid (height correction) model file','SWEN17_RH2000.gtx', + NULL,NULL,NULL,NULL,NULL,NULL,0); -- cgit v1.2.3 From 95ee9fabd268dde1a3c8b51e88bb7dc318e29de1 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Thu, 21 Feb 2019 11:35:12 +0100 Subject: proj.db: add custom entry for 'FVR09 height to ETRS89' --- data/sql/grid_transformation_custom.sql | 13 +++++++++++++ 1 file changed, 13 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 89234ef7..3c47273e 100644 --- a/data/sql/grid_transformation_custom.sql +++ b/data/sql/grid_transformation_custom.sql @@ -24,6 +24,19 @@ INSERT INTO "grid_transformation" VALUES( 'EPSG','8666','Geoid (height correction) model file','dnn.gtx', NULL,NULL,NULL,NULL,NULL,NULL,0); +-- Faroe Islands + +INSERT INTO "grid_transformation" VALUES( + 'PROJ','EPSG_5317_TO_EPSG_4937','FVR09 height to ETRS89', + NULL,NULL, + 'PROJ','HEIGHT_TO_GEOGRAPHIC3D','GravityRelatedHeight to Geographic3D', + 'EPSG','5317', -- source CRS (FVR09 height) + 'EPSG','4937', -- target CRS (ETRS89) + 'EPSG','3248', -- area of use: Faroe Islands - onshore + NULL, + 'EPSG','8666','Geoid (height correction) model file','fvr09.gtx', + NULL,NULL,NULL,NULL,NULL,NULL,0); + -- Sweden INSERT INTO "grid_transformation" VALUES( -- cgit v1.2.3 From 054d02760db6fc2c33889d577cd671baa8807909 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Mon, 25 Mar 2019 17:00:04 +0100 Subject: Database: add operation_version column to coordinate operation tables --- data/sql/grid_transformation_custom.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 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 3c47273e..e7180917 100644 --- a/data/sql/grid_transformation_custom.sql +++ b/data/sql/grid_transformation_custom.sql @@ -11,7 +11,7 @@ INSERT INTO "grid_transformation" VALUES( 'EPSG','3237', -- area of use: Denmark onshore NULL, 'EPSG','8666','Geoid (height correction) model file','dvr90.gtx', - NULL,NULL,NULL,NULL,NULL,NULL,0); + NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); INSERT INTO "grid_transformation" VALUES( 'PROJ','EPSG_5733_TO_EPSG_4937','DNN height to ETRS89', @@ -22,7 +22,7 @@ INSERT INTO "grid_transformation" VALUES( 'EPSG','3237', -- area of use: Denmark onshore NULL, 'EPSG','8666','Geoid (height correction) model file','dnn.gtx', - NULL,NULL,NULL,NULL,NULL,NULL,0); + NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); -- Faroe Islands @@ -35,7 +35,7 @@ INSERT INTO "grid_transformation" VALUES( 'EPSG','3248', -- area of use: Faroe Islands - onshore NULL, 'EPSG','8666','Geoid (height correction) model file','fvr09.gtx', - NULL,NULL,NULL,NULL,NULL,NULL,0); + NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); -- Sweden @@ -48,4 +48,4 @@ INSERT INTO "grid_transformation" VALUES( 'EPSG','3313', -- area of use: Sweden onshore NULL, 'EPSG','8666','Geoid (height correction) model file','SWEN17_RH2000.gtx', - NULL,NULL,NULL,NULL,NULL,NULL,0); + NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); -- cgit v1.2.3 From 3faaf339216f128be7a8bb354e858203e5ec6d7f Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Mon, 22 Apr 2019 15:26:43 +0200 Subject: Database: use non-deprecated code for SWEREF99 for 'RH2000 height to SWEREF99' transformation --- data/sql/grid_transformation_custom.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 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 e7180917..c269983e 100644 --- a/data/sql/grid_transformation_custom.sql +++ b/data/sql/grid_transformation_custom.sql @@ -40,11 +40,11 @@ INSERT INTO "grid_transformation" VALUES( -- Sweden INSERT INTO "grid_transformation" VALUES( - 'PROJ','EPSG_5613_TO_EPSG_4377','RH2000 height to SWEREF99', + 'PROJ','EPSG_5613_TO_EPSG_4977','RH2000 height to SWEREF99', NULL,NULL, 'PROJ','HEIGHT_TO_GEOGRAPHIC3D','GravityRelatedHeight to Geographic3D', 'EPSG','5613', -- source CRS (RH2000 height) - 'EPSG','4377', -- target CRS (SWEREF99) + 'EPSG','4977', -- target CRS (SWEREF99) 'EPSG','3313', -- area of use: Sweden onshore NULL, 'EPSG','8666','Geoid (height correction) model file','SWEN17_RH2000.gtx', -- cgit v1.2.3