diff options
| author | Sveinung Himle <56073535+himsve@users.noreply.github.com> | 2021-03-11 10:48:49 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-03-11 10:48:49 +0100 |
| commit | 763939849bd8e079a6ed73d8f6ef0be0286e99d5 (patch) | |
| tree | 6f9c30f372d3aebda516e0fbf9ceaccbf3d49d42 /data/sql/proj_db_table_defs.sql | |
| parent | b2d8e255daa523335f91161ed51ab98fc9ac75a8 (diff) | |
| download | PROJ-763939849bd8e079a6ed73d8f6ef0be0286e99d5.tar.gz PROJ-763939849bd8e079a6ed73d8f6ef0be0286e99d5.zip | |
Database: Additions to the norwegian NKG2020 transformation (#2548)
* 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
Co-authored-by: Even Rouault <even.rouault@spatialys.com>
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index b879cab8..037e2b6d 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -1089,7 +1089,7 @@ CREATE TABLE grid_alternatives( proj_grid_name TEXT NOT NULL, -- PROJ >= 7 grid name (e.g us_nga_egm08_25.tif) old_proj_grid_name TEXT, -- PROJ < 7 grid name (e.g egm08_25.gtx) proj_grid_format TEXT NOT NULL, -- 'GTiff', 'GTX', 'NTv2', JSON - proj_method TEXT NOT NULL, -- hgridshift, vgridshift, geoid_like, geocentricoffset or tinshift + proj_method TEXT NOT NULL, -- hgridshift, vgridshift, geoid_like, geocentricoffset, tinshift or velocity_grid inverse_direction BOOLEAN NOT NULL CHECK (inverse_direction IN (0, 1)), -- whether the PROJ grid direction is reversed w.r.t to the authority one (TRUE in that case) package_name TEXT, -- no longer used. Must be NULL url TEXT, -- optional URL where to download the PROJ grid @@ -1099,7 +1099,7 @@ CREATE TABLE grid_alternatives( CONSTRAINT fk_grid_alternatives_grid_packages FOREIGN KEY (package_name) REFERENCES grid_packages(package_name), CONSTRAINT check_grid_alternatives_grid_fromat CHECK (proj_grid_format IN ('GTiff', 'GTX', 'NTv2', 'JSON')), - CONSTRAINT check_grid_alternatives_proj_method CHECK (proj_method IN ('hgridshift', 'vgridshift', 'geoid_like', 'geocentricoffset', 'tinshift')), + CONSTRAINT check_grid_alternatives_proj_method CHECK (proj_method IN ('hgridshift', 'vgridshift', 'geoid_like', 'geocentricoffset', 'tinshift', 'velocity_grid')), CONSTRAINT check_grid_alternatives_inverse_direction CHECK (NOT(proj_method = 'geoid_like' AND inverse_direction = 1)), CONSTRAINT check_grid_alternatives_package_name CHECK (package_name IS NULL), CONSTRAINT check_grid_alternatives_direct_download_url CHECK (NOT(direct_download IS NULL AND url IS NOT NULL)), |