Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 776:cee3a0c22bb1
Modified the Workflow for Verticalprofiles on Instantaneouspoints so that the Inputvalues of the Mapviewer-Interface take effect.
Also integrated the Regionfilter to this Product
gnv-artifacts/trunk@843 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 26 Mar 2010 15:29:41 +0000 |
| parents | f28a7eac542a |
| children | feeaf5aec552 |
comparison
equal
deleted
inserted
replaced
| 775:eedad2ddad14 | 776:cee3a0c22bb1 |
|---|---|
| 567 WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \ | 567 WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \ |
| 568 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ | 568 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ |
| 569 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ | 569 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ |
| 570 M.SOURCEID= ? AND \ | 570 M.SOURCEID= ? AND \ |
| 571 INTERSECTS(SHAPE, \ | 571 INTERSECTS(SHAPE, \ |
| 572 (SELECT st_astext(SHAPE) \ | 572 (SELECT st_astext(SHAPE) \ |
| 573 FROM MEDIAN.FEATUREAREA \ | 573 FROM MEDIAN.FEATUREAREA \ |
| 574 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | 574 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
| 575 FEATURECODE = ? )\ | 575 FEATURECODE = ? )\ |
| 576 ) \ | 576 ) \ |
| 577 ORDER BY S.DESCRIPTION | |
| 578 verticalprofile_instantaneouspoint_series_with_wkt = SELECT \ | |
| 579 S.SERIESID KEY, \ | |
| 580 S.DESCRIPTION VALUE \ | |
| 581 FROM MEDIAN.INSTANTANEOUSPOINT, \ | |
| 582 MEDIAN.SERIES S, \ | |
| 583 MEDIAN.MEASUREMENT M \ | |
| 584 WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \ | |
| 585 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ | |
| 586 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ | |
| 587 M.SOURCEID= ? AND \ | |
| 588 INTERSECTS(SHAPE, "?") \ | |
| 577 ORDER BY S.DESCRIPTION | 589 ORDER BY S.DESCRIPTION |
| 578 | 590 |
| 579 verticalprofile_instantaneouspoint_point = SELECT \ | 591 verticalprofile_instantaneouspoint_point = SELECT \ |
| 580 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ | 592 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ |
| 581 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \ | 593 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \ |
| 585 MEDIAN.MEASUREMENT M \ | 597 MEDIAN.MEASUREMENT M \ |
| 586 WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \ | 598 WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \ |
| 587 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ | 599 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ |
| 588 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ | 600 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ |
| 589 M.SOURCEID = ? \ | 601 M.SOURCEID = ? \ |
| 602 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ | |
| 603 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE | |
| 604 | |
| 605 verticalprofile_instantaneouspoint_point_with_aera = SELECT \ | |
| 606 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ | |
| 607 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \ | |
| 608 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \ | |
| 609 ST_ASTEXT(SHAPE) \ | |
| 610 FROM MEDIAN.INSTANTANEOUSPOINT, \ | |
| 611 MEDIAN.MEASUREMENT M \ | |
| 612 WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \ | |
| 613 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ | |
| 614 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ | |
| 615 M.SOURCEID = ? AND \ | |
| 616 INTERSECTS(SHAPE, \ | |
| 617 (SELECT st_astext(SHAPE) \ | |
| 618 FROM MEDIAN.FEATUREAREA \ | |
| 619 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | |
| 620 FEATURECODE = ? )\ | |
| 621 ) \ | |
| 622 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ | |
| 623 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE | |
| 624 | |
| 625 verticalprofile_instantaneouspoint_point_with_wkt = SELECT \ | |
| 626 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ | |
| 627 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \ | |
| 628 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \ | |
| 629 ST_ASTEXT(SHAPE) \ | |
| 630 FROM MEDIAN.INSTANTANEOUSPOINT, \ | |
| 631 MEDIAN.MEASUREMENT M \ | |
| 632 WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \ | |
| 633 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ | |
| 634 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ | |
| 635 M.SOURCEID = ? AND \ | |
| 636 INTERSECTS(SHAPE,"?") \ | |
| 590 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ | 637 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ |
| 591 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE | 638 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE |
| 592 | 639 |
| 593 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ | 640 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ |
| 594 P.PARAMETERID KEY, \ | 641 P.PARAMETERID KEY, \ |