Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/SedimentLoadDataFactory.java @ 8259:1fc453fbc5df
Measurement stations without range should not be used in calculation and we assume the beginning of the range is the station.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 11 Sep 2014 16:12:39 +0200 |
| parents | 25c3a62863d2 |
| children | 17db08570637 |
comparison
equal
deleted
inserted
replaced
| 8258:155a886ab19b | 8259:1fc453fbc5df |
|---|---|
| 53 "sqti.stop_time AS sq_stop_time, " + | 53 "sqti.stop_time AS sq_stop_time, " + |
| 54 "sqti.id AS sq_ti_id, " + | 54 "sqti.id AS sq_ti_id, " + |
| 55 "slv.value AS slv_value, " + | 55 "slv.value AS slv_value, " + |
| 56 "gf.name AS gf_name, " + | 56 "gf.name AS gf_name, " + |
| 57 "ms.id AS ms_id, " + | 57 "ms.id AS ms_id, " + |
| 58 "ms.station AS ms_station, " + | 58 "rs.a AS ms_station, " + |
| 59 "ms.measurement_type AS ms_type " + | 59 "ms.measurement_type AS ms_type " + |
| 60 "FROM load_at_river sl " + | 60 "FROM load_at_river sl " + |
| 61 "CROSS JOIN measurement_station ms " + | 61 "CROSS JOIN measurement_station ms " + |
| 62 "JOIN ranges rs ON ms.range_id = rs.id " + | |
| 62 "JOIN time_intervals ti ON sl.time_interval_id = ti.id " + | 63 "JOIN time_intervals ti ON sl.time_interval_id = ti.id " + |
| 63 "LEFT JOIN time_intervals sqti ON sl.sq_time_interval_id = sqti.id " + | 64 "LEFT JOIN time_intervals sqti ON sl.sq_time_interval_id = sqti.id " + |
| 64 "JOIN grain_fraction gf ON sl.grain_fraction_id = gf.id " + | 65 "JOIN grain_fraction gf ON sl.grain_fraction_id = gf.id " + |
| 65 "JOIN rivers r ON ms.river_id = r.id " + | 66 "JOIN rivers r ON ms.river_id = r.id " + |
| 66 "LEFT JOIN sediment_load_values slv " + | 67 "LEFT JOIN sediment_load_values slv " + |