diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-10-24 17:39:52 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-10-24 17:39:52 +0200 |
| commit | 99152afb0bf25d5d56fffc6a87bf8b392fd2cac1 (patch) | |
| tree | e4b4b22c6de9606fc57521e5a028b98f67819593 /data/sql/customizations.sql | |
| parent | 469520cbc82f0016f4c84265ac91978075cbba23 (diff) | |
| download | PROJ-99152afb0bf25d5d56fffc6a87bf8b392fd2cac1.tar.gz PROJ-99152afb0bf25d5d56fffc6a87bf8b392fd2cac1.zip | |
Database: move NZGD2000 deformation model from customizations.sql to new other_tranformation_custom.sql
Diffstat (limited to 'data/sql/customizations.sql')
| -rw-r--r-- | data/sql/customizations.sql | 101 |
1 files changed, 0 insertions, 101 deletions
diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index 96e7fe80..beaaf8fd 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -88,107 +88,6 @@ INSERT INTO "usage" VALUES( 'EPSG','1024' -- unknown ); - --- Temporary entry for NZGD2000 deformation model -INSERT INTO other_transformation VALUES( - 'PROJ','NZGD2000-20180701','NZGD2000 to ITRF96', - 'New Zealand Deformation Model. Defines the secular model (National Deformation Model) and patches for significant deformation events since 2000', - 'PROJ', 'PROJString', - '+proj=pipeline ' || - '+step +proj=unitconvert +xy_in=deg +xy_out=rad ' || - '+step +proj=axisswap +order=2,1 ' || - '+step +proj=defmodel +model=nz_linz_nzgd2000-20180701.json ' || - '+step +proj=axisswap +order=2,1 ' || - '+step +proj=unitconvert +xy_in=rad +xy_out=deg', - 'EPSG','4959', - 'EPSG','7907', - NULL, --accuracy - NULL,NULL,NULL,NULL,NULL,NULL, -- param1 - NULL,NULL,NULL,NULL,NULL,NULL, -- param2 - NULL,NULL,NULL,NULL,NULL,NULL, -- param3 - NULL,NULL,NULL,NULL,NULL,NULL, -- param4 - NULL,NULL,NULL,NULL,NULL,NULL, -- param5 - NULL,NULL,NULL,NULL,NULL,NULL, -- param6 - NULL,NULL,NULL,NULL,NULL,NULL, -- param7 - NULL,NULL, - '20180701', -- operation version - 0); -INSERT INTO "usage" VALUES( - 'PROJ', - 'NZGD2000-20180701_USAGE', - 'other_transformation', - 'PROJ', - 'NZGD2000-20180701', - 'EPSG','1175', -- extent - 'EPSG','1024' -- unknown -); - - -INSERT INTO "concatenated_operation" VALUES('PROJ','NZGD2000_TO_ITRF97','NZGD2000 to ITRF97','Concatenation of PROJ:NZGD2000-20180701 and 9079','EPSG','4959','EPSG','7908',NULL,NULL,0); -INSERT INTO "concatenated_operation_step" VALUES('PROJ','NZGD2000_TO_ITRF97',1,'PROJ','NZGD2000-20180701'); -INSERT INTO "concatenated_operation_step" VALUES('PROJ','NZGD2000_TO_ITRF97',2,'EPSG','9079'); -INSERT INTO "usage" VALUES( - 'PROJ', - 'NZGD2000_TO_ITRF97_USAGE', - 'concatenated_operation', - 'PROJ', - 'NZGD2000_TO_ITRF97', - 'EPSG','1175', -- extent - 'EPSG','1024' -- unknown -); - -INSERT INTO "concatenated_operation" VALUES('PROJ','NZGD2000_TO_ITRF2000','NZGD2000 to ITRF2000','Concatenation of PROJ:NZGD2000-20180701 and 9080','EPSG','4959','EPSG','7909',NULL,NULL,0); -INSERT INTO "concatenated_operation_step" VALUES('PROJ','NZGD2000_TO_ITRF2000',1,'PROJ','NZGD2000-20180701'); -INSERT INTO "concatenated_operation_step" VALUES('PROJ','NZGD2000_TO_ITRF2000',2,'EPSG','9080'); -INSERT INTO "usage" VALUES( - 'PROJ', - 'NZGD2000_TO_ITRF2000_USAGE', - 'concatenated_operation', - 'PROJ', - 'NZGD2000_TO_ITRF2000', - 'EPSG','1175', -- extent - 'EPSG','1024' -- unknown -); - -INSERT INTO "concatenated_operation" VALUES('PROJ','NZGD2000_TO_ITRF2005','NZGD2000 to ITRF2005','Concatenation of PROJ:NZGD2000-20180701 and 9081','EPSG','4959','EPSG','7910',NULL,NULL,0); -INSERT INTO "concatenated_operation_step" VALUES('PROJ','NZGD2000_TO_ITRF2005',1,'PROJ','NZGD2000-20180701'); -INSERT INTO "concatenated_operation_step" VALUES('PROJ','NZGD2000_TO_ITRF2005',2,'EPSG','9081'); -INSERT INTO "usage" VALUES( - 'PROJ', - 'NZGD2000_TO_ITRF2005_USAGE', - 'concatenated_operation', - 'PROJ', - 'NZGD2000_TO_ITRF2005', - 'EPSG','1175', -- extent - 'EPSG','1024' -- unknown -); - -INSERT INTO "concatenated_operation" VALUES('PROJ','NZGD2000_TO_ITRF2008','NZGD2000 to ITRF2008','Concatenation of PROJ:NZGD2000-20180701 and EPSG:9082','EPSG','4959','EPSG','7911',NULL,NULL,0); -INSERT INTO "concatenated_operation_step" VALUES('PROJ','NZGD2000_TO_ITRF2008',1,'PROJ','NZGD2000-20180701'); -INSERT INTO "concatenated_operation_step" VALUES('PROJ','NZGD2000_TO_ITRF2008',2,'EPSG','9082'); -INSERT INTO "usage" VALUES( - 'PROJ', - 'NZGD2000_TO_ITRF2008_USAGE', - 'concatenated_operation', - 'PROJ', - 'NZGD2000_TO_ITRF2008', - 'EPSG','1175', -- extent - 'EPSG','1024' -- unknown -); - -INSERT INTO "concatenated_operation" VALUES('PROJ','NZGD2000_TO_ITRF2014','NZGD2000 to ITRF2014','Concatenation of PROJ:NZGD2000-20180701 and EPSG:9083','EPSG','4959','EPSG','7912',NULL,NULL,0); -INSERT INTO "concatenated_operation_step" VALUES('PROJ','NZGD2000_TO_ITRF2014',1,'PROJ','NZGD2000-20180701'); -INSERT INTO "concatenated_operation_step" VALUES('PROJ','NZGD2000_TO_ITRF2014',2,'EPSG','9083'); -INSERT INTO "usage" VALUES( - 'PROJ', - 'NZGD2000_TO_ITRF2014_USAGE', - 'concatenated_operation', - 'PROJ', - 'NZGD2000_TO_ITRF2014', - 'EPSG','1175', -- extent - 'EPSG','1024' -- unknown -); - -- alias of EPSG:3857 INSERT INTO "projected_crs" VALUES('EPSG','900913','Google Maps Global Mercator',NULL,'EPSG','4499','EPSG','4326','EPSG','3856',NULL,1); INSERT INTO "usage" VALUES( |
