aboutsummaryrefslogtreecommitdiff
path: root/data
diff options
context:
space:
mode:
Diffstat (limited to 'data')
-rw-r--r--data/sql/customizations.sql101
-rw-r--r--data/sql/other_transformation_custom.sql101
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
+);
generated by cgit v1.2.3 (git 2.25.1) at 2025-12-15 19:07:09 +0000