Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
3277:232fc90e6ee2 3278:831193935739
44 FROM waterway.fairway_availability 44 FROM waterway.fairway_availability
45 ORDER BY bottleneck_id, date_info DESC), 45 ORDER BY bottleneck_id, date_info DESC),
46 waterlevel_latest AS ( 46 waterlevel_latest AS (
47 SELECT DISTINCT ON (fk_gauge_id) fk_gauge_id, water_level 47 SELECT DISTINCT ON (fk_gauge_id) fk_gauge_id, water_level
48 FROM waterway.gauge_measurements 48 FROM waterway.gauge_measurements
49 WHERE is_waterlevel
50 ORDER BY fk_gauge_id, measure_date DESC) 49 ORDER BY fk_gauge_id, measure_date DESC)
51 SELECT 50 SELECT
52 b.id, 51 b.id,
53 b.bottleneck_id, 52 b.bottleneck_id,
54 b.objnam, 53 b.objnam,