diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-02-11 11:06:49 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2021-02-11 11:06:49 +0100 |
| commit | d3a6ca45adc0b3303a599612070535e4cb600662 (patch) | |
| tree | 9f26f7e915bc2c1da54b1537170b6b7b31532500 | |
| parent | 93d2571d56d63bd0d2904ad7d0c7c51dc702ca33 (diff) | |
| download | PROJ-d3a6ca45adc0b3303a599612070535e4cb600662.tar.gz PROJ-d3a6ca45adc0b3303a599612070535e4cb600662.zip | |
Database: update to EPSG v10.014
| -rw-r--r-- | data/sql/commit.sql | 4 | ||||
| -rw-r--r-- | data/sql/customizations.sql | 2 | ||||
| -rw-r--r-- | data/sql/grid_transformation.sql | 34 | ||||
| -rw-r--r-- | data/sql/metadata.sql | 4 | ||||
| -rwxr-xr-x | scripts/build_db.py | 53 |
5 files changed, 35 insertions, 62 deletions
diff --git a/data/sql/commit.sql b/data/sql/commit.sql index f3fcc69a..48dc4150 100644 --- a/data/sql/commit.sql +++ b/data/sql/commit.sql @@ -184,13 +184,13 @@ FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'missing au_ga_AUSGeoid98.tif') WHERE NOT EXISTS(SELECT 1 FROM grid_alternatives WHERE proj_grid_name = 'au_ga_AUSGeoid98.tif'); - -- clause because of buggy entries in EPSG 10.013 + -- clause because of buggy entries in EPSG 10.014 SELECT RAISE(ABORT, 'invalid Geog3D to Geog2D + GravityRelatedHeight (foo) entries: target CRS is not a compound CRS') WHERE EXISTS (SELECT 1 FROM grid_transformation gt WHERE method_auth_name = 'EPSG' AND method_code IN ('1088', '1089', '1090', '1091', '1092', '1093', '1094', '1095', '1096', '1097', '1098', '1103') AND gt.deprecated = 0 AND NOT EXISTS (SELECT 1 FROM compound_crs c WHERE gt.target_crs_code = c.code AND gt.target_crs_auth_name = c.auth_name) AND - NOT (gt.auth_name = 'EPSG' AND gt.code IN ('9610', '9613', '9619', '9633')) + NOT (gt.auth_name = 'EPSG' AND gt.code IN ('9627')) ); END; diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index 10c671e8..47991268 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -357,5 +357,5 @@ SELECT FROM grid_transformation gt JOIN usage u ON u.object_auth_name = gt.auth_name AND u.object_code = gt.code AND u.object_table_name = 'grid_transformation' WHERE method_auth_name = 'EPSG' AND method_code IN ('1088', '1089', '1090', '1091', '1092', '1093', '1094', '1095', '1096', '1097', '1098', '1103') AND gt.deprecated = 0 - AND EXISTS (SELECT 1 FROM compound_crs c WHERE target_crs_code = c.code AND target_crs_auth_name = c.auth_name) -- clause because of buggy entries in EPSG 10.013 + AND EXISTS (SELECT 1 FROM compound_crs c WHERE target_crs_code = c.code AND target_crs_auth_name = c.auth_name) -- clause because of buggy entries in EPSG 10.014 ; diff --git a/data/sql/grid_transformation.sql b/data/sql/grid_transformation.sql index 25059df6..b15aba30 100644 --- a/data/sql/grid_transformation.sql +++ b/data/sql/grid_transformation.sql @@ -916,6 +916,16 @@ INSERT INTO "grid_transformation" VALUES('EPSG','9591','ETRS89 to ETRS89 + Malin INSERT INTO "usage" VALUES('EPSG','15081','grid_transformation','EPSG','9591','EPSG','1305','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9592','ETRS89 to ETRS89 + Belfast height (2)','Reversible alternative to ETRS89 to Belfast height (2) (code 7958).','EPSG','1096','Geog3D to Geog2D+GravityRelatedHeight (OSGM15-Ire)','EPSG','4937','EPSG','9450',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','14504','grid_transformation','EPSG','9592','EPSG','2530','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9593','ETRS89 to ETRS89 + NN2000 height (1)','Reversible alternative to ETRS89 to NN2000 height (1) (code 9485).','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','4937','EPSG','5942',0.02,'EPSG','8666','Geoid (height correction) model file','HREF2018B_NN2000_EUREF89.gtx',NULL,NULL,NULL,NULL,'EPSG','4258','SK-Nor 2018',0); +INSERT INTO "usage" VALUES('EPSG','14465','grid_transformation','EPSG','9593','EPSG','1352','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9594','ETRS89 to ETRS89 + NN54 height (1)','Reversible alternative to ETRS89 to NN54 height (1) (code 9484).','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','4937','EPSG','6144',0.02,'EPSG','8666','Geoid (height correction) model file','href2008a.gtx',NULL,NULL,NULL,NULL,'EPSG','4258','SK-Nor 2008',0); +INSERT INTO "usage" VALUES('EPSG','14464','grid_transformation','EPSG','9594','EPSG','1352','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9595','NAD83(2011) to NAD83(2011) + NAVD88 height (3)','Reversible alternative to NAD83(2011) to NAVD88 height (3) (code 9229). Uses Geoid18 hybrid model. Replaces 12B model. See information source for further information.','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','6319','EPSG','6349',0.015,'EPSG','8666','Geoid (height correction) model file','g2018u0.bin',NULL,NULL,NULL,NULL,'EPSG','6318','NGS-US Conus 18',0); +INSERT INTO "usage" VALUES('EPSG','14853','grid_transformation','EPSG','9595','EPSG','1323','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9596','NAD83(2011) to NAD83(2011) + NAVD88 height (2)','Reversible alternative to NAD83(2011) to NAVD88 height (2) (code 6327).','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','6319','EPSG','6349',0.02,'EPSG','8666','Geoid (height correction) model file','g2012ba0.bin',NULL,NULL,NULL,NULL,'EPSG','6318','NGS-US AK',0); +INSERT INTO "usage" VALUES('EPSG','14456','grid_transformation','EPSG','9596','EPSG','1330','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9597','ETRS89 to ETRS89 + NAP height (2)','Reversible alternative to ETRS89 to NAP height (2) (code 9283).','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','4937','EPSG','9286',0.001,'EPSG','8666','Geoid (height correction) model file','nlgeo2018.gtx',NULL,NULL,NULL,NULL,'EPSG','4258','NSGI-Nld 2018',0); +INSERT INTO "usage" VALUES('EPSG','14455','grid_transformation','EPSG','9597','EPSG','1275','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9598','GR96 to GR96 + GVR2000 height (1)','Reversible alternative to GR96 to GVR2000 height (1) (code 8268). File is also available in NOAA VDatum format (ggeoid2000.gtx) and GeoTIFF format (ggeoid2000.tif). ','EPSG','1093','Geog3D to Geog2D+GravityRelatedHeight (Gravsoft)','EPSG','4909','EPSG','8349',0.1,'EPSG','8666','Geoid (height correction) model file','gr2000g.gri',NULL,NULL,NULL,NULL,'EPSG','4747','SDFE-Grl',0); INSERT INTO "usage" VALUES('EPSG','15074','grid_transformation','EPSG','9598','EPSG','4461','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9599','GR96 to GR96 + GVR2016 height (1)','Reversible alternative to GR96 to GVR2016 height (1) (code 8269). File is also available in NOAA VDatum format (ggeoid2016.gtx) and GeoTIFF format (ggeoid2016.tif).','EPSG','1093','Geog3D to Geog2D+GravityRelatedHeight (Gravsoft)','EPSG','4909','EPSG','8350',0.1,'EPSG','8666','Geoid (height correction) model file','ggeoid16.gri',NULL,NULL,NULL,NULL,'EPSG','4747','SDFE-Grl',0); @@ -940,13 +950,13 @@ INSERT INTO "grid_transformation" VALUES('EPSG','9608','ETRS89 to ETRS89 + Mallo INSERT INTO "usage" VALUES('EPSG','14281','grid_transformation','EPSG','9608','EPSG','4602','EPSG','1026'); INSERT INTO "grid_transformation" VALUES('EPSG','9609','ETRS89 to ETRS89 + Menorca height (1)','Reversible alternative to ETRS89 to Menorca height (1) (code 9412).','EPSG','1092','Geog3D to Geog2D+GravityRelatedHeight (EGM2008)','EPSG','4937','EPSG','9509',0.05,'EPSG','8666','Geoid (height correction) model file','EGM08_REDNAP.txt',NULL,NULL,NULL,NULL,'EPSG','4258','IGN-Esp 2008',0); INSERT INTO "usage" VALUES('EPSG','14441','grid_transformation','EPSG','9609','EPSG','4603','EPSG','1270'); -INSERT INTO "grid_transformation" VALUES('EPSG','9610','REGCAN95 to REGCAN95 + El Hierro height (1)','Reversible alternative to REGCAN95 to El Hierro height (1) (code 9421).','EPSG','1092','Geog3D to Geog2D+GravityRelatedHeight (EGM2008)','EPSG','4080','EPSG','9401',0.05,'EPSG','8666','Geoid (height correction) model file','EGM08_REDNAP_Canarias.txt',NULL,NULL,NULL,NULL,'EPSG','4081','IGN-Esp 2008',0); +INSERT INTO "grid_transformation" VALUES('EPSG','9610','REGCAN95 to REGCAN95 + El Hierro height (1)','Reversible alternative to REGCAN95 to El Hierro height (1) (code 9421).','EPSG','1092','Geog3D to Geog2D+GravityRelatedHeight (EGM2008)','EPSG','4080','EPSG','9510',0.05,'EPSG','8666','Geoid (height correction) model file','EGM08_REDNAP_Canarias.txt',NULL,NULL,NULL,NULL,'EPSG','4081','IGN-Esp 2008',0); INSERT INTO "usage" VALUES('EPSG','15102','grid_transformation','EPSG','9610','EPSG','4597','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9611','REGCAN95 to REGCAN95 + Fuerteventura height (1)','Reversible alternative to REGCAN95 to Fuerteventura height (1) (code 9416).','EPSG','1092','Geog3D to Geog2D+GravityRelatedHeight (EGM2008)','EPSG','4080','EPSG','9511',0.05,'EPSG','8666','Geoid (height correction) model file','EGM08_REDNAP_Canarias.txt',NULL,NULL,NULL,NULL,'EPSG','4081','IGN-Esp 2008',0); INSERT INTO "usage" VALUES('EPSG','14443','grid_transformation','EPSG','9611','EPSG','4592','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9612','REGCAN95 to REGCAN95 + Gran Canaria height (1)','Reversible alternative to REGCAN95 to Gran Canaria height (1) (code 9417).','EPSG','1092','Geog3D to Geog2D+GravityRelatedHeight (EGM2008)','EPSG','4080','EPSG','9512',0.05,'EPSG','8666','Geoid (height correction) model file','EGM08_REDNAP_Canarias.txt',NULL,NULL,NULL,NULL,'EPSG','4081','IGN-Esp 2008',0); INSERT INTO "usage" VALUES('EPSG','15071','grid_transformation','EPSG','9612','EPSG','4593','EPSG','1270'); -INSERT INTO "grid_transformation" VALUES('EPSG','9613','REGCAN95 to REGCAN95 + La Gomera height (1)','Reversible alternative to REGCAN95 to La Gomera height (1) (code 9419).','EPSG','1092','Geog3D to Geog2D+GravityRelatedHeight (EGM2008)','EPSG','4080','EPSG','9399',0.05,'EPSG','8666','Geoid (height correction) model file','EGM08_REDNAP_Canarias.txt',NULL,NULL,NULL,NULL,'EPSG','4081','IGN-Esp 2008',0); +INSERT INTO "grid_transformation" VALUES('EPSG','9613','REGCAN95 to REGCAN95 + La Gomera height (1)','Reversible alternative to REGCAN95 to La Gomera height (1) (code 9419).','EPSG','1092','Geog3D to Geog2D+GravityRelatedHeight (EGM2008)','EPSG','4080','EPSG','9513',0.05,'EPSG','8666','Geoid (height correction) model file','EGM08_REDNAP_Canarias.txt',NULL,NULL,NULL,NULL,'EPSG','4081','IGN-Esp 2008',0); INSERT INTO "usage" VALUES('EPSG','14445','grid_transformation','EPSG','9613','EPSG','4595','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9614','REGCAN95 to REGCAN95 + La Palma height (1)','Reversible alternative to REGCAN95 to La Palma height (1) (code 9420).','EPSG','1092','Geog3D to Geog2D+GravityRelatedHeight (EGM2008)','EPSG','4080','EPSG','9514',0.05,'EPSG','8666','Geoid (height correction) model file','EGM08_REDNAP_Canarias.txt',NULL,NULL,NULL,NULL,'EPSG','4081','IGN-Esp 2008',0); INSERT INTO "usage" VALUES('EPSG','14446','grid_transformation','EPSG','9614','EPSG','4596','EPSG','1270'); @@ -958,19 +968,35 @@ INSERT INTO "grid_transformation" VALUES('EPSG','9617','SHGD2015 to SHGD2015 + S INSERT INTO "usage" VALUES('EPSG','14449','grid_transformation','EPSG','9617','EPSG','3183','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9618','WGS 84 to WGS 84 + EGM2008 height (2)','Reversible alternative to WGS 84 to EGM2008 height (2) (code 3859).','EPSG','1092','Geog3D to Geog2D+GravityRelatedHeight (EGM2008)','EPSG','4979','EPSG','9518',0.5,'EPSG','8666','Geoid (height correction) model file','Und_min1x1_egm2008_isw=82_WGS84_TideFree.gz',NULL,NULL,NULL,NULL,'EPSG','4326','NGA-World',0); INSERT INTO "usage" VALUES('EPSG','15073','grid_transformation','EPSG','9618','EPSG','1262','EPSG','1270'); -INSERT INTO "grid_transformation" VALUES('EPSG','9619','FEH2010 to FEH2010 + FCSVR10 height (1)','Reversible alternative to FEH2010 to FCSVR10 height (1) (code 5626).','EPSG','1093','Geog3D to Geog2D+GravityRelatedHeight (Gravsoft)','EPSG','5592','EPSG','5597',0.1,'EPSG','8666','Geoid (height correction) model file','fehmarn_geoid10.gri',NULL,NULL,NULL,NULL,'EPSG','5593','FEM-Dnk-Deu Feh',0); +INSERT INTO "grid_transformation" VALUES('EPSG','9619','FEH2010 to FEH2010 + FCSVR10 height (1)','Reversible alternative to FEH2010 to FCSVR10 height (1) (code 5626).','EPSG','1093','Geog3D to Geog2D+GravityRelatedHeight (Gravsoft)','EPSG','5592','EPSG','9519',0.1,'EPSG','8666','Geoid (height correction) model file','fehmarn_geoid10.gri',NULL,NULL,NULL,NULL,'EPSG','5593','FEM-Dnk-Deu Feh',0); INSERT INTO "usage" VALUES('EPSG','14326','grid_transformation','EPSG','9619','EPSG','3890','EPSG','1139'); INSERT INTO "grid_transformation" VALUES('EPSG','9620','KSA-GRF17 to KSA-GRF17 + KSA-VRF14 height (1)','Reversible alternative to KSA-GRF17 to KSA-VRF14 height (1) (code 9355). File also available in IGN2009 format. To access KSA-GEOID17 contact GCS by email to info@gcs.gov.sa. ','EPSG','1093','Geog3D to Geog2D+GravityRelatedHeight (Gravsoft)','EPSG','9332','EPSG','9520',0.1,'EPSG','8666','Geoid (height correction) model file','KSA-GEOID17.gra',NULL,NULL,NULL,NULL,'EPSG','9333','GCS-Sau',0); INSERT INTO "usage" VALUES('EPSG','14453','grid_transformation','EPSG','9620','EPSG','3303','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9621','POSGAR 2007 to POSGAR 2007 + SRVN16 height (1)','Reversible alternative to POSGAR 2007 to SRVN16 height (1) (code 9256). Uses geoid model Ar16. See information source for more information.','EPSG','1093','Geog3D to Geog2D+GravityRelatedHeight (Gravsoft)','EPSG','5342','EPSG','9521',0.05,'EPSG','8666','Geoid (height correction) model file','GEOIDE-Ar16.gri',NULL,NULL,NULL,NULL,'EPSG','5340','IGN-Arg',0); INSERT INTO "usage" VALUES('EPSG','15056','grid_transformation','EPSG','9621','EPSG','4573','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9622','NAD83(2011) to NAD83(2011) + PRVD02 height (2)','Reversible alternative to NAD83(2011) to PRVD02 height (2) (code 9230). Uses Geoid18 hybrid model. Replaces 12B model. See information source for further information.','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','6319','EPSG','9522',0.015,'EPSG','8666','Geoid (height correction) model file','g2018p0.bin',NULL,NULL,NULL,NULL,'EPSG','6318','NGS-Pri 18',0); +INSERT INTO "usage" VALUES('EPSG','14458','grid_transformation','EPSG','9622','EPSG','3294','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9623','NAD83(2011) to NAD83(2011) + VIVD09 height (2)','Reversible alternative to NAD83(2011) to VIVD09 height (2) (code 9231). Uses Geoid18 hybrid model. Replaces 12B model. See information source for further information.','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','6319','EPSG','9523',0.015,'EPSG','8666','Geoid (height correction) model file','g2018p0.bin',NULL,NULL,NULL,NULL,'EPSG','6318','NGS-Vir 18',0); +INSERT INTO "usage" VALUES('EPSG','14459','grid_transformation','EPSG','9623','EPSG','3330','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9624','NAD83(MA11) to NAD83(MA11) + GUVD04 height (1)','Reversible alternative to NAD83(MA11) to GUVD04 height (1) (code 7648). Uses Geoid12B hybrid model. See information source for further information.','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','6324','EPSG','9524',0.02,'EPSG','8666','Geoid (height correction) model file','g2012bg0.bin',NULL,NULL,NULL,NULL,'EPSG','6325','NGS-Gum 12B',0); +INSERT INTO "usage" VALUES('EPSG','14460','grid_transformation','EPSG','9624','EPSG','3255','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9625','NAD83(MA11) to NAD83(MA11) + NMVD03 height (1)','Reversible alternative to NAD83(MA11) to NMVD03 height (1) (code 7649). Uses Geoid12B hybrid model. See information source for further information.','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','6324','EPSG','9525',0.02,'EPSG','8666','Geoid (height correction) model file','g2012bg0.bin',NULL,NULL,NULL,NULL,'EPSG','6325','NGS-Mnp 12B',0); +INSERT INTO "usage" VALUES('EPSG','14461','grid_transformation','EPSG','9625','EPSG','4171','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9626','NAD83(PA11) to NAD83(PA11) + ASVD02 height (1)','Reversible alternative to NAD83(PA11) to ASVD02 height (1) (code 7650). Uses Geoid12B hybrid model. See information source for further information.','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','6321','EPSG','9526',0.02,'EPSG','8666','Geoid (height correction) model file','g2012bs0.bin',NULL,NULL,NULL,NULL,'EPSG','6322','NGS-Asm 12B',0); +INSERT INTO "usage" VALUES('EPSG','14463','grid_transformation','EPSG','9626','EPSG','2288','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9627','NZGD2000 to NZGD2000 + NZVD2009 height (2)','Reversible alternative to NZGD2000 to NZVD2009 height (2) (code 9325).','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','4959','EPSG','4440',0.1,'EPSG','8666','Geoid (height correction) model file','nzgeoid2009.gtx',NULL,NULL,NULL,NULL,'EPSG','4167','LINZ-NZ 2009 gtx',0); +INSERT INTO "usage" VALUES('EPSG','14466','grid_transformation','EPSG','9627','EPSG','1175','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9628','NZGD2000 to NZGD2000 + NZVD2016 height (2)','Reversible alternative to NZGD2000 to NZVD2016 height (2) (code 9326).','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','4959','EPSG','9528',0.1,'EPSG','8666','Geoid (height correction) model file','nzgeoid2016.gtx',NULL,NULL,NULL,NULL,'EPSG','4167','LINZ-NZ 2016 gtx',0); +INSERT INTO "usage" VALUES('EPSG','14467','grid_transformation','EPSG','9628','EPSG','1175','EPSG','1270'); +INSERT INTO "grid_transformation" VALUES('EPSG','9629','SRGI2013 to SRGI2013 + INAGeoid2020 height (1)','Reversible alternative to SRGI2013 to INAGeoid2020 height (1) (code 9305).','EPSG','1088','Geog3D to Geog2D+GravityRelatedHeight (gtx)','EPSG','9469','EPSG','9529',0.0,'EPSG','8666','Geoid (height correction) model file','INAGEOID20.gtx',NULL,NULL,NULL,NULL,'EPSG','9470','BIG-Idn INAGeoid20',0); +INSERT INTO "usage" VALUES('EPSG','14468','grid_transformation','EPSG','9629','EPSG','1122','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9630','RGFG95 to RGFG95 + NGG1977 height (1)','Reversible alternative to RGFG95 to NGG1977 height (1) (code 10011).','EPSG','1094','Geog3D to Geog2D+GravityRelatedHeight (IGN1997)','EPSG','4967','EPSG','9530',998.0,'EPSG','8666','Geoid (height correction) model file','ggguy00.txt',NULL,NULL,NULL,NULL,'EPSG','4624','IGN Guf',0); INSERT INTO "usage" VALUES('EPSG','14469','grid_transformation','EPSG','9630','EPSG','3146','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9631','RGAF09 to RGAF09 + Guadeloupe 1988 height (2)','Reversible alternative to RGAF09 to Guadeloupe 1988 height (2) (code 9133).','EPSG','1095','Geog3D to Geog2D+GravityRelatedHeight (IGN2009)','EPSG','5488','EPSG','9531',0.05,'EPSG','8666','Geoid (height correction) model file','RAGTBT2016.mnt',NULL,NULL,NULL,NULL,'EPSG','5489','IGN Glp GT 2016',0); INSERT INTO "usage" VALUES('EPSG','14470','grid_transformation','EPSG','9631','EPSG','2892','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9632','RGAF09 to RGAF09 + IGN 1988 LS height (2)','Reversible alternative to RGAF09 to IGN 1988 LS height (2) (code 9134).','EPSG','1095','Geog3D to Geog2D+GravityRelatedHeight (IGN2009)','EPSG','5488','EPSG','9532',0.1,'EPSG','8666','Geoid (height correction) model file','RALS2016.mnt',NULL,NULL,NULL,NULL,'EPSG','5489','IGN Glp LSt 2016',0); INSERT INTO "usage" VALUES('EPSG','14472','grid_transformation','EPSG','9632','EPSG','2895','EPSG','1270'); -INSERT INTO "grid_transformation" VALUES('EPSG','9633','RGAF09 to RGAF09 + IGN 1988 MG height (2)','Reversible alternative to RGAF09 to IGN 1988 MG height (2) (code 9135).','EPSG','1095','Geog3D to Geog2D+GravityRelatedHeight (IGN2009)','EPSG','5488','EPSG','5617',0.1,'EPSG','8666','Geoid (height correction) model file','RAMG2016.mnt',NULL,NULL,NULL,NULL,'EPSG','5489','IGN Glp MG 2016',0); +INSERT INTO "grid_transformation" VALUES('EPSG','9633','RGAF09 to RGAF09 + IGN 1988 MG height (2)','Reversible alternative to RGAF09 to IGN 1988 MG height (2) (code 9135).','EPSG','1095','Geog3D to Geog2D+GravityRelatedHeight (IGN2009)','EPSG','5488','EPSG','9533',0.1,'EPSG','8666','Geoid (height correction) model file','RAMG2016.mnt',NULL,NULL,NULL,NULL,'EPSG','5489','IGN Glp MG 2016',0); INSERT INTO "usage" VALUES('EPSG','15076','grid_transformation','EPSG','9633','EPSG','2894','EPSG','1270'); INSERT INTO "grid_transformation" VALUES('EPSG','9634','RGAF09 to RGAF09 + IGN 1988 SB height (2)','Reversible alternative to RGAF09 to IGN 1988 SB height (2) (code 9187).','EPSG','1095','Geog3D to Geog2D+GravityRelatedHeight (IGN2009)','EPSG','5488','EPSG','9534',0.1,'EPSG','8666','Geoid (height correction) model file','gg10_sbv2.mnt',NULL,NULL,NULL,NULL,'EPSG','5489','IGN Glp StB',0); INSERT INTO "usage" VALUES('EPSG','15077','grid_transformation','EPSG','9634','EPSG','2891','EPSG','1270'); diff --git a/data/sql/metadata.sql b/data/sql/metadata.sql index cdeff46d..0d68697c 100644 --- a/data/sql/metadata.sql +++ b/data/sql/metadata.sql @@ -9,5 +9,5 @@ INSERT INTO "metadata" VALUES('DATABASE.LAYOUT.VERSION.MAJOR', 1); INSERT INTO "metadata" VALUES('DATABASE.LAYOUT.VERSION.MINOR', 0); -INSERT INTO "metadata" VALUES('EPSG.VERSION', 'v10.013'); -INSERT INTO "metadata" VALUES('EPSG.DATE', '2021-02-05'); +INSERT INTO "metadata" VALUES('EPSG.VERSION', 'v10.014'); +INSERT INTO "metadata" VALUES('EPSG.DATE', '2021-02-10'); diff --git a/scripts/build_db.py b/scripts/build_db.py index c29cf019..90a4bd46 100755 --- a/scripts/build_db.py +++ b/scripts/build_db.py @@ -528,59 +528,6 @@ def fill_grid_transformation(proj_db_cursor): expected_order += 1 n_params = expected_order - 1 - # TODO: remove below hacks once EPSG has fixed its blunder - if param_code[0] is None and code == 9593: - print('Bogus ETRS89 to ETRS89 + NN2000 height (1) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9594: - print('Bogus ETRS89 to ETRS89 + NN54 height (1) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9595: - print('Bogus NAD83(2011) to NAD83(2011) + NAVD88 height (3) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9596: - print('Bogus NAD83(2011) to NAD83(2011) + NAVD88 height (2) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9597: - print('Bogus ETRS89 to ETRS89 + NAP height (2) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9622: - print('Bogus NAD83(2011) to NAD83(2011) + PRVD02 height (2) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9623: - print('Bogus NAD83(2011) to NAD83(2011) + VIVD09 height (2) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9624: - print('Bogus NAD83(MA11) to NAD83(MA11) + GUVD04 height (1) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9625: - print('Bogus NAD83(MA11) to NAD83(MA11) + NMVD03 height (1) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9626: - print('Bogus NAD83(PA11) to NAD83(PA11) + ASVD02 height (1) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9627: - print('Bogus NZGD2000 to NZGD2000 + NZVD2009 height (2) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9628: - print('Bogus NZGD2000 to NZGD2000 + NZVD2016 height (2) transformation in EPSG 10.013. Missing grid') - continue - - if param_code[0] is None and code == 9629: - print('Bogus SRGI2013 to SRGI2013 + INAGeoid2020 height (1) transformation in EPSG 10.013. Missing grid') - continue - assert param_code[0] in (1048, 1050, 8656, 8657, 8666, 8732, 8727), (code, param_code[0]) grid2_param_auth_name = None |
