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 |