diff 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
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Mon May 17 14:12:53 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Tue May 18 14:27:46 2010 +0000
@@ -125,8 +125,109 @@
               TSV.TIMESERIESID, \
               TSV.TIMEVALUE
               
+#############################################
+#############################################
+##########     Zeitserie       ##############
+##########    Vektordaten     ###############
+#############################################
+#############################################
 
-#############################################
+timeseries_parameter_vector=SELECT DISTINCT \
+        p.PARAMETERID KEY, \
+        p.GERMANNAME || '  ['|| p.UNIT ||']' VALUE, \
+        p.GERMANNAME \
+    FROM MEDIAN.PARAMETER P, \
+         MEDIAN.TIMESERIES TS, \
+         MEDIAN.TIMESERIESVECTORVALUE TSV, \
+         MEDIAN.MEASUREMENT M, \
+         MEDIAN.TIMESERIESPOINT TSP \
+    WHERE M.FEATUREID = TSP.FEATUREID AND \
+          M.MEASUREMENTID = TSV.MEASUREMENTID AND \
+          TS.TIMESERIESID = TSV.TIMESERIESID AND \
+          P.PARAMETERID = TS.PARAMETERID AND \
+          TSP.FEATUREID = ? \
+    ORDER BY P.GERMANNAME
+    
+timeseries_depth_height_vector=SELECT DISTINCT \
+        M.MEASUREMENTID KEY, \
+        M.ZLOCATION VALUE, \
+        P.PARAMETERID PARAMETERID \
+    FROM MEDIAN.MEASUREMENT M, \
+         MEDIAN.TIMESERIESVECTORVALUE TSV, \
+         MEDIAN.TIMESERIES T, \
+         MEDIAN.PARAMETER P \
+    WHERE M.MEASUREMENTID = TSV.MEASUREMENTID AND \
+          TSV.TIMESERIESID = T.TIMESERIESID AND \
+          T.PARAMETERID = P.PARAMETERID AND \
+          M.FEATUREID = ? AND \
+          P.PARAMETERID = ? \
+    ORDER BY m.ZLOCATION DESC
+
+timeseries_interval_vector=select min(tsv.TIMEVALUE) MIN, \
+        max(tsv.TIMEVALUE) MAX \
+    from MEDIAN.TIMESERIES t, \
+         MEDIAN.TIMESERIESVECTORVALUE tsv \
+    where tsv.TIMESERIESID = t.TIMESERIESID AND \
+          t.PARAMETERID = ? AND \
+          tsv.MEASUREMENTID = ?
+
+timeseries_chart_data_vector=SELECT tsv.TIMEVALUE XORDINATE, \
+        tsv.XCOMPONENT, \
+        tsv.YCOMPONENT, \
+        tsv.ZCOMPONENT, \
+        1 SPEED, \
+        1 DIRECTION, \
+        t.PARAMETERID GROUP1, \
+        tsv.MEASUREMENTID GROUP2, \
+        tsv.TIMESERIESID GROUP3, \
+        t.TIMEINTERVAL GAPID \
+    FROM MEDIAN.TIMESERIESVECTORVALUE tsv, \
+         MEDIAN.TIMESERIES t \
+    WHERE tsv.TIMESERIESID = t.TIMESERIESID AND \
+          t.PARAMETERID = ? AND \
+          tsv.MEASUREMENTID = ? AND \
+          tsv.TIMEVALUE >= ? AND \
+          tsv.TIMEVALUE <= ? \
+    ORDER BY tsv.MEASUREMENTID, \
+             tsv.TIMESERIESID, \
+             t.PARAMETERID, \
+             tsv.TIMEVALUE
+
+timeseries_odv_data_vector = SELECT SI.NAME CRUISE, \
+            MEDIAN.TIMESERIESPOINT.NAME STATION, \
+            '*' TYPE, \
+            ST_ASTEXT(SHAPE), \
+            0 BOTDEPTH, \
+            (M.ZLOCATION *-1) DEPTH, \
+            TSV.TIMEVALUE, \
+            TSV.XCOMPONENT, \
+            TSV.YCOMPONENT, \
+            TSV.ZCOMPONENT, \
+            1 SPEED, \
+            1 DIRECTION, \
+            TS.PARAMETERID PARAMETER, \
+            TSV.MEASUREMENTID, \
+            TSV.TIMESERIESID, \
+            '1' QF \
+     FROM MEDIAN.TIMESERIESPOINT, \
+          MEDIAN.TIMESERIESVECTORVALUE 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 \
+           TS.PARAMETERID = ?  AND \
+           TSV.MEASUREMENTID = ? AND \
+           TSV.TIMEVALUE >= ? AND \
+           TSV.TIMEVALUE <= ? \
+     ORDER BY TS.PARAMETERID, \
+              TSV.MEASUREMENTID, \
+              TSV.TIMESERIESID, \
+              TSV.TIMEVALUE
+
+############################################
 #############################################
 ##########   Zeitserie Mesh    ##############
 #############################################

http://dive4elements.wald.intevation.org