diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-01-22 22:09:26 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-01-22 22:31:44 +0100 |
| commit | ffcd6253bb6b275cfc8884eeb88aa2eeac75e3b6 (patch) | |
| tree | cd279a62afef8567235ee6ad37ff1d38c75db7b8 /data/sql/proj_db_table_defs.sql | |
| parent | db31b6dfa9c8fe37d5706d95ce81012b8db3c3b9 (diff) | |
| download | PROJ-ffcd6253bb6b275cfc8884eeb88aa2eeac75e3b6.tar.gz PROJ-ffcd6253bb6b275cfc8884eeb88aa2eeac75e3b6.zip | |
Database: update to EPSG v9.8.6
Fixes #1867
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index 50b5e4ae..14e0c789 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( @@ -1106,7 +1105,6 @@ CREATE TABLE grid_alternatives( CONSTRAINT check_grid_alternatives_proj_method CHECK (proj_method IN ('hgridshift', 'vgridshift')), 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_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)) |