aboutsummaryrefslogtreecommitdiff
path: root/data/sql/grid_transformation_custom.sql
diff options
context:
space:
mode:
authorJavier Jimenez Shaw <j1@jimenezshaw.com>2021-03-25 14:47:23 +0100
committergithub-actions[bot] <github-actions[bot]@users.noreply.github.com>2021-03-25 13:47:53 +0000
commitc5f2cc2c8cc5f068b090f48cf048f3ea5203bc02 (patch)
tree6a3a2945026dd1c246f265fb6f09643863e2040c /data/sql/grid_transformation_custom.sql
parent03b5f40edf0fe5716f8ff72ae7db992b1786990b (diff)
downloadPROJ-c5f2cc2c8cc5f068b090f48cf048f3ea5203bc02.tar.gz
PROJ-c5f2cc2c8cc5f068b090f48cf048f3ea5203bc02.zip
Database: add grid alternatives and transformation custom for ch_swisstopo_chgeo2004_ETRS89_LHN95 and ch_swisstopo_chgeo2004_ETRS89_LN02 (#2584)
Diffstat (limited to 'data/sql/grid_transformation_custom.sql')
-rw-r--r--data/sql/grid_transformation_custom.sql42
1 files changed, 42 insertions, 0 deletions
diff --git a/data/sql/grid_transformation_custom.sql b/data/sql/grid_transformation_custom.sql
index 02bcc8ec..fb4d434c 100644
--- a/data/sql/grid_transformation_custom.sql
+++ b/data/sql/grid_transformation_custom.sql
@@ -169,3 +169,45 @@ INSERT INTO "usage" VALUES(
'EPSG','3263', -- area of use: Japan - onshore mainland
'EPSG','1024' -- unknown
);
+
+-- Switzerland
+
+INSERT INTO "grid_transformation" VALUES(
+ 'PROJ','EPSG_4937_TO_EPSG_5729','ETRS89 to LHN95 height',
+ NULL,
+ 'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)',
+ 'EPSG','4937', -- source CRS (ETRS89)
+ 'EPSG','5729', -- target CRS (LHN95 height)
+ NULL,
+ 'EPSG','8666','Geoid (height correction) model file','chgeo2004_ETRS.agr',
+ NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+
+INSERT INTO "usage" VALUES(
+ 'PROJ',
+ 'EPSG_4937_TO_EPSG_5729_USAGE',
+ 'grid_transformation',
+ 'PROJ',
+ 'EPSG_4937_TO_EPSG_5729',
+ 'EPSG','1286', -- area of use: Europe - Liechtenstein and Switzerland
+ 'EPSG','1024' -- unknown
+);
+
+INSERT INTO "grid_transformation" VALUES(
+ 'PROJ','EPSG_4937_TO_EPSG_5728','ETRS89 to LN02 height',
+ NULL,
+ 'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)',
+ 'EPSG','4937', -- source CRS (ETRS89)
+ 'EPSG','5728', -- target CRS (LN02 height)
+ NULL,
+ 'EPSG','8666','Geoid (height correction) model file','chgeo2004_htrans_ETRS.agr',
+ NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+
+INSERT INTO "usage" VALUES(
+ 'PROJ',
+ 'EPSG_4937_TO_EPSG_5728_USAGE',
+ 'grid_transformation',
+ 'PROJ',
+ 'EPSG_4937_TO_EPSG_5728',
+ 'EPSG','1286', -- area of use: Europe - Liechtenstein and Switzerland
+ 'EPSG','1024' -- unknown
+);