Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/sq/MeasurementFactory.java @ 4009:60d88ec49c3b
S(Q) relation. Fixed SQL statements.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Tue, 02 Oct 2012 01:42:45 +0200 |
| parents | fea3d9210948 |
| children | f02aa4ff3c0f |
comparison
equal
deleted
inserted
replaced
| 4008:fea3d9210948 | 4009:60d88ec49c3b |
|---|---|
| 24 { | 24 { |
| 25 public static final String SQL_TOTALS = | 25 public static final String SQL_TOTALS = |
| 26 "SELECT " + | 26 "SELECT " + |
| 27 "m.Q_BPEGEL AS Q_BPEGEL,"+ | 27 "m.Q_BPEGEL AS Q_BPEGEL,"+ |
| 28 "m.TSCHWEB AS TSCHWEB," + | 28 "m.TSCHWEB AS TSCHWEB," + |
| 29 "m.TSAND AS TSAND" + | 29 "m.TSAND AS TSAND " + |
| 30 "FROM MESSUNG m " + | 30 "FROM MESSUNG m " + |
| 31 "JOIN STATION s ON m.STATIONID = s.STATIONID " + | 31 "JOIN STATION s ON m.STATIONID = s.STATIONID " + |
| 32 "JOIN GEWAESSER r ON s.GEWAESSERID = r.GEWAESSERID " + | 32 "JOIN GEWAESSER r ON s.GEWAESSERID = r.GEWAESSERID " + |
| 33 "WHERE " + | 33 "WHERE " + |
| 34 "r.NAME = :river_name " + | 34 "r.NAME = :river_name " + |
| 47 "g.UFERABLINKS AS UFERABLINKS," + | 47 "g.UFERABLINKS AS UFERABLINKS," + |
| 48 "m.TSCHWEB AS TSCHWEB," + | 48 "m.TSCHWEB AS TSCHWEB," + |
| 49 "m.TSAND AS TSAND," + | 49 "m.TSAND AS TSAND," + |
| 50 "gp.GTRIEB AS GTRIEB," + | 50 "gp.GTRIEB AS GTRIEB," + |
| 51 "m.TGESCHIEBE AS TGESCHIEBE," + | 51 "m.TGESCHIEBE AS TGESCHIEBE," + |
| 52 "sie.SIEB01 AS SIEB01, sie.SIEB02 AS SIEB02," + | 52 "si.SIEB01 AS SIEB01, si.SIEB02 AS SIEB02," + |
| 53 "sie.SIEB03 AS SIEB03, sie.SIEB04 AS SIEB04," + | 53 "si.SIEB03 AS SIEB03, si.SIEB04 AS SIEB04," + |
| 54 "sie.SIEB05 AS SIEB05, sie.SIEB06 AS SIEB06," + | 54 "si.SIEB05 AS SIEB05, si.SIEB06 AS SIEB06," + |
| 55 "sie.SIEB07 AS SIEB07, sie.SIEB08 AS SIEB08," + | 55 "si.SIEB07 AS SIEB07, si.SIEB08 AS SIEB08," + |
| 56 "sie.SIEB09 AS SIEB09, sie.SIEB10 AS SIEB10," + | 56 "si.SIEB09 AS SIEB09, si.SIEB10 AS SIEB10," + |
| 57 "sie.SIEB11 AS SIEB11, sie.SIEB12 AS SIEB12," + | 57 "si.SIEB11 AS SIEB11, si.SIEB12 AS SIEB12," + |
| 58 "sie.SIEB13 AS SIEB13, sie.SIEB14 AS SIEB14," + | 58 "si.SIEB13 AS SIEB13, si.SIEB14 AS SIEB14," + |
| 59 "sie.SIEB15 AS SIEB15, sie.SIEB16 AS SIEB16," + | 59 "si.SIEB15 AS SIEB15, si.SIEB16 AS SIEB16," + |
| 60 "sie.SIEB17 AS SIEB17, sie.SIEB18 AS SIEB18," + | 60 "si.SIEB17 AS SIEB17, si.SIEB18 AS SIEB18," + |
| 61 "sie.SIEB19 AS SIEB19, sie.SIEB20 AS SIEB20," + | 61 "si.SIEB19 AS SIEB19, si.SIEB20 AS SIEB20," + |
| 62 "sie.SIEB21 AS SIEB21," + | 62 "si.SIEB21 AS SIEB21," + |
| 63 "gs.RSIEB01 AS RSIEB01, gs.RSIEB02 AS RSIEB02," + | 63 "gs.RSIEB01 AS RSIEB01, gs.RSIEB02 AS RSIEB02," + |
| 64 "gs.RSIEB03 AS RSIEB03, gs.RSIEB04 AS RSIEB04," + | 64 "gs.RSIEB03 AS RSIEB03, gs.RSIEB04 AS RSIEB04," + |
| 65 "gs.RSIEB05 AS RSIEB05, gs.RSIEB06 AS RSIEB06," + | 65 "gs.RSIEB05 AS RSIEB05, gs.RSIEB06 AS RSIEB06," + |
| 66 "gs.RSIEB07 AS RSIEB07, gs.RSIEB08 AS RSIEB08," + | 66 "gs.RSIEB07 AS RSIEB07, gs.RSIEB08 AS RSIEB08," + |
| 67 "gs.RSIEB09 AS RSIEB09, gs.RSIEB10 AS RSIEB10," + | 67 "gs.RSIEB09 AS RSIEB09, gs.RSIEB10 AS RSIEB10," + |
| 72 "gs.RSIEB19 AS RSIEB19, gs.RSIEB20 AS RSIEB20," + | 72 "gs.RSIEB19 AS RSIEB19, gs.RSIEB20 AS RSIEB20," + |
| 73 "gs.RSIEB21 AS RSIEB21, gs.REST AS REST " + | 73 "gs.RSIEB21 AS RSIEB21, gs.REST AS REST " + |
| 74 "FROM MESSUNG m " + | 74 "FROM MESSUNG m " + |
| 75 "JOIN STATION s ON m.STATIONID = s.STATIONID " + | 75 "JOIN STATION s ON m.STATIONID = s.STATIONID " + |
| 76 "JOIN GEWAESSER r ON s.GEWAESSERID = r.GEWAESSERID " + | 76 "JOIN GEWAESSER r ON s.GEWAESSERID = r.GEWAESSERID " + |
| 77 "JOIN glotrechte g ON m.MESSUNGID = g.MESSUNGID " + | 77 "JOIN GLOTRECHTE g ON m.MESSUNGID = g.MESSUNGID " + |
| 78 "JOIN gprobe gp ON g.GLOTRECHTEID = gp.GLOTRECHTEID " + | 78 "JOIN GPROBE gp ON g.GLOTRECHTEID = gp.GLOTRECHTEID " + |
| 79 "JOIN GSIEBUNG gs ON g.GLOTRECHTEID = gs.GLOTRECHTEID " + | 79 "JOIN GSIEBUNG gs ON g.GLOTRECHTEID = gs.GLOTRECHTEID " + |
| 80 "JOIN GSIEBSATZ si ON m.GSIEBSATZID = si.GSIEBSATZID " + | |
| 80 "WHERE " + | 81 "WHERE " + |
| 81 "r.NAME = :river_name " + | 82 "r.NAME = :river_name " + |
| 82 "AND m.Q_BPEGEL IS NOT NULL " + | 83 "AND m.Q_BPEGEL IS NOT NULL " + |
| 83 "AND s.KM BETWEEN :location - 0.001 AND :location + 0.001 " + | 84 "AND s.KM BETWEEN :location - 0.001 AND :location + 0.001 " + |
| 84 "AND m.DATUM BETWEEN :from AND :to " + | 85 "AND m.DATUM BETWEEN :from AND :to " + |