Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 216:9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
gnv-artifacts/trunk@274 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Wed, 28 Oct 2009 16:26:03 +0000 |
| parents | c0a798299efc |
| children | 3dcd2b0b456e |
comparison
equal
deleted
inserted
replaced
| 215:c92a6e0ab79a | 216:9db263ee2678 |
|---|---|
| 542 MEDIAN.MESHPOINT.IPOSITION | 542 MEDIAN.MESHPOINT.IPOSITION |
| 543 | 543 |
| 544 | 544 |
| 545 ############################################# | 545 ############################################# |
| 546 ############################################# | 546 ############################################# |
| 547 ########### Profilschnitt MESH ########### | 547 ############# Profilschnitt MESH ############ |
| 548 ############################################# | 548 ############################################# |
| 549 ############################################# | 549 ############################################# |
| 550 verticalcrosssection_mesh_date = select distinct \ | 550 verticalcrosssection_mesh_date = select distinct \ |
| 551 msv.TIMEVALUE KEY, \ | 551 msv.TIMEVALUE KEY, \ |
| 552 msv.TIMEVALUE VALUE \ | 552 msv.TIMEVALUE VALUE \ |
| 587 order by msv.TIMEVALUE, \ | 587 order by msv.TIMEVALUE, \ |
| 588 msv.PARAMETERID, \ | 588 msv.PARAMETERID, \ |
| 589 MEDIAN.MESHPOINT.JPOSITION , \ | 589 MEDIAN.MESHPOINT.JPOSITION , \ |
| 590 MEDIAN.MESHPOINT.IPOSITION, \ | 590 MEDIAN.MESHPOINT.IPOSITION, \ |
| 591 MEDIAN.MESHPOINT.KPOSITION | 591 MEDIAN.MESHPOINT.KPOSITION |
| 592 | |
| 593 ############################################# | |
| 594 ############################################# | |
| 595 ########## Horizontalschnitt MESH ########### | |
| 596 ############################################# | |
| 597 ############################################# | |
| 598 horizontalcrosssection_meshpoint_depth = SELECT DISTINCT MP.KPOSITION KEY, \ | |
| 599 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \ | |
| 600 from MEDIAN.MESHLAYER ML, \ | |
| 601 MEDIAN.MESHPOINT MP, \ | |
| 602 MEDIAN.MESH M \ | |
| 603 WHERE ML.KPOSITION = MP.KPOSITION AND \ | |
| 604 ML.MESHID = MP.MESHID AND \ | |
| 605 M.OBJECTID = ? AND \ | |
| 606 MP.MESHID = M.MESHID \ | |
| 607 ORDER BY MP.KPOSITION | |
| 608 | |
| 609 horizontalcrosssection_mesh_date = select distinct \ | |
| 610 msv.TIMEVALUE KEY, \ | |
| 611 msv.TIMEVALUE VALUE \ | |
| 612 from MEDIAN.MESHSCALARVALUE msv , \ | |
| 613 MEDIAN.MESH m \ | |
| 614 where m.OBJECTID = ? AND \ | |
| 615 msv.PARTID >= m.PARTIDMIN AND \ | |
| 616 msv.PARTID <= m.PARTIDMAX AND \ | |
| 617 msv.PARAMETERID = ? \ | |
| 618 order by msv.TIMEVALUE | |
| 619 | |
| 620 horizontalcrosssection_mesh_data = Select 1 from dual; |