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 | |
| parent | 763939849bd8e079a6ed73d8f6ef0be0286e99d5 (diff) | |
| download | PROJ-e10a849cd01c5b15e3123da1f6df845006322843.tar.gz PROJ-e10a849cd01c5b15e3123da1f6df845006322843.zip | |
Database: fix NKG transformations
Diffstat (limited to 'data')
| -rw-r--r-- | data/Makefile.am | 1 | ||||
| -rw-r--r-- | data/sql/nkg.sql | 13 | ||||
| -rw-r--r-- | data/sql/nkg_post_customizations.sql | 13 | ||||
| -rw-r--r-- | data/sql_filelist.cmake | 3 |
4 files changed, 16 insertions, 14 deletions
diff --git a/data/Makefile.am b/data/Makefile.am index 762f902d..b9073bfc 100644 --- a/data/Makefile.am +++ b/data/Makefile.am @@ -43,6 +43,7 @@ SQL_ORDERED_LIST = sql/begin.sql \ sql/grid_alternatives.sql \ sql/grid_alternatives_generated_noaa.sql \ sql/customizations.sql \ + sql/nkg_post_customizations.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 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'); diff --git a/data/sql_filelist.cmake b/data/sql_filelist.cmake index b683a892..2103e19e 100644 --- a/data/sql_filelist.cmake +++ b/data/sql_filelist.cmake @@ -35,6 +35,7 @@ set(SQL_FILES "${SQL_DIR}/nkg.sql" "${SQL_DIR}/grid_alternatives.sql" "${SQL_DIR}/grid_alternatives_generated_noaa.sql" - "${SQL_DIR}/customizations.sql" + "${SQL_DIR}/customizations.sql" + "${SQL_DIR}/nkg_post_customizations.sql" "${SQL_DIR}/commit.sql" ) |