From f969d51e0bf128bfacba075e689205b512b31583 Mon Sep 17 00:00:00 2001 From: Kristian Evers Date: Mon, 21 Dec 2020 14:30:43 +0100 Subject: 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. --- data/sql/nkg.sql | 2174 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 2174 insertions(+) create mode 100644 data/sql/nkg.sql (limited to 'data/sql') 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 +); + + -- cgit v1.2.3