Mercurial > gemma

diff schema/geoserver_views.sql @ 3278:831193935739

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Avoid storing of NtS messages other than water level
author Tom Gottfried <tom@intevation.de>
date Wed, 15 May 2019 19:42:21 +0200
parents 232fc90e6ee2
children ec6163c6687d
line wrap: on
line diff
--- a/schema/geoserver_views.sql	Wed May 15 19:08:49 2019 +0200
+++ b/schema/geoserver_views.sql	Wed May 15 19:42:21 2019 +0200
@@ -46,7 +46,6 @@
     waterlevel_latest AS (
         SELECT DISTINCT ON (fk_gauge_id) fk_gauge_id, water_level
             FROM waterway.gauge_measurements
-            WHERE is_waterlevel
             ORDER BY fk_gauge_id, measure_date DESC)
     SELECT
         b.id,