diff gnv-artifacts/doc/conf/queries.properties @ 1101:e38f93d64253

A depth in an odv export has a negative value now (issue230). gnv-artifacts/trunk@1227 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Mon, 28 Jun 2010 09:33:11 +0000
parents fb2d07f7a5ae
children 19813e72ec06
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties	Mon Jun 28 07:24:21 2010 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Mon Jun 28 09:33:11 2010 +0000
@@ -523,7 +523,7 @@
             '*' TYPE, \
             ST_ASTEXT(SHAPE), \
             0 BOTDEPTH, \
-            (M.ZLOCATION *-1) DEPTH, \
+            (M.ZLOCATION) DEPTH, \
             TSV.TIMEVALUE, \
             TSV.DATAVALUE, \
             TS.PARAMETERID PARAMETER, \
@@ -637,7 +637,7 @@
             '*' TYPE, \
             ST_ASTEXT(SHAPE), \
             0 BOTDEPTH, \
-            (M.ZLOCATION *-1) DEPTH, \
+            (M.ZLOCATION) DEPTH, \
             TVV.TIMEVALUE, \
             TVV.XCOMPONENT, \
             TVV.YCOMPONENT, \
@@ -816,7 +816,7 @@
         '*' TYPE, \
         ST_ASTEXT(SHAPE), \
         0 BOTDEPTH, \
-        (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
+        (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)) DEPTH, \
         msv.DATAVALUE, \
         msv.PARAMETERID PARAMETER, \
         msv.TIMEVALUE , \
@@ -938,7 +938,7 @@
         '*' TYPE, \
         ST_ASTEXT(SHAPE), \
         0 BOTDEPTH, \
-        (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
+        (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)) DEPTH, \
         MVV.XCOMPONENT, \
         MVV.YCOMPONENT, \
         MVV.ZCOMPONENT, \
@@ -1123,7 +1123,7 @@
         '*' TYPE, \
         ST_ASTEXT(SHAPE), \
         0 BOTDEPTH, \
-        (M.ZLOCATION * -1) DEPTH, \
+        (M.ZLOCATION) DEPTH, \
         MSV.DATAVALUE, \
         MSV.PARAMETERID PARAMETER, \
         MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE , \

http://dive4elements.wald.intevation.org