diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2019-11-18 22:33:48 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2019-11-18 22:41:24 +0100 |
| commit | df339795a8af5487cbff234083a8151c1b3eb181 (patch) | |
| tree | a5e1a8ee5cdadc9eedff51470b02b04c6d4e7fab /data/sql/proj_db_table_defs.sql | |
| parent | b063035618a00218daed43260750ee4e60d5c84e (diff) | |
| download | PROJ-df339795a8af5487cbff234083a8151c1b3eb181.tar.gz PROJ-df339795a8af5487cbff234083a8151c1b3eb181.zip | |
Database: add a publication_date column to geodetic_datum and vertical_datum
Populated from realization_epoch column from EPSG
The 'publication_date' naming is from OGC Topic 2, and hasn't been yet adopted
by the EPSG dataset.
See http://docs.opengeospatial.org/as/18-005r4/18-005r4.html , Annex G, clause 11
and https://32zn56499nov99m251h4e9t8-wpengine.netdna-ssl.com/wp-content/uploads/2019/09/EPSG-relational-data-model-changes_2019-09-18.pdf
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index ee91aa3d..ad71c4af 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -108,6 +108,7 @@ CREATE TABLE geodetic_datum ( prime_meridian_code TEXT NOT NULL, area_of_use_auth_name TEXT NOT NULL, area_of_use_code TEXT NOT NULL, + publication_date TEXT, --- YYYY-MM-DD format 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), @@ -134,6 +135,7 @@ CREATE TABLE vertical_datum ( scope TEXT, area_of_use_auth_name TEXT NOT NULL, area_of_use_code TEXT NOT NULL, + publication_date TEXT CHECK (NULL OR length(publication_date) = 10), --- YYYY-MM-DD format deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_vertical_datum PRIMARY KEY (auth_name, code), CONSTRAINT fk_vertical_datum_area FOREIGN KEY (area_of_use_auth_name, area_of_use_code) REFERENCES area(auth_name, code) |