# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1538065975 -7200
# Node ID d32516051d082d0bd65beb6781740401bb6540a4
# Parent  d025e1f5e71ddb3d3842255e4dca2c051e66e3b4
Add view to help geoserver serve contour lines

diff -r d025e1f5e71d -r d32516051d08 schema/gemma.sql
--- a/schema/gemma.sql	Thu Sep 27 17:58:56 2018 +0200
+++ b/schema/gemma.sql	Thu Sep 27 18:32:55 2018 +0200
@@ -418,6 +418,17 @@
         lines geography(multilinestringz, 4326) NOT NULL,
         UNIQUE (sounding_result_id, height)
     )
+    -- A view to help geoserver serve contour lines.
+    -- At least geoserver-2.13.2 does not serve type geography correctly
+    CREATE VIEW waterway.sounding_results_contour_lines_geoserver AS
+        SELECT bottleneck_id,
+                date_info,
+                height,
+                CAST(lines AS geometry(multilinestringz, 4326)) AS lines
+            FROM waterway.sounding_results_contour_lines cl
+                JOIN waterway.sounding_results sr
+                    ON sr.id = cl.sounding_result_id
+
     --
     -- Fairway availability
     --