Mercurial > gemma

comparison pkg/controllers/surveys.go @ 5406:6d73836bc2fb marking-single-beam

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
quick fix of typo
author Thomas Junk <thomas.junk@intevation.de>
date Tue, 06 Jul 2021 14:26:02 +0200
parents 5e7fca6ef935
children d45d5fafdc5b
comparison
equal deleted inserted replaced
5405:5e7fca6ef935 5406:6d73836bc2fb
32 s.bottleneck_id, 32 s.bottleneck_id,
33 s.date_info::text, 33 s.date_info::text,
34 s.depth_reference, 34 s.depth_reference,
35 COALESCE(g.objname, 'ERROR: MISSING GAUGE') AS gauge_objname, 35 COALESCE(g.objname, 'ERROR: MISSING GAUGE') AS gauge_objname,
36 r.value AS waterlevel_value, 36 r.value AS waterlevel_value,
37 COALESCE(s.surtype, 'ERROR: MISSING SURVEY TYPE) AS surtype 37 COALESCE(s.surtyp, 'ERROR: MISSING SURVEY TYPE') AS surtype
38 FROM waterway.bottlenecks AS b 38 FROM waterway.bottlenecks AS b
39 JOIN waterway.sounding_results AS s ON b.bottleneck_id = s.bottleneck_id 39 JOIN waterway.sounding_results AS s ON b.bottleneck_id = s.bottleneck_id
40 LEFT JOIN waterway.gauges AS g 40 LEFT JOIN waterway.gauges AS g
41 ON b.gauge_location = g.location AND s.date_info::timestamptz <@ g.validity 41 ON b.gauge_location = g.location AND s.date_info::timestamptz <@ g.validity
42 LEFT JOIN waterway.gauges_reference_water_levels AS r 42 LEFT JOIN waterway.gauges_reference_water_levels AS r