# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1257772293 0
# Node ID 56dcedc4a96c93c1449dca95b1f25108f90e51a1
# Parent  993fd465c9045e1d068a4a08c807c4dfa5506d71
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints

gnv-artifacts/trunk@305 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 993fd465c904 -r 56dcedc4a96c gnv-artifacts/ChangeLog
--- 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. 
diff -r 993fd465c904 -r 56dcedc4a96c gnv-artifacts/doc/conf/queries.properties
--- 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 ##############