Merge pull request #2494 from kbevers/nkg_trans_final

Implementing the NKG transformations in proj.db

3 files changed, 2176 insertions, 0 deletions

diff --git a/data/Makefile.am b/data/Makefile.am
index eda69a9a..8f65ed5c 100644
--- a/data/Makefile.am
+++ b/data/Makefile.am
@@ -42,6 +42,7 @@ SQL_ORDERED_LIST = sql/begin.sql \
 		sql/grid_alternatives.sql \
 		sql/grid_alternatives_generated_noaa.sql \
 		sql/customizations.sql \
+		sql/nkg.sql \
 		sql/commit.sql
 
 EXTRA_DIST = proj.ini GL27 nad.lst nad27 nad83 \
diff --git a/data/sql/nkg.sql b/data/sql/nkg.sql
new file mode 100644
index 00000000..93d82f97
--- /dev/null
+++ b/data/sql/nkg.sql
@@ -0,0 +1,2174 @@
+INSERT INTO "metadata" VALUES('NKG.SOURCE', 'https://github.com/NordicGeodesy/NordicTransformations');
+INSERT INTO "metadata" VALUES('NKG.VERSION', '1.0.0');
+INSERT INTO "metadata" VALUES('NKG.DATE', '2020-12-21');
+
+-- Append NKG to authority references
+UPDATE
+   authority_to_authority_preference
+SET
+   allowed_authorities = allowed_authorities || ',NKG'
+WHERE
+   source_auth_name = 'EPSG' AND target_auth_name = 'EPSG';
+
+INSERT INTO "authority_to_authority_preference"
+    (source_auth_name,target_auth_name, allowed_authorities)
+VALUES
+    ('NKG', 'EPSG', 'NKG,PROJ,EPSG');
+
+-- extent for NKG2008 transformations
+INSERT INTO "extent" VALUES(
+    'NKG','EXTENT_2008',            -- extend auth+code
+    'Nordic and Baltic countries',  -- name
+    'Denmark; Estonia; Finland; Latvia; Lithuania; Norway; Sweden', -- description
+    53.0,                       -- south latitude
+    73.0,                       -- north latitude
+    3.0,                        -- west longitude
+    40.0,                       -- east longitude
+    0
+);
+
+-- extent for NKG2020 transformations
+INSERT INTO "extent" VALUES(
+    'NKG','EXTENT_2020',            -- extend auth+code
+    'Nordic and Baltic countries',  -- name
+    'Denmark; Estonia; Finland; Latvia; Lithuania; Norway; Sweden', -- description
+    50.0,                       -- south latitude
+    75.0,                       -- north latitude
+    0.0,                        -- west longitude
+    49.0,                       -- east longitude
+    0
+);
+
+-- Scope for both NKG2008 and NKG2020 transformations
+INSERT INTO "scope" VALUES (
+    'NKG', 'SCOPE_GENERIC', -- scope auth+code
+    'Geodesy. High accuracy ETRS89 transformations', -- scope
+    0                       --deprecated
+);
+
+
+-------------------------------------------------------
+--                DATUM+CRS: NKG_ETRF00
+-------------------------------------------------------
+
+INSERT INTO "geodetic_datum" VALUES (
+    'NKG','DATUM_NKG_ETRF00', -- auth+code
+    'NKG_ETRF00',   -- name
+    NULL,           -- description
+    'EPSG','7019',  -- ellipsoid auth+code
+    'EPSG','8901',  -- prime meridian auth+code
+    '2016-03-16',   -- publication date
+    2000.0,         -- frame reference epoch
+    NULL,           -- ensemble accuracy
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG','5007',
+    'geodetic_datum',
+    'NKG','DATUM_NKG_ETRF00',
+    'NKG','EXTENT_2008',    -- extend auth+code
+    'NKG','SCOPE_GENERIC'   -- scope auth+code
+);
+
+-- Add CRS entry for NKG common frame ETRF_NKG00
+INSERT INTO "geodetic_crs" VALUES(
+    'NKG','ETRF00', -- CRS auth+code
+    'NKG_ETRF00',   -- name
+    'NKG Common reference frame 2000', -- description
+    'geocentric',   -- type
+    'EPSG','6500',  -- CRS type auth+code: ECEF
+    'NKG','DATUM_NKG_ETRF00', -- datum auth+code
+    NULL,           -- text definition
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5101',          -- usage auth+code
+    'geodetic_crs',         -- object_table_name
+    'NKG', 'ETRF00',        -- object auth+code
+    'NKG', 'EXTENT_2008',   -- extent auth+code
+    'NKG', 'SCOPE_GENERIC'  -- scope auth+code
+);
+
+-------------------------------------------------------
+--                DATUM+CRS: NKG_ETRF14
+-------------------------------------------------------
+
+INSERT INTO "geodetic_datum" VALUES (
+    'NKG','DATUM_NKG_ETRF14', -- auth+code
+    'NKG_ETRF14',   -- name
+    NULL,           -- description
+    'EPSG','7019',  -- ellipsoid auth+code
+    'EPSG','8901',  -- prime meridian auth+code
+    '2021-03-01',   -- publication date
+    2000.0,         -- frame reference epoch
+    NULL,           -- ensemble accuracy
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG','5033',
+    'geodetic_datum',
+    'NKG','DATUM_NKG_ETRF14',
+    'NKG','EXTENT_2020', -- extend auth+code
+    'NKG','SCOPE_GENERIC' -- scope auth+code
+);
+
+-- Add CRS entry for NKG common frame ETRF_NKG00
+INSERT INTO "geodetic_crs" VALUES(
+    'NKG','ETRF14', -- CRS auth+code
+    'NKG_ETRF14',   -- name
+    'NKG Common reference frame 2014', -- description
+    'geocentric',   -- type
+    'EPSG','6500',  -- CRS type auth+code: ECEF
+    'NKG','DATUM_NKG_ETRF14', -- datum auth+code
+    NULL,           -- text definition
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5102',          -- usage auth+code
+    'geodetic_crs',         -- object_table_name
+    'NKG', 'ETRF14',        -- object auth+code
+    'NKG', 'EXTENT_2020',   -- extent auth+code
+    'NKG', 'SCOPE_GENERIC'  -- scope auth+code
+);
+
+-------------------------------------------------------
+--     Transformation: ITRF2000 -> NKG_ETRF00
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation" VALUES (
+    'NKG', 'ITRF2000_TO_NKG_ETRF00', -- operation auth+code
+    'ITRF2000 to NKG_ETRF00', -- name
+    'Time-dependent transformation from ITRF2000 to NKG_ETRF00', -- description
+    'EPSG', '4919', -- source_crs:  ITRF2000
+    'NKG', 'ETRF00',-- target_crs:  NKG_ETRF00
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG','NKG_ETRF00_TO_ETRF2000', -- operation auth+code
+    'NKG_ETRF00 to ETRF2000',       -- name
+    NULL,                           -- description
+    'PROJ', 'PROJString',           -- method auth+code
+    '+proj=deformation +t_epoch=2000.0 +grids=eur_nkg_nkgrf03vel_realigned.tif',
+    'NKG', 'ETRF00',-- source_crs:  NKG_ETRF00
+    'EPSG','7930',  -- target_crs:  ETRF2000
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5003',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG','NKG_ETRF00_TO_ETRF2000', -- object auth+code
+    'NKG','EXTENT_2008',    -- extent auth+code
+    'NKG','SCOPE_GENERIC'   -- scope auth+code
+);
+
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2000_TO_NKG_ETRF00', 2, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000
+    ('NKG', 'ITRF2000_TO_NKG_ETRF00', 3, 'NKG', 'NKG_ETRF00_TO_ETRF2000')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5001',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2000_TO_NKG_ETRF00', -- object auth+code
+    'NKG', 'EXTENT_2008',       -- extent auth+code
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+-------------------------------------------------------
+--     Transformation: ITRF2014 -> NKG_ETRF14
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation" VALUES (
+    'NKG', 'ITRF2014_TO_NKG_ETRF14', -- operation auth+code
+    'ITRF2014 to NKG_ETRF14', -- name
+    'Time-dependent transformation from ITRF2014 to NKG_ETRF14', -- description
+    'EPSG', '7789', -- source_crs:  ITRF2014
+    'NKG', 'ETRF14',-- target_crs:  NKG_ETRF14
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG','NKG_ETRF14_TO_ETRF2014', -- operation auth+code
+    'NKG_ETRF14 to ETRF2014',       -- name
+    NULL,                           -- description
+    'PROJ', 'PROJString',           -- method auth+code
+    '+proj=deformation +t_epoch=2000.0 +grids=eur_nkg_nkgrf17vel.tif',
+    'NKG', 'ETRF14',-- source_crs:  NKG_ETRF14
+    'EPSG','8401',  -- target_crs:  ETRF2014
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5034',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG','NKG_ETRF14_TO_ETRF2014', -- object auth+code
+    'NKG','EXTENT_2020',    -- extent auth+code
+    'NKG','SCOPE_GENERIC'   -- scope auth+code
+);
+
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2014_TO_NKG_ETRF14', 2, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014
+    ('NKG', 'ITRF2014_TO_NKG_ETRF14', 3, 'NKG', 'NKG_ETRF14_TO_ETRF2014')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5035',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2014_TO_NKG_ETRF14', -- object auth+code
+    'NKG', 'EXTENT_2020',       -- extent auth+code
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+
+-------------------------------------------------------------
+-- Intermediate transformations: NKG_ETRF00 -> ETRFyy@2000.00
+-------------------------------------------------------------
+
+-- DK
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','P1_2008_DK', -- operation auth+code
+    'NKG_ETRF00 to ETRF92@2000.0', -- name
+    'Transformation from NKG_ETRF00 to ETRF92, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF00', -- source auth+code
+    'EPSG','7920',  -- target auth+code
+    0.005,          -- accuracy
+    0.03863,        -- x
+    0.147,          -- y
+    0.02776,        -- z
+    'EPSG','9001',
+    0.00617753,     -- rx
+    5.064e-05,      -- ry
+    4.729e-05,      -- rz
+    'EPSG','9104',
+    -0.009420,      -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2008',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5004',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','P1_2008_DK',         -- object auth+code
+    'EPSG', '1080',             -- extent: Denmark - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+
+-- EE
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','P1_2008_EE', -- operation auth+code
+    'NKG_ETRF00 to ETRF96@2000.0', -- name
+    'Transformation from NKG_ETRF00 to ETRF96, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF00', -- source auth+code
+    'EPSG','7926',  -- target auth+code
+    0.005,           -- accuracy
+    0.12194,        -- x
+    0.02225,        -- y
+    -0.03541,       -- z
+    'EPSG','9001',
+    0.00227196,     -- rx
+    -0.00323934,    -- ry
+    0.00247008,     -- rz
+    'EPSG','9104',
+    -0.005626,      -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2008',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5008',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','P1_2008_EE',         -- object auth+code
+    'EPSG', '1090',             -- extent: Estonia - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+
+-- FI
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','P1_2008_FI', -- operation auth+code
+    'NKG_ETRF00 to ETRF96@2000.0', -- name
+    'Transformation from NKG_ETRF00 to ETRF96, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF00', -- source auth+code
+    'EPSG','7926',  -- target auth+code
+    0.005,          -- accuracy
+    0.07251,        -- x
+    -0.13019,       -- y
+    -0.11323,       -- z
+    'EPSG','9001',
+    -0.00157399,    -- rx
+    -0.00308833,    -- ry
+    0.00410332,     -- rz
+    'EPSG','9104',
+    0.013012,       -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2008',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5009',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','P1_2008_FI',         -- object auth+code
+    'EPSG', '1095',             -- extent: Finland - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+
+-- LV
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','P1_2008_LV', -- operation auth+code
+    'NKG_ETRF00 to ETRF89@2000.0', -- name
+    'Transformation from NKG_ETRF00 to ETRF89, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF00', -- source auth+code
+    'EPSG','7914',  -- target auth+code
+    0.02,           -- accuracy
+    0.41812,        -- x
+    -0.78105,       -- y
+    -0.01335,       -- z
+    'EPSG','9001',
+    -0.0216436,     -- rx
+    -0.0115184,     -- ry
+    0.01719911,     -- rz
+    'EPSG','9104',
+    0.000757,       -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2008',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5010',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','P1_2008_LV',         -- object auth+code
+    'EPSG', '1139',             -- extent: Latvia - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+-- LT
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','P1_2008_LT', -- operation auth+code
+    'NKG_ETRF00 to ETRF2000@2000.0', -- name
+    'Transformation from NKG_ETRF00 to ETRF2000, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF00', -- source auth+code
+    'EPSG','7930',  -- target auth+code
+    0.01,           -- accuracy
+    0.05692,        -- x
+    0.115495,       -- y
+    -0.00078,       -- z
+    'EPSG','9001',
+    0.00314291,     -- rx
+    -0.00147975,    -- ry
+    -0.00134758,    -- rz
+    'EPSG','9104',
+    -0.006182,      -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2008',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5011',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','P1_2008_LT',         -- object auth+code
+    'EPSG', '1145',             -- extent: Lithuania - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+
+-- NO
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','P1_2008_NO', -- operation auth+code
+    'NKG_ETRF00 to ETRF93@2000.0', -- name
+    'Transformation from NKG_ETRF00 to ETRF93, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF00', -- source auth+code
+    'EPSG','7922',  -- target auth+code
+    0.005,          -- accuracy
+    -0.13116,       -- x
+    -0.02817,       -- y
+    0.02036,        -- z
+    'EPSG','9001',
+    -0.00038674,    -- rx
+    0.00408947,     -- ry
+    0.00103588,     -- rz
+    'EPSG','9104',
+    0.006569,       -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2008',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5012',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','P1_2008_NO',         -- object auth+code
+    'EPSG', '1352',             -- extent: Norway - onshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+
+-- SE
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','P1_2008_SE', -- operation auth+code
+    'NKG_ETRF00 to ETRF97@2000.0', -- name
+    'Transformation from NKG_ETRF00 to ETRF97, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF00', -- source auth+code
+    'EPSG','7928',  -- target auth+code
+    0.005,          -- accuracy
+    -0.01642,       -- x
+    -0.00064,       -- y
+    -0.0305,        -- z
+    'EPSG','9001',
+    0.00187431,     -- rx
+    0.00046382,     -- ry
+    0.00228487,     -- rz
+    'EPSG','9104',
+    0.001861,       -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2008',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5014',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','P1_2008_SE',         -- object auth+code
+    'EPSG', '1225',             -- extent: Sweden - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+
+-------------------------------------------------------------
+-- Intermediate transformations: NKG_ETRF14 -> ETRFyy@2000.00
+-------------------------------------------------------------
+
+-- DK
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','PAR_2020_DK', -- operation auth+code
+    'NKG_ETRF14 to ETRF92@2000.0', -- name
+    'Transformation from NKG_ETRF14 to ETRF92, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF14', -- source auth+code
+    'EPSG','7920',  -- target auth+code
+    0.005,          -- accuracy
+    0.66818,        -- x
+    0.04453,        -- y
+    -0.45049,       -- z
+    'EPSG','9001',
+    0.00312883,     -- rx
+    -0.02373423,    -- ry
+    0.00442969,     -- rz
+    'EPSG','9104',
+    -0.003136,      -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2020',     -- operation version
+    0
+);
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5036',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','PAR_2020_DK',        -- object auth+code
+    'EPSG', '1080',             -- extent: Denmark - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+
+-- EE
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','PAR_2020_EE', -- operation auth+code
+    'NKG_ETRF14 to ETRF96@2000.0', -- name
+    'Transformation from NKG_ETRF14 to ETRF96, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF14', -- source auth+code
+    'EPSG','7926',  -- target auth+code
+    0.005,          -- accuracy
+    -0.05027,       -- x
+    -0.11595,       -- y
+    0.03012,        -- z
+    'EPSG','9001',
+    -0.00310814,    -- rx
+    0.00457237,     -- ry
+    0.00472406,     -- rz
+    'EPSG','9104',
+    0.003191,       -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2020',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5037',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','PAR_2020_EE',         -- object auth+code
+    'EPSG', '1090',             -- extent: Estonia - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+
+-- FI
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','PAR_2020_FI', -- operation auth+code
+    'NKG_ETRF14 to ETRF96@2000.0', -- name
+    'Transformation from NKG_ETRF14 to ETRF96, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF14', -- source auth+code
+    'EPSG','7926',  -- target auth+code
+    0.005,          -- accuracy
+    0.15651,        -- x
+    -0.10993,       -- y
+    -0.10935,       -- z
+    'EPSG','9001',
+    -0.00312861,    -- rx
+    -0.00378935,    -- ry
+    0.00403512,     -- rz
+    'EPSG','9104',
+    0.00529,        -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2020',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5038',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','PAR_2020_FI',        -- object auth+code
+    'EPSG', '1095',             -- extent: Finland - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+
+-- LV
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','PAR_2020_LV', -- operation auth+code
+    'NKG_ETRF14 to ETRF89@2000.0', -- name
+    'Transformation from NKG_ETRF14 to ETRF89, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF14', -- source auth+code
+    'EPSG','7914',  -- target auth+code
+    0.01,           -- accuracy
+    0.09745,        -- x
+    -0.69388,       -- y
+    0.52901,        -- z
+    'EPSG','9001',
+    -0.0192069,     -- rx
+    0.01043272,     -- ry
+    0.02327169,     -- rz
+    'EPSG','9104',
+    -0.049663,      -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2020',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5039',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','PAR_2020_LV',        -- object auth+code
+    'EPSG', '1139',             -- extent: Latvia - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+-- LT
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','PAR_2020_LT', -- operation auth+code
+    'NKG_ETRF14 to ETRF2000@2000.0', -- name
+    'Transformation from NKG_ETRF14 to ETRF2000, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF14', -- source auth+code
+    'EPSG','7930',  -- target auth+code
+    0.015,          -- accuracy
+    0.36749,        -- x
+    0.14351,        -- y
+    -0.18472,       -- z
+    'EPSG','9001',
+    0.0047914,      -- rx
+    -0.01027566,    -- ry
+    0.00276102,     -- rz
+    'EPSG','9104',
+    -0.003684,      -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2020',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5040',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','PAR_2020_LT',         -- object auth+code
+    'EPSG', '1145',             -- extent: Lithuania - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+
+
+-- SE
+INSERT INTO "helmert_transformation" VALUES (
+    'NKG','PAR_2020_SE', -- operation auth+code
+    'NKG_ETRF14 to ETRF97@2000.0', -- name
+    'Transformation from NKG_ETRF14 to ETRF97, at transformation reference epoch 2000.0', -- description / remark
+    'EPSG','1033',  -- method auth+code
+    'Position Vector transformation (geocentric domain)',
+    'NKG','ETRF14', -- source auth+code
+    'EPSG','7928',  -- target auth+code
+    0.005,          -- accuracy
+    0.03054,        -- x
+    0.04606,        -- y
+   -0.07944,        -- z
+    'EPSG','9001',
+    0.00141958,     -- rx
+    0.00015132,     -- ry
+    0.00150337,     -- rz
+    'EPSG','9104',
+    0.003002,       -- s
+    'EPSG','9202',
+    NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
+    'NKG 2020',     -- operation version
+    0
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5042',              -- usage auth+code
+    'helmert_transformation',   -- object_table_name
+    'NKG','PAR_2020_SE',        -- object auth+code
+    'EPSG', '1225',             -- extent: Sweden - onshore and offshore
+    'NKG',  'SCOPE_GENERIC'     -- scope
+);
+
+
+
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF00 -> ETRF92@1994.704 (DK)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'ETRF92_2000_TO_ETRF92_1994',-- object auth+code
+    'ETRF92@2000.0 to ETRF92@1994.704', -- name
+    NULL, -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=-5.296 +grids=eur_nkg_nkgrf03vel_realigned.tif',
+    'EPSG','7920',  -- source_crs:  ETRF92@2000.0
+    'EPSG','4936',  -- target_crs:  ETRS89 (DK)
+    0.005,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5005',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'ETRF92_2000_TO_ETRF92_1994', -- object auth+code
+    'EPSG', '1080',         -- extent: Denmark - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF00_TO_DK', -- operation auth+code
+    'NKG_ETRF00 to ETRS89(DK)', -- name
+    'Transformation from NKG_ETRF00@2000.0 to ETRF92@1994.704', -- description
+    'NKG', 'ETRF00',-- source_crs:  NKG_ETRF00
+    'EPSG','4936',  -- target_crs:  ETRS89 (DK)
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF00_TO_DK', 1, 'NKG', 'P1_2008_DK'),
+    ('NKG', 'ETRF00_TO_DK', 2, 'NKG', 'ETRF92_2000_TO_ETRF92_1994')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5006',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF00_TO_DK',      -- object auth+code
+    'EPSG', '1080',             -- extent: Denmark - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2000 -> ETRF92@1994.704 (DK)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2000_TO_DK',  -- operation auth+code
+    'ITRF2000 to ETRS89(DK)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89(DK)', -- description
+    'EPSG', '4919', -- source_crs:  ITRF2000
+    'EPSG', '4936', -- target_crs:  ETRS89(DK)
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2000_TO_DK', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000
+    ('NKG', 'ITRF2000_TO_DK', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'),
+    ('NKG', 'ITRF2000_TO_DK', 3, 'NKG', 'P1_2008_DK'),
+    ('NKG', 'ITRF2000_TO_DK', 4, 'NKG', 'ETRF92_2000_TO_ETRF92_1994')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5013',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2000_TO_DK',    -- object auth+code
+    'EPSG', '1080',             -- extent: Denmark - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF00 -> ETRF96@1997.56 (EE)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'ETRF96_2000_TO_ETRF96_1997_56',-- object auth+code
+    'ETRF96@2000.0 to ETRF96@1997.56', -- name
+    NULL, -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=-2.44 +grids=eur_nkg_nkgrf03vel_realigned.tif',
+    'EPSG','7926',  -- source_crs:  ETRF96@2000.0
+    'EPSG','4936',  -- target_crs:  ETRS89 (EE)
+    0.005,          -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5015',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'ETRF96_2000_TO_ETRF96_1997_56', -- object auth+code
+    'EPSG', '1090',         -- extent: Estonia - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF00_TO_EE', -- operation auth+code
+    'NKG_ETRF00 to ETRS89 (EUREF-EST97)', -- name
+    'Transformation from NKG_ETRF00@2000.0 to ETRF96@1997.56', -- description
+    'NKG', 'ETRF00',-- source_crs:  NKG_ETRF00
+    'EPSG','4936',  -- target_crs:  ETRS89 (EE)
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF00_TO_EE', 1, 'NKG', 'P1_2008_EE'),
+    ('NKG', 'ETRF00_TO_EE', 2, 'NKG', 'ETRF96_2000_TO_ETRF96_1997_56')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5016',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF00_TO_EE',      -- object auth+code
+    'EPSG', '1090',             -- extent: Estonia - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2000 -> ETRF96@1997.56 (EE)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2000_TO_EE',  -- operation auth+code
+    'ITRF2000 to ETRS89(EE)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89 (EUREF-EST97)', -- description
+    'EPSG', '4919', -- source_crs:  ITRF2000
+    'EPSG', '4936', -- target_crs:  ETRS89(EE)
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2000_TO_EE', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000
+    ('NKG', 'ITRF2000_TO_EE', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'),
+    ('NKG', 'ITRF2000_TO_EE', 3, 'NKG', 'P1_2008_EE'),
+    ('NKG', 'ITRF2000_TO_EE', 4, 'NKG', 'ETRF96_2000_TO_ETRF96_1997_56')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5017',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2000_TO_EE',    -- object auth+code
+    'EPSG', '1090',             -- extent: Estonia - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF00 -> ETRF96@1997.0 (FI)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'ETRF96_2000_TO_ETRF96_1997',-- object auth+code
+    'ETRF96@2000.0 to ETRF96@1997.0',     -- name
+    NULL,                               -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=-3.0 +grids=eur_nkg_nkgrf03vel_realigned.tif',
+    'EPSG','7926',  -- source_crs:  ETRF96@2000.0
+    'EPSG','4936',  -- target_crs:  ETRS89 (FI)
+    0.005,          -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5018',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'ETRF96_2000_TO_ETRF96_1997', -- object auth+code
+    'EPSG', '1095',         -- extent: Finland - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF00_TO_FI', -- operation auth+code
+    'NKG_ETRF00 to ETRS89 (EUREF-FIN)', -- name
+    'Transformation from NKG_ETRF00@2000.0 to ETRF96@1997.0', -- description
+    'NKG', 'ETRF00',-- source_crs:  NKG_ETRF00
+    'EPSG','4936',  -- target_crs:  ETRS89 (FI)
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF00_TO_FI', 1, 'NKG', 'P1_2008_FI'),
+    ('NKG', 'ETRF00_TO_FI', 2, 'NKG', 'ETRF96_2000_TO_ETRF96_1997')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5019',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF00_TO_FI',      -- object auth+code
+    'EPSG', '1095',             -- extent: Finland - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2000 -> ETRF96@1997.0 (FI)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2000_TO_FI',  -- operation auth+code
+    'ITRF2000 to ETRS89 (EUREF-FIN)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89 (EUREF-FIN)', -- description
+    'EPSG', '4919', -- source_crs:  ITRF2000
+    'EPSG', '4936', -- target_crs:  ETRS89(FI)
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2000_TO_FI', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000
+    ('NKG', 'ITRF2000_TO_FI', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'),
+    ('NKG', 'ITRF2000_TO_FI', 3, 'NKG', 'P1_2008_FI'),
+    ('NKG', 'ITRF2000_TO_FI', 4, 'NKG', 'ETRF96_2000_TO_ETRF96_1997')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5020',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2000_TO_FI',    -- object auth+code
+    'EPSG', '1095',             -- extent: Finland - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF00 -> ETRF89@1992.75 (LV)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'ETRF89_2000_TO_ETRF89_1992',-- object auth+code
+    'ETRF89@2000.0 to ETRF89@1992.75',  -- name
+    NULL,                               -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=-7.25 +grids=eur_nkg_nkgrf03vel_realigned.tif',
+    'EPSG','7914',  -- source_crs:  ETRF89@2000.0
+    'EPSG','4948',  -- target_crs:  LKS-92
+    0.005,          -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5021',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'ETRF89_2000_TO_ETRF89_1992', -- object auth+code
+    'EPSG', '1139',         -- extent: Latvia - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF00_TO_LV', -- operation auth+code
+    'NKG_ETRF00 to ETRS89 (LKS-92)', -- name
+    'Transformation from NKG_ETRF00@2000.0 to ETRF89@1992.75', -- description
+    'NKG', 'ETRF00',-- source_crs:  NKG_ETRF00
+    'EPSG','4948',  -- target_crs:  LKS-92
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF00_TO_LV', 1, 'NKG', 'P1_2008_LV'),
+    ('NKG', 'ETRF00_TO_LV', 2, 'NKG', 'ETRF89_2000_TO_ETRF89_1992')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5022',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF00_TO_LV',      -- object auth+code
+    'EPSG', '1139',             -- extent: Latvia - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2000 -> ETRF89@1992.75 (LV)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2000_TO_LV',  -- operation auth+code
+    'ITRF2000 to ETRS89 (LKS-92)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89 (LKS-92)', -- description
+    'EPSG', '4919', -- source_crs:  ITRF2000
+    'EPSG', '4948', -- target_crs:  LKS-92
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2000_TO_LV', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000
+    ('NKG', 'ITRF2000_TO_LV', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'),
+    ('NKG', 'ITRF2000_TO_LV', 3, 'NKG', 'P1_2008_LV'),
+    ('NKG', 'ITRF2000_TO_LV', 4, 'NKG', 'ETRF89_2000_TO_ETRF89_1992')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5023',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2000_TO_LV',    -- object auth+code
+    'EPSG', '1139',             -- extent: Latvia - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF00 -> ETRF2000@2003.75 (LT)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'ETRF2000_2000_TO_ETRF_2000_2003',-- object auth+code
+    'ETRF2000@2000.0 to ETRF2000@2003.75',  -- name
+    NULL,                                   -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=3.75 +grids=eur_nkg_nkgrf03vel_realigned.tif',
+    'EPSG','7930',  -- source_crs:  ETRF2000@2000.0
+    'EPSG','4950',  -- target_crs:  LKS94
+    0.005,          -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5024',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'ETRF2000_2000_TO_ETRF_2000_2003', -- object auth+code
+    'EPSG', '1145',         -- extent: Lithuania - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF00_TO_LT', -- operation auth+code
+    'NKG_ETRF00 to LKS94', -- name
+    'Transformation from NKG_ETRF00@2000.0 to ETRF2000@2003.75', -- description
+    'NKG', 'ETRF00',-- source_crs:  NKG_ETRF00
+    'EPSG','4950',  -- target_crs:  LKS94
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF00_TO_LT', 1, 'NKG', 'P1_2008_LT'),
+    ('NKG', 'ETRF00_TO_LT', 2, 'NKG', 'ETRF2000_2000_TO_ETRF_2000_2003')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5025',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF00_TO_LT',      -- object auth+code
+    'EPSG', '1145',             -- extent: Lithuania - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2000 -> ETRF2000@2003.75 (LT)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2000_TO_LT',  -- operation auth+code
+    'ITRF2000 to ETRS89(LT)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89(LT)', -- description
+    'EPSG', '4919', -- source_crs:  ITRF2000
+    'EPSG', '4950', -- target_crs:  LKS94
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2000_TO_LT', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000
+    ('NKG', 'ITRF2000_TO_LT', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'),
+    ('NKG', 'ITRF2000_TO_LT', 3, 'NKG', 'P1_2008_LT'),
+    ('NKG', 'ITRF2000_TO_LT', 4, 'NKG', 'ETRF2000_2000_TO_ETRF_2000_2003')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5026',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2000_TO_LT',    -- object auth+code
+    'EPSG', '1145',             -- extent: Lithuania - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF00 -> ETRF93@1995.0 (NO)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'ETRF93_2000_TO_ETRF93_1995',-- object auth+code
+    'ETRF93@2000.0 to ETRF93@1995.0',   -- name
+    NULL,                               -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=-5 +grids=eur_nkg_nkgrf03vel_realigned.tif',
+    'EPSG','7922',  -- source_crs:  ETRF93@2000.0
+    'EPSG','4936',  -- target_crs:  ETRS89 (NO)
+    0.005,          -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5027',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'ETRF93_2000_TO_ETRF93_1995', -- object auth+code
+    'EPSG', '1352',         -- extent: Norway - onshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF00_TO_NO', -- operation auth+code
+    'NKG_ETRF00 to ETRS89(NO)', -- name
+    'Transformation from NKG_ETRF00@2000.0 to ETRF93@1995.0', -- description
+    'NKG', 'ETRF00',-- source_crs:  NKG_ETRF00
+    'EPSG','4936',  -- target_crs:  ETRS89 (NO)
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF00_TO_NO', 1, 'NKG', 'P1_2008_NO'),
+    ('NKG', 'ETRF00_TO_NO', 2, 'NKG', 'ETRF93_2000_TO_ETRF93_1995')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5028',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF00_TO_NO',      -- object auth+code
+    'EPSG', '1352',             -- extent: Norway - onshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2000 -> ETRF93@1995.0 (NO)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2000_TO_NO',  -- operation auth+code
+    'ITRF2000 to ETRS89(NO)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89(NO)', -- description
+    'EPSG', '4919', -- source_crs:  ITRF2000
+    'EPSG', '4936', -- target_crs:  ETRS89(NO)
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2000_TO_NO', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000
+    ('NKG', 'ITRF2000_TO_NO', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'),
+    ('NKG', 'ITRF2000_TO_NO', 3, 'NKG', 'P1_2008_NO'),
+    ('NKG', 'ITRF2000_TO_NO', 4, 'NKG', 'ETRF93_2000_TO_ETRF93_1995')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5029',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2000_TO_NO',    -- object auth+code
+    'EPSG', '1352',             -- extent: Norway - onshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF00 -> ETRF97@1999.5 (SE)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'ETRF97_2000_TO_ETRF97_1999',-- object auth+code
+    'ETRF97@2000.0 to ETRF97@1999.5',   -- name
+    NULL,                               -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=-0.5 +grids=eur_nkg_nkgrf03vel_realigned.tif',
+    'EPSG','7928',  -- source_crs:  ETRF97@2000.0
+    'EPSG','4976',  -- target_crs:  SWEREF99
+    0.005,          -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5030',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'ETRF97_2000_TO_ETRF97_1999', -- object auth+code
+    'EPSG', '1225',         -- extent: Sweden - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF00_TO_SE', -- operation auth+code
+    'NKG_ETRF00 to SWEREF99', -- name
+    'Transformation from NKG_ETRF00@2000.0 to ETRF97@1999.5', -- description
+    'NKG', 'ETRF00',-- source_crs:  NKG_ETRF00
+    'EPSG','4976',  -- target_crs:  SWEREF99
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF00_TO_SE', 1, 'NKG', 'P1_2008_SE'),
+    ('NKG', 'ETRF00_TO_SE', 2, 'NKG', 'ETRF97_2000_TO_ETRF97_1999')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5031',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF00_TO_SE',      -- object auth+code
+    'EPSG', '1225',             -- extent: Sweden - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2000 -> ETRF97@1999.5 (SE)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2000_TO_SE',  -- operation auth+code
+    'ITRF2000 to ETRS89(SE)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89(SE)', -- description
+    'EPSG', '4919', -- source_crs:  ITRF2000
+    'EPSG', '4976', -- target_crs:  SWEREF99
+    0.01,           -- accuracy
+    'NKG 2008',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2000_TO_SE', 1, 'EPSG', '7941'), -- ITRF2000 -> ETRF2000
+    ('NKG', 'ITRF2000_TO_SE', 2, 'NKG', 'NKG_ETRF00_TO_ETRF2000'),
+    ('NKG', 'ITRF2000_TO_SE', 3, 'NKG', 'P1_2008_SE'),
+    ('NKG', 'ITRF2000_TO_SE', 4, 'NKG', 'ETRF97_2000_TO_ETRF97_1999')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5032',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2000_TO_SE',    -- object auth+code
+    'EPSG', '1225',             -- extent: Sweden - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF14 -> ETRF92@1994.704 (DK)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'DK_2020_INTRAPLATE',        -- object auth+code
+    'ETRF92@2000.0 to ETRF92@1994.704', -- name
+    NULL,                               -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=15.829 +grids=eur_nkg_nkgrf17vel.tif',
+    'EPSG','7920',  -- source_crs:  ETRF92@2000.0
+    'EPSG','4936',  -- target_crs:  ETRS89 (DK)
+    0.005,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5043',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'DK_2020_INTRAPLATE', -- object auth+code
+    'EPSG', '1080',         -- extent: Denmark - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF14_TO_DK', -- operation auth+code
+    'NKG_ETRF14 to ETRS89(DK)', -- name
+    'Transformation from NKG_ETRF14@2000.0 to ETRF92@1994.704', -- description
+    'NKG', 'ETRF14',-- source_crs:  NKG_ETRF00
+    'EPSG','4936',  -- target_crs:  ETRS89 (DK)
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF14_TO_DK', 1, 'NKG', 'PAR_2020_DK'),
+    ('NKG', 'ETRF14_TO_DK', 2, 'NKG', 'DK_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5044',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF14_TO_DK',      -- object auth+code
+    'EPSG', '1080',             -- extent: Denmark - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2014 -> ETRF92@1994.704 (DK)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2014_TO_DK',  -- operation auth+code
+    'ITRF2014 to ETRS89(DK)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89(DK)', -- description
+    'EPSG', '7789', -- source_crs:  ITRF2014
+    'EPSG', '4936', -- target_crs:  ETRS89(DK)
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2014_TO_DK', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014
+    ('NKG', 'ITRF2014_TO_DK', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'),
+    ('NKG', 'ITRF2014_TO_DK', 3, 'NKG', 'PAR_2020_DK'),
+    ('NKG', 'ITRF2014_TO_DK', 4, 'NKG', 'DK_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5045',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2014_TO_DK',    -- object auth+code
+    'EPSG', '1080',             -- extent: Denmark - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+INSERT INTO "supersession" VALUES (
+    'concatenated_operation',
+    'NKG', 'ITRF2000_TO_DK',
+    'concatenated_operation',
+    'NKG', 'ITRF2014_TO_DK',
+    'NKG',
+    0
+);
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF14 -> ETRF96@1997.56 (EE)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'EE_2020_INTRAPLATE',-- object auth+code
+    'ETRF96@2000.0 to ETRF96@1997.56', -- name
+    NULL, -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=-2.44 +grids=eur_nkg_nkgrf17vel.tif',
+    'EPSG','7926',  -- source_crs:  ETRF96@2000.0
+    'EPSG','4936',  -- target_crs:  ETRS89 (EE)
+    0.005,          -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5046',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'EE_2020_INTRAPLATE', -- object auth+code
+    'EPSG', '1090',         -- extent: Estonia - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF14_TO_EE', -- operation auth+code
+    'NKG_ETRF14 to ETRS89 (EUREF-EST97)', -- name
+    'Transformation from NKG_ETRF14@2000.0 to ETRF96@1997.56', -- description
+    'NKG', 'ETRF14',-- source_crs:  NKG_ETRF00
+    'EPSG','4936',  -- target_crs:  ETRS89 (EE)
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF14_TO_EE', 1, 'NKG', 'PAR_2020_EE'),
+    ('NKG', 'ETRF14_TO_EE', 2, 'NKG', 'EE_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5047',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF14_TO_EE',      -- object auth+code
+    'EPSG', '1090',             -- extent: Estonia - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2014 -> ETRF96@1997.56 (EE)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2014_TO_EE',  -- operation auth+code
+    'ITRF2014 to ETRS89 (EUREF-EST97)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89 (EUREF-EST97)', -- description
+    'EPSG', '7789', -- source_crs:  ITRF2014
+    'EPSG', '4936', -- target_crs:  ETRS89(EE)
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2014_TO_EE', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014
+    ('NKG', 'ITRF2014_TO_EE', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'),
+    ('NKG', 'ITRF2014_TO_EE', 3, 'NKG', 'PAR_2020_EE'),
+    ('NKG', 'ITRF2014_TO_EE', 4, 'NKG', 'EE_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5048',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2014_TO_EE',    -- object auth+code
+    'EPSG', '1090',             -- extent: Estonia - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+INSERT INTO "supersession" VALUES (
+    'concatenated_operation',
+    'NKG', 'ITRF2000_TO_EE',
+    'concatenated_operation',
+    'NKG', 'ITRF2014_TO_EE',
+    'NKG',
+    0
+);
+
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF14 -> ETRF96@1997.0 (FI)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'FI_2020_INTRAPLATE',-- object auth+code
+    'ETRF96@2000.0 to ETRF96@1997.0', -- name
+    NULL, -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=-3 +grids=eur_nkg_nkgrf17vel.tif',
+    'EPSG','7926',  -- source_crs:  ETRF96@2000.0
+    'EPSG','4936',  -- target_crs:  ETRS89 (FI)
+    0.005,          -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5049',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'FI_2020_INTRAPLATE', -- object auth+code
+    'EPSG', '1095',         -- extent: Finland - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF14_TO_FI', -- operation auth+code
+    'NKG_ETRF14 to ETRS89 (EUREF-FIN)', -- name
+    'Transformation from NKG_ETRF14@2000.0 to ETRF96@1997.0', -- description
+    'NKG', 'ETRF14',-- source_crs:  NKG_ETRF00
+    'EPSG','4936',  -- target_crs:  ETRS89 (FI)
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF14_TO_FI', 1, 'NKG', 'PAR_2020_FI'),
+    ('NKG', 'ETRF14_TO_FI', 2, 'NKG', 'FI_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5050',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF14_TO_FI',      -- object auth+code
+    'EPSG', '1095',             -- extent: Finland - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2014 -> ETRF96@1997.0 (FI)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2014_TO_FI',  -- operation auth+code
+    'ITRF2014 to ETRS89 (EUREF-FIN)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89 (EUREF-FIN)', -- description
+    'EPSG', '7789', -- source_crs:  ITRF2014
+    'EPSG', '4936', -- target_crs:  ETRS89(FI)
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2014_TO_FI', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014
+    ('NKG', 'ITRF2014_TO_FI', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'),
+    ('NKG', 'ITRF2014_TO_FI', 3, 'NKG', 'PAR_2020_FI'),
+    ('NKG', 'ITRF2014_TO_FI', 4, 'NKG', 'FI_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5051',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2014_TO_FI',    -- object auth+code
+    'EPSG', '1095',             -- extent: Finland - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+INSERT INTO "supersession" VALUES (
+    'concatenated_operation',
+    'NKG', 'ITRF2000_TO_FI',
+    'concatenated_operation',
+    'NKG', 'ITRF2014_TO_FI',
+    'NKG',
+    0
+);
+
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF14 -> ETRF89@1992.75 (LV)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'LV_2020_INTRAPLATE',        -- object auth+code
+    'ETRF89@2000.0 to ETRF89@1992.75 (LKS-92)',  -- name
+    NULL,                               -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=-7.25 +grids=eur_nkg_nkgrf17vel.tif',
+    'EPSG','7914',  -- source_crs:  ETRF89@2000.0
+    'EPSG','4948',  -- target_crs:  LKS-92
+    0.005,          -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5052',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'LV_2020_INTRAPLATE', -- object auth+code
+    'EPSG', '1139',         -- extent: Latvia - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF14_TO_LV', -- operation auth+code
+    'NKG_ETRF14 to ETRS89 (LKS-92)', -- name
+    'Transformation from NKG_ETRF14@2000.0 to ETRF89@1992.75', -- description
+    'NKG', 'ETRF14',-- source_crs:  NKG_ETRF00
+    'EPSG','4948',  -- target_crs:  LKS-92
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF14_TO_LV', 1, 'NKG', 'PAR_2020_LV'),
+    ('NKG', 'ETRF14_TO_LV', 2, 'NKG', 'LV_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5053',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF14_TO_LV',      -- object auth+code
+    'EPSG', '1139',             -- extent: Latvia - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2014 -> ETRF89@1992.75 (LV)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2014_TO_LV',  -- operation auth+code
+    'ITRF2014 to ETRS89 (LKS-92)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89 (LKS-92)', -- description
+    'EPSG', '7789', -- source_crs:  ITRF2014
+    'EPSG', '4948', -- target_crs:  LKS-92
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2014_TO_LV', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014
+    ('NKG', 'ITRF2014_TO_LV', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'),
+    ('NKG', 'ITRF2014_TO_LV', 3, 'NKG', 'PAR_2020_LV'),
+    ('NKG', 'ITRF2014_TO_LV', 4, 'NKG', 'LV_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5054',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2014_TO_LV',    -- object auth+code
+    'EPSG', '1139',             -- extent: Latvia - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+INSERT INTO "supersession" VALUES (
+    'concatenated_operation',
+    'NKG', 'ITRF2000_TO_LV',
+    'concatenated_operation',
+    'NKG', 'ITRF2014_TO_LV',
+    'NKG',
+    0
+);
+
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF14 -> ETRF2000@2003.75 (LT)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'LT_2020_INTRAPLATE',            -- object auth+code
+    'ETRF2000@2000.0 to ETRF2000@2003.75 (LKS94)',  -- name
+    NULL,                                   -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=3.75 +grids=eur_nkg_nkgrf17vel.tif',
+    'EPSG','7930',  -- source_crs:  ETRF2000@2000.0
+    'EPSG','4950',  -- target_crs:  LKS94
+    0.005,          -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5055',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'LT_2020_INTRAPLATE', -- object auth+code
+    'EPSG', '1145',         -- extent: Lithuania - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF14_TO_LT', -- operation auth+code
+    'NKG_ETRF14 to LKS94', -- name
+    'Transformation from NKG_ETRF14@2000.0 to ETRF2000@2003.75 (LKS94)', -- description
+    'NKG', 'ETRF14',-- source_crs:  NKG_ETRF00
+    'EPSG','4950',  -- target_crs:  LKS94
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF14_TO_LT', 1, 'NKG', 'PAR_2020_LT'),
+    ('NKG', 'ETRF14_TO_LT', 2, 'NKG', 'LT_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5056',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF14_TO_LT',      -- object auth+code
+    'EPSG', '1145',             -- extent: Lithuania - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2014 -> ETRF2000@2003.75 (LT)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2014_TO_LT',  -- operation auth+code
+    'ITRF2014 to ETRS89(LT)', -- name
+    'Time-dependent transformation from ITRF2014 to ETRS89(LT)', -- description
+    'EPSG', '7789', -- source_crs:  ITRF2014
+    'EPSG', '4950', -- target_crs:  LKS94
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2014_TO_LT', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014
+    ('NKG', 'ITRF2014_TO_LT', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'),
+    ('NKG', 'ITRF2014_TO_LT', 3, 'NKG', 'PAR_2020_LT'),
+    ('NKG', 'ITRF2014_TO_LT', 4, 'NKG', 'LT_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5057',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2014_TO_LT',    -- object auth+code
+    'EPSG', '1145',             -- extent: Lithuania - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+INSERT INTO "supersession" VALUES (
+    'concatenated_operation',
+    'NKG', 'ITRF2000_TO_LT',
+    'concatenated_operation',
+    'NKG', 'ITRF2014_TO_LT',
+    'NKG',
+    0
+);
+
+
+-------------------------------------------------------
+-- Transformation: NKG_ETRF14 -> ETRF97@1999.5 (SE)
+-------------------------------------------------------
+
+INSERT INTO "other_transformation" (
+    auth_name,
+    code,
+    name,
+    description,
+    method_auth_name,
+    method_code,
+    method_name,
+    source_crs_auth_name,
+    source_crs_code,
+    target_crs_auth_name,
+    target_crs_code,
+    accuracy,
+    operation_version,
+    deprecated
+)
+VALUES(
+    'NKG', 'SE_2020_INTRAPLATE',-- object auth+code
+    'ETRF97@2000.0 to ETRF97@1999.5', -- name
+    NULL, -- description
+    'PROJ', 'PROJString',               -- method auth+cod
+    '+proj=deformation +dt=-0.5 +grids=eur_nkg_nkgrf17vel.tif',
+    'EPSG','7928',  -- source_crs:  ETRF97@2000.0
+    'EPSG','4976',  -- target_crs:  SWEREF99
+    0.005,          -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5061',          -- usage auth+code
+    'other_transformation', -- object_table_name
+    'NKG', 'SE_2020_INTRAPLATE', -- object auth+code
+    'EPSG', '1225',         -- extent: Sweden - onshore and offshore
+    'NKG',  'SCOPE_GENERIC' -- scope
+);
+
+INSERT INTO "concatenated_operation" VALUES(
+    'NKG', 'ETRF14_TO_SE', -- operation auth+code
+    'NKG_ETRF14 to SWEREF99', -- name
+    'Transformation from NKG_ETRF14@2000.0 to SWEREF99 (ETRF97@1999.5)', -- description
+    'NKG', 'ETRF14',-- source_crs:  NKG_ETRF00
+    'EPSG','4976',  -- target_crs:  SWEREF99
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+);
+
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ETRF14_TO_SE', 1, 'NKG', 'PAR_2020_SE'),
+    ('NKG', 'ETRF14_TO_SE', 2, 'NKG', 'SE_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5062',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ETRF14_TO_SE',      -- object auth+code
+    'EPSG', '1225',             -- extent: Sweden - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+
+-------------------------------------------------------
+-- Transformation: ITRF2014 -> ETRF97@1999.5 (SE)
+-------------------------------------------------------
+
+INSERT INTO "concatenated_operation"  VALUES (
+    'NKG', 'ITRF2014_TO_SE',  -- operation auth+code
+    'ITRF2014 to ETRS89(SE)', -- name
+    'Time-dependent transformation from ITRF2014 to SWEREF99', -- description
+    'EPSG', '7789', -- source_crs:  ITRF2014
+    'EPSG', '4976', -- target_crs:  SWEREF99
+    0.01,           -- accuracy
+    'NKG 2020',     -- operation_version
+    0               -- deprecated
+
+);
+
+INSERT INTO "concatenated_operation_step" (
+    operation_auth_name, operation_code, step_number, step_auth_name, step_code
+) VALUES
+    ('NKG', 'ITRF2014_TO_SE', 1, 'EPSG', '8366'), -- ITRF2014 -> ETRF2014
+    ('NKG', 'ITRF2014_TO_SE', 2, 'NKG', 'NKG_ETRF14_TO_ETRF2014'),
+    ('NKG', 'ITRF2014_TO_SE', 3, 'NKG', 'PAR_2020_SE'),
+    ('NKG', 'ITRF2014_TO_SE', 4, 'NKG', 'SE_2020_INTRAPLATE')
+;
+
+
+INSERT INTO "usage" VALUES (
+    'NKG', '5063',              -- usage auth+code
+    'concatenated_operation',   -- object_table_name
+    'NKG', 'ITRF2014_TO_SE',    -- object auth+code
+    'EPSG', '1352',             -- extent: Sweden - onshore and offshore
+    'NKG', 'SCOPE_GENERIC'      -- scope auth+code
+);
+
+
+INSERT INTO "supersession" VALUES (
+    'concatenated_operation',
+    'NKG', 'ITRF2000_TO_SE',
+    'concatenated_operation',
+    'NKG', 'ITRF2014_TO_SE',
+    'NKG',
+    0
+);
+
+
diff --git a/data/sql_filelist.cmake b/data/sql_filelist.cmake
index a21e8630..e7bca4ff 100644
--- a/data/sql_filelist.cmake
+++ b/data/sql_filelist.cmake
@@ -35,5 +35,6 @@ set(SQL_FILES
   "${SQL_DIR}/grid_alternatives.sql"
   "${SQL_DIR}/grid_alternatives_generated_noaa.sql"
   "${SQL_DIR}/customizations.sql"
+  "${SQL_DIR}/nkg.sql"
   "${SQL_DIR}/commit.sql"
 )