diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-01-17 00:24:03 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-01-17 00:52:19 +0100 |
| commit | 4724025e6c817761052fc0dc8810fd489a9e0104 (patch) | |
| tree | 21117e52f95b8f36880efef8cd71c1fcec21242c /data/sql/customizations.sql | |
| parent | 66fd99a8831955034cb25c8468ecfe1f9d3a7d62 (diff) | |
| parent | d76e6202d27c730b4dcbf16b8c1575c11b703485 (diff) | |
| download | PROJ-4724025e6c817761052fc0dc8810fd489a9e0104.tar.gz PROJ-4724025e6c817761052fc0dc8810fd489a9e0104.zip | |
Merge branch 'master' into rfc4_merge_back_master
Diffstat (limited to 'data/sql/customizations.sql')
| -rw-r--r-- | data/sql/customizations.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index 8003c921..503a1fe0 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -26,6 +26,17 @@ UPDATE grid_transformation SET interpolation_crs_auth_name = 'EPSG', interpolation_crs_code = '4289' WHERE auth_name = 'EPSG' AND code = '7001'; +-- EPSG:1312 'NAD27 to NAD83 (3)' / NTv1_0.gsb has a accuracy of 1m whereas +-- EPSG:1313 'NAD27 to NAD83 (4)' / NTv2_0.gsb has a accuracy of 1.5m +-- so we will never select automatically NTv2_0.gsb. Worse the advertize +-- accuracy of the NTv1 method + +UPDATE grid_transformation SET accuracy = 2.0 WHERE auth_name = 'EPSG' AND code = '1312'; + +-- Same for EPSG:1462 vs EPSG:1573 + +UPDATE grid_transformation SET accuracy = 2.0 WHERE auth_name = 'EPSG' AND code = '1462'; + -- Define the allowed authorities, and their precedence, when researching a -- coordinate operation @@ -90,3 +101,16 @@ INSERT INTO "geoid_model" SELECT 'GEOID12A', auth_name, code FROM grid_transform 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; + +---- PROJ historic +datum aliases ----- + +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6326','WGS84','PROJ'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6121','GGRS87','PROJ'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6269','NAD83','PROJ'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6267','NAD27','PROJ'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6314','potsdam','PROJ'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6223','carthage','PROJ'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6312','hermannskogel','PROJ'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6299','ire65','PROJ'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6272','nzgd49','PROJ'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6277','OSGB36','PROJ'); |