Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/model/sinfo/CollisionAggregateValue.java @ 9160:38e8febd11b6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added methods to select collision values and collision counts
author mschaefer
date Tue, 19 Jun 2018 14:24:41 +0200
parents 8d4e7e08dbc0
children
rev   line source
9117
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
1 /* Copyright (C) 2017 by Bundesanstalt für Gewässerkunde
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
2 * Software engineering by
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
3 * Björnsen Beratende Ingenieure GmbH
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
4 * Dr. Schumacher Ingenieurbüro für Wasser und Umwelt
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
5 *
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
6 * This file is Free Software under the GNU AGPL (>=v3)
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
7 * and comes with ABSOLUTELY NO WARRANTY! Check out the
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
8 * documentation coming with Dive4Elements River for details.
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
9 */
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
10
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
11 package org.dive4elements.river.model.sinfo;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
12
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
13 import java.io.Serializable;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
14 import java.util.ArrayList;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
15 import java.util.Date;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
16 import java.util.List;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
17
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
18 import org.dive4elements.river.backend.SessionHolder;
9160
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
19 import org.dive4elements.river.backend.utils.DateUtil;
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
20 import org.dive4elements.river.model.River;
9117
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
21 import org.hibernate.SQLQuery;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
22 import org.hibernate.Session;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
23 import org.hibernate.type.StandardBasicTypes;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
24
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
25
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
26 /**
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
27 * Aggregation of collision_values
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
28 *
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
29 * @author Matthias Schäfer
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
30 *
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
31 */
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
32 public class CollisionAggregateValue implements Serializable {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
33
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
34 /***** FIELDS *****/
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
35
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
36 private static final long serialVersionUID = 1;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
37
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
38 private Collision parent;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
39
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
40 private double station;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
41
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
42 // private CollisionType collisionType;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
43
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
44 private Date minDate;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
45
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
46 private Date maxDate;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
47
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
48 private int count;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
49
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
50 private double gaugeW;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
51
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
52
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
53 /***** CONSTRUCTORS *****/
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
54
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
55 public CollisionAggregateValue() {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
56 }
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
57
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
58 public CollisionAggregateValue(final Collision collision, final double station, final Date minDate, final Date maxDate, final int count,
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
59 final double gaugeW) {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
60 this.parent = collision;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
61 this.station = station;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
62 // this.collisionType = collisionType;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
63 this.minDate = minDate;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
64 this.maxDate = maxDate;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
65 this.count = count;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
66 this.gaugeW = gaugeW;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
67 }
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
68
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
69
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
70 /***** METHODS *****/
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
71
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
72 public int getCount() {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
73 return this.count;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
74 }
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
75
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
76 public Collision getCollision() {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
77 return this.parent;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
78 }
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
79
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
80 public double getStation() {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
81 return this.station;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
82 }
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
83
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
84 // public CollisionType getCollisionType() {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
85 // return this.collisionType;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
86 // }
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
87
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
88 public Date getMinDate() {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
89 return this.minDate;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
90 }
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
91
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
92 public Date getMaxDate() {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
93 return this.maxDate;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
94 }
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
95
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
96 public Double getGaugeW() {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
97 return this.gaugeW;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
98 }
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
99
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
100 /**
9160
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
101 * Selects from the database the collision aggregate values of a data series in a km range
9117
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
102 */
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
103 public static List<CollisionAggregateValue> getValuesByKm(final Collision parent, final double kmLo, final double kmHi) {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
104 final Session session = SessionHolder.HOLDER.get();
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
105 final SQLQuery query = session.createSQLQuery("SELECT FLOOR(station+0.4999) AS station, COUNT(*) AS count,"
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
106 + " MIN(event_date) AS date_min, MAX(event_date) AS date_max,"
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
107 + " AVG(gauge_w) AS gauge_w"
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
108 + " FROM collision_values v INNER JOIN collision s ON v.collision_id=s.id"
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
109 + " WHERE (collision_id=:parent)"
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
110 + " AND (station BETWEEN (:kmLo - 0.0001) AND (:kmHi + 0.0001))"
9160
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
111 + " GROUP BY FLOOR(station+0.4999)"
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
112 + " ORDER BY FLOOR(station+0.4999)")
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
113 .addScalar("station", StandardBasicTypes.DOUBLE).addScalar("count", StandardBasicTypes.INTEGER)
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
114 .addScalar("date_min", StandardBasicTypes.DATE).addScalar("date_max", StandardBasicTypes.DATE)
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
115 .addScalar("gauge_w", StandardBasicTypes.DOUBLE);
9117
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
116 query.setInteger("parent", parent.getId());
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
117 query.setDouble("kmLo", new Double(kmLo));
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
118 query.setDouble("kmHi", new Double(kmHi));
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
119 final List<CollisionAggregateValue> values = new ArrayList();
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
120 final List<Object[]> rows = query.list();
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
121 if (rows != null) {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
122 for (int i = 0; i <= rows.size() - 1; i++) {
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
123 values.add(new CollisionAggregateValue(parent, (double) rows.get(i)[0], (Date) rows.get(i)[2], (Date) rows.get(i)[3],
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
124 (int) rows.get(i)[1], (double) rows.get(i)[4]));
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
125 }
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
126 }
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
127 return values;
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
128 }
9160
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
129
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
130 /**
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
131 * Selects from the database the collision aggregate values of a km range of a river and a range of years
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
132 */
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
133 public static List<CollisionAggregateValue> getValuesByKm(final River river, final double kmLo, final double kmHi, final int fromYear, final int toYear) {
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
134 final Session session = SessionHolder.HOLDER.get();
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
135 final SQLQuery query = session.createSQLQuery("SELECT FLOOR(station+0.4999) AS station, COUNT(*) AS count,"
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
136 + " MIN(event_date) AS date_min, MAX(event_date) AS date_max,"
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
137 + " AVG(gauge_w) AS gauge_w"
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
138 + " FROM collision_values v INNER JOIN collision s ON v.collision_id=s.id"
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
139 + " WHERE (s.river_id=:river_id)"
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
140 + " AND (station BETWEEN (:kmLo - 0.0001) AND (:kmHi + 0.0001))"
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
141 + " AND (event_date BETWEEN :fromDate AND :toDate)"
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
142 + " GROUP BY FLOOR(station+0.4999)"
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
143 + " ORDER BY FLOOR(station+0.4999)")
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
144 .addScalar("station", StandardBasicTypes.DOUBLE).addScalar("count", StandardBasicTypes.INTEGER)
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
145 .addScalar("date_min", StandardBasicTypes.DATE).addScalar("date_max", StandardBasicTypes.DATE)
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
146 .addScalar("gauge_w", StandardBasicTypes.DOUBLE);
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
147 query.setInteger("river_id", river.getId());
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
148 query.setDouble("kmLo", new Double(kmLo));
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
149 query.setDouble("kmHi", new Double(kmHi));
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
150 query.setDate("fromDate", DateUtil.getStartDateFromYear(fromYear));
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
151 query.setDate("toDate", DateUtil.getEndDateFromYear(toYear));
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
152 final List<CollisionAggregateValue> values = new ArrayList();
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
153 final List<Object[]> rows = query.list();
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
154 if (rows != null) {
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
155 for (int i = 0; i <= rows.size() - 1; i++) {
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
156 values.add(new CollisionAggregateValue(null, (double) rows.get(i)[0], (Date) rows.get(i)[2], (Date) rows.get(i)[3],
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
157 (int) rows.get(i)[1], (double) rows.get(i)[4]));
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
158 }
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
159 }
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
160 return values;
38e8febd11b6 Added methods to select collision values and collision counts
mschaefer
parents: 9152
diff changeset
161 }
9117
623b51bf03d7 Added datacage select and chart display for river bed collision counts loaded from database
mschaefer
parents:
diff changeset
162 }
http://dive4elements.wald.intevation.org