From 752696eb8ac0ecb9ff96432ec5849625ed452f74 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Sun, 16 May 2021 12:41:07 +0200
Subject: Database: update to EPSG v10.022

---
 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 f0c02f4b..b0b6ab4f 100644
--- a/data/sql/grid_transformation.sql
+++ b/data/sql/grid_transformation.sql
@@ -322,9 +322,9 @@ INSERT INTO "grid_transformation" VALUES('EPSG','5334','ETRS89 to Belfast height
 INSERT INTO "usage" VALUES('EPSG','9347','grid_transformation','EPSG','5334','EPSG','2530','EPSG','1133');
 INSERT INTO "grid_transformation" VALUES('EPSG','5335','ETRS89 to Malin Head height (1)','May be used for transformations from WGS 84 to Malin Head. Replaced by ETRS89 to Malin Head height (2) (code 7959).','EPSG','1045','Geographic3D to GravityRelatedHeight (OSGM02-Ire)','EPSG','4937','EPSG','5731',0.04,'EPSG','8666','Geoid (height correction) model file','OSGM02_RoI.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-Ire',0);
 INSERT INTO "usage" VALUES('EPSG','9348','grid_transformation','EPSG','5335','EPSG','1305','EPSG','1133');
-INSERT INTO "grid_transformation" VALUES('EPSG','5338','OSGB 1936 to ETRS89 (1)','Approximate alternative to official OSTN02 method (tfm code 7952). Accuracy at 2000 test points compared to OSTN02 (tfm code 1039): latitude 0.5mm av, 17mm max; longitude 0.8mm av, 23mm max. May be taken as approximate CT to WGS 84 - see code 5339.','EPSG','9615','NTv2','EPSG','4277','EPSG','4258',0.03,'EPSG','8656','Latitude and longitude difference file','OSTN02_NTv2.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'OSGB-UK Gbr02 NT',0);
+INSERT INTO "grid_transformation" VALUES('EPSG','5338','OSGB36 to ETRS89 (1)','Approximate alternative to official OSTN02 method (tfm code 7952). Accuracy at 2000 test points compared to OSTN02 (tfm code 1039): latitude 0.5mm av, 17mm max; longitude 0.8mm av, 23mm max. May be taken as approximate CT to WGS 84 - see code 5339.','EPSG','9615','NTv2','EPSG','4277','EPSG','4258',0.03,'EPSG','8656','Latitude and longitude difference file','OSTN02_NTv2.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'OSGB-UK Gbr02 NT',0);
 INSERT INTO "usage" VALUES('EPSG','9349','grid_transformation','EPSG','5338','EPSG','4616','EPSG','1273');
-INSERT INTO "grid_transformation" VALUES('EPSG','5339','OSGB 1936 to WGS 84 (7)','Parameter values taken from OSGB 1936 to ETRS89 (1) (tfm code 5338) assuming that ETRS89 is coincident with WGS 84 within the accuracy of the tfm. Within accuracy of the tfm equivalent to OSGB 1936 / British National Grid to WGS 84 (2) (tfm code 15956).','EPSG','9615','NTv2','EPSG','4277','EPSG','4326',1.0,'EPSG','8656','Latitude and longitude difference file','OSTN02_NTv2.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'OGP-UK Gbr02 NT',0);
+INSERT INTO "grid_transformation" VALUES('EPSG','5339','OSGB36 to WGS 84 (7)','Parameter values taken from OSGB36 to ETRS89 (1) (tfm code 5338) assuming that ETRS89 is coincident with WGS 84 within the accuracy of the tfm.','EPSG','9615','NTv2','EPSG','4277','EPSG','4326',1.0,'EPSG','8656','Latitude and longitude difference file','OSTN02_NTv2.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'OGP-UK Gbr02 NT',0);
 INSERT INTO "usage" VALUES('EPSG','9350','grid_transformation','EPSG','5339','EPSG','4616','EPSG','1041');
 INSERT INTO "grid_transformation" VALUES('EPSG','5409','NGVD29 height to NAVD88 height (1)','Interpolation within the gridded data file may be made using any of the horizontal CRSs NAD27, NAD83 or NAD83(HARN).','EPSG','9658','Vertical Offset by Grid Interpolation (VERTCON)','EPSG','5702','EPSG','5703',0.02,'EPSG','8732','Vertical offset file','vertconw.94',NULL,NULL,NULL,NULL,NULL,NULL,'NGS-US Conus W',1);
 INSERT INTO "usage" VALUES('EPSG','9377','grid_transformation','EPSG','5409','EPSG','2950','EPSG','1255');
@@ -1082,6 +1082,28 @@ INSERT INTO "grid_transformation" VALUES('EPSG','9719','ETRF2000-PL to EVRF2007-
 INSERT INTO "usage" VALUES('EPSG','15238','grid_transformation','EPSG','9719','EPSG','3293','EPSG','1133');
 INSERT INTO "grid_transformation" VALUES('EPSG','9720','ETRF2000-PL to ETRF2000-PL + EVRF2007-PL height (1)','Reversible alternative to ETRF2000-PL to EVRF2007-PL height (1) (code 9719).','EPSG','1100','Geog3D to Geog2D+GravityRelatedHeight (PL txt)','EPSG','9701','EPSG','9657',0.03,'EPSG','8666','Geoid (height correction) model file','gugik-geoid2011-PL-EVRF2007-NH.txt',NULL,NULL,NULL,NULL,'EPSG','9702','GUGiK-Pol geoid11 EVRF07',0);
 INSERT INTO "usage" VALUES('EPSG','15239','grid_transformation','EPSG','9720','EPSG','3293','EPSG','1270');
+INSERT INTO "grid_transformation" VALUES('EPSG','9727','ETRS89 to Genoa 1942 height (1)','Replaces ITALGEO99. For reversible alternative to this transformation see ETRS89 to ETRS89+ Genoa 1942 height (1) (code 9729).','EPSG','1106','Geographic3D to GravityRelatedHeight (ITAL2005)','EPSG','4937','EPSG','5214',0.035,'EPSG','8666','Geoid (height correction) model file','geo_igm_mar06.grd',NULL,NULL,NULL,NULL,NULL,NULL,'IGM-Ita 2005 main Sic',0);
+INSERT INTO "usage" VALUES('EPSG','15332','grid_transformation','EPSG','9727','EPSG','3736','EPSG','1133');
+INSERT INTO "grid_transformation" VALUES('EPSG','9728','ETRS89 to Cagliari 1956 height (1)','For reversible alternative to this transformation see ETRS89 to ETRS89 + Cagliari 1956 height (1) (code 9730).','EPSG','1106','Geographic3D to GravityRelatedHeight (ITAL2005)','EPSG','4937','EPSG','9722',0.035,'EPSG','8666','Geoid (height correction) model file','geo_igm_mar06.grd',NULL,NULL,NULL,NULL,NULL,NULL,'IGM-Ita 2005 Sardinia',0);
+INSERT INTO "usage" VALUES('EPSG','15337','grid_transformation','EPSG','9728','EPSG','2339','EPSG','1133');
+INSERT INTO "grid_transformation" VALUES('EPSG','9729','ETRS89 to ETRS89 + Genoa 1942 height (1)','Reversible alternative to ETRS89 to Genoa 1942 height (1) (code 9727).','EPSG','1105','Geog3D to Geog2D+GravityRelatedHeight (ITAL2005)','EPSG','4937','EPSG','9723',0.035,'EPSG','8666','Geoid (height correction) model file','geo_igm_mar06.grd',NULL,NULL,NULL,NULL,'EPSG','4258','IGM-Ita 2005 main Sic',0);
+INSERT INTO "usage" VALUES('EPSG','15333','grid_transformation','EPSG','9729','EPSG','3736','EPSG','1270');
+INSERT INTO "grid_transformation" VALUES('EPSG','9730','ETRS89 to ETRS89 + Cagliari 1956 height (1)','Reversible alternative to ETRS89 to Cagliari 1956 height (1) (code 9728).','EPSG','1105','Geog3D to Geog2D+GravityRelatedHeight (ITAL2005)','EPSG','4937','EPSG','9725',0.035,'EPSG','8666','Geoid (height correction) model file','geo_igm_mar06.grd',NULL,NULL,NULL,NULL,'EPSG','4258','IGM-Ita 2005 Sardinia',0);
+INSERT INTO "usage" VALUES('EPSG','15283','grid_transformation','EPSG','9730','EPSG','2339','EPSG','1270');
+INSERT INTO "grid_transformation" VALUES('EPSG','9732','Monte Mario to ED50 (1)','For the reverse transformation from ED50 to Monte Mario, iteration may be avoided by using an alternative grid file (35160622_47161840_E50_R40.gsb). ','EPSG','9615','NTv2','EPSG','4265','EPSG','4230',0.1,'EPSG','8656','Latitude and longitude difference file','35160622_47161840_R40_E50.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'IGM-Ita',0);
+INSERT INTO "usage" VALUES('EPSG','15306','grid_transformation','EPSG','9732','EPSG','4619','EPSG','1031');
+INSERT INTO "grid_transformation" VALUES('EPSG','9733','Monte Mario to IGM95 (4)','For the reverse transformation from IGM95 to Monte Mario, iteration may be avoided by using an alternative grid file (35160622_47161840_F89_R40.gsb). ','EPSG','9615','NTv2','EPSG','4265','EPSG','4670',0.1,'EPSG','8656','Latitude and longitude difference file','35160622_47161840_R40_F89.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'IGM-Ita',0);
+INSERT INTO "usage" VALUES('EPSG','15327','grid_transformation','EPSG','9733','EPSG','4619','EPSG','1031');
+INSERT INTO "grid_transformation" VALUES('EPSG','9734','Monte Mario to RDN2008 (5)','For the reverse transformation from RDN2008 to Monte Mario, iteration may be avoided by using an alternative grid file (35160622_47161840_F00_R40.gsb). ','EPSG','9615','NTv2','EPSG','4265','EPSG','6706',0.1,'EPSG','8656','Latitude and longitude difference file','35160622_47161840_R40_F00.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'IGM-Ita',0);
+INSERT INTO "usage" VALUES('EPSG','15308','grid_transformation','EPSG','9734','EPSG','4619','EPSG','1031');
+INSERT INTO "grid_transformation" VALUES('EPSG','9735','ED50 to IGM95 (1)','For the reverse transformation from IGM95 to ED50, iteration may be avoided by using an alternative grid file (35160622_47161840_F89_E50.gsb).','EPSG','9615','NTv2','EPSG','4230','EPSG','4670',0.2,'EPSG','8656','Latitude and longitude difference file','35160622_47161840_E50_F89.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'IGM-Ita',0);
+INSERT INTO "usage" VALUES('EPSG','15334','grid_transformation','EPSG','9735','EPSG','4619','EPSG','1032');
+INSERT INTO "grid_transformation" VALUES('EPSG','9736','ED50 to RDN2008 (1)','For the reverse transformation from RDN2008 to ED50, iteration may be avoided by using an alternative grid file (35160622_47161840_F00_E50.gsb). ','EPSG','9615','NTv2','EPSG','4230','EPSG','6706',0.2,'EPSG','8656','Latitude and longitude difference file','35160622_47161840_E50_F00.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'IGM-Ita',0);
+INSERT INTO "usage" VALUES('EPSG','15335','grid_transformation','EPSG','9736','EPSG','4619','EPSG','1032');
+INSERT INTO "grid_transformation" VALUES('EPSG','9737','IGM95 to RDN2008 (1)','For the reverse transformation from RDN2008 to IGM95, iteration may be avoided by using an alternative grid file (35160622_47161840_F00_F89.gsb). ','EPSG','9615','NTv2','EPSG','4670','EPSG','6706',0.01,'EPSG','8656','Latitude and longitude difference file','35160622_47161840_F89_F00.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'IGM-Ita',0);
+INSERT INTO "usage" VALUES('EPSG','15336','grid_transformation','EPSG','9737','EPSG','4619','EPSG','1150');
+INSERT INTO "grid_transformation" VALUES('EPSG','9740','ETRS89 to EOS21-IRF (1)','In conjunction with the EOS-TM map projection (code 9738) applied to EOS21-IRF (code 9739), emulates the EOS21 Snake projection. Applied to ETRS89 (as realized through the OSNet v2009 CORS) defines EOS21-IRF hence is errorless.','EPSG','9615','NTv2','EPSG','4258','EPSG','9739',0.0,'EPSG','8656','Latitude and longitude difference file','TN15-ETRS89-to-EOS21-IRF.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'NR-Gbr EOS21 OSNet2009',0);
+INSERT INTO "usage" VALUES('EPSG','15342','grid_transformation','EPSG','9740','EPSG','4620','EPSG','1141');
 INSERT INTO "grid_transformation" VALUES('EPSG','10000','RGF93 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 to NGF-IGN69 height (1) (code 10000) assuming that RGF93 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);
-- 
cgit v1.2.3

