diff options
Diffstat (limited to 'data/sql')
| -rw-r--r-- | data/sql/nkg.sql | 2174 |
1 files changed, 2174 insertions, 0 deletions
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 +); + + |