From 76d31bfa28d3d5c92c98a9a9a27b3cfedb44b9b4 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Fri, 21 Jan 2022 22:35:51 +0100 Subject: Database: update to EPSG 10.048 Ultra minor update --- data/sql/helmert_transformation.sql | 6 ++++-- data/sql/metadata.sql | 4 ++-- 2 files changed, 6 insertions(+), 4 deletions(-) (limited to 'data') diff --git a/data/sql/helmert_transformation.sql b/data/sql/helmert_transformation.sql index 4eb62af8..4c17c67f 100644 --- a/data/sql/helmert_transformation.sql +++ b/data/sql/helmert_transformation.sql @@ -969,7 +969,7 @@ INSERT INTO "helmert_transformation" VALUES('EPSG','1823','Minna to WGS 84 (9)', INSERT INTO "usage" VALUES('EPSG','8744','helmert_transformation','EPSG','1823','EPSG','3816','EPSG','1136'); INSERT INTO "helmert_transformation" VALUES('EPSG','1824','Minna to WGS 84 (10)','Used by Shell SNEPCO for Gongola basin.','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4263','EPSG','4326',25.0,-93.0,-94.0,124.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SHL-Nga Gongola',0); INSERT INTO "usage" VALUES('EPSG','8745','helmert_transformation','EPSG','1824','EPSG','3824','EPSG','1136'); -INSERT INTO "helmert_transformation" VALUES('EPSG','1825','Hong Kong 1980 to WGS 84 (1)','Published 1st March 2002. Parameter values from Hong Kong 1980 to Hong Kong Geodetic CS (1) (code 8437) with change of rotation convention. Assumes Hong Kong Geodetic CS and WGS 84 are equivalent within the accuracy of the transformation.','EPSG','9606','Position Vector transformation (geog2D domain)','EPSG','4611','EPSG','4326',1.0,-162.619,-276.959,-161.764,'EPSG','9001',0.067753,-2.243649,-1.158827,'EPSG','9104',-1.094246,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LSD-HKG 2002',0); +INSERT INTO "helmert_transformation" VALUES('EPSG','1825','Hong Kong 1980 to WGS 84 (1)','Derived via ITRF96 @ 1998.121. Published 2002-03-01. Parameter values from Hong Kong 1980 to Hong Kong Geodetic CS (1) (code 9913) assuming Hong Kong Geodetic CS and WGS 84 are equivalent within the accuracy of the CT.','EPSG','9607','Coordinate Frame rotation (geog2D domain)','EPSG','4611','EPSG','4326',1.0,-162.619,-276.959,-161.764,'EPSG','9001',-0.067753,2.243648,1.158828,'EPSG','9104',-1.094246,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LSD-HKG 2002',0); INSERT INTO "usage" VALUES('EPSG','8746','helmert_transformation','EPSG','1825','EPSG','1118','EPSG','1252'); INSERT INTO "helmert_transformation" VALUES('EPSG','1826','JGD2000 to WGS 84 (1)','Excludes area affected by the 2011 Tohoku earthquake. For areas of northern Honshu affected by the earthquake see JGD2000 to WGS 84 (2) (code 9896).','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4612','EPSG','4326',1.0,0.0,0.0,0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EPSG-Jpn',0); INSERT INTO "usage" VALUES('EPSG','8747','helmert_transformation','EPSG','1826','EPSG','4163','EPSG','1252'); @@ -2079,7 +2079,7 @@ INSERT INTO "helmert_transformation" VALUES('EPSG','8435','Macao 2008 to Macao 1 INSERT INTO "usage" VALUES('EPSG','10556','helmert_transformation','EPSG','8435','EPSG','1147','EPSG','1041'); INSERT INTO "helmert_transformation" VALUES('EPSG','8436','Macao 2008 to WGS 84 (1)','Approximation at the +/- 1m level assuming that Macao 2008 is equivalent to WGS 84.','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','8431','EPSG','4326',1.0,0.0,0.0,0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'OGP-Bmu',0); INSERT INTO "usage" VALUES('EPSG','10557','helmert_transformation','EPSG','8436','EPSG','1147','EPSG','1252'); -INSERT INTO "helmert_transformation" VALUES('EPSG','8437','Hong Kong 1980 to Hong Kong Geodetic CS (1)','Also published as a transformation to WGS 84 using the position vector method - see Hong Kong 1980 to WGS 84 (1) (code 1825).','EPSG','9607','Coordinate Frame rotation (geog2D domain)','EPSG','4611','EPSG','8427',1.0,-162.619,-276.961,-161.763,'EPSG','9001',0.067741,-2.243649,-1.158827,'EPSG','9104',-1.094239,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LSD-HKG 2002',0); +INSERT INTO "helmert_transformation" VALUES('EPSG','8437','Hong Kong 1980 to Hong Kong Geodetic CS (1)','Also published as a transformation to WGS 84 using the position vector method - see Hong Kong 1980 to WGS 84 (1) (code 1825).','EPSG','9607','Coordinate Frame rotation (geog2D domain)','EPSG','4611','EPSG','8427',1.0,-162.619,-276.961,-161.763,'EPSG','9001',0.067741,-2.243649,-1.158827,'EPSG','9104',-1.094239,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LSD-HKG 2002',1); INSERT INTO "usage" VALUES('EPSG','10558','helmert_transformation','EPSG','8437','EPSG','1118','EPSG','1041'); INSERT INTO "helmert_transformation" VALUES('EPSG','8438','Macao 1920 to WGS 84 (1)','Derived from Macao 2008 to Macao 1920 (1) (code 8435) (reversed) assuming that Macao 2008 is equivalent to WGS 84 within the accuracy of the transformation. Some parameter values differ in the reverse due to the high rotations.','EPSG','9636','Molodensky-Badekas (CF geog2D domain)','EPSG','8428','EPSG','4326',1.0,-202.865,-303.99,-155.873,'EPSG','9001',-34.079,76.126,32.66,'EPSG','9104',6.096,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-2361554.788,5417536.177,2391608.926,'EPSG','9001','EPSG-Mac',0); INSERT INTO "usage" VALUES('EPSG','10559','helmert_transformation','EPSG','8438','EPSG','1147','EPSG','1252'); @@ -2473,6 +2473,8 @@ INSERT INTO "helmert_transformation" VALUES('EPSG','9899','LUREF to ETRS89 (6)', INSERT INTO "usage" VALUES('EPSG','17306','helmert_transformation','EPSG','9899','EPSG','1146','EPSG','1282'); INSERT INTO "helmert_transformation" VALUES('EPSG','9901','UCS-2000 to ETRS89 (1)','Rounded parameter values taken from UCS-2000 to ITRF2000 (1) (code 7817) assuming that ETRS89 is equivalent to ITRS2000 within the accuracy of the transformation.','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','5561','EPSG','4258',1.0,24.0,-121.0,-76.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'OGP-Ukr SSGC',0); INSERT INTO "usage" VALUES('EPSG','17069','helmert_transformation','EPSG','9901','EPSG','1242','EPSG','1252'); +INSERT INTO "helmert_transformation" VALUES('EPSG','9913','Hong Kong 1980 to Hong Kong Geodetic CS (1)','Derived via ITRF96 @ 1998.121. Published 2002-03-01. Also published as a transformation to WGS 84 - see Hong Kong 1980 to WGS 84 (1) (code 1825).','EPSG','9607','Coordinate Frame rotation (geog2D domain)','EPSG','4611','EPSG','8427',1.0,-162.619,-276.959,-161.764,'EPSG','9001',-0.067753,2.243648,1.158828,'EPSG','9104',-1.094246,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LSD-HKG 2002',0); +INSERT INTO "usage" VALUES('EPSG','17339','helmert_transformation','EPSG','9913','EPSG','1118','EPSG','1041'); INSERT INTO "helmert_transformation" VALUES('EPSG','9936','JGD2011 to WGS 84 (1)','','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','6668','EPSG','4326',1.0,0.0,0.0,0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EPSG-Jpn',0); INSERT INTO "usage" VALUES('EPSG','17201','helmert_transformation','EPSG','9936','EPSG','1129','EPSG','1252'); INSERT INTO "helmert_transformation" VALUES('EPSG','9937','LUREF to ETRS89 (7)','LUREF 2020 parameters. For an equivalent CT using the Coordinate Frame method see CT 9938. Defines LUREF from 2020. Replaces LUREF 2014 parameters (CT 9898). Info source gives this CT in reverse direction. Derived using ETRF2000 @2013-01-27.','EPSG','9636','Molodensky-Badekas (CF geog2D domain)','EPSG','4181','EPSG','4258',0.0,-265.9196,76.9506,20.2222,'EPSG','9001',0.48171,3.09948,-2.68639,'EPSG','9104',0.46346,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4101567.0943,440245.0881,4848681.4115,'EPSG','9001','ACT-Lux MB 2020',0); diff --git a/data/sql/metadata.sql b/data/sql/metadata.sql index 31f90733..e576a9af 100644 --- a/data/sql/metadata.sql +++ b/data/sql/metadata.sql @@ -9,8 +9,8 @@ INSERT INTO "metadata" VALUES('DATABASE.LAYOUT.VERSION.MAJOR', 1); INSERT INTO "metadata" VALUES('DATABASE.LAYOUT.VERSION.MINOR', 2); -INSERT INTO "metadata" VALUES('EPSG.VERSION', 'v10.047'); -INSERT INTO "metadata" VALUES('EPSG.DATE', '2022-01-07'); +INSERT INTO "metadata" VALUES('EPSG.VERSION', 'v10.048'); +INSERT INTO "metadata" VALUES('EPSG.DATE', '2022-01-21'); -- The value of ${PROJ_VERSION} is substituted at build time by the actual -- value. -- cgit v1.2.3