From 5085e294875c17ab5b0a6275f35b4a41eda3b158 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Wed, 26 Jan 2022 14:32:44 +0100
Subject: Database: update to EPSG 10.051

---
 data/sql/grid_transformation.sql | 26 ++++++++++++++++++++++++--
 1 file changed, 24 insertions(+), 2 deletions(-)

(limited to 'data/sql/grid_transformation.sql')

diff --git a/data/sql/grid_transformation.sql b/data/sql/grid_transformation.sql
index c94084f5..af3f9152 100644
--- a/data/sql/grid_transformation.sql
+++ b/data/sql/grid_transformation.sql
@@ -738,7 +738,7 @@ INSERT INTO "grid_transformation" VALUES('EPSG','9325','NZGD2000 to NZVD2009 hei
 INSERT INTO "usage" VALUES('EPSG','14379','grid_transformation','EPSG','9325','EPSG','1175','EPSG','1133');
 INSERT INTO "grid_transformation" VALUES('EPSG','9326','NZGD2000 to NZVD2016 height (2)','Defines NZVD2016 vertical datum (datum code 1169, CRS code 7839). Supersedes NZGD2000 to NZVD2016 height (1) (code 7840) after change of grid file format. For reversible alternative to this CT see NZGD2000 to NZGD2000 + NZVD2016 height (2) (code 9628).','EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)','EPSG','4959','EPSG','7839',0.1,'EPSG','8666','Geoid (height correction) model file','nzgeoid2016.gtx',NULL,NULL,NULL,NULL,NULL,NULL,'LINZ-NZ 2016 gtx',0);
 INSERT INTO "usage" VALUES('EPSG','14382','grid_transformation','EPSG','9326','EPSG','1175','EPSG','1133');
-INSERT INTO "grid_transformation" VALUES('EPSG','9327','NTF to RGF93 v1 (1)','May be emulated using NTv2 method - see tfm code 15958.','EPSG','1087','Geocentric translation by Grid Interpolation (IGN)','EPSG','4275','EPSG','4171',1.0,'EPSG','8727','Geocentric translation file','gr3df97a.txt',NULL,NULL,NULL,NULL,'EPSG','4171','IGN-Fra 1m',0);
+INSERT INTO "grid_transformation" VALUES('EPSG','9327','NTF to RGF93 v1 (1)','May be emulated using NTv2 method - see tfm code 15958. Also used to transform between NTF and later realizations of RGF93.','EPSG','1087','Geocentric translation by Grid Interpolation (IGN)','EPSG','4275','EPSG','4171',1.0,'EPSG','8727','Geocentric translation file','gr3df97a.txt',NULL,NULL,NULL,NULL,'EPSG','4171','IGN-Fra 1m',0);
 INSERT INTO "usage" VALUES('EPSG','13956','grid_transformation','EPSG','9327','EPSG','3694','EPSG','1041');
 INSERT INTO "grid_transformation" VALUES('EPSG','9328','NEA74 Noumea to RGNC91-93 (3)','Developed in July 2002 and officially adopted in August 2005. May be emulated using NTv2 method - see RGNC91-93 to NEA74 Noumea (4) (code 1295).','EPSG','1087','Geocentric translation by Grid Interpolation (IGN)','EPSG','4644','EPSG','4749',0.05,'EPSG','8727','Geocentric translation file','gr3dnc03a.mnt',NULL,NULL,NULL,NULL,'EPSG','4749','BGN-Ncl 0.05m',0);
 INSERT INTO "usage" VALUES('EPSG','13957','grid_transformation','EPSG','9328','EPSG','2823','EPSG','1031');
@@ -1130,6 +1130,14 @@ INSERT INTO "grid_transformation" VALUES('EPSG','9886','NAD27 to NAD83(CSRS)v2 (
 INSERT INTO "usage" VALUES('EPSG','16978','grid_transformation','EPSG','9886','EPSG','2375','EPSG','1151');
 INSERT INTO "grid_transformation" VALUES('EPSG','9887','NAD83 to NAD83(CSRS)v2 (2)','Can be taken as an approximate transformation NAD83 to WGS 84 - see code 1697.','EPSG','9615','NTv2','EPSG','4269','EPSG','8237',1.5,'EPSG','8656','Latitude and longitude difference file','SK83-98.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'SK PMC-Can SK',0);
 INSERT INTO "usage" VALUES('EPSG','16979','grid_transformation','EPSG','9887','EPSG','2375','EPSG','1151');
+INSERT INTO "grid_transformation" VALUES('EPSG','9888','NTF to RGF93 v2 (1)','Parameter file is from NTF to RGF93 v1 (code 9327), assuming that RGF93 v1 is equivalent to RGF93 v2 within the accuracy of the transformation. May be emulated using NTv2 method - see CT code 9890.','EPSG','1087','Geocentric translation by Grid Interpolation (IGN)','EPSG','4275','EPSG','9777',1.0,'EPSG','8727','Geocentric translation file','gr3df97a.txt',NULL,NULL,NULL,NULL,'EPSG','9777','IGN-Fra 1m',0);
+INSERT INTO "usage" VALUES('EPSG','17063','grid_transformation','EPSG','9888','EPSG','3694','EPSG','1041');
+INSERT INTO "grid_transformation" VALUES('EPSG','9889','NTF to RGF93 v2b (1)','Parameter file is from NTF to RGF93 v1 (code 9327), assuming that RGF93 v1 is equivalent to RGF93 v2b within the accuracy of the transformation. May be emulated using NTv2 method - see CT code 9891.','EPSG','1087','Geocentric translation by Grid Interpolation (IGN)','EPSG','4275','EPSG','9782',1.0,'EPSG','8727','Geocentric translation file','gr3df97a.txt',NULL,NULL,NULL,NULL,'EPSG','9782','IGN-Fra 1m',0);
+INSERT INTO "usage" VALUES('EPSG','17064','grid_transformation','EPSG','9889','EPSG','3694','EPSG','1041');
+INSERT INTO "grid_transformation" VALUES('EPSG','9890','RGF93 v2 to NTF (2)','Emulation of transformation NTF to RGF93 v2 (1), code 9888. Note that grid file parameters are of opposite sign. Parameter file is from RGF93 v1 to NTF (code 15958), assuming that RGF93 v1 is equivalent to RGF93 v2 within the accuracy of the CT.','EPSG','9615','NTv2','EPSG','9777','EPSG','4275',1.0,'EPSG','8656','Latitude and longitude difference file','rgf93_ntf.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'ESRI-Fra 1m emulation',0);
+INSERT INTO "usage" VALUES('EPSG','17060','grid_transformation','EPSG','9890','EPSG','3694','EPSG','1041');
+INSERT INTO "grid_transformation" VALUES('EPSG','9891','RGF93 v2b to NTF (2)','Emulation of transformation NTF to RGF93 v2b (1), code 9889. Note that grid file parameters are of opposite sign. Parameter file is from RGF93 v1 to NTF (code 15958), assuming that RGF93 v1 is equivalent to RGF93 v2b within the accuracy of the CT.','EPSG','9615','NTv2','EPSG','9782','EPSG','4275',1.0,'EPSG','8656','Latitude and longitude difference file','rgf93_ntf.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'ESRI-Fra 1m emulation',0);
+INSERT INTO "usage" VALUES('EPSG','17062','grid_transformation','EPSG','9891','EPSG','3694','EPSG','1041');
 INSERT INTO "grid_transformation" VALUES('EPSG','9896','JGD2000 to WGS 84 (2)','Parameter file from JGD2000 to JGD2011 (1) (code 6713) assuming that JGD2011 is equivalent to WGS 84 within the accuracy of this CT. Use for area affected by the 2011 Tohoku earthquake; for areas outside this extent use JGD2000 to WGS 84 (1) (code 1826).','EPSG','9615','NTv2','EPSG','4612','EPSG','4326',1.0,'EPSG','8656','Latitude and longitude difference file','touhokutaiheiyouoki2011.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'IOGP-Jpn N Honshu',0);
 INSERT INTO "usage" VALUES('EPSG','17283','grid_transformation','EPSG','9896','EPSG','4170','EPSG','1252');
 INSERT INTO "grid_transformation" VALUES('EPSG','9900','Genoa 1942 height to EVRF2019 height (1)','Determined at 26 points, SD 0.062m. Offset: mean -0.285m, minimum -0.441m, maximum -0.194m. The extent corresponds to the area in Italy containing benchmarks with EVRF heights.','EPSG','1085','Vertical Offset by Grid Interpolation (asc)','EPSG','5214','EPSG','9389',0.124,'EPSG','8732','Vertical offset file','it_2019z.asc',NULL,NULL,NULL,NULL,'EPSG','4258','EuG-Ita 2019z 2020-09',0);
@@ -1138,12 +1146,26 @@ INSERT INTO "grid_transformation" VALUES('EPSG','9902','Baltic 1977 height to EV
 INSERT INTO "usage" VALUES('EPSG','17066','grid_transformation','EPSG','9902','EPSG','3324','EPSG','1059');
 INSERT INTO "grid_transformation" VALUES('EPSG','9903','Baltic 1977 height to EVRF2019 mean-tide height (1)','Determined at 154 points, SD 0.032m. Offset: mean 0.131m, minimum 0.066m, maximum 0.268m.','EPSG','1085','Vertical Offset by Grid Interpolation (asc)','EPSG','5705','EPSG','9390',0.064,'EPSG','8732','Vertical offset file','ua_2019m.asc',NULL,NULL,NULL,NULL,'EPSG','4258','EuG-Ukr 2019m 2021',0);
 INSERT INTO "usage" VALUES('EPSG','17067','grid_transformation','EPSG','9903','EPSG','3324','EPSG','1059');
+INSERT INTO "grid_transformation" VALUES('EPSG','9914','ETRS89 to BI height (1)','For reversible alternative to this transformation see ETRS89 to ETRS89 + BI height (1) (code 9915).','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','9451',0.02,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-Gbr 2015',0);
+INSERT INTO "usage" VALUES('EPSG','17330','grid_transformation','EPSG','9914','EPSG','4390','EPSG','1133');
+INSERT INTO "grid_transformation" VALUES('EPSG','9915','ETRS89 to ETRS89 + BI height (1)','Reversible alternative to ETRS89 to BI height (1) (code 9914).','EPSG','1097','Geog3D to Geog2D+GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','9452',0.02,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,'EPSG','4258','OS-Gbr 2015',0);
+INSERT INTO "usage" VALUES('EPSG','17331','grid_transformation','EPSG','9915','EPSG','4390','EPSG','1270');
+INSERT INTO "grid_transformation" VALUES('EPSG','9916','ETRS89 to BI height (2)','Parameter file taken from ETRS89 to Belfast height (2). Belfast is a member of the BI ensemble. For reversible alternative to this transformation see ETRS89 to ETRS89 + BI height (2) (code 9917).','EPSG','1072','Geographic3D to GravityRelatedHeight (OSGM15-Ire)','EPSG','4937','EPSG','9451',0.014,'EPSG','8666','Geoid (height correction) model file','OSGM15_Belfast.gri',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK NI 2015',0);
+INSERT INTO "usage" VALUES('EPSG','17324','grid_transformation','EPSG','9916','EPSG','2530','EPSG','1133');
+INSERT INTO "grid_transformation" VALUES('EPSG','9917','ETRS89 to ETRS89 + BI height (2)','Reversible alternative to ETRS89 to BI height (2) (code 9916).','EPSG','1096','Geog3D to Geog2D+GravityRelatedHeight (OSGM15-Ire)','EPSG','4937','EPSG','9452',0.014,'EPSG','8666','Geoid (height correction) model file','OSGM15_Belfast.gri',NULL,NULL,NULL,NULL,'EPSG','4258','OS-UK NI 2015',0);
+INSERT INTO "usage" VALUES('EPSG','17325','grid_transformation','EPSG','9917','EPSG','2530','EPSG','1270');
+INSERT INTO "grid_transformation" VALUES('EPSG','9918','ETRS89 to BI height (3)','Parameter file taken from ETRS89 to Malin Head height (2). Malin Head is a member of the BI ensemble. For reversible alternative to this transformation see ETRS89 to ETRS89 + BI height (3) (code 9919).','EPSG','1072','Geographic3D to GravityRelatedHeight (OSGM15-Ire)','EPSG','4937','EPSG','9451',0.023,'EPSG','8666','Geoid (height correction) model file','OSGM15_Malin.gri',NULL,NULL,NULL,NULL,NULL,NULL,'OS-Ire 2015',0);
+INSERT INTO "usage" VALUES('EPSG','17341','grid_transformation','EPSG','9918','EPSG','1305','EPSG','1133');
+INSERT INTO "grid_transformation" VALUES('EPSG','9919','ETRS89 to ETRS89 + BI height (3)','Reversible alternative to ETRS89 to BI height (3) (code 9918).','EPSG','1096','Geog3D to Geog2D+GravityRelatedHeight (OSGM15-Ire)','EPSG','4937','EPSG','9452',0.023,'EPSG','8666','Geoid (height correction) model file','OSGM15_Malin.gri',NULL,NULL,NULL,NULL,'EPSG','4258','OS-Ire 2015',0);
+INSERT INTO "usage" VALUES('EPSG','17342','grid_transformation','EPSG','9919','EPSG','1305','EPSG','1270');
 INSERT INTO "grid_transformation" VALUES('EPSG','9921','Genoa 1942 height to EVRF2019 mean-tide height (1)','Determined at 26 points, SD 0.054m. Offset: mean -0.328m, minimum -0.469m, maximum -0.249m. The extent corresponds to the area in Italy containing benchmarks with EVRF heights.','EPSG','1085','Vertical Offset by Grid Interpolation (asc)','EPSG','5214','EPSG','9390',0.108,'EPSG','8732','Vertical offset file','it_2019m.asc',NULL,NULL,NULL,NULL,'EPSG','4258','EuG-Ita 2019m 2020-09',0);
 INSERT INTO "usage" VALUES('EPSG','17318','grid_transformation','EPSG','9921','EPSG','4659','EPSG','1059');
 INSERT INTO "grid_transformation" VALUES('EPSG','9925','ETRS89 to DHHN2016 height (1)','Accuracy approx. 1 cm in the lowlands, approx. 2 cm in the high mountains and 2 - 6 cm offshore. For reversible alternative to this transformation see ETRS89 to ETRS89 + DHHN2016 height (1) (code 9926).','EPSG','1082','Geographic3D to GravityRelatedHeight (txt)','EPSG','4937','EPSG','7837',0.02,'EPSG','8666','Geoid (height correction) model file','GCG2016.txt',NULL,NULL,NULL,NULL,NULL,NULL,'BKG-Deu 2016',0);
 INSERT INTO "usage" VALUES('EPSG','17171','grid_transformation','EPSG','9925','EPSG','3339','EPSG','1133');
 INSERT INTO "grid_transformation" VALUES('EPSG','9926','ETRS89 to ETRS89 + DHHN2016 height (1)','Reversible alternative to ETRS89 to DHHN2016 height (1) (code 9925). Accuracy approx. 1 cm in the lowlands, approx. 2 cm in the high mountains and 2 - 6 cm offshore.','EPSG','1098','Geog3D to Geog2D+GravityRelatedHeight (txt)','EPSG','4937','EPSG','9924',0.02,'EPSG','8666','Geoid (height correction) model file','GCG2016.txt',NULL,NULL,NULL,NULL,'EPSG','4258','BKG-Deu 2016',0);
 INSERT INTO "usage" VALUES('EPSG','17170','grid_transformation','EPSG','9926','EPSG','3339','EPSG','1270');
+INSERT INTO "grid_transformation" VALUES('EPSG','9940','DHDN to ETRS89 (11)','Official transformation of Hesse for the land survey register (ALKIS).','EPSG','9615','NTv2','EPSG','4314','EPSG','4258',0.1,'EPSG','8656','Latitude and longitude difference file','HeTa2010.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'LVGL-Deu HE 2010',0);
+INSERT INTO "usage" VALUES('EPSG','17340','grid_transformation','EPSG','9940','EPSG','4660','EPSG','1055');
 INSERT INTO "grid_transformation" VALUES('EPSG','10000','RGF93 v1 to NGF-IGN69 height (1)','May be used for transformations from WGS 84 to NGF-IGN69 height. Accuracy at each 0.1 deg x 0.1 degree grid node is given within the geoid model file.','EPSG','9664','Geographic3D to GravityRelatedHeight (IGN1997)','EPSG','4965','EPSG','5720',0.5,'EPSG','8666','Geoid (height correction) model file','ggf97a.txt',NULL,NULL,NULL,NULL,NULL,NULL,'IGN Fra',0);
 INSERT INTO "usage" VALUES('EPSG','11001','grid_transformation','EPSG','10000','EPSG','1326','EPSG','1133');
 INSERT INTO "grid_transformation" VALUES('EPSG','10001','ETRS89 to NGF-IGN69 height (1)','Parameter values taken from RGF93 v1 to NGF-IGN69 height (1) (code 10000) assuming that RGF93 v1 is equivalent to ETRS89 within the accuracy of the transformation. Accuracy at each 0.1 deg x 0.1 degree grid node is given within the geoid model file.','EPSG','9664','Geographic3D to GravityRelatedHeight (IGN1997)','EPSG','4937','EPSG','5720',0.5,'EPSG','8666','Geoid (height correction) model file','ggf97a.txt',NULL,NULL,NULL,NULL,NULL,NULL,'IGN Fra',0);
@@ -1378,7 +1400,7 @@ INSERT INTO "grid_transformation" VALUES('EPSG','15954','RD/83 to WGS 84 (1)','P
 INSERT INTO "usage" VALUES('EPSG','11965','grid_transformation','EPSG','15954','EPSG','2545','EPSG','1252');
 INSERT INTO "grid_transformation" VALUES('EPSG','15955','PD/83 to WGS 84 (1)','Parameter values taken from DHDN to ETRS89 (8) (code 15948) as PD/83 and ETRS89 may be considered equivalent to DHDN and WGS 84 respectively within the accuracy of the transformation.','EPSG','9615','NTv2','EPSG','4746','EPSG','4326',1.0,'EPSG','8656','Latitude and longitude difference file','BETA2007.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'OGP-Deu BeTA2007',0);
 INSERT INTO "usage" VALUES('EPSG','11966','grid_transformation','EPSG','15955','EPSG','2544','EPSG','1252');
-INSERT INTO "grid_transformation" VALUES('EPSG','15958','RGF93 v1 to NTF (2)','Emulation using NTv2 method of transformation NTF to RGF93 v1 (1), code 9327. Note that grid file parameters are of opposite sign. May be taken as approximate transformation to ETRS89 or WGS 84 - see tfm codes 15959 and 15960.','EPSG','9615','NTv2','EPSG','4171','EPSG','4275',1.0,'EPSG','8656','Latitude and longitude difference file','rgf93_ntf.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'ESRI-Fra 1m emulation',0);
+INSERT INTO "grid_transformation" VALUES('EPSG','15958','RGF93 v1 to NTF (2)','Emulation using NTv2 method of NTF to RGF93 v1 (1), code 9327. Note that grid file parameters are of opposite sign. May be taken as approximate CT to ETRS89 or WGS 84 (see codes 15959 and 15960). Also used to transform later realizations of RGF93 to NTF.','EPSG','9615','NTv2','EPSG','4171','EPSG','4275',1.0,'EPSG','8656','Latitude and longitude difference file','rgf93_ntf.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'ESRI-Fra 1m emulation',0);
 INSERT INTO "usage" VALUES('EPSG','11969','grid_transformation','EPSG','15958','EPSG','3694','EPSG','1041');
 INSERT INTO "grid_transformation" VALUES('EPSG','15959','ETRS89 to NTF (3)','These parameter values are taken from RGF93 to NTF (2) (code 15958) as RGF93 may be considered equivalent to ETRS89 within the accuracy of the transformation.','EPSG','9615','NTv2','EPSG','4258','EPSG','4275',1.0,'EPSG','8656','Latitude and longitude difference file','rgf93_ntf.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'EPSG-Fra 1m emulation',0);
 INSERT INTO "usage" VALUES('EPSG','11970','grid_transformation','EPSG','15959','EPSG','3694','EPSG','1041');
-- 
cgit v1.2.3

