From eeb9fef28aed4f7e5d62d8c5064f96e1090ee348 Mon Sep 17 00:00:00 2001
From: Sveinung Himle <56073535+himsve@users.noreply.github.com>
Date: Thu, 11 Mar 2021 10:48:49 +0100
Subject: Database: Additions to the norwegian NKG2020 transformation (#2548),
 and NGO48 to ETRS89 TIN transfrm (#2554)

* Correction grid NKG:ETRF14 to EPSG:7922

* Added NKG:ITRF_TO_NO GIE test

* Correction grid no_kv_NKGETRF14_EPSG7922_2000 added to grid_alternatives.sql

* proj_method 'velocity_grid' added in check_grid_alternatives_proj_method. NKG velocity grid added to grid_alternatives.sql

* also include follow-up fix to master #2548: e10a849cd01c5b15e3123da1f6df845006322843

* Add NGO48 (EPSG:4273) to ETRS89 (EPSG:4258) triangulation-based transformation (#2554)

Co-authored-by: Even Rouault <even.rouault@spatialys.com>
---
 data/sql/nkg_post_customizations.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 data/sql/nkg_post_customizations.sql

(limited to 'data/sql/nkg_post_customizations.sql')

diff --git a/data/sql/nkg_post_customizations.sql b/data/sql/nkg_post_customizations.sql
new file mode 100644
index 00000000..68bf0dbf
--- /dev/null
+++ b/data/sql/nkg_post_customizations.sql
@@ -0,0 +1,13 @@
+
+-- 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');
-- 
cgit v1.2.3

