# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1255685485 0
# Node ID 5d050f6de41d8982c5d97e837dc43f2dcf069e6e
# Parent  3e4256a6b48b18eec5c696e90a2bb17beae016a8
The Levelnumber of Meshes will also be visualized in the choose of depth GT_0020.0020

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

diff -r 3e4256a6b48b -r 5d050f6de41d gnv-artifacts/ChangeLog
--- a/gnv-artifacts/ChangeLog	Fri Oct 16 08:44:09 2009 +0000
+++ b/gnv-artifacts/ChangeLog	Fri Oct 16 09:31:25 2009 +0000
@@ -1,5 +1,10 @@
 2009-10-16  Tim Englich  <tim.englich@intevation.de>
 
+	* src/test/ressources/queries.properties:
+	  The Levelnumber of Meshes will also be visualized in the choose of depth GT_0020.0020
+
+2009-10-16  Tim Englich  <tim.englich@intevation.de>
+	
 	* src/test/ressources/conf.xml: 
 	  Added Coordinate-Values to Title of the TimeseriesDiagramm for Meshes
 	  
diff -r 3e4256a6b48b -r 5d050f6de41d gnv-artifacts/src/test/ressources/queries.properties
--- a/gnv-artifacts/src/test/ressources/queries.properties	Fri Oct 16 08:44:09 2009 +0000
+++ b/gnv-artifacts/src/test/ressources/queries.properties	Fri Oct 16 09:31:25 2009 +0000
@@ -105,7 +105,7 @@
          INTERSECTS(SHAPE,"?")
 
 timeseries_meshpoint_depth = select mp.FEATUREID KEY, \
-        -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \
+        mp.KPOSITION || ' ( '|| -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION || ' )' as VALUE \
     from MEDIAN.MESHLAYER ml, \
          MEDIAN.MESHPOINT mp \
     where ml.KPOSITION = mp.KPOSITION and \
@@ -450,7 +450,7 @@
 #############################################
 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
          mp.KPOSITION KEY, \
-        -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \
+         mp.KPOSITION || ' ( '||-ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION || ' ) ' VALUE \
     from MEDIAN.MESHLAYER ml, \
          MEDIAN.MESHPOINT mp \
     where ml.KPOSITION = mp.KPOSITION and \