Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
217:3dcd2b0b456e | 218:926530bda1a7 |
---|---|
617 msv.PARTID >= m.PARTIDMIN AND \ | 617 msv.PARTID >= m.PARTIDMIN AND \ |
618 msv.PARTID <= m.PARTIDMAX AND \ | 618 msv.PARTID <= m.PARTIDMAX AND \ |
619 msv.PARAMETERID = ? \ | 619 msv.PARAMETERID = ? \ |
620 order by msv.TIMEVALUE | 620 order by msv.TIMEVALUE |
621 | 621 |
622 horizontalcrosssection_mesh_data = Select 1 from dual; | 622 horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \ |
623 MSV.DATAVALUE YORDINATE, \ | |
624 MEDIAN.MESHFACE.JPOSITION, \ | |
625 MEDIAN.MESHFACE.IPOSITION, \ | |
626 MEDIAN.MESHFACE.KPOSITION \ | |
627 from MEDIAN.MESHLAYER ML, \ | |
628 MEDIAN.MESHFACE, \ | |
629 MEDIAN.MESH M, \ | |
630 MEDIAN.MESHSCALARVALUE MSV \ | |
631 where MSV.FEATUREID = MEDIAN.MESHFACE.FEATUREID AND \ | |
632 ML.KPOSITION = MEDIAN.MESHFACE.KPOSITION and \ | |
633 ML.MESHID = MEDIAN.MESHFACE.MESHID and \ | |
634 M.MESHID = MEDIAN.MESHFACE.MESHID AND \ | |
635 M.PARTIDMIN <= MSV.PARTID AND \ | |
636 M.PARTIDMAX >= MSV.PARTID AND \ | |
637 MSV.PARAMETERID = ? AND \ | |
638 MSV.TIMEVALUE = ? AND \ | |
639 M.OBJECTID = ? AND \ | |
640 MEDIAN.MESHFACE.KPOSITION = ? \ | |
641 order by MEDIAN.MESHFACE.JPOSITION , \ | |
642 MEDIAN.MESHFACE.IPOSITION |