Mercurial > dive4elements > gnv-client
diff 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 |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Mon Nov 09 13:10:17 2009 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Mon Nov 09 13:11:33 2009 +0000 @@ -258,6 +258,36 @@ TS.PARAMETERID , \ TSV.TIMEVALUE +verticalprofile_odv_data = SELECT SI.NAME CRUISE, \ + MEDIAN.TIMESERIESPOINT.NAME STATION, \ + '*' TYPE, \ + ST_ASTEXT(SHAPE), \ + 0 BOTDEPTH, \ + (M.ZLOCATION *-1) DEPTH, \ + TSV.TIMEVALUE, \ + TSV.DATAVALUE, \ + TS.PARAMETERID PARAMETER, \ + TSV.MEASUREMENTID, \ + TSV.TIMESERIESID \ + FROM MEDIAN.TIMESERIESPOINT , \ + MEDIAN.TIMESERIESVALUE TSV, \ + MEDIAN.TIMESERIES TS, \ + MEDIAN.MEASUREMENT M, \ + MEDIAN.SOURCEINFO SI \ + WHERE SI.SOURCEID = M.SOURCEID AND \ + M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \ + M.MEASUREMENTID = TSV.MEASUREMENTID AND \ + TSV.TIMESERIESID = TS.TIMESERIESID AND \ + M.FEATUREID = ? AND \ + TS.PARAMETERID IN ( ? ) AND \ + TSV.TIMEVALUE IN (?) AND \ + M.ZLOCATION >= ? AND \ + M.ZLOCATION <= ? \ + ORDER BY TSV.MEASUREMENTID , \ + TSV.TIMESERIESID , \ + TS.PARAMETERID , \ + TSV.TIMEVALUE + ############################################# ############################################# ########## Vertikalprofil Mesh ##############