Mercurial > gemma

diff schema/geoserver_views.sql @ 4582:51dc19001808 iso-areas

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added geoserver view and named style to match.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 08 Oct 2019 16:13:53 +0200
parents c657dec6b0fa
children 0b01fd83bc3b
line wrap: on
line diff
--- a/schema/geoserver_views.sql	Tue Oct 08 14:29:33 2019 +0200
+++ b/schema/geoserver_views.sql	Tue Oct 08 16:13:53 2019 +0200
@@ -196,3 +196,12 @@
             GROUP BY bottleneck_id) sr ON sr.bottleneck_id = bn.bottleneck_id
     WHERE bn.validity @> current_timestamp
     ORDER BY objnam;
+
+CREATE OR REPLACE VIEW waterway.sounding_results_areas_geoserver AS
+  SELECT
+    bottleneck_id,
+    date_info,
+    height,
+    CAST(areas AS geometry(multipolygon, 4326)) as areas
+  FROM waterway.sounding_results_iso_areas ia
+  JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id;