Mercurial > dive4elements > gnv-client
changeset 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 | 993fd465c904 |
| children | a157c6042cb4 |
| files | gnv-artifacts/ChangeLog gnv-artifacts/doc/conf/queries.properties |
| diffstat | 2 files changed, 38 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/gnv-artifacts/ChangeLog Mon Nov 09 13:10:17 2009 +0000 +++ b/gnv-artifacts/ChangeLog Mon Nov 09 13:11:33 2009 +0000 @@ -35,6 +35,14 @@ 2009-11-09 Tim Englich <tim.englich@intevation.de> + * doc/conf/queries.properties: + Added SQLStatemenet for ODV-Data for VerticalProfiles + on TimeSeriesPoints. + * doc/conf/products/verticalprofile/conf_timeseriespoint.xml: + Added QueryID for ODV-Data-Query + +2009-11-09 Tim Englich <tim.englich@intevation.de> + * src/test/ressources/timeseries/timeseries_step_06_out_*.xml: Added the missing out-Modes to the Testcase and rename it to the common used way in this TestCases.
--- 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 ##############