Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/src/test/ressources/queries.properties @ 197:bab92ad1165d
Added the required Classes an Configuration for providing VerticalCrossSections
gnv-artifacts/trunk@250 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 20 Oct 2009 13:32:05 +0000 |
| parents | 60c61f323f16 |
| children |
comparison
equal
deleted
inserted
replaced
| 196:60c61f323f16 | 197:bab92ad1165d |
|---|---|
| 499 MEDIAN.MESHPOINT.KPOSITION, \ | 499 MEDIAN.MESHPOINT.KPOSITION, \ |
| 500 msv.PARAMETERID, \ | 500 msv.PARAMETERID, \ |
| 501 MEDIAN.MESHPOINT.JPOSITION , \ | 501 MEDIAN.MESHPOINT.JPOSITION , \ |
| 502 MEDIAN.MESHPOINT.IPOSITION | 502 MEDIAN.MESHPOINT.IPOSITION |
| 503 | 503 |
| 504 | |
| 505 ############################################# | |
| 506 ############################################# | |
| 507 ########### Profilschnitt MESH ########### | |
| 508 ############################################# | |
| 509 ############################################# | |
| 510 verticalcrosssection_mesh_date = select distinct \ | |
| 511 msv.TIMEVALUE KEY, \ | |
| 512 msv.TIMEVALUE VALUE \ | |
| 513 from MEDIAN.MESHSCALARVALUE msv , \ | |
| 514 MEDIAN.MESH m \ | |
| 515 where m.OBJECTID = ? AND \ | |
| 516 msv.PARTID >= m.PARTIDMIN AND \ | |
| 517 msv.PARTID <= m.PARTIDMAX AND \ | |
| 518 msv.PARAMETERID = ? \ | |
| 519 order by msv.TIMEVALUE | |
| 520 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ | |
| 521 msv.DATAVALUE YORDINATE, \ | |
| 522 msv.PARAMETERID GROUP1, \ | |
| 523 msv.TIMEVALUE GROUP2, \ | |
| 524 MEDIAN.MESHPOINT.JPOSITION, \ | |
| 525 MEDIAN.MESHPOINT.IPOSITION, \ | |
| 526 MEDIAN.MESHPOINT.KPOSITION \ | |
| 527 from MEDIAN.MESHLAYER ml, \ | |
| 528 MEDIAN.MESHPOINT , \ | |
| 529 MEDIAN.MESH m, \ | |
| 530 MEDIAN.MESHSCALARVALUE msv \ | |
| 531 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ | |
| 532 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ | |
| 533 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ | |
| 534 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 535 m.PARTIDMIN <= msv.PARTID AND \ | |
| 536 m.PARTIDMAX >= msv.PARTID AND \ | |
| 537 msv.PARAMETERID = ? AND \ | |
| 538 msv.TIMEVALUE = ? AND \ | |
| 539 m.OBJECTID = ? AND \ | |
| 540 MEDIAN.MESHPOINT.FEATUREID in \ | |
| 541 ( select FEATUREID \ | |
| 542 from MEDIAN.MESHPOINT mp, \ | |
| 543 MEDIAN.MESH m \ | |
| 544 where m.OBJECTID = ? AND \ | |
| 545 mp.MESHID = m.MESHID AND \ | |
| 546 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ | |
| 547 order by msv.TIMEVALUE, \ | |
| 548 msv.PARAMETERID, \ | |
| 549 MEDIAN.MESHPOINT.JPOSITION , \ | |
| 550 MEDIAN.MESHPOINT.IPOSITION, \ | |
| 551 MEDIAN.MESHPOINT.KPOSITION | |
| 552 |