From 99152afb0bf25d5d56fffc6a87bf8b392fd2cac1 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Sat, 24 Oct 2020 17:39:52 +0200
Subject: Database: move NZGD2000 deformation model from customizations.sql to
 new other_tranformation_custom.sql

---
 data/sql/other_transformation_custom.sql | 101 +++++++++++++++++++++++++++++++
 1 file changed, 101 insertions(+)

(limited to 'data/sql/other_transformation_custom.sql')

diff --git a/data/sql/other_transformation_custom.sql b/data/sql/other_transformation_custom.sql
index 8d9b0426..c0c2bf11 100644
--- a/data/sql/other_transformation_custom.sql
+++ b/data/sql/other_transformation_custom.sql
@@ -40,3 +40,104 @@ INSERT INTO other_transformation VALUES(
     'EPSG','5717','EPSG','3900',0.01,
     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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EPSG','4123',NULL,0);
 INSERT INTO "usage" VALUES('PROJ','N60_TO_N2000_USAGE','other_transformation','PROJ','N60_TO_N2000','EPSG','3333','EPSG','1024');
+
+
+-- 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
+);
-- 
cgit v1.2.3

