# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1274435198 0
# Node ID 3fe08ea3f2b6846700e67f24038289ffa080e42d
# Parent  461d4489705c008ab6d18fa0e1ff3838f6f731ff
Added queries for meshes using vectorvalues for verticalprofiles.

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

diff -r 461d4489705c -r 3fe08ea3f2b6 gnv-artifacts/ChangeLog
--- a/gnv-artifacts/ChangeLog	Fri May 21 09:16:59 2010 +0000
+++ b/gnv-artifacts/ChangeLog	Fri May 21 09:46:38 2010 +0000
@@ -1,3 +1,8 @@
+2010-05-21  Tim Englich  <tim.englich@intevation.de>
+
+	* doc/conf/queries.properties: 
+	  Added queries for meshes using vectorvalues for verticalprofiles.
+
 2010-05-21  Ingo Weinzierl <ingo.weinzierl@intevation.de>
 
 	  Issue269
diff -r 461d4489705c -r 3fe08ea3f2b6 gnv-artifacts/doc/conf/queries.properties
--- a/gnv-artifacts/doc/conf/queries.properties	Fri May 21 09:16:59 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Fri May 21 09:46:38 2010 +0000
@@ -731,7 +731,133 @@
     order by msv.TIMEVALUE, \
              ml.UPPERZLOCATION, \
              msv.PARAMETERID
+
+#############################################
+#############################################
+########## Vertikalprofil Mesh ##############
+##########     Vektordaten     ##############
+#############################################
+#############################################
+
+verticalprofile_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
+
+verticalprofile_mesh_year_vector= SELECT DISTINCT \
+        to_char(MVV.TIMEVALUE,'YYYY') KEY, \
+        to_char(MVV.TIMEVALUE,'YYYY') VALUE \
+    FROM MEDIAN.MESHVECTORVALUE MVV, \
+         MEDIAN.MESH M \
+    WHERE M.OBJECTID = ?  AND \
+          MVV.PARTID >= M.PARTIDMIN AND \
+          MVV.PARTID <= M.PARTIDMAX AND \
+          MVV.PARAMETERID in (?) \
+    ORDER BY to_char(MVV.TIMEVALUE, 'YYYY')
+          
+verticalprofile_mesh_date_vector= SELECT DISTINCT \
+        MVV.TIMEVALUE KEY, \
+        MVV.TIMEVALUE VALUE \
+    FROM MEDIAN.MESHVECTORVALUE MVV, \
+         MEDIAN.MESH M \
+    WHERE M.OBJECTID = ?  AND \
+          MVV.PARTID >= M.PARTIDMIN AND \
+          MVV.PARTID <= M.PARTIDMAX AND \
+          MVV.PARAMETERID in (?) AND \
+          to_char(MVV.TIMEVALUE,'YYYY') in (?) \
+    ORDER BY MVV.TIMEVALUE
+
+verticalprofile_mesh_chart_data_vector=SELECT ML.UPPERZLOCATION XORDINATE, \
+           MP.KPOSITION KPOSITION, \
+           MVV.XCOMPONENT, \
+           MVV.YCOMPONENT, \
+           MVV.ZCOMPONENT, \
+           MVV.SPEED, \
+           MVV.DIRECTION, \
+           MVV.PARAMETERID GROUP1, \
+           MVV.TIMEVALUE GROUP2, \
+           1 GROUP3, \
+           2 DATAID, \
+           MP.FEATUREID, \
+           MP.MESHID \
+    from MEDIAN.MESHLAYER ML, \
+         MEDIAN.MESHPOINT MP, \
+         MEDIAN.MESH M, \
+         MEDIAN.MESHCURRENTVALUE MVV \
+    where MVV.FEATUREID = MP. FEATUREID AND \
+          ML.KPOSITION = MP.KPOSITION AND \
+          ML.MESHID = MP.MESHID AND \
+          M.MESHID = MP.MESHID AND \
+          M.PARTIDMIN <= MVV.PARTID AND \
+          M.PARTIDMAX >= MVV.PARTID AND \
+          MVV.PARAMETERID IN (?) AND \
+          MVV.TIMEVALUE IN (?) AND \
+          M.OBJECTID = ? AND \
+          MP.FEATUREID IN \
+            ( SELECT FEATUREID \
+              FROM MEDIAN.MESHPOINT MP, \
+                   MEDIAN.MESH M \
+              WHERE M.OBJECTID = ? AND \
+                    MP.MESHID = M.MESHID  AND \
+                    IPOSITION = (SELECT IPOSITION FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?) AND \
+                    JPOSITION = (SELECT JPOSITION FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?)) AND \
+          MP.KPOSITION <= ? AND \
+          MP.KPOSITION >= ? \
+   ORDER BY MVV.PARAMETERID, \
+            MVV.TIMEVALUE, \
+            ML.UPPERZLOCATION
             
+verticalprofile_mesh_odv_data_vector=SELECT 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.XCOMPONENT, \
+        MVV.YCOMPONENT, \
+        MVV.ZCOMPONENT, \
+        MVV.SPEED, \
+        MVV.DIRECTION, \
+        MVV.PARAMETERID PARAMETER, \
+        MVV.TIMEVALUE , \
+        '1' QF \
+    FROM MEDIAN.MESHLAYER ML, \
+         MEDIAN.MESHPOINT, \
+         MEDIAN.MESH M, \
+         MEDIAN.MESHCURRENTVALUE MVV, \
+         MEDIAN.SOURCEINFO SI \
+    WHERE M.SOURCEID = SI.SOURCEID AND \
+          MVV.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
+          ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \
+          ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \
+          M.MESHID = MEDIAN.MESHPOINT.MESHID AND \
+          M.PARTIDMIN <= MVV.PARTID AND \
+          M.PARTIDMAX >= MVV.PARTID AND \
+          MVV.PARAMETERID IN (?) AND \
+          MVV.TIMEVALUE IN (?) AND \
+          M.OBJECTID = ? AND \
+          MEDIAN.MESHPOINT.FEATUREID IN \
+                          ( SELECT FEATUREID \
+                            FROM MEDIAN.MESHPOINT MP, \
+                                 MEDIAN.MESH M \
+                            WHERE M.OBJECTID = ? AND \
+                                  MP.MESHID = M.MESHID  AND \
+                                  IPOSITION = (SELECT IPOSITION FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?) AND \
+                                  JPOSITION = (SELECT JPOSITION FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?)) AND \
+          MEDIAN.MESHPOINT.KPOSITION <= ? AND \
+          MEDIAN.MESHPOINT.KPOSITION >= ? \
+    ORDER BY MVV.TIMEVALUE, \
+             ML.UPPERZLOCATION, \
+             MVV.PARAMETERID
+
 #############################################
 #############################################
 ##### Vertikalprofil InstantaneousPoint #####