From 1929cb69e8d1a56822999c7890a69e1ad9729713 Mon Sep 17 00:00:00 2001 From: Javier Jimenez Shaw Date: Thu, 7 Oct 2021 18:36:46 +0200 Subject: add mx_inegi_ggm10.tif vertical grid file, with custom transformation --- data/sql/grid_alternatives.sql | 3 +++ data/sql/grid_transformation_custom.sql | 22 ++++++++++++++++++++++ 2 files changed, 25 insertions(+) (limited to 'data') 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..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 55b71df675729831fdd9467018a51f78be7349c5 Mon Sep 17 00:00:00 2001 From: Javier Jimenez Shaw Date: Thu, 7 Oct 2021 18:53:50 +0200 Subject: add GGM10 (Mexico to NAVD88) to geoid_model sql table --- data/sql/customizations.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'data') 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'); -- cgit v1.2.3 From c78c85f9507b9b17213893be8dba33062e1fa292 Mon Sep 17 00:00:00 2001 From: Javier Jimenez Shaw 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') 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 From 86bdfcf0d49e7674363d84f4612256fffbdbdc41 Mon Sep 17 00:00:00 2001 From: Javier Jimenez Shaw Date: Fri, 8 Oct 2021 14:21:29 +0200 Subject: update metadata.sql to PROJ_DATA version 1.8 --- data/sql/metadata.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'data') diff --git a/data/sql/metadata.sql b/data/sql/metadata.sql index 38d76533..f3987969 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'); -- cgit v1.2.3