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

http://dive4elements.wald.intevation.org