# HG changeset patch
# User Tim Englich <tim.englich@intevation.de>
# Date 1260526419 0
# Node ID 8f168e12a96304324a4143bbb9ed5eebb673742a
# Parent  c16c622ba2f3bfa84a97cdba715b22cd1794a688
Added Z-Value to verticalcrosssection_mesh_chart_data.

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

diff -r c16c622ba2f3 -r 8f168e12a963 gnv-artifacts/ChangeLog
--- a/gnv-artifacts/ChangeLog	Fri Dec 11 10:02:10 2009 +0000
+++ b/gnv-artifacts/ChangeLog	Fri Dec 11 10:13:39 2009 +0000
@@ -1,5 +1,9 @@
 2009-12-11  Tim Englich  <tim.englich@intevation.de>
 
+	* doc/conf/queries.properties: 
+	  Added Z-Value to verticalcrosssection_mesh_chart_data.
+
+2009-12-11  Tim Englich  <tim.englich@intevation.de>	
     * src/test/java/de/intevation/gnv/artifacts/GNVArtifactsTestCaseBase.java,
       src/test/java/de/intevation/gnv/artifacts/InstantaneousPointHorizontalProfileTestCase.java, 
       src/test/java/de/intevation/gnv/artifacts/InstantaneousPointVerticalProfileTestCase.java, 
diff -r c16c622ba2f3 -r 8f168e12a963 gnv-artifacts/doc/conf/queries.properties
--- a/gnv-artifacts/doc/conf/queries.properties	Fri Dec 11 10:02:10 2009 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Fri Dec 11 10:13:39 2009 +0000
@@ -902,6 +902,7 @@
           msv.PARAMETERID = ? \
     order by msv.TIMEVALUE
 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
+           ((ml.UPPERZLOCATION  + ml.LOWERZLOCATION) / 2) Z, \
            msv.DATAVALUE YORDINATE, \
            msv.PARAMETERID GROUP1, \
            msv.TIMEVALUE GROUP2, \