Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 346:8f168e12a963
Added Z-Value to verticalcrosssection_mesh_chart_data.
gnv-artifacts/trunk@414 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 11 Dec 2009 10:13:39 +0000 |
| parents | c94936b1f4ba |
| children | 24c21a720aa5 |
comparison
equal
deleted
inserted
replaced
| 345:c16c622ba2f3 | 346:8f168e12a963 |
|---|---|
| 900 msv.PARTID >= m.PARTIDMIN AND \ | 900 msv.PARTID >= m.PARTIDMIN AND \ |
| 901 msv.PARTID <= m.PARTIDMAX AND \ | 901 msv.PARTID <= m.PARTIDMAX AND \ |
| 902 msv.PARAMETERID = ? \ | 902 msv.PARAMETERID = ? \ |
| 903 order by msv.TIMEVALUE | 903 order by msv.TIMEVALUE |
| 904 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ | 904 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ |
| 905 ((ml.UPPERZLOCATION + ml.LOWERZLOCATION) / 2) Z, \ | |
| 905 msv.DATAVALUE YORDINATE, \ | 906 msv.DATAVALUE YORDINATE, \ |
| 906 msv.PARAMETERID GROUP1, \ | 907 msv.PARAMETERID GROUP1, \ |
| 907 msv.TIMEVALUE GROUP2, \ | 908 msv.TIMEVALUE GROUP2, \ |
| 908 MEDIAN.MESHPOINT.JPOSITION, \ | 909 MEDIAN.MESHPOINT.JPOSITION, \ |
| 909 MEDIAN.MESHPOINT.IPOSITION, \ | 910 MEDIAN.MESHPOINT.IPOSITION, \ |