From a9b6f39494e6dab0ea02af9d82e7b3d570f5422f Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Thu, 24 Sep 2020 22:41:59 +0200 Subject: Database: "minimal" update to EPSG v10.003 Content mostly unchanged since v9.9 This update is "minimal" in that it mostly reflects the removal of the 'area' table, replaced now by 'extent', 'scope' and 'usage' Other new aspects of EPSG v10 are left aside. --- data/sql/grid_transformation_custom.sql | 91 ++++++++++++++++++++++++++++----- 1 file changed, 77 insertions(+), 14 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 38210c00..cb8c757a 100644 --- a/data/sql/grid_transformation_custom.sql +++ b/data/sql/grid_transformation_custom.sql @@ -4,83 +4,146 @@ INSERT INTO "grid_transformation" VALUES( 'PROJ','EPSG_4937_TO_EPSG_5799','ETRS89 to DVR90 height', - NULL,NULL, + NULL, 'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)', 'EPSG','4937', -- source CRS (ETRS89) 'EPSG','5799', -- target CRS (DVR90 height) - 'EPSG','3237', -- area of use: Denmark onshore NULL, 'EPSG','8666','Geoid (height correction) model file','dvr90.gtx', NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); +INSERT INTO "usage" VALUES( + 'PROJ', + 'EPSG_4937_TO_EPSG_5799_USAGE', + 'grid_transformation', + 'PROJ', + 'EPSG_4937_TO_EPSG_5799', + 'EPSG','3237', -- area of use: Denmark onshore + 'EPSG','1024' -- unknown +); + INSERT INTO "grid_transformation" VALUES( 'PROJ','EPSG_4937_TO_EPSG_5733','ETRS89 to DNN height', - NULL,NULL, + NULL, 'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)', 'EPSG','4937', -- source CRS (ETRS89) 'EPSG','5733', -- target CRS (DNN height) - 'EPSG','3237', -- area of use: Denmark onshore NULL, 'EPSG','8666','Geoid (height correction) model file','dnn.gtx', NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); +INSERT INTO "usage" VALUES( + 'PROJ', + 'EPSG_4937_TO_EPSG_5733_USAGE', + 'grid_transformation', + 'PROJ', + 'EPSG_4937_TO_EPSG_5733', + 'EPSG','3237', -- area of use: Denmark onshore + 'EPSG','1024' -- unknown +); + -- Faroe Islands INSERT INTO "grid_transformation" VALUES( 'PROJ','EPSG_4937_TO_EPSG_5317','ETRS89 to FVR09 height', - NULL,NULL, + NULL, 'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)', 'EPSG','4937', -- source CRS (ETRS89) 'EPSG','5317', -- target CRS (FVR09 height) - 'EPSG','3248', -- area of use: Faroe Islands - onshore NULL, 'EPSG','8666','Geoid (height correction) model file','fvr09.gtx', NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); +INSERT INTO "usage" VALUES( + 'PROJ', + 'EPSG_4937_TO_EPSG_5317_USAGE', + 'grid_transformation', + 'PROJ', + 'EPSG_4937_TO_EPSG_5317', + 'EPSG','3248', -- area of use: Faroe Islands - onshore + 'EPSG','1024' -- unknown +); + -- Sweden INSERT INTO "grid_transformation" VALUES( 'PROJ','EPSG_4977_TO_EPSG_5613','SWEREF99 to RH2000 height', - NULL,NULL, + NULL, 'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)', 'EPSG','4977', -- source CRS (SWEREF99) 'EPSG','5613', -- target CRS (RH2000 height) - 'EPSG','3313', -- area of use: Sweden onshore NULL, 'EPSG','8666','Geoid (height correction) model file','SWEN17_RH2000.gtx', NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); +INSERT INTO "usage" VALUES( + 'PROJ', + 'EPSG_4977_TO_EPSG_5613_USAGE', + 'grid_transformation', + 'PROJ', + 'EPSG_4977_TO_EPSG_5613', + 'EPSG','3313', -- area of use: Sweden onshore + 'EPSG','1024' -- unknown +); + -- Iceland INSERT INTO "grid_transformation" VALUES( 'PROJ','EPSG_5323_TO_EPSG_8089','ISN2004 to ISH2004 height', - NULL,NULL, + NULL, 'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)', 'EPSG','5323', -- source CRS (ISN2004 geographic 3D) 'EPSG','8089', -- target CRS (ISH2004 height) - '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 "usage" VALUES( + 'PROJ', + 'EPSG_5323_TO_EPSG_8089_USAGE', + 'grid_transformation', + 'PROJ', + 'EPSG_5323_TO_EPSG_8089', + 'EPSG','1120', -- area of use: Iceland - onshore and offshore + 'EPSG','1024' -- unknown +); + INSERT INTO "grid_transformation" VALUES( 'PROJ','EPSG_4945_TO_EPSG_8089','ISN93 to ISH2004 height', - NULL,NULL, + NULL, 'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)', 'EPSG','4945', -- source CRS (ISN93 geographic 3D) 'EPSG','8089', -- target CRS (ISH2004 height) - '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 "usage" VALUES( + 'PROJ', + 'EPSG_4945_TO_EPSG_8089_USAGE', + 'grid_transformation', + 'PROJ', + 'EPSG_4945_TO_EPSG_8089', + 'EPSG','1120', -- area of use: Iceland - onshore and offshore + 'EPSG','1024' -- unknown +); + INSERT INTO "grid_transformation" VALUES( 'PROJ','EPSG_8085_TO_EPSG_8089','ISN2016 to ISH2004 height', - NULL,NULL, + NULL, 'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)', 'EPSG','8085', -- source CRS (ISN2016 geographic 3D) 'EPSG','8089', -- target CRS (ISH2004 height) - '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); + +INSERT INTO "usage" VALUES( + 'PROJ', + 'EPSG_8085_TO_EPSG_8089_USAGE', + 'grid_transformation', + 'PROJ', + 'EPSG_8085_TO_EPSG_8089', + 'EPSG','1120', -- area of use: Iceland - onshore and offshore + 'EPSG','1024' -- unknown +); -- cgit v1.2.3