diff gnv-artifacts/doc/conf/queries.properties @ 1042:07b829c06981

Integrated View MEDIAN.TIMESERIESFULLVECTORVALUE in queries for vector data on timeSeriesPoints gnv-artifacts/trunk@1114 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 21 May 2010 07:54:01 +0000
parents da4306683186
children d955571cdf2a
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Thu May 20 09:47:19 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Fri May 21 07:54:01 2010 +0000
@@ -175,13 +175,13 @@
         tsv.XCOMPONENT, \
         tsv.YCOMPONENT, \
         tsv.ZCOMPONENT, \
-        1 SPEED, \
-        1 DIRECTION, \
+        tsv.SPEED, \
+        tsv.DIRECTION, \
         t.PARAMETERID GROUP1, \
         tsv.MEASUREMENTID GROUP2, \
         tsv.TIMESERIESID GROUP3, \
         t.TIMEINTERVAL GAPID \
-    FROM MEDIAN.TIMESERIESVECTORVALUE tsv, \
+    FROM MEDIAN.TIMESERIESFULLVECTORVALUE tsv, \
          MEDIAN.TIMESERIES t \
     WHERE tsv.TIMESERIESID = t.TIMESERIESID AND \
           t.PARAMETERID = ? AND \
@@ -203,14 +203,14 @@
             TSV.XCOMPONENT, \
             TSV.YCOMPONENT, \
             TSV.ZCOMPONENT, \
-            1 SPEED, \
-            1 DIRECTION, \
+            TSV.SPEED, \
+            TSV.DIRECTION, \
             TS.PARAMETERID PARAMETER, \
             TSV.MEASUREMENTID, \
             TSV.TIMESERIESID, \
             '1' QF \
      FROM MEDIAN.TIMESERIESPOINT, \
-          MEDIAN.TIMESERIESVECTORVALUE TSV, \
+          MEDIAN.TIMESERIESFULLVECTORVALUE TSV, \
           MEDIAN.TIMESERIES TS, \
           MEDIAN.MEASUREMENT M, \
           MEDIAN.SOURCEINFO SI \

http://dive4elements.wald.intevation.org