Mercurial > gemma
diff schema/gemma.sql @ 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 | aeaa2adf5a8b |
children | 34ea9d5df653 |
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 --