# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1274441808 0
# Node ID 05ab74539ed3877e6389a4f96a584442f63d87ef
# Parent  026f89df4091f234edc90610048eadd81ed494ac
Added queries for meshes using vectorvalues for 'Horizontales Schnittprofil'

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

diff -r 026f89df4091 -r 05ab74539ed3 gnv-artifacts/ChangeLog
--- a/gnv-artifacts/ChangeLog	Fri May 21 10:54:29 2010 +0000
+++ b/gnv-artifacts/ChangeLog	Fri May 21 11:36:48 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 "Horizontales Schnittprofil"
+
 2010-05-21  Tim Englich  <tim.englich@intevation.de>
 
 	* doc/conf/queries.properties: 
diff -r 026f89df4091 -r 05ab74539ed3 gnv-artifacts/doc/conf/queries.properties
--- a/gnv-artifacts/doc/conf/queries.properties	Fri May 21 10:54:29 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Fri May 21 11:36:48 2010 +0000
@@ -1531,6 +1531,53 @@
             msv.PARAMETERID, \
             MEDIAN.MESHPOINT.JPOSITION, \
             MEDIAN.MESHPOINT.IPOSITION
+
+#############################################
+#############################################
+########### Horizontalprofil MESH ###########
+###########     Schnittprofil     ###########
+###########      Vektordaten      ###########
+#############################################
+#############################################
+
+horizontalprofile_mesh_cross_chart_data_vector =  SELECT ST_ASTEXT(SHAPE), \
+           MVV.XCOMPONENT, \
+           MVV.YCOMPONENT, \
+           MVV.ZCOMPONENT, \
+           MVV.SPEED, \
+           MVV.DIRECTION, \
+           MVV.PARAMETERID GROUP1, \
+           MEDIAN.MESHPOINT.KPOSITION GROUP2, \
+           MVV.TIMEVALUE GROUP3, \
+           MEDIAN.MESHPOINT.JPOSITION, \
+           MEDIAN.MESHPOINT.IPOSITION, \
+           2 DATAID \
+    FROM MEDIAN.MESHLAYER ML, \
+         MEDIAN.MESHPOINT, \
+         MEDIAN.MESH M, \
+         MEDIAN.MESHCURRENTVALUE MVV \
+    WHERE 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 = ? AND \
+          MVV.TIMEVALUE = ? AND \
+          M.OBJECTID = ? AND \
+          ML.KPOSITION in (?) AND \
+          MEDIAN.MESHPOINT.FEATUREID in \
+              ( \
+               SELECT DISTINCT FEATUREID \
+               FROM MEDIAN.MESHPOINT \
+               WHERE ? \
+               ) \
+    ORDER BY MVV.TIMEVALUE, \
+             MEDIAN.MESHPOINT.KPOSITION, \
+             MVV.PARAMETERID, \
+             MEDIAN.MESHPOINT.JPOSITION, \
+             MEDIAN.MESHPOINT.IPOSITION
+
 #############################################
 #############################################
 ############# Profilschnitt MESH ############