Mercurial > gemma

comparison pkg/controllers/surveys.go @ 3645:02951a62e8c6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
'Historicise' bottlenecks on import
author Tom Gottfried <tom@intevation.de>
date Wed, 12 Jun 2019 17:11:15 +0200
parents ec6163c6687d
children 2a079d0a71c1
comparison
equal deleted inserted replaced
3644:9e91b416d5bb 3645:02951a62e8c6
34 FROM waterway.bottlenecks AS b 34 FROM waterway.bottlenecks AS b
35 JOIN waterway.gauges AS g 35 JOIN waterway.gauges AS g
36 ON b.gauge_location = g.location AND b.gauge_validity = g.validity 36 ON b.gauge_location = g.location AND b.gauge_validity = g.validity
37 JOIN waterway.sounding_results AS s ON b.id = s.bottleneck_id 37 JOIN waterway.sounding_results AS s ON b.id = s.bottleneck_id
38 LEFT JOIN waterway.gauges_reference_water_levels AS r 38 LEFT JOIN waterway.gauges_reference_water_levels AS r
39 USING (depth_reference, location, validity) 39 ON s.depth_reference = r.depth_reference
40 AND g.location = r.location AND g.validity = r.validity
40 WHERE b.objnam = $1` 41 WHERE b.objnam = $1`
41 ) 42 )
42 43
43 func listSurveys( 44 func listSurveys(
44 _ interface{}, 45 _ interface{},