aboutsummaryrefslogtreecommitdiff
path: root/data/sql/nkg_post_customizations.sql
diff options
context:
space:
mode:
authorKristian Evers <kristianevers@gmail.com>2021-03-23 21:06:52 +0100
committerGitHub <noreply@github.com>2021-03-23 21:06:52 +0100
commit03b5f40edf0fe5716f8ff72ae7db992b1786990b (patch)
treec38d1a29f665915b6e437695e3628ddcb1cef478 /data/sql/nkg_post_customizations.sql
parent9a7ee56058d1d01a35acc37b622430601401aa3f (diff)
parenteeb9fef28aed4f7e5d62d8c5064f96e1090ee348 (diff)
downloadPROJ-03b5f40edf0fe5716f8ff72ae7db992b1786990b.tar.gz
PROJ-03b5f40edf0fe5716f8ff72ae7db992b1786990b.zip
Merge pull request #2600 from rouault/backport_2548
[Backport 8.0] Database: Additions to the norwegian NKG2020 transformation (#2548), …
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');