diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-01-23 19:04:31 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-01-23 19:04:31 +0100 |
| commit | 1ca02b5659bced7036f345803a1c981c5ced9690 (patch) | |
| tree | 6a49b1132015c17cb5caae47ac9235240bfd0b12 /data/sql/proj_db_table_defs.sql | |
| parent | ef20438a3af9a507806eefdeae69ce0914847c70 (diff) | |
| parent | 00dd98457af1f32e7bb2b9677f6319f72fcfacf9 (diff) | |
| download | PROJ-1ca02b5659bced7036f345803a1c981c5ced9690.tar.gz PROJ-1ca02b5659bced7036f345803a1c981c5ced9690.zip | |
Merge pull request #1869 from rouault/update_to_epsg_9_8_6
Database: update to EPSG v9.8.6
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index 50b5e4ae..59cef3bc 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -65,8 +65,7 @@ CREATE TABLE area( east_lon FLOAT CHECK (east_lon BETWEEN -180 AND 180), deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_area PRIMARY KEY (auth_name, code), - CONSTRAINT check_area_lat CHECK (south_lat <= north_lat), - CONSTRAINT check_area_lon CHECK (west_lon <= east_lon OR (east_lon + 360 - west_lon <= 200)) + CONSTRAINT check_area_lat CHECK (south_lat <= north_lat) ); CREATE TABLE prime_meridian( @@ -1093,7 +1092,7 @@ CREATE TABLE grid_alternatives( original_grid_name TEXT NOT NULL PRIMARY KEY, -- original grid name (e.g. Und_min2.5x2.5_egm2008_isw=82_WGS84_TideFree.gz). For LOS/LAS format, the .las files proj_grid_name TEXT NOT NULL, -- PROJ grid name (e.g egm08_25.gtx) proj_grid_format TEXT NOT NULL, -- one of 'CTable2', 'NTv1', 'NTv2', 'GTX' - proj_method TEXT NOT NULL, -- hgridshift or vgridshift + proj_method TEXT NOT NULL, -- hgridshift, vgridshift or geoid_like 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, -- package name that contains the file url TEXT, -- optional URL where to download the PROJ grid @@ -1103,10 +1102,10 @@ 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 ('CTable2', 'NTv1', 'NTv2', 'GTX')), - CONSTRAINT check_grid_alternatives_proj_method CHECK (proj_method IN ('hgridshift', 'vgridshift')), + CONSTRAINT check_grid_alternatives_proj_method CHECK (proj_method IN ('hgridshift', 'vgridshift', 'geoid_like')), CONSTRAINT check_grid_alternatives_not_hgridshift CHECK (NOT(proj_method != 'hgridshift' AND proj_grid_format IN ('CTable2', 'NTv1', 'NTv2'))), - CONSTRAINT check_grid_alternatives_not_vgridshift CHECK (NOT(proj_method != 'vgridshift' AND proj_grid_format IN ('GTX'))), - CONSTRAINT check_grid_alternatives_original_grid_name CHECK (NOT(original_grid_name = proj_grid_name AND inverse_direction != 0)), + CONSTRAINT check_grid_alternatives_not_vgridshift CHECK (NOT(proj_method = 'hgridshift' AND proj_grid_format IN ('GTX'))), + CONSTRAINT check_grid_alternatives_inverse_direction CHECK (NOT(proj_method = 'geoid_like' AND inverse_direction = 1)), CONSTRAINT check_grid_alternatives_package_name_url CHECK (NOT(package_name IS NOT NULL AND url IS NOT NULL)), CONSTRAINT check_grid_alternatives_direct_download_url CHECK (NOT(direct_download IS NULL AND url IS NOT NULL)), CONSTRAINT check_grid_alternatives_open_license_url CHECK (NOT(open_license IS NULL AND url IS NOT NULL)) |