diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2019-11-02 18:48:20 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2019-11-02 22:28:54 +0100 |
| commit | 7492e65bfebadfcd44d3e2e4916a9d19e4bc6ae2 (patch) | |
| tree | e93fe704abf9c95f4b3ef19f42e65bfd8f2a999a /data/sql/customizations.sql | |
| parent | 31fd3de9c2b2f823c01b3c2dbadddf4a7101fa16 (diff) | |
| download | PROJ-7492e65bfebadfcd44d3e2e4916a9d19e4bc6ae2.tar.gz PROJ-7492e65bfebadfcd44d3e2e4916a9d19e4bc6ae2.zip | |
Add a geoid_model name in database, use GEOIDMODEL for transformations, add a proj_create_vertical_crs_ex()
Diffstat (limited to 'data/sql/customizations.sql')
| -rw-r--r-- | data/sql/customizations.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index 99891dc1..b0804ebd 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -95,3 +95,20 @@ INSERT INTO "helmert_transformation" VALUES('PROJ','WGS84_TO_WGS84_TRANSIT','WGS 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; + +INSERT INTO "geoid_model" SELECT 'GEOID03', auth_name, code FROM grid_transformation WHERE auth_name = 'EPSG' AND grid_name LIKE 'geoid03%' AND deprecated = 0; + +INSERT INTO "geoid_model" SELECT 'GEOID06', auth_name, code FROM grid_transformation WHERE auth_name = 'EPSG' AND grid_name LIKE 'geoid06%' AND deprecated = 0; + +INSERT INTO "geoid_model" SELECT 'GEOID09', auth_name, code FROM grid_transformation WHERE auth_name = 'EPSG' AND grid_name LIKE 'geoid09%' AND deprecated = 0; + +-- Geoid12A and Geoid12B are identical +INSERT INTO "geoid_model" SELECT 'GEOID12A', auth_name, code FROM grid_transformation WHERE auth_name = 'EPSG' AND grid_name LIKE 'g2012b%' AND deprecated = 0; + +INSERT INTO "geoid_model" SELECT 'GEOID12B', auth_name, code FROM grid_transformation WHERE auth_name = 'EPSG' AND grid_name LIKE 'g2012b%' AND deprecated = 0; + +INSERT INTO "geoid_model" SELECT 'GEOID18', auth_name, code FROM grid_transformation WHERE auth_name = 'EPSG' AND grid_name LIKE 'g2018%' AND deprecated = 0; |