diff options
| author | Kristian Evers <kristianevers@gmail.com> | 2020-12-21 14:30:43 +0100 |
|---|---|---|
| committer | Kristian Evers <kristianevers@gmail.com> | 2020-12-21 16:37:57 +0100 |
| commit | f969d51e0bf128bfacba075e689205b512b31583 (patch) | |
| tree | f0a248ef08fb51ef0ec29178ef41fd4168d4c85d | |
| parent | fd98b78140b5b3f976af25d71cb121ee1ba30fa6 (diff) | |
| download | PROJ-f969d51e0bf128bfacba075e689205b512b31583.tar.gz PROJ-f969d51e0bf128bfacba075e689205b512b31583.zip | |
Implementing the NKG transformations in proj.db
This adds the NKG 2008 and 2020 transformations to proj.db. The NKG
transformations offers transformations between global reference frames
and the national realisations of ETRS89 in Denmark, Estonia, Finland,
Latvia, Lithuania, Norway and Sweden.
The 2008 transformations are already implemented in the NKG 2008 file
but will now be more accessible with the modern API.
The 2020 transformations are new to PROJ and offers and updated version
of the 2008 transformations using a new and improved deformation model
(eu_nkg_nkgrf17vel.tif). A 2020 version of the NKG transformations are
currently not available for Norway but will in all likelyhood be
included at a later point in time.
| -rw-r--r-- | data/Makefile.am | 1 | ||||
| -rw-r--r-- | data/sql/nkg.sql | 2174 | ||||
| -rw-r--r-- | data/sql_filelist.cmake | 1 | ||||
| -rw-r--r-- | test/gie/nkg.gie | 240 | ||||
| -rw-r--r-- | test/unit/test_c_api.cpp | 8 |
5 files changed, 2421 insertions, 3 deletions
diff --git a/data/Makefile.am b/data/Makefile.am index eda69a9a..8f65ed5c 100644 --- a/data/Makefile.am +++ b/data/Makefile.am @@ -42,6 +42,7 @@ SQL_ORDERED_LIST = sql/begin.sql \ sql/grid_alternatives.sql \ sql/grid_alternatives_generated_noaa.sql \ sql/customizations.sql \ + sql/nkg.sql \ sql/commit.sql EXTRA_DIST = proj.ini GL27 nad.lst nad27 nad83 \ diff --git a/data/sql/nkg.sql b/data/sql/nkg.sql new file mode 100644 index 00000000..93d82f97 --- /dev/null +++ b/data/sql/nkg.sql @@ -0,0 +1,2174 @@ +INSERT INTO "metadata" VALUES('NKG.SOURCE', 'https://github.com/NordicGeodesy/NordicTransformations'); +INSERT INTO "metadata" VALUES('NKG.VERSION', '1.0.0'); +INSERT INTO "metadata" VALUES('NKG.DATE', '2020-12-21'); + +-- Append NKG to authority references +UPDATE + authority_to_authority_preference +SET + allowed_authorities = allowed_authorities || ',NKG' +WHERE + source_auth_name = 'EPSG' AND target_auth_name = 'EPSG'; + +INSERT INTO "authority_to_authority_preference" + (source_auth_name,target_auth_name, allowed_authorities) +VALUES + ('NKG', 'EPSG', 'NKG,PROJ,EPSG'); + +-- extent for NKG2008 transformations +INSERT INTO "extent" VALUES( + 'NKG','EXTENT_2008', -- extend auth+code + 'Nordic and Baltic countries', -- name + 'Denmark; Estonia; Finland; Latvia; Lithuania; Norway; Sweden', -- description + 53.0, -- south latitude + 73.0, -- north latitude + 3.0, -- west longitude + 40.0, -- east longitude + 0 +); + +-- extent for NKG2020 transformations +INSERT INTO "extent" VALUES( + 'NKG','EXTENT_2020', -- extend auth+code + 'Nordic and Baltic countries', -- name + 'Denmark; Estonia; Finland; Latvia; Lithuania; Norway; Sweden', -- description + 50.0, -- south latitude + 75.0, -- north latitude + 0.0, -- west longitude + 49.0, -- east longitude + 0 +); + +-- Scope for both NKG2008 and NKG2020 transformations +INSERT INTO "scope" VALUES ( + 'NKG', 'SCOPE_GENERIC', -- scope auth+code + 'Geodesy. High accuracy ETRS89 transformations', -- scope + 0 --deprecated +); + + +------------------------------------------------------- +-- DATUM+CRS: NKG_ETRF00 +------------------------------------------------------- + +INSERT INTO "geodetic_datum" VALUES ( + 'NKG','DATUM_NKG_ETRF00', -- auth+code + 'NKG_ETRF00', -- name + NULL, -- description + 'EPSG','7019', -- ellipsoid auth+code + 'EPSG','8901', -- prime meridian auth+code + '2016-03-16', -- publication date + 2000.0, -- frame reference epoch + NULL, -- ensemble accuracy + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG','5007', + 'geodetic_datum', + 'NKG','DATUM_NKG_ETRF00', + 'NKG','EXTENT_2008', -- extend auth+code + 'NKG','SCOPE_GENERIC' -- scope auth+code +); + +-- Add CRS entry for NKG common frame ETRF_NKG00 +INSERT INTO "geodetic_crs" VALUES( + 'NKG','ETRF00', -- CRS auth+code + 'NKG_ETRF00', -- name + 'NKG Common reference frame 2000', -- description + 'geocentric', -- type + 'EPSG','6500', -- CRS type auth+code: ECEF + 'NKG','DATUM_NKG_ETRF00', -- datum auth+code + NULL, -- text definition + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5101', -- usage auth+code + 'geodetic_crs', -- object_table_name + 'NKG', 'ETRF00', -- object auth+code + 'NKG', 'EXTENT_2008', -- extent auth+code + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + +------------------------------------------------------- +-- DATUM+CRS: NKG_ETRF14 +------------------------------------------------------- + +INSERT INTO "geodetic_datum" VALUES ( + 'NKG','DATUM_NKG_ETRF14', -- auth+code + 'NKG_ETRF14', -- name + NULL, -- description + 'EPSG','7019', -- ellipsoid auth+code + 'EPSG','8901', -- prime meridian auth+code + '2021-03-01', -- publication date + 2000.0, -- frame reference epoch + NULL, -- ensemble accuracy + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG','5033', + 'geodetic_datum', + 'NKG','DATUM_NKG_ETRF14', + 'NKG','EXTENT_2020', -- extend auth+code + 'NKG','SCOPE_GENERIC' -- scope auth+code +); + +-- Add CRS entry for NKG common frame ETRF_NKG00 +INSERT INTO "geodetic_crs" VALUES( + 'NKG','ETRF14', -- CRS auth+code + 'NKG_ETRF14', -- name + 'NKG Common reference frame 2014', -- description + 'geocentric', -- type + 'EPSG','6500', -- CRS type auth+code: ECEF + 'NKG','DATUM_NKG_ETRF14', -- datum auth+code + NULL, -- text definition + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5102', -- usage auth+code + 'geodetic_crs', -- object_table_name + 'NKG', 'ETRF14', -- object auth+code + 'NKG', 'EXTENT_2020', -- extent auth+code + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + +------------------------------------------------------- +-- Transformation: ITRF2000 -> NKG_ETRF00 +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2000_TO_NKG_ETRF00', -- operation auth+code + 'ITRF2000 to NKG_ETRF00', -- name + 'Time-dependent transformation from ITRF2000 to NKG_ETRF00', -- description + 'EPSG', '4919', -- source_crs: ITRF2000 + 'NKG', 'ETRF00',-- target_crs: NKG_ETRF00 + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG','NKG_ETRF00_TO_ETRF2000', -- operation auth+code + 'NKG_ETRF00 to ETRF2000', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+code + '+proj=deformation +t_epoch=2000.0 +grids=eur_nkg_nkgrf03vel_realigned.tif', + 'NKG', 'ETRF00',-- source_crs: NKG_ETRF00 + 'EPSG','7930', -- target_crs: ETRF2000 + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5003', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG','NKG_ETRF00_TO_ETRF2000', -- object auth+code + 'NKG','EXTENT_2008', -- extent auth+code + 'NKG','SCOPE_GENERIC' -- scope auth+code +); + + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2000_TO_NKG_ETRF00', 2, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000 + ('NKG', 'ITRF2000_TO_NKG_ETRF00', 3, 'NKG', 'NKG_ETRF00_TO_ETRF2000') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5001', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2000_TO_NKG_ETRF00', -- object auth+code + 'NKG', 'EXTENT_2008', -- extent auth+code + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + +------------------------------------------------------- +-- Transformation: ITRF2014 -> NKG_ETRF14 +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2014_TO_NKG_ETRF14', -- operation auth+code + 'ITRF2014 to NKG_ETRF14', -- name + 'Time-dependent transformation from ITRF2014 to NKG_ETRF14', -- description + 'EPSG', '7789', -- source_crs: ITRF2014 + 'NKG', 'ETRF14',-- target_crs: NKG_ETRF14 + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG','NKG_ETRF14_TO_ETRF2014', -- operation auth+code + 'NKG_ETRF14 to ETRF2014', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+code + '+proj=deformation +t_epoch=2000.0 +grids=eur_nkg_nkgrf17vel.tif', + 'NKG', 'ETRF14',-- source_crs: NKG_ETRF14 + 'EPSG','8401', -- target_crs: ETRF2014 + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5034', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG','NKG_ETRF14_TO_ETRF2014', -- object auth+code + 'NKG','EXTENT_2020', -- extent auth+code + 'NKG','SCOPE_GENERIC' -- scope auth+code +); + + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2014_TO_NKG_ETRF14', 2, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014 + ('NKG', 'ITRF2014_TO_NKG_ETRF14', 3, 'NKG', 'NKG_ETRF14_TO_ETRF2014') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5035', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2014_TO_NKG_ETRF14', -- object auth+code + 'NKG', 'EXTENT_2020', -- extent auth+code + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + + +------------------------------------------------------------- +-- Intermediate transformations: NKG_ETRF00 -> ETRFyy@2000.00 +------------------------------------------------------------- + +-- DK +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','P1_2008_DK', -- operation auth+code + 'NKG_ETRF00 to ETRF92@2000.0', -- name + 'Transformation from NKG_ETRF00 to ETRF92, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF00', -- source auth+code + 'EPSG','7920', -- target auth+code + 0.005, -- accuracy + 0.03863, -- x + 0.147, -- y + 0.02776, -- z + 'EPSG','9001', + 0.00617753, -- rx + 5.064e-05, -- ry + 4.729e-05, -- rz + 'EPSG','9104', + -0.009420, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2008', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5004', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','P1_2008_DK', -- object auth+code + 'EPSG', '1080', -- extent: Denmark - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + + +-- EE +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','P1_2008_EE', -- operation auth+code + 'NKG_ETRF00 to ETRF96@2000.0', -- name + 'Transformation from NKG_ETRF00 to ETRF96, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF00', -- source auth+code + 'EPSG','7926', -- target auth+code + 0.005, -- accuracy + 0.12194, -- x + 0.02225, -- y + -0.03541, -- z + 'EPSG','9001', + 0.00227196, -- rx + -0.00323934, -- ry + 0.00247008, -- rz + 'EPSG','9104', + -0.005626, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2008', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5008', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','P1_2008_EE', -- object auth+code + 'EPSG', '1090', -- extent: Estonia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + + +-- FI +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','P1_2008_FI', -- operation auth+code + 'NKG_ETRF00 to ETRF96@2000.0', -- name + 'Transformation from NKG_ETRF00 to ETRF96, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF00', -- source auth+code + 'EPSG','7926', -- target auth+code + 0.005, -- accuracy + 0.07251, -- x + -0.13019, -- y + -0.11323, -- z + 'EPSG','9001', + -0.00157399, -- rx + -0.00308833, -- ry + 0.00410332, -- rz + 'EPSG','9104', + 0.013012, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2008', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5009', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','P1_2008_FI', -- object auth+code + 'EPSG', '1095', -- extent: Finland - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + + +-- LV +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','P1_2008_LV', -- operation auth+code + 'NKG_ETRF00 to ETRF89@2000.0', -- name + 'Transformation from NKG_ETRF00 to ETRF89, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF00', -- source auth+code + 'EPSG','7914', -- target auth+code + 0.02, -- accuracy + 0.41812, -- x + -0.78105, -- y + -0.01335, -- z + 'EPSG','9001', + -0.0216436, -- rx + -0.0115184, -- ry + 0.01719911, -- rz + 'EPSG','9104', + 0.000757, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2008', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5010', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','P1_2008_LV', -- object auth+code + 'EPSG', '1139', -- extent: Latvia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +-- LT +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','P1_2008_LT', -- operation auth+code + 'NKG_ETRF00 to ETRF2000@2000.0', -- name + 'Transformation from NKG_ETRF00 to ETRF2000, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF00', -- source auth+code + 'EPSG','7930', -- target auth+code + 0.01, -- accuracy + 0.05692, -- x + 0.115495, -- y + -0.00078, -- z + 'EPSG','9001', + 0.00314291, -- rx + -0.00147975, -- ry + -0.00134758, -- rz + 'EPSG','9104', + -0.006182, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2008', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5011', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','P1_2008_LT', -- object auth+code + 'EPSG', '1145', -- extent: Lithuania - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + + +-- NO +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','P1_2008_NO', -- operation auth+code + 'NKG_ETRF00 to ETRF93@2000.0', -- name + 'Transformation from NKG_ETRF00 to ETRF93, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF00', -- source auth+code + 'EPSG','7922', -- target auth+code + 0.005, -- accuracy + -0.13116, -- x + -0.02817, -- y + 0.02036, -- z + 'EPSG','9001', + -0.00038674, -- rx + 0.00408947, -- ry + 0.00103588, -- rz + 'EPSG','9104', + 0.006569, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2008', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5012', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','P1_2008_NO', -- object auth+code + 'EPSG', '1352', -- extent: Norway - onshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + + +-- SE +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','P1_2008_SE', -- operation auth+code + 'NKG_ETRF00 to ETRF97@2000.0', -- name + 'Transformation from NKG_ETRF00 to ETRF97, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF00', -- source auth+code + 'EPSG','7928', -- target auth+code + 0.005, -- accuracy + -0.01642, -- x + -0.00064, -- y + -0.0305, -- z + 'EPSG','9001', + 0.00187431, -- rx + 0.00046382, -- ry + 0.00228487, -- rz + 'EPSG','9104', + 0.001861, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2008', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5014', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','P1_2008_SE', -- object auth+code + 'EPSG', '1225', -- extent: Sweden - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + + +------------------------------------------------------------- +-- Intermediate transformations: NKG_ETRF14 -> ETRFyy@2000.00 +------------------------------------------------------------- + +-- DK +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','PAR_2020_DK', -- operation auth+code + 'NKG_ETRF14 to ETRF92@2000.0', -- name + 'Transformation from NKG_ETRF14 to ETRF92, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF14', -- source auth+code + 'EPSG','7920', -- target auth+code + 0.005, -- accuracy + 0.66818, -- x + 0.04453, -- y + -0.45049, -- z + 'EPSG','9001', + 0.00312883, -- rx + -0.02373423, -- ry + 0.00442969, -- rz + 'EPSG','9104', + -0.003136, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2020', -- operation version + 0 +); + + +INSERT INTO "usage" VALUES ( + 'NKG', '5036', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','PAR_2020_DK', -- object auth+code + 'EPSG', '1080', -- extent: Denmark - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + + +-- EE +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','PAR_2020_EE', -- operation auth+code + 'NKG_ETRF14 to ETRF96@2000.0', -- name + 'Transformation from NKG_ETRF14 to ETRF96, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF14', -- source auth+code + 'EPSG','7926', -- target auth+code + 0.005, -- accuracy + -0.05027, -- x + -0.11595, -- y + 0.03012, -- z + 'EPSG','9001', + -0.00310814, -- rx + 0.00457237, -- ry + 0.00472406, -- rz + 'EPSG','9104', + 0.003191, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2020', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5037', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','PAR_2020_EE', -- object auth+code + 'EPSG', '1090', -- extent: Estonia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + + +-- FI +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','PAR_2020_FI', -- operation auth+code + 'NKG_ETRF14 to ETRF96@2000.0', -- name + 'Transformation from NKG_ETRF14 to ETRF96, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF14', -- source auth+code + 'EPSG','7926', -- target auth+code + 0.005, -- accuracy + 0.15651, -- x + -0.10993, -- y + -0.10935, -- z + 'EPSG','9001', + -0.00312861, -- rx + -0.00378935, -- ry + 0.00403512, -- rz + 'EPSG','9104', + 0.00529, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2020', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5038', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','PAR_2020_FI', -- object auth+code + 'EPSG', '1095', -- extent: Finland - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + + +-- LV +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','PAR_2020_LV', -- operation auth+code + 'NKG_ETRF14 to ETRF89@2000.0', -- name + 'Transformation from NKG_ETRF14 to ETRF89, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF14', -- source auth+code + 'EPSG','7914', -- target auth+code + 0.01, -- accuracy + 0.09745, -- x + -0.69388, -- y + 0.52901, -- z + 'EPSG','9001', + -0.0192069, -- rx + 0.01043272, -- ry + 0.02327169, -- rz + 'EPSG','9104', + -0.049663, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2020', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5039', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','PAR_2020_LV', -- object auth+code + 'EPSG', '1139', -- extent: Latvia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +-- LT +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','PAR_2020_LT', -- operation auth+code + 'NKG_ETRF14 to ETRF2000@2000.0', -- name + 'Transformation from NKG_ETRF14 to ETRF2000, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF14', -- source auth+code + 'EPSG','7930', -- target auth+code + 0.015, -- accuracy + 0.36749, -- x + 0.14351, -- y + -0.18472, -- z + 'EPSG','9001', + 0.0047914, -- rx + -0.01027566, -- ry + 0.00276102, -- rz + 'EPSG','9104', + -0.003684, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2020', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5040', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','PAR_2020_LT', -- object auth+code + 'EPSG', '1145', -- extent: Lithuania - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + + + +-- SE +INSERT INTO "helmert_transformation" VALUES ( + 'NKG','PAR_2020_SE', -- operation auth+code + 'NKG_ETRF14 to ETRF97@2000.0', -- name + 'Transformation from NKG_ETRF14 to ETRF97, at transformation reference epoch 2000.0', -- description / remark + 'EPSG','1033', -- method auth+code + 'Position Vector transformation (geocentric domain)', + 'NKG','ETRF14', -- source auth+code + 'EPSG','7928', -- target auth+code + 0.005, -- accuracy + 0.03054, -- x + 0.04606, -- y + -0.07944, -- z + 'EPSG','9001', + 0.00141958, -- rx + 0.00015132, -- ry + 0.00150337, -- rz + 'EPSG','9104', + 0.003002, -- s + 'EPSG','9202', + NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, + 'NKG 2020', -- operation version + 0 +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5042', -- usage auth+code + 'helmert_transformation', -- object_table_name + 'NKG','PAR_2020_SE', -- object auth+code + 'EPSG', '1225', -- extent: Sweden - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + + + + +------------------------------------------------------- +-- Transformation: NKG_ETRF00 -> ETRF92@1994.704 (DK) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'ETRF92_2000_TO_ETRF92_1994',-- object auth+code + 'ETRF92@2000.0 to ETRF92@1994.704', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=-5.296 +grids=eur_nkg_nkgrf03vel_realigned.tif', + 'EPSG','7920', -- source_crs: ETRF92@2000.0 + 'EPSG','4936', -- target_crs: ETRS89 (DK) + 0.005, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5005', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'ETRF92_2000_TO_ETRF92_1994', -- object auth+code + 'EPSG', '1080', -- extent: Denmark - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF00_TO_DK', -- operation auth+code + 'NKG_ETRF00 to ETRS89(DK)', -- name + 'Transformation from NKG_ETRF00@2000.0 to ETRF92@1994.704', -- description + 'NKG', 'ETRF00',-- source_crs: NKG_ETRF00 + 'EPSG','4936', -- target_crs: ETRS89 (DK) + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF00_TO_DK', 1, 'NKG', 'P1_2008_DK'), + ('NKG', 'ETRF00_TO_DK', 2, 'NKG', 'ETRF92_2000_TO_ETRF92_1994') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5006', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF00_TO_DK', -- object auth+code + 'EPSG', '1080', -- extent: Denmark - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2000 -> ETRF92@1994.704 (DK) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2000_TO_DK', -- operation auth+code + 'ITRF2000 to ETRS89(DK)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89(DK)', -- description + 'EPSG', '4919', -- source_crs: ITRF2000 + 'EPSG', '4936', -- target_crs: ETRS89(DK) + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2000_TO_DK', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000 + ('NKG', 'ITRF2000_TO_DK', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'), + ('NKG', 'ITRF2000_TO_DK', 3, 'NKG', 'P1_2008_DK'), + ('NKG', 'ITRF2000_TO_DK', 4, 'NKG', 'ETRF92_2000_TO_ETRF92_1994') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5013', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2000_TO_DK', -- object auth+code + 'EPSG', '1080', -- extent: Denmark - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + +------------------------------------------------------- +-- Transformation: NKG_ETRF00 -> ETRF96@1997.56 (EE) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'ETRF96_2000_TO_ETRF96_1997_56',-- object auth+code + 'ETRF96@2000.0 to ETRF96@1997.56', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=-2.44 +grids=eur_nkg_nkgrf03vel_realigned.tif', + 'EPSG','7926', -- source_crs: ETRF96@2000.0 + 'EPSG','4936', -- target_crs: ETRS89 (EE) + 0.005, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5015', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'ETRF96_2000_TO_ETRF96_1997_56', -- object auth+code + 'EPSG', '1090', -- extent: Estonia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF00_TO_EE', -- operation auth+code + 'NKG_ETRF00 to ETRS89 (EUREF-EST97)', -- name + 'Transformation from NKG_ETRF00@2000.0 to ETRF96@1997.56', -- description + 'NKG', 'ETRF00',-- source_crs: NKG_ETRF00 + 'EPSG','4936', -- target_crs: ETRS89 (EE) + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF00_TO_EE', 1, 'NKG', 'P1_2008_EE'), + ('NKG', 'ETRF00_TO_EE', 2, 'NKG', 'ETRF96_2000_TO_ETRF96_1997_56') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5016', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF00_TO_EE', -- object auth+code + 'EPSG', '1090', -- extent: Estonia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2000 -> ETRF96@1997.56 (EE) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2000_TO_EE', -- operation auth+code + 'ITRF2000 to ETRS89(EE)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89 (EUREF-EST97)', -- description + 'EPSG', '4919', -- source_crs: ITRF2000 + 'EPSG', '4936', -- target_crs: ETRS89(EE) + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2000_TO_EE', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000 + ('NKG', 'ITRF2000_TO_EE', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'), + ('NKG', 'ITRF2000_TO_EE', 3, 'NKG', 'P1_2008_EE'), + ('NKG', 'ITRF2000_TO_EE', 4, 'NKG', 'ETRF96_2000_TO_ETRF96_1997_56') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5017', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2000_TO_EE', -- object auth+code + 'EPSG', '1090', -- extent: Estonia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + + +------------------------------------------------------- +-- Transformation: NKG_ETRF00 -> ETRF96@1997.0 (FI) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'ETRF96_2000_TO_ETRF96_1997',-- object auth+code + 'ETRF96@2000.0 to ETRF96@1997.0', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=-3.0 +grids=eur_nkg_nkgrf03vel_realigned.tif', + 'EPSG','7926', -- source_crs: ETRF96@2000.0 + 'EPSG','4936', -- target_crs: ETRS89 (FI) + 0.005, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5018', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'ETRF96_2000_TO_ETRF96_1997', -- object auth+code + 'EPSG', '1095', -- extent: Finland - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF00_TO_FI', -- operation auth+code + 'NKG_ETRF00 to ETRS89 (EUREF-FIN)', -- name + 'Transformation from NKG_ETRF00@2000.0 to ETRF96@1997.0', -- description + 'NKG', 'ETRF00',-- source_crs: NKG_ETRF00 + 'EPSG','4936', -- target_crs: ETRS89 (FI) + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF00_TO_FI', 1, 'NKG', 'P1_2008_FI'), + ('NKG', 'ETRF00_TO_FI', 2, 'NKG', 'ETRF96_2000_TO_ETRF96_1997') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5019', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF00_TO_FI', -- object auth+code + 'EPSG', '1095', -- extent: Finland - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2000 -> ETRF96@1997.0 (FI) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2000_TO_FI', -- operation auth+code + 'ITRF2000 to ETRS89 (EUREF-FIN)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89 (EUREF-FIN)', -- description + 'EPSG', '4919', -- source_crs: ITRF2000 + 'EPSG', '4936', -- target_crs: ETRS89(FI) + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2000_TO_FI', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000 + ('NKG', 'ITRF2000_TO_FI', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'), + ('NKG', 'ITRF2000_TO_FI', 3, 'NKG', 'P1_2008_FI'), + ('NKG', 'ITRF2000_TO_FI', 4, 'NKG', 'ETRF96_2000_TO_ETRF96_1997') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5020', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2000_TO_FI', -- object auth+code + 'EPSG', '1095', -- extent: Finland - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + + +------------------------------------------------------- +-- Transformation: NKG_ETRF00 -> ETRF89@1992.75 (LV) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'ETRF89_2000_TO_ETRF89_1992',-- object auth+code + 'ETRF89@2000.0 to ETRF89@1992.75', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=-7.25 +grids=eur_nkg_nkgrf03vel_realigned.tif', + 'EPSG','7914', -- source_crs: ETRF89@2000.0 + 'EPSG','4948', -- target_crs: LKS-92 + 0.005, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5021', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'ETRF89_2000_TO_ETRF89_1992', -- object auth+code + 'EPSG', '1139', -- extent: Latvia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF00_TO_LV', -- operation auth+code + 'NKG_ETRF00 to ETRS89 (LKS-92)', -- name + 'Transformation from NKG_ETRF00@2000.0 to ETRF89@1992.75', -- description + 'NKG', 'ETRF00',-- source_crs: NKG_ETRF00 + 'EPSG','4948', -- target_crs: LKS-92 + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF00_TO_LV', 1, 'NKG', 'P1_2008_LV'), + ('NKG', 'ETRF00_TO_LV', 2, 'NKG', 'ETRF89_2000_TO_ETRF89_1992') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5022', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF00_TO_LV', -- object auth+code + 'EPSG', '1139', -- extent: Latvia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2000 -> ETRF89@1992.75 (LV) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2000_TO_LV', -- operation auth+code + 'ITRF2000 to ETRS89 (LKS-92)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89 (LKS-92)', -- description + 'EPSG', '4919', -- source_crs: ITRF2000 + 'EPSG', '4948', -- target_crs: LKS-92 + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2000_TO_LV', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000 + ('NKG', 'ITRF2000_TO_LV', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'), + ('NKG', 'ITRF2000_TO_LV', 3, 'NKG', 'P1_2008_LV'), + ('NKG', 'ITRF2000_TO_LV', 4, 'NKG', 'ETRF89_2000_TO_ETRF89_1992') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5023', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2000_TO_LV', -- object auth+code + 'EPSG', '1139', -- extent: Latvia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: NKG_ETRF00 -> ETRF2000@2003.75 (LT) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'ETRF2000_2000_TO_ETRF_2000_2003',-- object auth+code + 'ETRF2000@2000.0 to ETRF2000@2003.75', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=3.75 +grids=eur_nkg_nkgrf03vel_realigned.tif', + 'EPSG','7930', -- source_crs: ETRF2000@2000.0 + 'EPSG','4950', -- target_crs: LKS94 + 0.005, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5024', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'ETRF2000_2000_TO_ETRF_2000_2003', -- object auth+code + 'EPSG', '1145', -- extent: Lithuania - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF00_TO_LT', -- operation auth+code + 'NKG_ETRF00 to LKS94', -- name + 'Transformation from NKG_ETRF00@2000.0 to ETRF2000@2003.75', -- description + 'NKG', 'ETRF00',-- source_crs: NKG_ETRF00 + 'EPSG','4950', -- target_crs: LKS94 + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF00_TO_LT', 1, 'NKG', 'P1_2008_LT'), + ('NKG', 'ETRF00_TO_LT', 2, 'NKG', 'ETRF2000_2000_TO_ETRF_2000_2003') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5025', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF00_TO_LT', -- object auth+code + 'EPSG', '1145', -- extent: Lithuania - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2000 -> ETRF2000@2003.75 (LT) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2000_TO_LT', -- operation auth+code + 'ITRF2000 to ETRS89(LT)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89(LT)', -- description + 'EPSG', '4919', -- source_crs: ITRF2000 + 'EPSG', '4950', -- target_crs: LKS94 + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2000_TO_LT', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000 + ('NKG', 'ITRF2000_TO_LT', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'), + ('NKG', 'ITRF2000_TO_LT', 3, 'NKG', 'P1_2008_LT'), + ('NKG', 'ITRF2000_TO_LT', 4, 'NKG', 'ETRF2000_2000_TO_ETRF_2000_2003') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5026', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2000_TO_LT', -- object auth+code + 'EPSG', '1145', -- extent: Lithuania - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: NKG_ETRF00 -> ETRF93@1995.0 (NO) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'ETRF93_2000_TO_ETRF93_1995',-- object auth+code + 'ETRF93@2000.0 to ETRF93@1995.0', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=-5 +grids=eur_nkg_nkgrf03vel_realigned.tif', + 'EPSG','7922', -- source_crs: ETRF93@2000.0 + 'EPSG','4936', -- target_crs: ETRS89 (NO) + 0.005, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5027', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'ETRF93_2000_TO_ETRF93_1995', -- object auth+code + 'EPSG', '1352', -- extent: Norway - onshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF00_TO_NO', -- operation auth+code + 'NKG_ETRF00 to ETRS89(NO)', -- name + 'Transformation from NKG_ETRF00@2000.0 to ETRF93@1995.0', -- description + 'NKG', 'ETRF00',-- source_crs: NKG_ETRF00 + 'EPSG','4936', -- target_crs: ETRS89 (NO) + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF00_TO_NO', 1, 'NKG', 'P1_2008_NO'), + ('NKG', 'ETRF00_TO_NO', 2, 'NKG', 'ETRF93_2000_TO_ETRF93_1995') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5028', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF00_TO_NO', -- object auth+code + 'EPSG', '1352', -- extent: Norway - onshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2000 -> ETRF93@1995.0 (NO) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2000_TO_NO', -- operation auth+code + 'ITRF2000 to ETRS89(NO)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89(NO)', -- description + 'EPSG', '4919', -- source_crs: ITRF2000 + 'EPSG', '4936', -- target_crs: ETRS89(NO) + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2000_TO_NO', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000 + ('NKG', 'ITRF2000_TO_NO', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'), + ('NKG', 'ITRF2000_TO_NO', 3, 'NKG', 'P1_2008_NO'), + ('NKG', 'ITRF2000_TO_NO', 4, 'NKG', 'ETRF93_2000_TO_ETRF93_1995') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5029', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2000_TO_NO', -- object auth+code + 'EPSG', '1352', -- extent: Norway - onshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: NKG_ETRF00 -> ETRF97@1999.5 (SE) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'ETRF97_2000_TO_ETRF97_1999',-- object auth+code + 'ETRF97@2000.0 to ETRF97@1999.5', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=-0.5 +grids=eur_nkg_nkgrf03vel_realigned.tif', + 'EPSG','7928', -- source_crs: ETRF97@2000.0 + 'EPSG','4976', -- target_crs: SWEREF99 + 0.005, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5030', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'ETRF97_2000_TO_ETRF97_1999', -- object auth+code + 'EPSG', '1225', -- extent: Sweden - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF00_TO_SE', -- operation auth+code + 'NKG_ETRF00 to SWEREF99', -- name + 'Transformation from NKG_ETRF00@2000.0 to ETRF97@1999.5', -- description + 'NKG', 'ETRF00',-- source_crs: NKG_ETRF00 + 'EPSG','4976', -- target_crs: SWEREF99 + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF00_TO_SE', 1, 'NKG', 'P1_2008_SE'), + ('NKG', 'ETRF00_TO_SE', 2, 'NKG', 'ETRF97_2000_TO_ETRF97_1999') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5031', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF00_TO_SE', -- object auth+code + 'EPSG', '1225', -- extent: Sweden - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2000 -> ETRF97@1999.5 (SE) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2000_TO_SE', -- operation auth+code + 'ITRF2000 to ETRS89(SE)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89(SE)', -- description + 'EPSG', '4919', -- source_crs: ITRF2000 + 'EPSG', '4976', -- target_crs: SWEREF99 + 0.01, -- accuracy + 'NKG 2008', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2000_TO_SE', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000 + ('NKG', 'ITRF2000_TO_SE', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'), + ('NKG', 'ITRF2000_TO_SE', 3, 'NKG', 'P1_2008_SE'), + ('NKG', 'ITRF2000_TO_SE', 4, 'NKG', 'ETRF97_2000_TO_ETRF97_1999') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5032', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2000_TO_SE', -- object auth+code + 'EPSG', '1225', -- extent: Sweden - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + +------------------------------------------------------- +-- Transformation: NKG_ETRF14 -> ETRF92@1994.704 (DK) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'DK_2020_INTRAPLATE', -- object auth+code + 'ETRF92@2000.0 to ETRF92@1994.704', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=15.829 +grids=eur_nkg_nkgrf17vel.tif', + 'EPSG','7920', -- source_crs: ETRF92@2000.0 + 'EPSG','4936', -- target_crs: ETRS89 (DK) + 0.005, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5043', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'DK_2020_INTRAPLATE', -- object auth+code + 'EPSG', '1080', -- extent: Denmark - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF14_TO_DK', -- operation auth+code + 'NKG_ETRF14 to ETRS89(DK)', -- name + 'Transformation from NKG_ETRF14@2000.0 to ETRF92@1994.704', -- description + 'NKG', 'ETRF14',-- source_crs: NKG_ETRF00 + 'EPSG','4936', -- target_crs: ETRS89 (DK) + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF14_TO_DK', 1, 'NKG', 'PAR_2020_DK'), + ('NKG', 'ETRF14_TO_DK', 2, 'NKG', 'DK_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5044', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF14_TO_DK', -- object auth+code + 'EPSG', '1080', -- extent: Denmark - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2014 -> ETRF92@1994.704 (DK) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2014_TO_DK', -- operation auth+code + 'ITRF2014 to ETRS89(DK)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89(DK)', -- description + 'EPSG', '7789', -- source_crs: ITRF2014 + 'EPSG', '4936', -- target_crs: ETRS89(DK) + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2014_TO_DK', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014 + ('NKG', 'ITRF2014_TO_DK', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'), + ('NKG', 'ITRF2014_TO_DK', 3, 'NKG', 'PAR_2020_DK'), + ('NKG', 'ITRF2014_TO_DK', 4, 'NKG', 'DK_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5045', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2014_TO_DK', -- object auth+code + 'EPSG', '1080', -- extent: Denmark - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + +INSERT INTO "supersession" VALUES ( + 'concatenated_operation', + 'NKG', 'ITRF2000_TO_DK', + 'concatenated_operation', + 'NKG', 'ITRF2014_TO_DK', + 'NKG', + 0 +); + +------------------------------------------------------- +-- Transformation: NKG_ETRF14 -> ETRF96@1997.56 (EE) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'EE_2020_INTRAPLATE',-- object auth+code + 'ETRF96@2000.0 to ETRF96@1997.56', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=-2.44 +grids=eur_nkg_nkgrf17vel.tif', + 'EPSG','7926', -- source_crs: ETRF96@2000.0 + 'EPSG','4936', -- target_crs: ETRS89 (EE) + 0.005, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5046', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'EE_2020_INTRAPLATE', -- object auth+code + 'EPSG', '1090', -- extent: Estonia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF14_TO_EE', -- operation auth+code + 'NKG_ETRF14 to ETRS89 (EUREF-EST97)', -- name + 'Transformation from NKG_ETRF14@2000.0 to ETRF96@1997.56', -- description + 'NKG', 'ETRF14',-- source_crs: NKG_ETRF00 + 'EPSG','4936', -- target_crs: ETRS89 (EE) + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF14_TO_EE', 1, 'NKG', 'PAR_2020_EE'), + ('NKG', 'ETRF14_TO_EE', 2, 'NKG', 'EE_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5047', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF14_TO_EE', -- object auth+code + 'EPSG', '1090', -- extent: Estonia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2014 -> ETRF96@1997.56 (EE) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2014_TO_EE', -- operation auth+code + 'ITRF2014 to ETRS89 (EUREF-EST97)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89 (EUREF-EST97)', -- description + 'EPSG', '7789', -- source_crs: ITRF2014 + 'EPSG', '4936', -- target_crs: ETRS89(EE) + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2014_TO_EE', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014 + ('NKG', 'ITRF2014_TO_EE', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'), + ('NKG', 'ITRF2014_TO_EE', 3, 'NKG', 'PAR_2020_EE'), + ('NKG', 'ITRF2014_TO_EE', 4, 'NKG', 'EE_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5048', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2014_TO_EE', -- object auth+code + 'EPSG', '1090', -- extent: Estonia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + +INSERT INTO "supersession" VALUES ( + 'concatenated_operation', + 'NKG', 'ITRF2000_TO_EE', + 'concatenated_operation', + 'NKG', 'ITRF2014_TO_EE', + 'NKG', + 0 +); + + +------------------------------------------------------- +-- Transformation: NKG_ETRF14 -> ETRF96@1997.0 (FI) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'FI_2020_INTRAPLATE',-- object auth+code + 'ETRF96@2000.0 to ETRF96@1997.0', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=-3 +grids=eur_nkg_nkgrf17vel.tif', + 'EPSG','7926', -- source_crs: ETRF96@2000.0 + 'EPSG','4936', -- target_crs: ETRS89 (FI) + 0.005, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5049', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'FI_2020_INTRAPLATE', -- object auth+code + 'EPSG', '1095', -- extent: Finland - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF14_TO_FI', -- operation auth+code + 'NKG_ETRF14 to ETRS89 (EUREF-FIN)', -- name + 'Transformation from NKG_ETRF14@2000.0 to ETRF96@1997.0', -- description + 'NKG', 'ETRF14',-- source_crs: NKG_ETRF00 + 'EPSG','4936', -- target_crs: ETRS89 (FI) + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF14_TO_FI', 1, 'NKG', 'PAR_2020_FI'), + ('NKG', 'ETRF14_TO_FI', 2, 'NKG', 'FI_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5050', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF14_TO_FI', -- object auth+code + 'EPSG', '1095', -- extent: Finland - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2014 -> ETRF96@1997.0 (FI) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2014_TO_FI', -- operation auth+code + 'ITRF2014 to ETRS89 (EUREF-FIN)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89 (EUREF-FIN)', -- description + 'EPSG', '7789', -- source_crs: ITRF2014 + 'EPSG', '4936', -- target_crs: ETRS89(FI) + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2014_TO_FI', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014 + ('NKG', 'ITRF2014_TO_FI', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'), + ('NKG', 'ITRF2014_TO_FI', 3, 'NKG', 'PAR_2020_FI'), + ('NKG', 'ITRF2014_TO_FI', 4, 'NKG', 'FI_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5051', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2014_TO_FI', -- object auth+code + 'EPSG', '1095', -- extent: Finland - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + +INSERT INTO "supersession" VALUES ( + 'concatenated_operation', + 'NKG', 'ITRF2000_TO_FI', + 'concatenated_operation', + 'NKG', 'ITRF2014_TO_FI', + 'NKG', + 0 +); + + +------------------------------------------------------- +-- Transformation: NKG_ETRF14 -> ETRF89@1992.75 (LV) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'LV_2020_INTRAPLATE', -- object auth+code + 'ETRF89@2000.0 to ETRF89@1992.75 (LKS-92)', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=-7.25 +grids=eur_nkg_nkgrf17vel.tif', + 'EPSG','7914', -- source_crs: ETRF89@2000.0 + 'EPSG','4948', -- target_crs: LKS-92 + 0.005, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5052', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'LV_2020_INTRAPLATE', -- object auth+code + 'EPSG', '1139', -- extent: Latvia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF14_TO_LV', -- operation auth+code + 'NKG_ETRF14 to ETRS89 (LKS-92)', -- name + 'Transformation from NKG_ETRF14@2000.0 to ETRF89@1992.75', -- description + 'NKG', 'ETRF14',-- source_crs: NKG_ETRF00 + 'EPSG','4948', -- target_crs: LKS-92 + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF14_TO_LV', 1, 'NKG', 'PAR_2020_LV'), + ('NKG', 'ETRF14_TO_LV', 2, 'NKG', 'LV_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5053', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF14_TO_LV', -- object auth+code + 'EPSG', '1139', -- extent: Latvia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2014 -> ETRF89@1992.75 (LV) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2014_TO_LV', -- operation auth+code + 'ITRF2014 to ETRS89 (LKS-92)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89 (LKS-92)', -- description + 'EPSG', '7789', -- source_crs: ITRF2014 + 'EPSG', '4948', -- target_crs: LKS-92 + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2014_TO_LV', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014 + ('NKG', 'ITRF2014_TO_LV', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'), + ('NKG', 'ITRF2014_TO_LV', 3, 'NKG', 'PAR_2020_LV'), + ('NKG', 'ITRF2014_TO_LV', 4, 'NKG', 'LV_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5054', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2014_TO_LV', -- object auth+code + 'EPSG', '1139', -- extent: Latvia - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + +INSERT INTO "supersession" VALUES ( + 'concatenated_operation', + 'NKG', 'ITRF2000_TO_LV', + 'concatenated_operation', + 'NKG', 'ITRF2014_TO_LV', + 'NKG', + 0 +); + + +------------------------------------------------------- +-- Transformation: NKG_ETRF14 -> ETRF2000@2003.75 (LT) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'LT_2020_INTRAPLATE', -- object auth+code + 'ETRF2000@2000.0 to ETRF2000@2003.75 (LKS94)', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=3.75 +grids=eur_nkg_nkgrf17vel.tif', + 'EPSG','7930', -- source_crs: ETRF2000@2000.0 + 'EPSG','4950', -- target_crs: LKS94 + 0.005, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5055', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'LT_2020_INTRAPLATE', -- object auth+code + 'EPSG', '1145', -- extent: Lithuania - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF14_TO_LT', -- operation auth+code + 'NKG_ETRF14 to LKS94', -- name + 'Transformation from NKG_ETRF14@2000.0 to ETRF2000@2003.75 (LKS94)', -- description + 'NKG', 'ETRF14',-- source_crs: NKG_ETRF00 + 'EPSG','4950', -- target_crs: LKS94 + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF14_TO_LT', 1, 'NKG', 'PAR_2020_LT'), + ('NKG', 'ETRF14_TO_LT', 2, 'NKG', 'LT_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5056', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF14_TO_LT', -- object auth+code + 'EPSG', '1145', -- extent: Lithuania - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2014 -> ETRF2000@2003.75 (LT) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2014_TO_LT', -- operation auth+code + 'ITRF2014 to ETRS89(LT)', -- name + 'Time-dependent transformation from ITRF2014 to ETRS89(LT)', -- description + 'EPSG', '7789', -- source_crs: ITRF2014 + 'EPSG', '4950', -- target_crs: LKS94 + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2014_TO_LT', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014 + ('NKG', 'ITRF2014_TO_LT', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'), + ('NKG', 'ITRF2014_TO_LT', 3, 'NKG', 'PAR_2020_LT'), + ('NKG', 'ITRF2014_TO_LT', 4, 'NKG', 'LT_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5057', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2014_TO_LT', -- object auth+code + 'EPSG', '1145', -- extent: Lithuania - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + +INSERT INTO "supersession" VALUES ( + 'concatenated_operation', + 'NKG', 'ITRF2000_TO_LT', + 'concatenated_operation', + 'NKG', 'ITRF2014_TO_LT', + 'NKG', + 0 +); + + +------------------------------------------------------- +-- Transformation: NKG_ETRF14 -> ETRF97@1999.5 (SE) +------------------------------------------------------- + +INSERT INTO "other_transformation" ( + auth_name, + code, + name, + description, + method_auth_name, + method_code, + method_name, + source_crs_auth_name, + source_crs_code, + target_crs_auth_name, + target_crs_code, + accuracy, + operation_version, + deprecated +) +VALUES( + 'NKG', 'SE_2020_INTRAPLATE',-- object auth+code + 'ETRF97@2000.0 to ETRF97@1999.5', -- name + NULL, -- description + 'PROJ', 'PROJString', -- method auth+cod + '+proj=deformation +dt=-0.5 +grids=eur_nkg_nkgrf17vel.tif', + 'EPSG','7928', -- source_crs: ETRF97@2000.0 + 'EPSG','4976', -- target_crs: SWEREF99 + 0.005, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + +INSERT INTO "usage" VALUES ( + 'NKG', '5061', -- usage auth+code + 'other_transformation', -- object_table_name + 'NKG', 'SE_2020_INTRAPLATE', -- object auth+code + 'EPSG', '1225', -- extent: Sweden - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope +); + +INSERT INTO "concatenated_operation" VALUES( + 'NKG', 'ETRF14_TO_SE', -- operation auth+code + 'NKG_ETRF14 to SWEREF99', -- name + 'Transformation from NKG_ETRF14@2000.0 to SWEREF99 (ETRF97@1999.5)', -- description + 'NKG', 'ETRF14',-- source_crs: NKG_ETRF00 + 'EPSG','4976', -- target_crs: SWEREF99 + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated +); + + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ETRF14_TO_SE', 1, 'NKG', 'PAR_2020_SE'), + ('NKG', 'ETRF14_TO_SE', 2, 'NKG', 'SE_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5062', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ETRF14_TO_SE', -- object auth+code + 'EPSG', '1225', -- extent: Sweden - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + + +------------------------------------------------------- +-- Transformation: ITRF2014 -> ETRF97@1999.5 (SE) +------------------------------------------------------- + +INSERT INTO "concatenated_operation" VALUES ( + 'NKG', 'ITRF2014_TO_SE', -- operation auth+code + 'ITRF2014 to ETRS89(SE)', -- name + 'Time-dependent transformation from ITRF2014 to SWEREF99', -- description + 'EPSG', '7789', -- source_crs: ITRF2014 + 'EPSG', '4976', -- target_crs: SWEREF99 + 0.01, -- accuracy + 'NKG 2020', -- operation_version + 0 -- deprecated + +); + +INSERT INTO "concatenated_operation_step" ( + operation_auth_name, operation_code, step_number, step_auth_name, step_code +) VALUES + ('NKG', 'ITRF2014_TO_SE', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014 + ('NKG', 'ITRF2014_TO_SE', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'), + ('NKG', 'ITRF2014_TO_SE', 3, 'NKG', 'PAR_2020_SE'), + ('NKG', 'ITRF2014_TO_SE', 4, 'NKG', 'SE_2020_INTRAPLATE') +; + + +INSERT INTO "usage" VALUES ( + 'NKG', '5063', -- usage auth+code + 'concatenated_operation', -- object_table_name + 'NKG', 'ITRF2014_TO_SE', -- object auth+code + 'EPSG', '1352', -- extent: Sweden - onshore and offshore + 'NKG', 'SCOPE_GENERIC' -- scope auth+code +); + + +INSERT INTO "supersession" VALUES ( + 'concatenated_operation', + 'NKG', 'ITRF2000_TO_SE', + 'concatenated_operation', + 'NKG', 'ITRF2014_TO_SE', + 'NKG', + 0 +); + + diff --git a/data/sql_filelist.cmake b/data/sql_filelist.cmake index a21e8630..e7bca4ff 100644 --- a/data/sql_filelist.cmake +++ b/data/sql_filelist.cmake @@ -35,5 +35,6 @@ set(SQL_FILES "${SQL_DIR}/grid_alternatives.sql" "${SQL_DIR}/grid_alternatives_generated_noaa.sql" "${SQL_DIR}/customizations.sql" + "${SQL_DIR}/nkg.sql" "${SQL_DIR}/commit.sql" ) diff --git a/test/gie/nkg.gie b/test/gie/nkg.gie new file mode 100644 index 00000000..7414914e --- /dev/null +++ b/test/gie/nkg.gie @@ -0,0 +1,240 @@ +<gie-strict> + +# ------------------------------------------------------------------------------- +# NKG +# ------------------------------------------------------------------------------- +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2000_TO_NKG_ETRF00 +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.9311 948983.7980 5201383.2227 2020.5 + + +#------------------------------------------------------------------------------- +# DENMARK +#------------------------------------------------------------------------------- + +# 2008 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2000_TO_DK +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.9362 948983.7825 5201383.2292 2020.5 + + +operation operation urn:ogc:def:coordinateOperation:NKG::ETRF00_TO_DK +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.3829 948984.2188 5201383.5296 2020.5 + + +# 2020 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2014_TO_DK +tolerance 0.1 mm + +# BUDD +accept 3513638.0964 778956.5470 5248216.5248 2015.0 +expect 3513638.5607 778956.1875 5248216.2477 2015.0 + +#ESBC +accept 3582104.8458 532590.0946 5232755.0863 2015.0 +expect 3582105.2916 532589.7310 5232754.8057 2015.0 + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2014_TO_NKG_ETRF14 +tolerance 0.1 mm + +# BUDD +accept 3513638.0964 778956.5470 5248216.5248 2015.0 +expect 3513638.5071 778956.1528 5248216.2870 2015.0 + +# ESBC +accept 3582104.8458 532590.0946 5232755.0863 2015.0 +expect 3582105.2401 532589.6950 5232754.8507 2015.0 + +operation operation urn:ogc:def:coordinateOperation:NKG::ETRF14_TO_DK +tolerance 0.1 mm + +# BUDD +accept 3513638.5071 778956.1528 5248216.2870 2015.0 +expect 3513638.5607 778956.1875 5248216.2477 2015.0 + +# ESBC +accept 3582105.2401 532589.6950 5232754.8507 2015.0 +expect 3582105.2916 532589.7310 5232754.8057 2015.0 + +# ------------------------------------------------------------------------------- +# ESTONIA +# ------------------------------------------------------------------------------- + +# 2008 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2000_TO_EE +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.9395 948983.8006 5201383.2242 2020.5 + + +operation operation urn:ogc:def:coordinateOperation:NKG::ETRF00_TO_EE +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.3862 948984.2370 5201383.5246 2020.5 + + +# 2020 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2014_TO_EE +tolerance 0.1 mm + +# AJOE +accept 2922027.7409 1516183.8589 5444680.6502 2015.0 +expect 2922028.2730 1516183.5457 5444680.4094 2015.0 + +# ------------------------------------------------------------------------------- +# FINLAND +# ------------------------------------------------------------------------------- + +# 2008 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2000_TO_FI +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.9522 948983.7911 5201383.2230 2020.5 + + +operation operation urn:ogc:def:coordinateOperation:NKG::ETRF00_TO_FI +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.3989 948984.2274 5201383.5235 2020.5 + + +# 2020 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2014_TO_FI +tolerance 0.1 mm + +# DEGE +accept 2994012.0569 1112559.9272 5502272.0863 2015.0 +expect 2994012.5170 1112559.5902 5502271.7683 2015.0 + + +# ------------------------------------------------------------------------------- +# LATVIA +# ------------------------------------------------------------------------------- + +# 2008 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2000_TO_LV +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.9806 948983.8606 5201383.3118 2020.5 + + +operation operation urn:ogc:def:coordinateOperation:NKG::ETRF00_TO_LV +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.4273 948984.2970 5201383.6122 2020.5 + +# 2020 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2014_TO_LV +tolerance 0.1 mm + +# BAUS +accept 3226814.4746 1449250.4615 5289639.6134 2015.0 +expect 3226814.9950 1449250.1841 5289639.3779 2015.0 + + +# ------------------------------------------------------------------------------- +# LITHUANIA +# ------------------------------------------------------------------------------- + +# 2008 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2000_TO_LT +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.9358 948983.8042 5201383.2294 2020.5 + + +operation operation urn:ogc:def:coordinateOperation:NKG::ETRF00_TO_LT +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.3826 948984.2405 5201383.5299 2020.5 + +# 2020 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2014_TO_LT +tolerance 0.1 mm + +# VLNS +accept 3343600.4221 1580417.8797 5179337.3696 2015.0 +expect 3343600.9945 1580417.5661 5179337.1637 2015.0 + + +# ------------------------------------------------------------------------------- +# NORWAY +# ------------------------------------------------------------------------------- + +# 2008 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2000_TO_NO +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.9204 948983.8049 5201383.2054 2020.5 + + +operation operation urn:ogc:def:coordinateOperation:NKG::ETRF00_TO_NO +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.3671 948984.2412 5201383.5058 2020.5 + + +# ------------------------------------------------------------------------------- +# SWEDEN +# ------------------------------------------------------------------------------- + + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2000_TO_SE +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.9223 948983.7912 5201383.2025 2020.5 + + +operation operation urn:ogc:def:coordinateOperation:NKG::ETRF00_TO_SE +tolerance 1 mm + +accept 3541657.3778 948984.2343 5201383.5231 2020.5 +expect 3541657.3690 948984.2275 5201383.5030 2020.5 + +# 2020 Transformations + +operation operation urn:ogc:def:coordinateOperation:NKG::ITRF2014_TO_SE +tolerance 0.1 mm + +# ARJ0 +accept 2441774.9791 799268.3078 5818729.4941 2015.0 +expect 2441775.4338 799268.0336 5818729.1635 2015.0 + +# BOD3 +accept 2391774.0738 615615.1324 5860966.0796 2015.0 +expect 2391774.5409 615614.8770 5860965.8078 2015.0 + +# KIR0 +accept 2248123.0276 865686.7906 5886425.8928 2015.0 +expect 2248123.5028 865686.5301 5886425.5928 2015.0 + +</gie-strict> diff --git a/test/unit/test_c_api.cpp b/test/unit/test_c_api.cpp index e54c6fa7..d43d68ce 100644 --- a/test/unit/test_c_api.cpp +++ b/test/unit/test_c_api.cpp @@ -1183,10 +1183,12 @@ TEST_F(CApi, proj_get_authorities_from_database) { ASSERT_TRUE(list[2] != nullptr); EXPECT_EQ(list[2], std::string("IGNF")); ASSERT_TRUE(list[3] != nullptr); - EXPECT_EQ(list[3], std::string("OGC")); + EXPECT_EQ(list[3], std::string("NKG")); ASSERT_TRUE(list[4] != nullptr); - EXPECT_EQ(list[4], std::string("PROJ")); - EXPECT_EQ(list[5], nullptr); + EXPECT_EQ(list[4], std::string("OGC")); + ASSERT_TRUE(list[5] != nullptr); + EXPECT_EQ(list[5], std::string("PROJ")); + EXPECT_EQ(list[6], nullptr); } // --------------------------------------------------------------------------- |