# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1570027414 -7200
# Node ID f7b57136c8007818c671eecbaf896efc8ae5b938
# Parent  81b0f1cf2d41e7fe669f42b6ffdbd4e34ed3b7d5
Added table to to store iso areas of sounding results.

diff -r 81b0f1cf2d41 -r f7b57136c800 schema/gemma.sql
--- a/schema/gemma.sql	Wed Oct 02 16:27:07 2019 +0200
+++ b/schema/gemma.sql	Wed Oct 02 16:43:34 2019 +0200
@@ -699,6 +699,16 @@
             -- CHECK(ST_IsSimple(CAST(lines AS geometry))),
         PRIMARY KEY (sounding_result_id, height)
     )
+
+    CREATE TABLE sounding_results_iso_areas (
+        sounding_result_id int NOT NULL REFERENCES sounding_results
+            ON DELETE CASCADE,
+        height numeric NOT NULL,
+        areas geography(MULTIPOLYGON, 4326) NOT NULL,
+        -- TODO: generate valid simple features and add constraint:
+            -- CHECK(ST_IsSimple(CAST(areas AS geometry))),
+        PRIMARY KEY (sounding_result_id, height)
+    )
     --
     -- Fairway availability
     --
diff -r 81b0f1cf2d41 -r f7b57136c800 schema/version.sql
--- a/schema/version.sql	Wed Oct 02 16:27:07 2019 +0200
+++ b/schema/version.sql	Wed Oct 02 16:43:34 2019 +0200
@@ -1,1 +1,1 @@
-INSERT INTO gemma_schema_version(version) VALUES (1203);
+INSERT INTO gemma_schema_version(version) VALUES (1204);