diff gnv-artifacts/doc/conf/queries.properties @ 1043:d955571cdf2a

Added queries for Meshes using Vectorvalues for TimeSeries. gnv-artifacts/trunk@1115 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 21 May 2010 08:28:49 +0000
parents 07b829c06981
children 3fe08ea3f2b6
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Fri May 21 07:54:01 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Fri May 21 08:28:49 2010 +0000
@@ -337,6 +337,98 @@
              msv.TIMEVALUE, \
              msv.PARAMETERID
 
+#############################################
+#############################################
+##########   Zeitserie Mesh    ##############
+##########     Vektordaten     ##############
+#############################################
+#############################################
+
+timeseries_mesh_parameter_vector=SELECT DISTINCT \
+        P.PARAMETERID KEY, \
+        P.GERMANNAME || '  ['|| P.UNIT ||']' VALUE, \
+        P.GERMANNAME \
+    FROM MEDIAN.PARAMETER P, \
+         MEDIAN.MESHVECTORVALUE MVV, \
+         MEDIAN.MESH M \
+   WHERE M.OBJECTID = ? AND \
+          MVV.PARTID >= M.PARTIDMIN AND \
+          MVV.PARTID <= M.PARTIDMAX AND \
+          MVV.PARAMETERID = P.PARAMETERID \
+    ORDER BY P.GERMANNAME
+
+timeseries_mesh_interval_vector=SELECT /*+ parallel(TIMEVALUE,5) */ \
+        MIN(TIMEVALUE) MIN, \
+        MAX(TIMEVALUE) MAX \
+    FROM MEDIAN.MESHVECTORVALUE MVV, \
+         MEDIAN.MESH M \
+    WHERE M.OBJECTID = ? AND \
+          MVV.PARTID >= M.PARTIDMIN AND \
+          MVV.PARTID <= M.PARTIDMAX AND \
+          MVV.PARAMETERID IN (?)
+
+timeseries_mesh_chart_data_vector =SELECT /*+ parallel(TIMEVALUE,10) */ \
+        MVV.TIMEVALUE XORDINATE, \
+        MVV.XCOMPONENT, \
+        MVV.YCOMPONENT, \
+        MVV.ZCOMPONENT, \
+        MVV.SPEED, \
+        MVV.DIRECTION, \
+        MVV.PARAMETERID GROUP1, \
+        MVV.FEATUREID GROUP2, \
+        MP.FEATUREID GROUP3, \
+        -1 GAPID \
+    FROM MEDIAN.MESHCURRENTVALUE MVV, \
+         MEDIAN.MESHPOINT MP, \
+         MEDIAN.MESH M \
+    WHERE (M.OBJECTID = ? AND \
+           MVV.PARTID >= M.PARTIDMIN AND \
+           MVV.PARTID <= M.PARTIDMAX ) AND \
+          MVV.FEATUREID = MP.FEATUREID AND \
+          MVV.PARAMETERID in ( ? ) AND \
+          MP.FEATUREID in ( ? ) AND \
+          MVV.TIMEVALUE >= ? AND \
+          MVV.TIMEVALUE <= ? \
+    ORDER BY MP.FEATUREID, \
+             MVV.FEATUREID, \
+             MVV.PARAMETERID, \
+             MVV.TIMEVALUE
+
+timeseries_mesh_odv_data_vector = SELECT /*+ parallel(timevalue,10) */ \
+        SI.NAME CRUISE, \
+        M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
+        '*' TYPE, \
+        ST_ASTEXT(SHAPE), \
+        0 BOTDEPTH, \
+        (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
+        MVV.TIMEVALUE, \
+        MVV.XCOMPONENT, \
+        MVV.YCOMPONENT, \
+        MVV.ZCOMPONENT, \
+        MVV.SPEED, \
+        MVV.DIRECTION, \
+        MVV.PARAMETERID PARAMETER, \
+        '1' QF \
+    FROM MEDIAN.MESHCURRENTVALUE MVV, \
+         MEDIAN.MESHPOINT, \
+         MEDIAN.MESH M, \
+         MEDIAN.SOURCEINFO SI, \
+         MEDIAN.MESHLAYER ML \
+    WHERE (M.OBJECTID = ? AND \
+           MVV.PARTID >= M.PARTIDMIN AND \
+           MVV.PARTID <= M.PARTIDMAX ) AND \
+          M.SOURCEID = SI.SOURCEID AND \
+          ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \
+          ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \
+          MVV.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \
+          MVV.PARAMETERID in (? ) AND \
+          MEDIAN.MESHPOINT.FEATUREID in ( ? ) AND \
+          MVV.TIMEVALUE >= ? AND \
+          MVV.TIMEVALUE <= ? \
+    ORDER BY MEDIAN.MESHPOINT.FEATUREID, \
+             MVV.FEATUREID, \
+             MVV.TIMEVALUE, \
+             MVV.PARAMETERID
 
 #############################################
 #############################################
@@ -456,8 +548,7 @@
               TSV.TIMESERIESID, \
               TSV.TIMEVALUE, \
               TS.PARAMETERID
-              
-             
+
 #############################################
 #############################################
 ########## Vertikalprofil Mesh ##############

http://dive4elements.wald.intevation.org