aboutsummaryrefslogtreecommitdiff
path: root/data/sql
diff options
context:
space:
mode:
authorEven Rouault <even.rouault@spatialys.com>2021-10-15 23:35:04 +0200
committerGitHub <noreply@github.com>2021-10-15 23:35:04 +0200
commit04928472dbee772b6b31c78352dc486fb6543a91 (patch)
tree4c38d2173f5a19b61f2ba30eb1b985bb43e5d957 /data/sql
parent3aad65681afc77d054ce0f271ca64c24f0b3d2f9 (diff)
parent86bdfcf0d49e7674363d84f4612256fffbdbdc41 (diff)
downloadPROJ-04928472dbee772b6b31c78352dc486fb6543a91.tar.gz
PROJ-04928472dbee772b6b31c78352dc486fb6543a91.zip
Merge pull request #2889 from jjimenezshaw/mx_inegi_ggm10
Add transformations for GGM10, Mexican geoid model
Diffstat (limited to 'data/sql')
-rw-r--r--data/sql/customizations.sql2
-rw-r--r--data/sql/grid_alternatives.sql3
-rw-r--r--data/sql/grid_transformation_custom.sql22
-rw-r--r--data/sql/metadata.sql2
4 files changed, 28 insertions, 1 deletions
diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql
index 19b21b7d..74a241db 100644
--- a/data/sql/customizations.sql
+++ b/data/sql/customizations.sql
@@ -257,6 +257,8 @@ INSERT INTO "geoid_model" SELECT 'GEOID18', auth_name, code FROM grid_transforma
INSERT INTO "geoid_model" SELECT 'OSGM15', auth_name, code FROM grid_transformation WHERE auth_name = 'EPSG' AND grid_name LIKE '%OSGM15%' AND deprecated = 0;
+INSERT INTO "geoid_model" SELECT 'GGM10', auth_name, code FROM grid_transformation WHERE auth_name = 'PROJ' AND grid_name LIKE 'GGM10.txt' AND deprecated = 0;
+
---- PROJ historic +datum aliases -----
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6326','WGS84','PROJ');
diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 8a929de9..b754689a 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -177,6 +177,9 @@ VALUES
-- jp_gsi - Geospatial Information Authority of Japan
('jp_gsi_gsigeo2011.tif','jp_gsi_gsigeo2011.tif',NULL,'GTiff','geoid_like',0,NULL,'https://cdn.proj.org/jp_gsi_gsigeo2011.tif',1,1,NULL),
+-- mx_inegi - Instituto Nacional de Estadística, Geografía e Informática (INEGI) Mexico
+('GGM10.txt','mx_inegi_ggm10.tif',NULL,'GTiff','geoid_like',0,NULL,'https://cdn.proj.org/mx_inegi_ggm10.tif',1,1,NULL),
+
-- nc_dittt - Gouvernement de Nouvelle Calédonie - DITTT
('Ranc08_Circe.mnt','nc_dittt_Ranc08_Circe.tif',NULL,'GTiff','geoid_like',0,NULL,'https://cdn.proj.org/nc_dittt_Ranc08_Circe.tif',1,1,NULL),
('gr3dnc01b.mnt','nc_dittt_gr3dnc01b.tif',NULL,'GTiff','geocentricoffset',0,NULL,'https://cdn.proj.org/nc_dittt_gr3dnc01b.tif',1,1,NULL),
diff --git a/data/sql/grid_transformation_custom.sql b/data/sql/grid_transformation_custom.sql
index fb4d434c..db56b754 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','3278', -- area of use: Mexico - onshore
+ 'EPSG','1024' -- unknown
+);
diff --git a/data/sql/metadata.sql b/data/sql/metadata.sql
index 7f841ed2..8230e7da 100644
--- a/data/sql/metadata.sql
+++ b/data/sql/metadata.sql
@@ -18,4 +18,4 @@ INSERT INTO "metadata" VALUES('PROJ.VERSION', '${PROJ_VERSION}');
-- Version of the PROJ-data package with which this database is the most
-- compatible.
-INSERT INTO "metadata" VALUES('PROJ_DATA.VERSION', '1.7');
+INSERT INTO "metadata" VALUES('PROJ_DATA.VERSION', '1.8');