diff gnv-artifacts/doc/conf/queries.properties @ 1059:174f6eacd595

Added queries for TimeSeriesPoints using vectorvalues for verticalprofiles gnv-artifacts/trunk@1138 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Mon, 31 May 2010 08:20:17 +0000
parents 04967dc9c83f
children 9bb1979aabbe
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Fri May 28 07:37:59 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Mon May 31 08:20:17 2010 +0000
@@ -551,6 +551,124 @@
 
 #############################################
 #############################################
+##########   Vertikalprofil    ##############
+##########     Vektordaten     ##############
+#############################################
+#############################################
+
+verticalprofile_parameter_vector=SELECT DISTINCT \
+           P.PARAMETERID KEY, \
+           P.GERMANNAME || '  ['|| P.UNIT ||']' VALUE, \
+           P.GERMANNAME \
+    from MEDIAN.PARAMETER P, \
+           MEDIAN.TIMESERIES TS, \
+           MEDIAN.TIMESERIESVECTORVALUE TVV, \
+           MEDIAN.MEASUREMENT M \
+    where TS.PARAMETERID = P.PARAMETERID AND \
+          TS.TIMESERIESID = TVV.TIMESERIESID AND \
+          M.MEASUREMENTID = TVV.MEASUREMENTID AND \
+          M.FEATUREID = ? \
+    ORDER BY P.GERMANNAME
+
+verticalprofile_minmaxdepth_vector= SELECT MIN(M.ZLOCATION) MIN, \
+           MAX(M.ZLOCATION) MAX \
+    FROM MEDIAN.MEASUREMENT M, \
+         MEDIAN.TIMESERIES TS, \
+         MEDIAN.TIMESERIESVECTORVALUE TVV \
+    WHERE TS.TIMESERIESID = TVV.TIMESERIESID AND \
+          M.MEASUREMENTID = TVV.MEASUREMENTID AND \
+          M.FEATUREID = ? AND \
+          TS.PARAMETERID = ? 
+
+verticalprofile_year_vector=SELECT DISTINCT \
+        TO_CHAR(TVV.TIMEVALUE,'YYYY') KEY, \
+        TO_CHAR(TVV.TIMEVALUE,'YYYY') VALUE \
+    FROM MEDIAN.TIMESERIES TS, \
+         MEDIAN.TIMESERIESVECTORVALUE TVV, \
+         MEDIAN.MEASUREMENT M \
+    WHERE TS.TIMESERIESID = TVV.TIMESERIESID AND \
+          M.MEASUREMENTID = TVV.MEASUREMENTID AND \
+          M.FEATUREID = ? AND \
+          TS.PARAMETERID = ? \
+    ORDER BY to_char(TVV.TIMEVALUE,'YYYY')
+
+verticalprofile_date_vector=SELECT DISTINCT \
+           TVV.TIMEVALUE KEY, \
+           TVV.TIMEVALUE VALUE \
+    from MEDIAN.TIMESERIES TS, \
+         MEDIAN.TIMESERIESVECTORVALUE TVV, \
+         MEDIAN.MEASUREMENT M \
+    WHERE TS.TIMESERIESID = TVV.TIMESERIESID AND \
+          M.MEASUREMENTID = TVV.MEASUREMENTID AND \
+          M.FEATUREID = ? AND \
+          TS.PARAMETERID = ? AND \
+          TO_CHAR(TVV.TIMEVALUE,'YYYY') IN (?) \
+    ORDER BY TVV.TIMEVALUE 
+
+verticalprofile_chart_data_vector= SELECT M.ZLOCATION XORDINATE, \
+           TS.PARAMETERID GROUP1, \
+           TVV.TIMEVALUE, \
+           TVV.XCOMPONENT, \
+           TVV.YCOMPONENT, \
+           TVV.ZCOMPONENT, \
+           TVV.SPEED, \
+           TVV.DIRECTION, \
+           1 GROUP3, \
+           1 DATAID, \
+           M.FEATUREID, \
+           TS.TIMESERIESID \
+    FROM MEDIAN.TIMESERIES TS, \
+         MEDIAN.TIMESERIESFULLVECTORVALUE TVV, \
+         MEDIAN.MEASUREMENT M \
+    WHERE TS.TIMESERIESID = TVV.TIMESERIESID AND \
+          M.MEASUREMENTID = TVV.MEASUREMENTID AND \
+          M.FEATUREID = ? AND \
+          TS.PARAMETERID = ? AND \
+          TVV.TIMEVALUE = ? AND \
+          M.ZLOCATION >= ? AND \
+          M.ZLOCATION <= ? \
+    ORDER BY TVV.TIMEVALUE, \
+             TVV.TIMESERIESID, \
+             TS.PARAMETERID, \
+             TVV.TIMEVALUE
+
+verticalprofile_odv_data_vector = SELECT SI.NAME CRUISE, \
+            MEDIAN.TIMESERIESPOINT.NAME STATION, \
+            '*' TYPE, \
+            ST_ASTEXT(SHAPE), \
+            0 BOTDEPTH, \
+            (M.ZLOCATION *-1) DEPTH, \
+            TVV.TIMEVALUE, \
+            TVV.XCOMPONENT, \
+            TVV.YCOMPONENT, \
+            TVV.ZCOMPONENT, \
+            TVV.SPEED, \
+            TVV.DIRECTION, \
+            TS.PARAMETERID PARAMETER, \
+            TVV.MEASUREMENTID, \
+            TVV.TIMESERIESID, \
+            '1' QF \
+     FROM MEDIAN.TIMESERIESPOINT, \
+           MEDIAN.TIMESERIESFULLVECTORVALUE TVV, \
+          MEDIAN.TIMESERIES TS, \
+          MEDIAN.MEASUREMENT M, \
+          MEDIAN.SOURCEINFO SI \
+     WHERE SI.SOURCEID = M.SOURCEID AND \
+           M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \
+           M.MEASUREMENTID = TVV.MEASUREMENTID AND \
+           TVV.TIMESERIESID = TS.TIMESERIESID AND \
+           M.FEATUREID = ? AND \
+           TS.PARAMETERID = ? AND \
+           TVV.TIMEVALUE = ? AND \
+           M.ZLOCATION >= ? AND \
+           M.ZLOCATION <= ? \
+     ORDER BY TVV.MEASUREMENTID, \
+              TVV.TIMESERIESID, \
+              TVV.TIMEVALUE, \
+              TS.PARAMETERID
+
+#############################################
+#############################################
 ########## Vertikalprofil Mesh ##############
 #############################################
 #############################################

http://dive4elements.wald.intevation.org