# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1570537773 -7200
# Node ID 01ea1e547c289d518578d8c061dfa7b8eb34b0f4
# Parent  02cf2b4be955a0edffd32825f64d7155d39ab2a5
Added geoserver view for areas.

diff -r 02cf2b4be955 -r 01ea1e547c28 schema/updates/1204/03.geoserver-views.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1204/03.geoserver-views.sql	Tue Oct 08 14:29:33 2019 +0200
@@ -0,0 +1,9 @@
+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;
+
+GRANT SELECT ON ALL TABLES IN SCHEMA public, users, waterway TO waterway_user;