Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/doc/conf/queries.properties @ 741:2dc0666db49a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Modified the Workflow of Horizontalprofiles on Instantaneouspoints that the Data that was sent by the Mapviewer-Interface take effect. gnv-artifacts/trunk@780 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Mon, 15 Mar 2010 17:01:42 +0000
parents 40c9a48f51ea
children 686eecfafbbf
comparison
equal deleted inserted replaced
740:0563389138bb 741:2dc0666db49a
688 FROM MEDIAN.FEATUREAREA \ 688 FROM MEDIAN.FEATUREAREA \
689 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ 689 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
690 FEATURECODE = ? )\ 690 FEATURECODE = ? )\
691 ) \ 691 ) \
692 ORDER BY V.NAME 692 ORDER BY V.NAME
693
694 horizontalprofile_instantaneouspoint_vehicle_with_wkt = SELECT V.VEHICLEID KEY, \
695 V.NAME VALUE \
696 FROM MEDIAN.TRACK, \
697 MEDIAN.VEHICLE V, \
698 MEDIAN.CRUISE C \
699 WHERE V.VEHICLEID = C.VEHICLEID AND \
700 C.CRUISEID = MEDIAN.TRACK.CRUISEID AND \
701 MEDIAN.TRACK.TRACKID IN \
702 (SELECT DISTINCT S.TRACKID \
703 FROM MEDIAN.MEASUREMENT M ,\
704 MEDIAN.INSTANTANEOUSPOINT I, \
705 MEDIAN.SURVEYINFO S \
706 WHERE M.SOURCEID = ? AND \
707 I.FEATUREID = M.FEATUREID AND \
708 S.SURVEYID = I.SURVEYID)AND \
709 INTERSECTS(SHAPE,"?") \
710 ORDER BY V.NAME
711
693 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \ 712 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \
694 C.CRUISEID KEY, \ 713 C.CRUISEID KEY, \
695 V.NAME || ' ' || \ 714 V.NAME || ' ' || \
696 C.NAME || ' ' || \ 715 C.NAME || ' ' || \
697 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \ 716 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \
739 FROM MEDIAN.FEATUREAREA \ 758 FROM MEDIAN.FEATUREAREA \
740 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ 759 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
741 FEATURECODE = ? )\ 760 FEATURECODE = ? )\
742 ) \ 761 ) \
743 ORDER BY V.NAME 762 ORDER BY V.NAME
763
764 horizontalprofile_instantaneouspoint_cruise_with_wkt = SELECT C.CRUISEID KEY, \
765 V.NAME || ' ' || \
766 C.NAME || ' ' || \
767 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \
768 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE, \
769 V.NAME, \
770 C.NAME \
771 FROM MEDIAN.TRACK, \
772 MEDIAN.VEHICLE V, \
773 MEDIAN.CRUISE C \
774 WHERE V.VEHICLEID = C.VEHICLEID AND \
775 C.CRUISEID = MEDIAN.TRACK.CRUISEID AND \
776 MEDIAN.TRACK.TRACKID IN \
777 (SELECT DISTINCT S.TRACKID \
778 FROM MEDIAN.MEASUREMENT M ,\
779 MEDIAN.INSTANTANEOUSPOINT I, \
780 MEDIAN.SURVEYINFO S \
781 WHERE M.SOURCEID = ? AND \
782 C.VEHICLEID = ? AND \
783 I.FEATUREID = M.FEATUREID AND \
784 S.SURVEYID = I.SURVEYID)AND \
785 INTERSECTS(SHAPE,"?") \
786 ORDER BY V.NAME
787
744 horizontalprofile_instantaneouspoint_track= SELECT \ 788 horizontalprofile_instantaneouspoint_track= SELECT \
745 T.TRACKID KEY, \ 789 T.TRACKID KEY, \
746 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \ 790 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \
747 FROM MEDIAN.TRACK T \ 791 FROM MEDIAN.TRACK T \
748 WHERE T.CRUISEID = ? \ 792 WHERE T.CRUISEID = ? \
750 T.ENDDATE, \ 794 T.ENDDATE, \
751 T.NAME 795 T.NAME
752 796
753 horizontalprofile_instantaneouspoint_track_with_area = SELECT \ 797 horizontalprofile_instantaneouspoint_track_with_area = SELECT \
754 MEDIAN.TRACK.TRACKID KEY, \ 798 MEDIAN.TRACK.TRACKID KEY, \
755 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| NAME VALUE, \ 799 to_char(STARTDATE,'DD-MM-YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD-MM-YYYY HH24:MI') || ' - '|| NAME VALUE, \
756 NAME \ 800 NAME \
757 FROM MEDIAN.TRACK \ 801 FROM MEDIAN.TRACK \
758 WHERE MEDIAN.TRACK.CRUISEID = ? AND \ 802 WHERE MEDIAN.TRACK.CRUISEID = ? AND \
759 INTERSECTS(SHAPE, \ 803 INTERSECTS(SHAPE, \
760 (SELECT st_astext(SHAPE) \ 804 (SELECT st_astext(SHAPE) \
763 FEATURECODE = ? )\ 807 FEATURECODE = ? )\
764 ) \ 808 ) \
765 ORDER BY STARTDATE, \ 809 ORDER BY STARTDATE, \
766 ENDDATE, \ 810 ENDDATE, \
767 NAME 811 NAME
812
813 horizontalprofile_instantaneouspoint_track_with_wkt = SELECT \
814 MEDIAN.TRACK.TRACKID KEY, \
815 to_char(STARTDATE,'DD-MM-YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD-MM-YYYY HH24:MI') || ' - '|| NAME VALUE, \
816 NAME \
817 FROM MEDIAN.TRACK \
818 WHERE MEDIAN.TRACK.CRUISEID = ? AND \
819 INTERSECTS(SHAPE, "?") \
820 ORDER BY STARTDATE, \
821 ENDDATE, \
822 NAME
823
768 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \ 824 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \
769 SURVEYID KEY, \ 825 SURVEYID KEY, \
770 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \ 826 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \
771 FROM MEDIAN.SURVEYINFO \ 827 FROM MEDIAN.SURVEYINFO \
772 WHERE TRACKID = ? \ 828 WHERE TRACKID = ? \
http://dive4elements.wald.intevation.org