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 ############################################# |