diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-09-18 11:20:13 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-09-18 11:20:13 +0200 |
| commit | 438ead90d3502f1bf2cb6ed466e75661f33c9445 (patch) | |
| tree | feb3750efa9c76624966ebe0a9a6b4b806cfcfb9 /data/sql/proj_db_table_defs.sql | |
| parent | f22f3028ccdc87818feb0947f61b9b99914ff83a (diff) | |
| parent | 483717e59333f33e758485c104474ca10e0682ec (diff) | |
| download | PROJ-438ead90d3502f1bf2cb6ed466e75661f33c9445.tar.gz PROJ-438ead90d3502f1bf2cb6ed466e75661f33c9445.zip | |
Merge pull request #2859 from rouault/database_anchor
Database: add a 'anchor' field to geodetic_datum and vertical_datum tables
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index f353e4e8..9155fd8f 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -155,6 +155,7 @@ CREATE TABLE geodetic_datum ( publication_date TEXT, --- YYYY-MM-DD format frame_reference_epoch FLOAT, --- only set for dynamic datum, and should be set when it is a dynamic datum ensemble_accuracy FLOAT CHECK (ensemble_accuracy IS NULL OR ensemble_accuracy > 0), --- only for a datum ensemble. and should be set when it is a datum ensemble + anchor TEXT, deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_geodetic_datum PRIMARY KEY (auth_name, code), CONSTRAINT fk_geodetic_datum_ellipsoid FOREIGN KEY (ellipsoid_auth_name, ellipsoid_code) REFERENCES ellipsoid(auth_name, code), @@ -191,6 +192,7 @@ CREATE TABLE vertical_datum ( publication_date TEXT CHECK (NULL OR length(publication_date) = 10), --- YYYY-MM-DD format frame_reference_epoch FLOAT, --- only set for dynamic datum, and should be set when it is a dynamic datum ensemble_accuracy FLOAT CHECK (ensemble_accuracy IS NULL OR ensemble_accuracy > 0), --- only for a datum ensemble. and should be set when it is a datum ensemble + anchor TEXT, deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_vertical_datum PRIMARY KEY (auth_name, code) ) WITHOUT ROWID; @@ -247,7 +249,7 @@ CREATE TABLE geodetic_crs( code INTEGER_OR_TEXT NOT NULL CHECK (length(code) >= 1), name TEXT NOT NULL CHECK (length(name) >= 2), description TEXT, - type TEXT NOT NULL CHECK (type IN ('geographic 2D', 'geographic 3D', 'geocentric')), + type TEXT NOT NULL CHECK (type IN ('geographic 2D', 'geographic 3D', 'geocentric', 'other')), coordinate_system_auth_name TEXT, coordinate_system_code INTEGER_OR_TEXT, datum_auth_name TEXT, |