Mercurial > gemma

diff schema/geoserver_views.sql @ 3307:b90b17d0b5a9 sections-backend

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added sections_geoserver view, renamed stretch column to section in schema
author Markus Kottlaender <markus@intevation.de>
date Fri, 17 May 2019 11:28:20 +0200
parents ec6163c6687d
children 3e7a670896bd
line wrap: on
line diff
--- a/schema/geoserver_views.sql	Fri May 17 10:03:07 2019 +0200
+++ b/schema/geoserver_views.sql	Fri May 17 11:28:20 2019 +0200
@@ -100,6 +100,20 @@
         staging_done
     FROM waterway.stretches;
 
+CREATE OR REPLACE VIEW waterway.sections_geoserver AS
+    SELECT
+        id,
+        name,
+        (section).lower::varchar as lower,
+        (section).upper::varchar as upper,
+        area::Geometry(MULTIPOLYGON, 4326),
+        objnam,
+        nobjnam,
+        date_info,
+        source_organization,
+        staging_done
+    FROM waterway.sections;
+
 CREATE OR REPLACE VIEW waterway.sounding_results_contour_lines_geoserver AS
     SELECT bottleneck_id,
         date_info,