Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 237:56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
gnv-artifacts/trunk@305 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Mon, 09 Nov 2009 13:11:33 +0000 |
| parents | 3d6d89bcbf42 |
| children | 76897b73db4e |
comparison
equal
deleted
inserted
replaced
| 236:993fd465c904 | 237:56dcedc4a96c |
|---|---|
| 255 M.ZLOCATION <= ? \ | 255 M.ZLOCATION <= ? \ |
| 256 ORDER BY TSV.TIMEVALUE , \ | 256 ORDER BY TSV.TIMEVALUE , \ |
| 257 TSV.TIMESERIESID , \ | 257 TSV.TIMESERIESID , \ |
| 258 TS.PARAMETERID , \ | 258 TS.PARAMETERID , \ |
| 259 TSV.TIMEVALUE | 259 TSV.TIMEVALUE |
| 260 | |
| 261 verticalprofile_odv_data = SELECT SI.NAME CRUISE, \ | |
| 262 MEDIAN.TIMESERIESPOINT.NAME STATION, \ | |
| 263 '*' TYPE, \ | |
| 264 ST_ASTEXT(SHAPE), \ | |
| 265 0 BOTDEPTH, \ | |
| 266 (M.ZLOCATION *-1) DEPTH, \ | |
| 267 TSV.TIMEVALUE, \ | |
| 268 TSV.DATAVALUE, \ | |
| 269 TS.PARAMETERID PARAMETER, \ | |
| 270 TSV.MEASUREMENTID, \ | |
| 271 TSV.TIMESERIESID \ | |
| 272 FROM MEDIAN.TIMESERIESPOINT , \ | |
| 273 MEDIAN.TIMESERIESVALUE TSV, \ | |
| 274 MEDIAN.TIMESERIES TS, \ | |
| 275 MEDIAN.MEASUREMENT M, \ | |
| 276 MEDIAN.SOURCEINFO SI \ | |
| 277 WHERE SI.SOURCEID = M.SOURCEID AND \ | |
| 278 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \ | |
| 279 M.MEASUREMENTID = TSV.MEASUREMENTID AND \ | |
| 280 TSV.TIMESERIESID = TS.TIMESERIESID AND \ | |
| 281 M.FEATUREID = ? AND \ | |
| 282 TS.PARAMETERID IN ( ? ) AND \ | |
| 283 TSV.TIMEVALUE IN (?) AND \ | |
| 284 M.ZLOCATION >= ? AND \ | |
| 285 M.ZLOCATION <= ? \ | |
| 286 ORDER BY TSV.MEASUREMENTID , \ | |
| 287 TSV.TIMESERIESID , \ | |
| 288 TS.PARAMETERID , \ | |
| 289 TSV.TIMEVALUE | |
| 260 | 290 |
| 261 ############################################# | 291 ############################################# |
| 262 ############################################# | 292 ############################################# |
| 263 ########## Vertikalprofil Mesh ############## | 293 ########## Vertikalprofil Mesh ############## |
| 264 ############################################# | 294 ############################################# |