From 1929cb69e8d1a56822999c7890a69e1ad9729713 Mon Sep 17 00:00:00 2001
From: Javier Jimenez Shaw <j1@jimenezshaw.com>
Date: Thu, 7 Oct 2021 18:36:46 +0200
Subject: add mx_inegi_ggm10.tif vertical grid file, with custom transformation

---
 data/sql/grid_transformation_custom.sql | 22 ++++++++++++++++++++++
 1 file changed, 22 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 fb4d434c..ed6d0ec2 100644
--- a/data/sql/grid_transformation_custom.sql
+++ b/data/sql/grid_transformation_custom.sql
@@ -211,3 +211,25 @@ INSERT INTO "usage" VALUES(
     'EPSG','1286', -- area of use: Europe - Liechtenstein and Switzerland
     'EPSG','1024'  -- unknown
 );
+
+-- Mexico
+
+INSERT INTO "grid_transformation" VALUES(
+    'PROJ','EPSG_6364_TO_EPSG_5703','Mexico ITRF2008 to NAVD88 height',
+    NULL,
+    'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)',
+    'EPSG','6364', -- source CRS (Mexico ITRF2008)
+    'EPSG','5703', -- target CRS (NAVD88 height)
+    NULL,
+    'EPSG','8666','Geoid (height correction) model file','GGM10.txt',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+
+INSERT INTO "usage" VALUES(
+    'PROJ',
+    'EPSG_6364_TO_EPSG_5703_USAGE',
+    'grid_transformation',
+    'PROJ',
+    'EPSG_6364_TO_EPSG_5703',
+    'EPSG','1160', -- area of use: Mexico - onshore and offshore.
+    'EPSG','1024'  -- unknown
+);
-- 
cgit v1.2.3


From c78c85f9507b9b17213893be8dba33062e1fa292 Mon Sep 17 00:00:00 2001
From: Javier Jimenez Shaw <j1@jimenezshaw.com>
Date: Fri, 8 Oct 2021 14:20:49 +0200
Subject: Set area of use compatible with grid file

---
 data/sql/grid_transformation_custom.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(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 ed6d0ec2..db56b754 100644
--- a/data/sql/grid_transformation_custom.sql
+++ b/data/sql/grid_transformation_custom.sql
@@ -230,6 +230,6 @@ INSERT INTO "usage" VALUES(
     'grid_transformation',
     'PROJ',
     'EPSG_6364_TO_EPSG_5703',
-    'EPSG','1160', -- area of use: Mexico - onshore and offshore.
+    'EPSG','3278', -- area of use: Mexico - onshore
     'EPSG','1024'  -- unknown
 );
-- 
cgit v1.2.3

