diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-03-11 16:12:30 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2021-03-11 16:12:30 +0100 |
| commit | e10a849cd01c5b15e3123da1f6df845006322843 (patch) | |
| tree | af9a7342e034ee9c4cbb4a97df750d6a82862efa /data/sql | |
| parent | 763939849bd8e079a6ed73d8f6ef0be0286e99d5 (diff) | |
| download | PROJ-e10a849cd01c5b15e3123da1f6df845006322843.tar.gz PROJ-e10a849cd01c5b15e3123da1f6df845006322843.zip | |
Database: fix NKG transformations
Diffstat (limited to 'data/sql')
| -rw-r--r-- | data/sql/nkg.sql | 13 | ||||
| -rw-r--r-- | data/sql/nkg_post_customizations.sql | 13 |
2 files changed, 13 insertions, 13 deletions
diff --git a/data/sql/nkg.sql b/data/sql/nkg.sql index 56b46206..69a00603 100644 --- a/data/sql/nkg.sql +++ b/data/sql/nkg.sql @@ -2,19 +2,6 @@ INSERT INTO "metadata" VALUES('NKG.SOURCE', 'https://github.com/NordicGeodesy/No 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 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'); |
