Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/sinfo/tkhcalculation/BedQualityD50KmValueFinder.java @ 9017:9b9f5f4ddb80
Small changes with debug log
author | mschaefer |
---|---|
date | Mon, 23 Apr 2018 15:19:27 +0200 |
parents | 45f1ad66560e |
children | 5294114b1df4 |
comparison
equal
deleted
inserted
replaced
9016:6e5ff436febe | 9017:9b9f5f4ddb80 |
---|---|
54 * The query filters by km range, time period and layer (sub layer: below bed to max. 50 cm depth).<br /> | 54 * The query filters by km range, time period and layer (sub layer: below bed to max. 50 cm depth).<br /> |
55 * | 55 * |
56 * If PostgreSQL would support a median aggregate function like Oracle does, the aggregation could be placed into this | 56 * If PostgreSQL would support a median aggregate function like Oracle does, the aggregation could be placed into this |
57 * query. | 57 * query. |
58 */ | 58 */ |
59 private static final String SQL_BED_D50_SUBLAYER_MEASUREMENT = "SELECT t.km, t.datum, p.tiefevon, p.tiefebis, a.d50" | 59 private static final String SQL_BED_D50_SUBLAYER_MEASUREMENT = // |
60 + " FROM sohltest t INNER JOIN station s ON t.stationid = s.stationid" + " INNER JOIN gewaesser g ON s.gewaesserid = g.gewaesserid" | 60 "SELECT t.km, t.datum, p.tiefevon, p.tiefebis, a.d50" // |
61 + " INNER JOIN sohlprobe p ON t.sohltestid = p.sohltestid" + " INNER JOIN siebanalyse a ON p.sohlprobeid = a.sohlprobeid" | 61 + " FROM sohltest t INNER JOIN station s ON t.stationid = s.stationid" // |
62 + " WHERE (g.name = :name) AND (s.km BETWEEN :fromkm - 0.0001 AND :tokm + 0.0001)" + " AND (p.tiefevon > 0.0) AND (p.tiefebis <= 0.5)" | 62 + " INNER JOIN gewaesser g ON s.gewaesserid = g.gewaesserid" // |
63 + " AND (t.datum BETWEEN :fromdate AND :todate)" + " ORDER BY t.km ASC, a.d50 ASC"; | 63 + " INNER JOIN sohlprobe p ON t.sohltestid = p.sohltestid" // |
64 + " INNER JOIN siebanalyse a ON p.sohlprobeid = a.sohlprobeid" // | |
65 + " WHERE (g.name = :name) AND (s.km BETWEEN :fromkm - 0.0001 AND :tokm + 0.0001)" // | |
66 + " AND (p.tiefevon > 0.0) AND (p.tiefebis <= 0.5)" // | |
67 + " AND (t.datum BETWEEN :fromdate AND :todate)" // | |
68 + " ORDER BY t.km ASC, a.d50 ASC"; | |
64 | 69 |
65 private Calculation problems; | 70 private Calculation problems; |
66 | 71 |
67 /** | 72 /** |
68 * Real linear interpolator for kms and d50 values (m) | 73 * Real linear interpolator for kms and d50 values (m) |
114 final List<Object[]> rows = sqlQuery.list(); | 119 final List<Object[]> rows = sqlQuery.list(); |
115 final TDoubleArrayList kms = new TDoubleArrayList(); | 120 final TDoubleArrayList kms = new TDoubleArrayList(); |
116 final TDoubleArrayList values = new TDoubleArrayList(); | 121 final TDoubleArrayList values = new TDoubleArrayList(); |
117 final TDoubleArrayList kmd50s = new TDoubleArrayList(); | 122 final TDoubleArrayList kmd50s = new TDoubleArrayList(); |
118 | 123 |
124 // Median aggregate d50 values for each km | |
119 for (int i = 0; i <= rows.size() - 1; i++) { | 125 for (int i = 0; i <= rows.size() - 1; i++) { |
120 kmd50s.add((double) rows.get(i)[4]); | 126 kmd50s.add((double) rows.get(i)[4]); |
121 if (((i == rows.size() - 1) || !Utils.epsilonEquals((double) rows.get(i)[0], (double) rows.get(i + 1)[0], 0.0001))) { | 127 if (((i == rows.size() - 1) || !Utils.epsilonEquals((double) rows.get(i)[0], (double) rows.get(i + 1)[0], 0.0001))) { |
122 final int k = kmd50s.size() / 2; | 128 final int k = kmd50s.size() / 2; |
123 values.add(((k + k < kmd50s.size()) ? kmd50s.get(k) : (kmd50s.get(k - 1) + kmd50s.get(k)) / 2) / 1000); | 129 values.add(((k + k < kmd50s.size()) ? kmd50s.get(k) : (kmd50s.get(k - 1) + kmd50s.get(k)) / 2) / 1000); |
124 kms.add((double) rows.get(i)[0]); | 130 kms.add((double) rows.get(i)[0]); |
125 log.debug(String.format("loadValues km %.3f d50(mm) %.1f count %d", kms.get(kms.size() - 1), values.get(values.size() - 1), kmd50s.size())); | 131 log.debug(String.format("loadValues km %.3f d50(mm) %.1f count %d", kms.get(kms.size() - 1), values.get(values.size() - 1) * 1000, |
132 kmd50s.size())); | |
126 kmd50s.clear(); | 133 kmd50s.clear(); |
127 } | 134 } |
128 } | 135 } |
136 if (kms.size() >= 1) | |
137 log.debug(String.format("loadValues: %d kms found from %.3f to %.3f", kms.size(), kms.get(0), kms.get(kms.size() - 1))); | |
138 else | |
139 log.debug("loadValues: no kms found"); | |
129 | 140 |
130 if (kms.size() < 2 || values.size() < 2) { | 141 if (kms.size() < 2 || values.size() < 2) { |
131 problems.addProblem("bedqualityd50kmvaluefinder.empty", soundingYear); | 142 problems.addProblem("bedqualityd50kmvaluefinder.empty", soundingYear); |
132 return null; | 143 return null; |
133 } | 144 } |