From 206a45de20b4936efa0e216fce6addd768881508 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Tue, 7 Jan 2020 12:27:19 +0100 Subject: Database: insert PROJ.4 +datum values in alias_name table under PROJ authority --- data/sql/customizations.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'data/sql/customizations.sql') diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index 86d49b09..503a1fe0 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -101,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'); -- cgit v1.2.3