diff options
| author | Even Rouault <even.rouault@mines-paris.org> | 2019-03-26 12:07:47 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-03-26 12:07:47 +0100 |
| commit | 1e575f4e18ac35c382207bbc7b732aa9f0d30d5e (patch) | |
| tree | e48481b5800f2363791b8ff35ab572d7c9b5cc4c /data/sql/proj_db_table_defs.sql | |
| parent | d21fb4e9abd3246fcbece6724dd3d014c35df25e (diff) | |
| parent | ed0636425083034b55633402108b85bc765ae0eb (diff) | |
| download | PROJ-1e575f4e18ac35c382207bbc7b732aa9f0d30d5e.tar.gz PROJ-1e575f4e18ac35c382207bbc7b732aa9f0d30d5e.zip | |
Merge pull request #1368 from rouault/epsg_961_and_operationversion
Database: update to EPSG v9.6.1, IGNF v3.0.3, ESRI 10.7.0 and add operation_version column
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index d403f0eb..b7dcad89 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -558,6 +558,8 @@ CREATE TABLE helmert_transformation( pivot_uom_auth_name TEXT, pivot_uom_code TEXT, + operation_version TEXT, -- normally mandatory in OGC Topic 2 but optional here + deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_helmert_transformation PRIMARY KEY (auth_name, code), @@ -634,6 +636,8 @@ CREATE TABLE grid_transformation( interpolation_crs_auth_name TEXT, interpolation_crs_code TEXT, + operation_version TEXT, -- normally mandatory in OGC Topic 2 but optional here + deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_grid_transformation PRIMARY KEY (auth_name, code), @@ -790,6 +794,8 @@ CREATE TABLE other_transformation( param7_uom_auth_name TEXT, param7_uom_code TEXT, + operation_version TEXT, -- normally mandatory in OGC Topic 2 but optional here + deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_other_transformation PRIMARY KEY (auth_name, code), @@ -852,6 +858,8 @@ CREATE TABLE concatenated_operation( step3_auth_name TEXT, step3_code TEXT, + operation_version TEXT, -- normally mandatory in OGC Topic 2 but optional here + deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_concatenated_operation PRIMARY KEY (auth_name, code), |