comparison gnv-artifacts/doc/conf/queries.properties @ 352:24c21a720aa5

Added Support for "horizontale Schnittprofile" gnv-artifacts/trunk@425 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 15 Dec 2009 10:20:16 +0000
parents 8f168e12a963
children 3eee1369c79b
comparison
equal deleted inserted replaced
351:4ac3c1c1c060 352:24c21a720aa5
882 order by msv.TIMEVALUE, \ 882 order by msv.TIMEVALUE, \
883 MEDIAN.MESHPOINT.KPOSITION, \ 883 MEDIAN.MESHPOINT.KPOSITION, \
884 msv.PARAMETERID, \ 884 msv.PARAMETERID, \
885 MEDIAN.MESHPOINT.JPOSITION, \ 885 MEDIAN.MESHPOINT.JPOSITION, \
886 MEDIAN.MESHPOINT.IPOSITION 886 MEDIAN.MESHPOINT.IPOSITION
887 887
888 888 #############################################
889 #############################################
890 ########### Horizontalprofil MESH ###########
891 ########### Schnittprofil ###########
892 #############################################
893 #############################################
894 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
895 mp.KPOSITION KEY, \
896 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \
897 from MEDIAN.MESHLAYER ml, \
898 MEDIAN.MESHPOINT mp \
899 where ml.KPOSITION = mp.KPOSITION and \
900 ml.MESHID = mp.MESHID and \
901 mp.FEATUREID in \
902 ( select FEATUREID \
903 from MEDIAN.MESHPOINT mp, \
904 MEDIAN.MESH m \
905 where m.OBJECTID = ? AND \
906 mp.MESHID = m.MESHID )\
907 order by mp.KPOSITION
908
909 horizontalprofile_meshpoint_cross_ij=SELECT MEDIAN.MESHFACE.JPOSITION, \
910 MEDIAN.MESHFACE.IPOSITION \
911 FROM MEDIAN.MESHFACE, \
912 MEDIAN.MESH M \
913 WHERE MEDIAN.MESHFACE.KPOSITION = 1 AND \
914 M.MESHID = MEDIAN.MESHFACE.MESHID AND \
915 M.OBJECTID = ? AND \
916 INTERSECTS(SHAPE, "?")
917 horizontalprofile_mesh_cross_chart_data = SELECT ST_ASTEXT(SHAPE), \
918 msv.DATAVALUE YORDINATE, \
919 msv.PARAMETERID GROUP1, \
920 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
921 msv.TIMEVALUE GROUP3, \
922 MEDIAN.MESHPOINT.JPOSITION, \
923 MEDIAN.MESHPOINT.IPOSITION, \
924 2 DATAID \
925 from MEDIAN.MESHLAYER ml, \
926 MEDIAN.MESHPOINT, \
927 MEDIAN.MESH m, \
928 MEDIAN.MESHSCALARVALUE msv \
929 where msv.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \
930 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
931 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
932 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
933 m.PARTIDMIN <= msv.PARTID AND \
934 m.PARTIDMAX >= msv.PARTID AND \
935 msv.PARAMETERID in (?) AND \
936 msv.TIMEVALUE in (?) AND \
937 m.OBJECTID = ? AND \
938 ml.KPOSITION in (?) AND \
939 MEDIAN.MESHPOINT.FEATUREID in \
940 ( \
941 SELECT distinct FEATUREID \
942 FROM MEDIAN.MESHPOINT \
943 WHERE ? \
944 ) \
945 order by msv.TIMEVALUE, \
946 MEDIAN.MESHPOINT.KPOSITION, \
947 msv.PARAMETERID, \
948 MEDIAN.MESHPOINT.JPOSITION, \
949 MEDIAN.MESHPOINT.IPOSITION
889 ############################################# 950 #############################################
890 ############################################# 951 #############################################
891 ############# Profilschnitt MESH ############ 952 ############# Profilschnitt MESH ############
892 ############################################# 953 #############################################
893 ############################################# 954 #############################################

http://dive4elements.wald.intevation.org