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, \ |