Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 1037:da4306683186
Added queries for TimeSeriesPoints in vectorvalues for TimeSeries
gnv-artifacts/trunk@1109 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 18 May 2010 14:27:46 +0000 |
| parents | 35c442410738 |
| children | 07b829c06981 |
comparison
equal
deleted
inserted
replaced
| 1036:af53410ad551 | 1037:da4306683186 |
|---|---|
| 123 ORDER BY TS.PARAMETERID, \ | 123 ORDER BY TS.PARAMETERID, \ |
| 124 TSV.MEASUREMENTID, \ | 124 TSV.MEASUREMENTID, \ |
| 125 TSV.TIMESERIESID, \ | 125 TSV.TIMESERIESID, \ |
| 126 TSV.TIMEVALUE | 126 TSV.TIMEVALUE |
| 127 | 127 |
| 128 | 128 ############################################# |
| 129 ############################################# | 129 ############################################# |
| 130 ########## Zeitserie ############## | |
| 131 ########## Vektordaten ############### | |
| 132 ############################################# | |
| 133 ############################################# | |
| 134 | |
| 135 timeseries_parameter_vector=SELECT DISTINCT \ | |
| 136 p.PARAMETERID KEY, \ | |
| 137 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ | |
| 138 p.GERMANNAME \ | |
| 139 FROM MEDIAN.PARAMETER P, \ | |
| 140 MEDIAN.TIMESERIES TS, \ | |
| 141 MEDIAN.TIMESERIESVECTORVALUE TSV, \ | |
| 142 MEDIAN.MEASUREMENT M, \ | |
| 143 MEDIAN.TIMESERIESPOINT TSP \ | |
| 144 WHERE M.FEATUREID = TSP.FEATUREID AND \ | |
| 145 M.MEASUREMENTID = TSV.MEASUREMENTID AND \ | |
| 146 TS.TIMESERIESID = TSV.TIMESERIESID AND \ | |
| 147 P.PARAMETERID = TS.PARAMETERID AND \ | |
| 148 TSP.FEATUREID = ? \ | |
| 149 ORDER BY P.GERMANNAME | |
| 150 | |
| 151 timeseries_depth_height_vector=SELECT DISTINCT \ | |
| 152 M.MEASUREMENTID KEY, \ | |
| 153 M.ZLOCATION VALUE, \ | |
| 154 P.PARAMETERID PARAMETERID \ | |
| 155 FROM MEDIAN.MEASUREMENT M, \ | |
| 156 MEDIAN.TIMESERIESVECTORVALUE TSV, \ | |
| 157 MEDIAN.TIMESERIES T, \ | |
| 158 MEDIAN.PARAMETER P \ | |
| 159 WHERE M.MEASUREMENTID = TSV.MEASUREMENTID AND \ | |
| 160 TSV.TIMESERIESID = T.TIMESERIESID AND \ | |
| 161 T.PARAMETERID = P.PARAMETERID AND \ | |
| 162 M.FEATUREID = ? AND \ | |
| 163 P.PARAMETERID = ? \ | |
| 164 ORDER BY m.ZLOCATION DESC | |
| 165 | |
| 166 timeseries_interval_vector=select min(tsv.TIMEVALUE) MIN, \ | |
| 167 max(tsv.TIMEVALUE) MAX \ | |
| 168 from MEDIAN.TIMESERIES t, \ | |
| 169 MEDIAN.TIMESERIESVECTORVALUE tsv \ | |
| 170 where tsv.TIMESERIESID = t.TIMESERIESID AND \ | |
| 171 t.PARAMETERID = ? AND \ | |
| 172 tsv.MEASUREMENTID = ? | |
| 173 | |
| 174 timeseries_chart_data_vector=SELECT tsv.TIMEVALUE XORDINATE, \ | |
| 175 tsv.XCOMPONENT, \ | |
| 176 tsv.YCOMPONENT, \ | |
| 177 tsv.ZCOMPONENT, \ | |
| 178 1 SPEED, \ | |
| 179 1 DIRECTION, \ | |
| 180 t.PARAMETERID GROUP1, \ | |
| 181 tsv.MEASUREMENTID GROUP2, \ | |
| 182 tsv.TIMESERIESID GROUP3, \ | |
| 183 t.TIMEINTERVAL GAPID \ | |
| 184 FROM MEDIAN.TIMESERIESVECTORVALUE tsv, \ | |
| 185 MEDIAN.TIMESERIES t \ | |
| 186 WHERE tsv.TIMESERIESID = t.TIMESERIESID AND \ | |
| 187 t.PARAMETERID = ? AND \ | |
| 188 tsv.MEASUREMENTID = ? AND \ | |
| 189 tsv.TIMEVALUE >= ? AND \ | |
| 190 tsv.TIMEVALUE <= ? \ | |
| 191 ORDER BY tsv.MEASUREMENTID, \ | |
| 192 tsv.TIMESERIESID, \ | |
| 193 t.PARAMETERID, \ | |
| 194 tsv.TIMEVALUE | |
| 195 | |
| 196 timeseries_odv_data_vector = SELECT SI.NAME CRUISE, \ | |
| 197 MEDIAN.TIMESERIESPOINT.NAME STATION, \ | |
| 198 '*' TYPE, \ | |
| 199 ST_ASTEXT(SHAPE), \ | |
| 200 0 BOTDEPTH, \ | |
| 201 (M.ZLOCATION *-1) DEPTH, \ | |
| 202 TSV.TIMEVALUE, \ | |
| 203 TSV.XCOMPONENT, \ | |
| 204 TSV.YCOMPONENT, \ | |
| 205 TSV.ZCOMPONENT, \ | |
| 206 1 SPEED, \ | |
| 207 1 DIRECTION, \ | |
| 208 TS.PARAMETERID PARAMETER, \ | |
| 209 TSV.MEASUREMENTID, \ | |
| 210 TSV.TIMESERIESID, \ | |
| 211 '1' QF \ | |
| 212 FROM MEDIAN.TIMESERIESPOINT, \ | |
| 213 MEDIAN.TIMESERIESVECTORVALUE TSV, \ | |
| 214 MEDIAN.TIMESERIES TS, \ | |
| 215 MEDIAN.MEASUREMENT M, \ | |
| 216 MEDIAN.SOURCEINFO SI \ | |
| 217 WHERE SI.SOURCEID = M.SOURCEID AND \ | |
| 218 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \ | |
| 219 M.MEASUREMENTID = TSV.MEASUREMENTID AND \ | |
| 220 TSV.TIMESERIESID = TS.TIMESERIESID AND \ | |
| 221 TS.PARAMETERID = ? AND \ | |
| 222 TSV.MEASUREMENTID = ? AND \ | |
| 223 TSV.TIMEVALUE >= ? AND \ | |
| 224 TSV.TIMEVALUE <= ? \ | |
| 225 ORDER BY TS.PARAMETERID, \ | |
| 226 TSV.MEASUREMENTID, \ | |
| 227 TSV.TIMESERIESID, \ | |
| 228 TSV.TIMEVALUE | |
| 229 | |
| 230 ############################################ | |
| 130 ############################################# | 231 ############################################# |
| 131 ########## Zeitserie Mesh ############## | 232 ########## Zeitserie Mesh ############## |
| 132 ############################################# | 233 ############################################# |
| 133 ############################################# | 234 ############################################# |
| 134 | 235 |