From e7ef9b626ecabfe6bc5ff3793a9565426470a4a3 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
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

