Mercurial > dive4elements > river

comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/sq/MeasurementFactory.java @ 6955:94cb1845c667

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
(issue1452) Coalesce to zero to avoid NaN arithmetic.
author Andre Heinecke <aheinecke@intevation.de>
date Fri, 30 Aug 2013 15:45:14 +0200
parents b8f94e865875
children 90a3bcd8060a
comparison
equal deleted inserted replaced
6954:8d983cc183bb 6955:94cb1845c667
56 "m.Q_BPEGEL AS Q_BPEGEL,"+ 56 "m.Q_BPEGEL AS Q_BPEGEL,"+
57 "g.GLOTRECHTEID AS GLOTRECHTEID," + 57 "g.GLOTRECHTEID AS GLOTRECHTEID," +
58 "gp.LFDNR AS LFDNR," + 58 "gp.LFDNR AS LFDNR," +
59 "g.UFERABST AS UFERABST," + 59 "g.UFERABST AS UFERABST," +
60 "g.UFERABLINKS AS UFERABLINKS," + 60 "g.UFERABLINKS AS UFERABLINKS," +
61 "m.TSCHWEB AS TSCHWEB," + 61 "COALESCE(m.TSCHWEB, 0) AS TSCHWEB," +
62 "m.TSAND AS TSAND," + 62 "COALESCE(m.TSAND, 0) AS TSAND," +
63 "gp.GTRIEB_F AS GTRIEB," + 63 "COALESCE(gp.GTRIEB_F, 0) AS GTRIEB," +
64 "m.TGESCHIEBE AS TGESCHIEBE," + 64 "COALESCE(m.TGESCHIEBE, 0) AS TGESCHIEBE," +
65 "si.SIEB01 AS SIEB01, si.SIEB02 AS SIEB02," + 65 "COALESCE(si.SIEB01, 0) AS SIEB01, COALESCE(si.SIEB02, 0) AS SIEB02," +
66 "si.SIEB03 AS SIEB03, si.SIEB04 AS SIEB04," + 66 "COALESCE(si.SIEB03, 0) AS SIEB03, COALESCE(si.SIEB04, 0) AS SIEB04," +
67 "si.SIEB05 AS SIEB05, si.SIEB06 AS SIEB06," + 67 "COALESCE(si.SIEB05, 0) AS SIEB05, COALESCE(si.SIEB06, 0) AS SIEB06," +
68 "si.SIEB07 AS SIEB07, si.SIEB08 AS SIEB08," + 68 "COALESCE(si.SIEB07, 0) AS SIEB07, COALESCE(si.SIEB08, 0) AS SIEB08," +
69 "si.SIEB09 AS SIEB09, si.SIEB10 AS SIEB10," + 69 "COALESCE(si.SIEB09, 0) AS SIEB09, COALESCE(si.SIEB10, 0) AS SIEB10," +
70 "si.SIEB11 AS SIEB11, si.SIEB12 AS SIEB12," + 70 "COALESCE(si.SIEB11, 0) AS SIEB11, COALESCE(si.SIEB12, 0) AS SIEB12," +
71 "si.SIEB13 AS SIEB13, si.SIEB14 AS SIEB14," + 71 "COALESCE(si.SIEB13, 0) AS SIEB13, COALESCE(si.SIEB14, 0) AS SIEB14," +
72 "si.SIEB15 AS SIEB15, si.SIEB16 AS SIEB16," + 72 "COALESCE(si.SIEB15, 0) AS SIEB15, COALESCE(si.SIEB16, 0) AS SIEB16," +
73 "si.SIEB17 AS SIEB17, si.SIEB18 AS SIEB18," + 73 "COALESCE(si.SIEB17, 0) AS SIEB17, COALESCE(si.SIEB18, 0) AS SIEB18," +
74 "si.SIEB19 AS SIEB19, si.SIEB20 AS SIEB20," + 74 "COALESCE(si.SIEB19, 0) AS SIEB19, COALESCE(si.SIEB20, 0) AS SIEB20," +
75 "si.SIEB21 AS SIEB21," + 75 "COALESCE(si.SIEB21, 0) AS SIEB21," +
76 "gs.RSIEB01 AS RSIEB01, gs.RSIEB02 AS RSIEB02," + 76 "COALESCE(gs.RSIEB01, 0) AS RSIEB01, COALESCE(gs.RSIEB02, 0) AS RSIEB02," +
77 "gs.RSIEB03 AS RSIEB03, gs.RSIEB04 AS RSIEB04," + 77 "COALESCE(gs.RSIEB03, 0) AS RSIEB03, COALESCE(gs.RSIEB04, 0) AS RSIEB04," +
78 "gs.RSIEB05 AS RSIEB05, gs.RSIEB06 AS RSIEB06," + 78 "COALESCE(gs.RSIEB05, 0) AS RSIEB05, COALESCE(gs.RSIEB06, 0) AS RSIEB06," +
79 "gs.RSIEB07 AS RSIEB07, gs.RSIEB08 AS RSIEB08," + 79 "COALESCE(gs.RSIEB07, 0) AS RSIEB07, COALESCE(gs.RSIEB08, 0) AS RSIEB08," +
80 "gs.RSIEB09 AS RSIEB09, gs.RSIEB10 AS RSIEB10," + 80 "COALESCE(gs.RSIEB09, 0) AS RSIEB09, COALESCE(gs.RSIEB10, 0) AS RSIEB10," +
81 "gs.RSIEB11 AS RSIEB11, gs.RSIEB12 AS RSIEB12," + 81 "COALESCE(gs.RSIEB11, 0) AS RSIEB11, COALESCE(gs.RSIEB12, 0) AS RSIEB12," +
82 "gs.RSIEB13 AS RSIEB13, gs.RSIEB14 AS RSIEB14," + 82 "COALESCE(gs.RSIEB13, 0) AS RSIEB13, COALESCE(gs.RSIEB14, 0) AS RSIEB14," +
83 "gs.RSIEB15 AS RSIEB15, gs.RSIEB16 AS RSIEB16," + 83 "COALESCE(gs.RSIEB15, 0) AS RSIEB15, COALESCE(gs.RSIEB16, 0) AS RSIEB16," +
84 "gs.RSIEB17 AS RSIEB17, gs.RSIEB18 AS RSIEB18," + 84 "COALESCE(gs.RSIEB17, 0) AS RSIEB17, COALESCE(gs.RSIEB18, 0) AS RSIEB18," +
85 "gs.RSIEB19 AS RSIEB19, gs.RSIEB20 AS RSIEB20," + 85 "COALESCE(gs.RSIEB19, 0) AS RSIEB19, COALESCE(gs.RSIEB20, 0) AS RSIEB20," +
86 "gs.RSIEB21 AS RSIEB21, gs.REST AS REST " + 86 "COALESCE(gs.RSIEB21, 0) AS RSIEB21, COALESCE(gs.REST , 0) AS REST " +
87 "FROM MESSUNG m " + 87 "FROM MESSUNG m " +
88 "JOIN STATION s ON m.STATIONID = s.STATIONID " + 88 "JOIN STATION s ON m.STATIONID = s.STATIONID " +
89 "JOIN GEWAESSER r ON s.GEWAESSERID = r.GEWAESSERID " + 89 "JOIN GEWAESSER r ON s.GEWAESSERID = r.GEWAESSERID " +
90 "JOIN GLOTRECHTE g ON m.MESSUNGID = g.MESSUNGID " + 90 "JOIN GLOTRECHTE g ON m.MESSUNGID = g.MESSUNGID " +
91 "JOIN GPROBE gp ON g.GLOTRECHTEID = gp.GLOTRECHTEID " + 91 "JOIN GPROBE gp ON g.GLOTRECHTEID = gp.GLOTRECHTEID " +
http://dive4elements.wald.intevation.org