diff options
Diffstat (limited to 'data/sql/grid_transformation_custom.sql')
| -rw-r--r-- | data/sql/grid_transformation_custom.sql | 91 |
1 files changed, 77 insertions, 14 deletions
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 +); |