# HG changeset patch
# User Ingo Weinzierl <ingo.weinzierl@intevation.de>
# Date 1277717591 0
# Node ID e38f93d6425391326bd8054968c5f15bcf63852b
# Parent  2e50dfd45753781ffdd12a70492232252dbb4ffd
A depth in an odv export has a negative value now (issue230).

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

diff -r 2e50dfd45753 -r e38f93d64253 gnv-artifacts/ChangeLog
--- a/gnv-artifacts/ChangeLog	Mon Jun 28 07:24:21 2010 +0000
+++ b/gnv-artifacts/ChangeLog	Mon Jun 28 09:33:11 2010 +0000
@@ -1,3 +1,10 @@
+2010-06-28  Ingo Weinzierl <ingo.weinzierl@intevation.de>
+
+	  Issue230
+
+	* doc/conf/queries.properties: Removed multiplication of depth value with
+	  factor -1 for odv queries on vertical profiles.
+
 2010-06-28  Ingo Weinzierl <ingo.weinzierl@intevation.de>
 
 	  Issue300
diff -r 2e50dfd45753 -r e38f93d64253 gnv-artifacts/doc/conf/queries.properties
--- 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 , \