Database: move NZGD2000 deformation model from customizations.sql to new other_tranformation_custom.sql

2 files changed, 101 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(
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
+);