changeset 184:5d050f6de41d

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
author Tim Englich <tim.englich@intevation.de>
date Fri, 16 Oct 2009 09:31:25 +0000
parents 3e4256a6b48b
children 5fc8f41669a6
files gnv-artifacts/ChangeLog gnv-artifacts/src/test/ressources/queries.properties
diffstat 2 files changed, 7 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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
 	  
--- 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 \

http://dive4elements.wald.intevation.org