Mercurial > gemma
comparison pkg/controllers/surveys.go @ 3645:02951a62e8c6
'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{}, |