diff gnv-artifacts/doc/conf/queries.properties @ 1046:026f89df4091

Added queries for meshes using vectorvalues for horizontalprofiles. gnv-artifacts/trunk@1118 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 21 May 2010 10:54:29 +0000
parents 3fe08ea3f2b6
children 05ab74539ed3
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Fri May 21 09:46:38 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Fri May 21 10:54:29 2010 +0000
@@ -1376,7 +1376,99 @@
             MEDIAN.MESHPOINT.JPOSITION, \
             MEDIAN.MESHPOINT.IPOSITION, \
             msv.PARAMETERID
-            
+
+#############################################
+#############################################
+########### Horizontalprofil MESH ###########
+###########      Vektordaten      ###########
+#############################################
+#############################################
+
+horizontalprofile_mesh_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, \
+           MEDIAN.MESHPOINT.MESHID \
+    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 \
+          MEDIAN.MESHPOINT.FEATUREID IN \
+            ( SELECT FEATUREID \
+              from MEDIAN.MESHPOINT MP, \
+                   MEDIAN.MESH M \
+              where M.OBJECTID = ? AND \
+                    MP.MESHID = M.MESHID  AND \
+                    KPOSITION IN ( ? ) AND \
+                    ? = (SELECT ? FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?)) \
+   ORDER BY MVV.TIMEVALUE, \
+            MEDIAN.MESHPOINT.KPOSITION, \
+            MVV.PARAMETERID, \
+            MEDIAN.MESHPOINT.JPOSITION, \
+            MEDIAN.MESHPOINT.IPOSITION
+
+horizontalprofile_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, \
+          MEDIAN.MESHPOINT.JPOSITION, \
+          MEDIAN.MESHPOINT.IPOSITION , \
+          '1' QF \
+    from MEDIAN.MESHLAYER ML, \
+         MEDIAN.MESHPOINT, \
+         MEDIAN.MESH M, \
+         MEDIAN.MESHCURRENTVALUE MVV, \
+         MEDIAN.SOURCEINFO SI \
+    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.SOURCEID = SI.SOURCEID AND \
+          M.PARTIDMIN <= MVV.PARTID AND \
+          M.PARTIDMAX >= MVV.PARTID AND \
+          MVV.PARAMETERID = ? AND \
+          MVV.TIMEVALUE = ? 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 \
+                    KPOSITION IN ( ? ) AND \
+                    ? = (SELECT ? FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?)) \
+   ORDER BY MVV.TIMEVALUE, \
+            MEDIAN.MESHPOINT.KPOSITION, \
+            MEDIAN.MESHPOINT.JPOSITION, \
+            MEDIAN.MESHPOINT.IPOSITION, \
+            MVV.PARAMETERID
+
 #############################################
 #############################################
 ########### Horizontalprofil MESH ###########

http://dive4elements.wald.intevation.org