Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/doc/conf/queries.properties @ 1045:3fe08ea3f2b6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added queries for meshes using vectorvalues for verticalprofiles. gnv-artifacts/trunk@1117 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 21 May 2010 09:46:38 +0000
parents d955571cdf2a
children 026f89df4091
comparison
equal deleted inserted replaced
1044:461d4489705c 1045:3fe08ea3f2b6
729 MEDIAN.MESHPOINT.KPOSITION <= ? AND \ 729 MEDIAN.MESHPOINT.KPOSITION <= ? AND \
730 MEDIAN.MESHPOINT.KPOSITION >= ? \ 730 MEDIAN.MESHPOINT.KPOSITION >= ? \
731 order by msv.TIMEVALUE, \ 731 order by msv.TIMEVALUE, \
732 ml.UPPERZLOCATION, \ 732 ml.UPPERZLOCATION, \
733 msv.PARAMETERID 733 msv.PARAMETERID
734
735 #############################################
736 #############################################
737 ########## Vertikalprofil Mesh ##############
738 ########## Vektordaten ##############
739 #############################################
740 #############################################
741
742 verticalprofile_mesh_parameter_vector=SELECT DISTINCT \
743 P.PARAMETERID KEY, \
744 P.GERMANNAME || ' ['|| P.UNIT ||']' VALUE, \
745 P.GERMANNAME \
746 FROM MEDIAN.PARAMETER P, \
747 MEDIAN.MESHVECTORVALUE MVV, \
748 MEDIAN.MESH M \
749 WHERE M.OBJECTID = ? AND \
750 MVV.PARTID >= M.PARTIDMIN AND \
751 MVV.PARTID <= M.PARTIDMAX AND \
752 MVV.PARAMETERID = P.PARAMETERID \
753 ORDER BY P.GERMANNAME
754
755 verticalprofile_mesh_year_vector= SELECT DISTINCT \
756 to_char(MVV.TIMEVALUE,'YYYY') KEY, \
757 to_char(MVV.TIMEVALUE,'YYYY') VALUE \
758 FROM MEDIAN.MESHVECTORVALUE MVV, \
759 MEDIAN.MESH M \
760 WHERE M.OBJECTID = ? AND \
761 MVV.PARTID >= M.PARTIDMIN AND \
762 MVV.PARTID <= M.PARTIDMAX AND \
763 MVV.PARAMETERID in (?) \
764 ORDER BY to_char(MVV.TIMEVALUE, 'YYYY')
765
766 verticalprofile_mesh_date_vector= SELECT DISTINCT \
767 MVV.TIMEVALUE KEY, \
768 MVV.TIMEVALUE VALUE \
769 FROM MEDIAN.MESHVECTORVALUE MVV, \
770 MEDIAN.MESH M \
771 WHERE M.OBJECTID = ? AND \
772 MVV.PARTID >= M.PARTIDMIN AND \
773 MVV.PARTID <= M.PARTIDMAX AND \
774 MVV.PARAMETERID in (?) AND \
775 to_char(MVV.TIMEVALUE,'YYYY') in (?) \
776 ORDER BY MVV.TIMEVALUE
777
778 verticalprofile_mesh_chart_data_vector=SELECT ML.UPPERZLOCATION XORDINATE, \
779 MP.KPOSITION KPOSITION, \
780 MVV.XCOMPONENT, \
781 MVV.YCOMPONENT, \
782 MVV.ZCOMPONENT, \
783 MVV.SPEED, \
784 MVV.DIRECTION, \
785 MVV.PARAMETERID GROUP1, \
786 MVV.TIMEVALUE GROUP2, \
787 1 GROUP3, \
788 2 DATAID, \
789 MP.FEATUREID, \
790 MP.MESHID \
791 from MEDIAN.MESHLAYER ML, \
792 MEDIAN.MESHPOINT MP, \
793 MEDIAN.MESH M, \
794 MEDIAN.MESHCURRENTVALUE MVV \
795 where MVV.FEATUREID = MP. FEATUREID AND \
796 ML.KPOSITION = MP.KPOSITION AND \
797 ML.MESHID = MP.MESHID AND \
798 M.MESHID = MP.MESHID AND \
799 M.PARTIDMIN <= MVV.PARTID AND \
800 M.PARTIDMAX >= MVV.PARTID AND \
801 MVV.PARAMETERID IN (?) AND \
802 MVV.TIMEVALUE IN (?) AND \
803 M.OBJECTID = ? AND \
804 MP.FEATUREID IN \
805 ( SELECT FEATUREID \
806 FROM MEDIAN.MESHPOINT MP, \
807 MEDIAN.MESH M \
808 WHERE M.OBJECTID = ? AND \
809 MP.MESHID = M.MESHID AND \
810 IPOSITION = (SELECT IPOSITION FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?) AND \
811 JPOSITION = (SELECT JPOSITION FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?)) AND \
812 MP.KPOSITION <= ? AND \
813 MP.KPOSITION >= ? \
814 ORDER BY MVV.PARAMETERID, \
815 MVV.TIMEVALUE, \
816 ML.UPPERZLOCATION
734 817
818 verticalprofile_mesh_odv_data_vector=SELECT SI.NAME CRUISE, \
819 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
820 '*' TYPE, \
821 ST_ASTEXT(SHAPE), \
822 0 BOTDEPTH, \
823 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
824 MVV.XCOMPONENT, \
825 MVV.YCOMPONENT, \
826 MVV.ZCOMPONENT, \
827 MVV.SPEED, \
828 MVV.DIRECTION, \
829 MVV.PARAMETERID PARAMETER, \
830 MVV.TIMEVALUE , \
831 '1' QF \
832 FROM MEDIAN.MESHLAYER ML, \
833 MEDIAN.MESHPOINT, \
834 MEDIAN.MESH M, \
835 MEDIAN.MESHCURRENTVALUE MVV, \
836 MEDIAN.SOURCEINFO SI \
837 WHERE M.SOURCEID = SI.SOURCEID AND \
838 MVV.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
839 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \
840 ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \
841 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \
842 M.PARTIDMIN <= MVV.PARTID AND \
843 M.PARTIDMAX >= MVV.PARTID AND \
844 MVV.PARAMETERID IN (?) AND \
845 MVV.TIMEVALUE IN (?) AND \
846 M.OBJECTID = ? AND \
847 MEDIAN.MESHPOINT.FEATUREID IN \
848 ( SELECT FEATUREID \
849 FROM MEDIAN.MESHPOINT MP, \
850 MEDIAN.MESH M \
851 WHERE M.OBJECTID = ? AND \
852 MP.MESHID = M.MESHID AND \
853 IPOSITION = (SELECT IPOSITION FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?) AND \
854 JPOSITION = (SELECT JPOSITION FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?)) AND \
855 MEDIAN.MESHPOINT.KPOSITION <= ? AND \
856 MEDIAN.MESHPOINT.KPOSITION >= ? \
857 ORDER BY MVV.TIMEVALUE, \
858 ML.UPPERZLOCATION, \
859 MVV.PARAMETERID
860
735 ############################################# 861 #############################################
736 ############################################# 862 #############################################
737 ##### Vertikalprofil InstantaneousPoint ##### 863 ##### Vertikalprofil InstantaneousPoint #####
738 ############################################# 864 #############################################
739 ############################################# 865 #############################################
http://dive4elements.wald.intevation.org