Mercurial > dive4elements > gnv-client
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 ############################################# |