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 \ |