Mercurial > dive4elements > river

comparison artifacts/src/main/java/org/dive4elements/river/artifacts/sinfo/tkhcalculation/BedQualityD50KmValueFinder.java @ 9665:8a84c9fef8ec

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
S-info/tkh: d50 average changed from median to arithmetic mean
author mschaefer
date Wed, 06 May 2020 16:17:38 +0200
parents 8e6b9cb9486a
children
comparison
equal deleted inserted replaced
9664:692f49b7de63 9665:8a84c9fef8ec
66 + " INNER JOIN sohlprobe p ON t.sohltestid = p.sohltestid" // 66 + " INNER JOIN sohlprobe p ON t.sohltestid = p.sohltestid" //
67 + " INNER JOIN siebanalyse a ON p.sohlprobeid = a.sohlprobeid" // 67 + " INNER JOIN siebanalyse a ON p.sohlprobeid = a.sohlprobeid" //
68 + " WHERE (g.name = :name)" // 68 + " WHERE (g.name = :name)" //
69 + " AND (p.tiefevon > 0.0) AND (p.tiefebis <= 0.5)" // 69 + " AND (p.tiefevon > 0.0) AND (p.tiefebis <= 0.5)" //
70 + " AND (t.datum BETWEEN :fromdate AND :todate)" // 70 + " AND (t.datum BETWEEN :fromdate AND :todate)" //
71 + " ORDER BY s.km ASC, a.d50 ASC"; 71 + " ORDER BY s.km ASC, a.d50 ASC";
72 72
73 public static final Date MIN_DATE = new Date(-10000000000000l); // Database does not cope with Long.MIN/Long.Max, so we go just a few hundred years 73 public static final Date MIN_DATE = new Date(-10000000000000l); // Database does not cope with Long.MIN/Long.Max, so we go just a few hundred years
74 // back/forward 74 // back/forward
75 public static final Date MAX_DATE = new Date(10000000000000l); 75 public static final Date MAX_DATE = new Date(10000000000000l);
76 76
125 sqlQuery.setString("name", seddbRiver); 125 sqlQuery.setString("name", seddbRiver);
126 // sqlQuery.setDouble("fromkm", kmRange.getMinimumDouble()); 126 // sqlQuery.setDouble("fromkm", kmRange.getMinimumDouble());
127 // sqlQuery.setDouble("tokm", kmRange.getMaximumDouble()); 127 // sqlQuery.setDouble("tokm", kmRange.getMaximumDouble());
128 sqlQuery.setDate("fromdate", startTime); 128 sqlQuery.setDate("fromdate", startTime);
129 sqlQuery.setDate("todate", endTime); 129 sqlQuery.setDate("todate", endTime);
130
131 final List<Object[]> rows = sqlQuery.list(); 130 final List<Object[]> rows = sqlQuery.list();
131
132 // Aggregate d50 values for each km
133 // final TDoubleArrayList kmsm = new TDoubleArrayList();
134 // final TDoubleArrayList valuesm = new TDoubleArrayList();
132 final TDoubleArrayList kms = new TDoubleArrayList(); 135 final TDoubleArrayList kms = new TDoubleArrayList();
133 final TDoubleArrayList values = new TDoubleArrayList(); 136 final TDoubleArrayList values = new TDoubleArrayList();
134 final TDoubleArrayList kmd50s = new TDoubleArrayList();
135
136 // Median aggregate d50 values for each km
137 if (rows != null) { 137 if (rows != null) {
138 // // median
139 // final TDoubleArrayList kmd50s = new TDoubleArrayList();
140 // for (int i = 0; i <= rows.size() - 1; i++) {
141 // log.trace("loadValues rows(" + i + ") " + rows.get(i)[0] + " " + rows.get(i)[1] + " " + rows.get(i)[2] + " " +
142 // rows.get(i)[3] + " "
143 // + rows.get(i)[4]);
144 // kmd50s.add((double) rows.get(i)[4]);
145 // if (((i == rows.size() - 1) || !Utils.epsilonEquals((double) rows.get(i)[0], (double) rows.get(i + 1)[0], 0.0001))) {
146 // final int k = kmd50s.size() / 2;
147 // valuesm.add(((k + k < kmd50s.size()) ? kmd50s.get(k) : (kmd50s.get(k - 1) + kmd50s.get(k)) / 2) / 1000);
148 // kmsm.add((double) rows.get(i)[0]);
149 // log.debug(String.format("loadValues km %.3f d50(mm) %.1f count %d", kmsm.get(kmsm.size() - 1),
150 // valuesm.get(valuesm.size() - 1) * 1000,
151 // kmd50s.size()));
152 // kmd50s.clear();
153 // }
154 // }
155 // arithmetic mean
156 double sum = 0;
157 int n = 0;
138 for (int i = 0; i <= rows.size() - 1; i++) { 158 for (int i = 0; i <= rows.size() - 1; i++) {
139 log.trace("loadValues rows(" + i + ") " + rows.get(i)[0] + " " + rows.get(i)[1] + " " + rows.get(i)[2] + " " + rows.get(i)[3] + " " 159 sum += (double) rows.get(i)[4];
140 + rows.get(i)[4]); 160 n++;
141 kmd50s.add((double) rows.get(i)[4]);
142 if (((i == rows.size() - 1) || !Utils.epsilonEquals((double) rows.get(i)[0], (double) rows.get(i + 1)[0], 0.0001))) { 161 if (((i == rows.size() - 1) || !Utils.epsilonEquals((double) rows.get(i)[0], (double) rows.get(i + 1)[0], 0.0001))) {
143 final int k = kmd50s.size() / 2;
144 values.add(((k + k < kmd50s.size()) ? kmd50s.get(k) : (kmd50s.get(k - 1) + kmd50s.get(k)) / 2) / 1000);
145 kms.add((double) rows.get(i)[0]); 162 kms.add((double) rows.get(i)[0]);
146 log.debug(String.format("loadValues km %.3f d50(mm) %.1f count %d", kms.get(kms.size() - 1), values.get(values.size() - 1) * 1000, 163 values.add((sum / n) / 1000);
147 kmd50s.size())); 164 log.debug(String.format("loadValues km %.3f d50(mm) %.1f count %d", kms.get(kms.size() - 1), values.get(values.size() - 1) * 1000, n));
148 kmd50s.clear(); 165 sum = 0;
166 n = 0;
149 } 167 }
150 } 168 }
151 } 169 }
152 if (kms.size() >= 1) 170 if (kms.size() >= 1)
153 log.debug(String.format("loadValues: %d kms found from %.3f to %.3f", kms.size(), kms.get(0), kms.get(kms.size() - 1))); 171 log.debug(String.format("loadValues: %d kms found from %.3f to %.3f", kms.size(), kms.get(0), kms.get(kms.size() - 1)));
176 */ 194 */
177 public double findD50(final double km) { 195 public double findD50(final double km) {
178 try { 196 try {
179 return this.interpolator.value(km); 197 return this.interpolator.value(km);
180 } 198 }
181 catch (@SuppressWarnings("unused") final ArgumentOutsideDomainException e) { 199 catch (final ArgumentOutsideDomainException e) {
182 // No stack trace because this might happen a lot (intended) and we produce an error message anyways. 200 // No stack trace because this might happen a lot (intended) and we produce an error message anyways.
183 // e.printStackTrace(); 201 // e.printStackTrace();
184 202
185 if (this.problems != null) { 203 if (this.problems != null) {
186 this.problems.addProblem(km, "bedqualityd50kmvaluefinder.missing"); 204 this.problems.addProblem(km, "bedqualityd50kmvaluefinder.missing");
http://dive4elements.wald.intevation.org