Mercurial > gemma
changeset 731:4d6329afc1ea
Added table for contour lines of sounding results.
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Sun, 23 Sep 2018 16:01:04 +0200 |
parents | 4c05bdbf8e4b |
children | 39b5cf9a6b8f |
files | schema/gemma.sql |
diffstat | 1 files changed, 7 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Sat Sep 22 22:23:21 2018 +0200 +++ b/schema/gemma.sql Sun Sep 23 16:01:04 2018 +0200 @@ -411,6 +411,13 @@ checksum varchar NOT NULL, octree_index bytea NOT NULL ) + + CREATE TABLE sounding_results_contour_lines ( + sounding_result_id int NOT NULL UNIQUE REFERENCES sounding_results, + height numeric NOT NULL, + lines geography(multilinestringz, 4326) NOT NULL, + UNIQUE (sounding_result_id, height) + ) -- -- Fairway availability --