aboutsummaryrefslogtreecommitdiff
path: root/data/sql/nkg_post_customizations.sql
diff options
context:
space:
mode:
authorSveinung Himle <56073535+himsve@users.noreply.github.com>2021-03-11 10:48:49 +0100
committerEven Rouault <even.rouault@spatialys.com>2021-03-23 15:52:34 +0100
commiteeb9fef28aed4f7e5d62d8c5064f96e1090ee348 (patch)
tree651ff0432c1be5325458cb3176f32cdd8474c65d /data/sql/nkg_post_customizations.sql
parent8e9239cfe4045a638d0f9e018cdb7d3f3f9622a5 (diff)
downloadPROJ-eeb9fef28aed4f7e5d62d8c5064f96e1090ee348.tar.gz
PROJ-eeb9fef28aed4f7e5d62d8c5064f96e1090ee348.zip
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>
Diffstat (limited to 'data/sql/nkg_post_customizations.sql')
-rw-r--r--data/sql/nkg_post_customizations.sql13
1 files changed, 13 insertions, 0 deletions
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');