Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 1042:07b829c06981
Integrated View MEDIAN.TIMESERIESFULLVECTORVALUE in queries for vector data on timeSeriesPoints
gnv-artifacts/trunk@1114 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 21 May 2010 07:54:01 +0000 |
| parents | da4306683186 |
| children | d955571cdf2a |
comparison
equal
deleted
inserted
replaced
| 1041:8a8ee5abc084 | 1042:07b829c06981 |
|---|---|
| 173 | 173 |
| 174 timeseries_chart_data_vector=SELECT tsv.TIMEVALUE XORDINATE, \ | 174 timeseries_chart_data_vector=SELECT tsv.TIMEVALUE XORDINATE, \ |
| 175 tsv.XCOMPONENT, \ | 175 tsv.XCOMPONENT, \ |
| 176 tsv.YCOMPONENT, \ | 176 tsv.YCOMPONENT, \ |
| 177 tsv.ZCOMPONENT, \ | 177 tsv.ZCOMPONENT, \ |
| 178 1 SPEED, \ | 178 tsv.SPEED, \ |
| 179 1 DIRECTION, \ | 179 tsv.DIRECTION, \ |
| 180 t.PARAMETERID GROUP1, \ | 180 t.PARAMETERID GROUP1, \ |
| 181 tsv.MEASUREMENTID GROUP2, \ | 181 tsv.MEASUREMENTID GROUP2, \ |
| 182 tsv.TIMESERIESID GROUP3, \ | 182 tsv.TIMESERIESID GROUP3, \ |
| 183 t.TIMEINTERVAL GAPID \ | 183 t.TIMEINTERVAL GAPID \ |
| 184 FROM MEDIAN.TIMESERIESVECTORVALUE tsv, \ | 184 FROM MEDIAN.TIMESERIESFULLVECTORVALUE tsv, \ |
| 185 MEDIAN.TIMESERIES t \ | 185 MEDIAN.TIMESERIES t \ |
| 186 WHERE tsv.TIMESERIESID = t.TIMESERIESID AND \ | 186 WHERE tsv.TIMESERIESID = t.TIMESERIESID AND \ |
| 187 t.PARAMETERID = ? AND \ | 187 t.PARAMETERID = ? AND \ |
| 188 tsv.MEASUREMENTID = ? AND \ | 188 tsv.MEASUREMENTID = ? AND \ |
| 189 tsv.TIMEVALUE >= ? AND \ | 189 tsv.TIMEVALUE >= ? AND \ |
| 201 (M.ZLOCATION *-1) DEPTH, \ | 201 (M.ZLOCATION *-1) DEPTH, \ |
| 202 TSV.TIMEVALUE, \ | 202 TSV.TIMEVALUE, \ |
| 203 TSV.XCOMPONENT, \ | 203 TSV.XCOMPONENT, \ |
| 204 TSV.YCOMPONENT, \ | 204 TSV.YCOMPONENT, \ |
| 205 TSV.ZCOMPONENT, \ | 205 TSV.ZCOMPONENT, \ |
| 206 1 SPEED, \ | 206 TSV.SPEED, \ |
| 207 1 DIRECTION, \ | 207 TSV.DIRECTION, \ |
| 208 TS.PARAMETERID PARAMETER, \ | 208 TS.PARAMETERID PARAMETER, \ |
| 209 TSV.MEASUREMENTID, \ | 209 TSV.MEASUREMENTID, \ |
| 210 TSV.TIMESERIESID, \ | 210 TSV.TIMESERIESID, \ |
| 211 '1' QF \ | 211 '1' QF \ |
| 212 FROM MEDIAN.TIMESERIESPOINT, \ | 212 FROM MEDIAN.TIMESERIESPOINT, \ |
| 213 MEDIAN.TIMESERIESVECTORVALUE TSV, \ | 213 MEDIAN.TIMESERIESFULLVECTORVALUE TSV, \ |
| 214 MEDIAN.TIMESERIES TS, \ | 214 MEDIAN.TIMESERIES TS, \ |
| 215 MEDIAN.MEASUREMENT M, \ | 215 MEDIAN.MEASUREMENT M, \ |
| 216 MEDIAN.SOURCEINFO SI \ | 216 MEDIAN.SOURCEINFO SI \ |
| 217 WHERE SI.SOURCEID = M.SOURCEID AND \ | 217 WHERE SI.SOURCEID = M.SOURCEID AND \ |
| 218 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \ | 218 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \ |