Implementing the NKG transformations in proj.db

This adds the NKG 2008 and 2020 transformations to proj.db. The NKG
transformations offers transformations between global reference frames
and the national realisations of ETRS89 in Denmark, Estonia, Finland,
Latvia, Lithuania, Norway and Sweden.

The 2008 transformations are already implemented in the NKG 2008 file
but will now be more accessible with the modern API.

The 2020 transformations are new to PROJ and offers and updated version
of the 2008 transformations using a new and improved deformation model
(eu_nkg_nkgrf17vel.tif). A 2020 version of the NKG transformations are
currently not available for Norway but will in all likelyhood be
included at a later point in time.

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"
 )