diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-10-11 19:50:09 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-10-11 19:50:09 +0200 |
| commit | ad80dc88a70032e1d96812b574b2d4d22e223394 (patch) | |
| tree | be61efbce545fc2940861e218e2e1f448f1bb66f /data/sql/proj_db_table_defs.sql | |
| parent | acd1cf3278a532b56f3f621e27a8895b3db3cb75 (diff) | |
| download | PROJ-ad80dc88a70032e1d96812b574b2d4d22e223394.tar.gz PROJ-ad80dc88a70032e1d96812b574b2d4d22e223394.zip | |
Database: add a frame_reference_epoch column in vertical_datum to be able to handle dynamic vertical datums, and instanciate them properly from database
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index 1862429a..60a12209 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -181,6 +181,7 @@ CREATE TABLE vertical_datum ( name TEXT NOT NULL CHECK (length(name) >= 2), description TEXT, 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 deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_vertical_datum PRIMARY KEY (auth_name, code) |