diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2019-10-16 12:27:12 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-10-16 12:27:12 +0200 |
| commit | 5fbcf98c9ac6184a066d66a39d55bd3084926b2f (patch) | |
| tree | 83c506c4927f4282384b6f15ebd0f53b0cc417ab /data/sql/customizations.sql | |
| parent | e2abe08de3d213980536944f9aa1d27352447ccd (diff) | |
| parent | 885f0b59eaac1424ed962117bac0f85edc42699b (diff) | |
| download | PROJ-5fbcf98c9ac6184a066d66a39d55bd3084926b2f.tar.gz PROJ-5fbcf98c9ac6184a066d66a39d55bd3084926b2f.zip | |
Merge pull request #1673 from rouault/update_epsg_9_8_3
Database: update to EPSG v9.8.3
Diffstat (limited to 'data/sql/customizations.sql')
| -rw-r--r-- | data/sql/customizations.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index 98633045..99891dc1 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -82,3 +82,16 @@ INSERT INTO "helmert_transformation" VALUES('PROJ','WGS84_TO_WGS84_G1150','WGS 8 INSERT INTO "helmert_transformation" VALUES('PROJ','WGS84_TO_WGS84_G1674','WGS 84 to WGS 84 (G1674)','','Accuracy 2m','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4326','EPSG','9056','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_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'; |