diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2019-11-02 23:38:41 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2019-11-02 23:38:41 +0100 |
| commit | 0923704ba34100643b7bce270c332fa2c430224c (patch) | |
| tree | 93b326ab6bdd73e60807391ed683eed60447e803 /data/sql/customizations.sql | |
| parent | 7492e65bfebadfcd44d3e2e4916a9d19e4bc6ae2 (diff) | |
| download | PROJ-0923704ba34100643b7bce270c332fa2c430224c.tar.gz PROJ-0923704ba34100643b7bce270c332fa2c430224c.zip | |
Database: add mapping between EPSG geoid and PROJ grid names for GEOID99, 03, 06, 09 and 18. Related to https://github.com/OSGeo/proj-datumgrid/pull/60 that add those grids in proj-datumgrid-north-america
Diffstat (limited to 'data/sql/customizations.sql')
| -rw-r--r-- | data/sql/customizations.sql | 13 |
1 files changed, 0 insertions, 13 deletions
diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index b0804ebd..6301bda9 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -83,19 +83,6 @@ INSERT INTO "helmert_transformation" VALUES('PROJ','WGS84_TO_WGS84_G1674','WGS 8 INSERT INTO "helmert_transformation" VALUES('PROJ','WGS84_TO_WGS84_G1762','WGS 84 to WGS 84 (G1762)','','Accuracy 2m','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4326','EPSG','9057','EPSG','1262',2.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,'',0); INSERT INTO "helmert_transformation" VALUES('PROJ','WGS84_TO_WGS84_TRANSIT','WGS 84 to WGS 84 (Transit)','','Accuracy 2m','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4326','EPSG','8888','EPSG','1262',2.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,'',0); ---- Remove a few supersessions --- - --- TODO: remove this once https://github.com/OSGeo/proj-datumgrid/issues/55 is dealt with --- The following supersessions are for geoid2012, replaced by geoid2018 --- but we don't have geoid2018 yet as PROJ grids, so remove for now those --- supersessions --- INSERT INTO "supersession" VALUES('grid_transformation','EPSG','6326','grid_transformation','EPSG','9229','EPSG'); --- INSERT INTO "supersession" VALUES('grid_transformation','EPSG','7646','grid_transformation','EPSG','9230','EPSG'); --- INSERT INTO "supersession" VALUES('grid_transformation','EPSG','7647','grid_transformation','EPSG','9231','EPSG'); -DELETE FROM supersession WHERE superseded_table_name = 'grid_transformation' AND superseded_auth_name = 'EPSG' AND superseded_code = '6326'; -DELETE FROM supersession WHERE superseded_table_name = 'grid_transformation' AND superseded_auth_name = 'EPSG' AND superseded_code = '7646'; -DELETE FROM supersession WHERE superseded_table_name = 'grid_transformation' AND superseded_auth_name = 'EPSG' AND superseded_code = '7647'; - ---- Geoid models ----- INSERT INTO "geoid_model" SELECT 'GEOID99', auth_name, code FROM grid_transformation WHERE auth_name = 'EPSG' AND grid_name LIKE 'g1999%' AND deprecated = 0; |