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

http://dive4elements.wald.intevation.org