Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 218:926530bda1a7
Integrated the OutputTransition for Horizontal Cross-Sections
gnv-artifacts/trunk@278 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 30 Oct 2009 11:26:03 +0000 |
| parents | 3dcd2b0b456e |
| children | 05663e307495 |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Thu Oct 29 15:58:47 2009 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Fri Oct 30 11:26:03 2009 +0000 @@ -619,4 +619,24 @@ msv.PARAMETERID = ? \ order by msv.TIMEVALUE -horizontalcrosssection_mesh_data = Select 1 from dual; \ No newline at end of file +horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \ + MSV.DATAVALUE YORDINATE, \ + MEDIAN.MESHFACE.JPOSITION, \ + MEDIAN.MESHFACE.IPOSITION, \ + MEDIAN.MESHFACE.KPOSITION \ + from MEDIAN.MESHLAYER ML, \ + MEDIAN.MESHFACE, \ + MEDIAN.MESH M, \ + MEDIAN.MESHSCALARVALUE MSV \ + where MSV.FEATUREID = MEDIAN.MESHFACE.FEATUREID AND \ + ML.KPOSITION = MEDIAN.MESHFACE.KPOSITION and \ + ML.MESHID = MEDIAN.MESHFACE.MESHID and \ + M.MESHID = MEDIAN.MESHFACE.MESHID AND \ + M.PARTIDMIN <= MSV.PARTID AND \ + M.PARTIDMAX >= MSV.PARTID AND \ + MSV.PARAMETERID = ? AND \ + MSV.TIMEVALUE = ? AND \ + M.OBJECTID = ? AND \ + MEDIAN.MESHFACE.KPOSITION = ? \ + order by MEDIAN.MESHFACE.JPOSITION , \ + MEDIAN.MESHFACE.IPOSITION \ No newline at end of file