Mercurial > gemma

diff schema/updates/1461/01.config.sql @ 5423:24156a964eaa marking-single-beam

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
[WIP] Add support for scan marking points in geoserver.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 08 Jul 2021 12:21:55 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1461/01.config.sql	Thu Jul 08 12:21:55 2021 +0200
@@ -0,0 +1,15 @@
+-- GeoServer SQL views without time support
+INSERT INTO sys_admin.published_services (
+    schema, name, srid, key_column, view_def
+) VALUES
+    ('waterway', 'sounding_results_marking_points_geoserver', 4326, NULL, $$
+        SELECT bottleneck_id,
+            to_char(date_info, 'YYYY-MM-DD') AS date_info,
+            height,
+            points,
+            surtyp,
+            zpg_exception
+        FROM waterway.sounding_results_marking_points mp
+            JOIN waterway.sounding_results sr ON sr.id = mp.sounding_result_id
+    $$);
+