Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 246:b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
gnv-artifacts/trunk@315 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 10 Nov 2009 14:37:42 +0000 |
| parents | 9697a6b8d2c9 |
| children | af474a541f74 |
comparison
equal
deleted
inserted
replaced
| 245:9697a6b8d2c9 | 246:b7f69809239c |
|---|---|
| 840 msv.PARAMETERID, \ | 840 msv.PARAMETERID, \ |
| 841 MEDIAN.MESHPOINT.JPOSITION , \ | 841 MEDIAN.MESHPOINT.JPOSITION , \ |
| 842 MEDIAN.MESHPOINT.IPOSITION, \ | 842 MEDIAN.MESHPOINT.IPOSITION, \ |
| 843 MEDIAN.MESHPOINT.KPOSITION | 843 MEDIAN.MESHPOINT.KPOSITION |
| 844 | 844 |
| 845 verticalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \ | |
| 846 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ | |
| 847 '*' TYPE, \ | |
| 848 ST_ASTEXT(SHAPE), \ | |
| 849 0 BOTDEPTH, \ | |
| 850 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ | |
| 851 MSV.TIMEVALUE, \ | |
| 852 MSV.DATAVALUE , \ | |
| 853 MSV.PARAMETERID PARAMETER, \ | |
| 854 MEDIAN.MESHPOINT.JPOSITION, \ | |
| 855 MEDIAN.MESHPOINT.IPOSITION, \ | |
| 856 MEDIAN.MESHPOINT.KPOSITION \ | |
| 857 from MEDIAN.MESHLAYER ml, \ | |
| 858 MEDIAN.MESHPOINT , \ | |
| 859 MEDIAN.MESH m, \ | |
| 860 MEDIAN.SOURCEINFO SI, \ | |
| 861 MEDIAN.MESHSCALARVALUE msv \ | |
| 862 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ | |
| 863 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ | |
| 864 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ | |
| 865 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 866 m.PARTIDMIN <= msv.PARTID AND \ | |
| 867 m.PARTIDMAX >= msv.PARTID AND \ | |
| 868 M.SOURCEID = SI.SOURCEID AND \ | |
| 869 msv.PARAMETERID = ? AND \ | |
| 870 msv.TIMEVALUE = ? AND \ | |
| 871 m.OBJECTID = ? AND \ | |
| 872 MEDIAN.MESHPOINT.FEATUREID in \ | |
| 873 ( select FEATUREID \ | |
| 874 from MEDIAN.MESHPOINT mp, \ | |
| 875 MEDIAN.MESH m \ | |
| 876 where m.OBJECTID = ? AND \ | |
| 877 mp.MESHID = m.MESHID AND \ | |
| 878 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ | |
| 879 order by msv.TIMEVALUE, \ | |
| 880 msv.PARAMETERID, \ | |
| 881 MEDIAN.MESHPOINT.JPOSITION , \ | |
| 882 MEDIAN.MESHPOINT.IPOSITION, \ | |
| 883 MEDIAN.MESHPOINT.KPOSITION | |
| 884 | |
| 845 ############################################# | 885 ############################################# |
| 846 ############################################# | 886 ############################################# |
| 847 ########## Horizontalschnitt MESH ########### | 887 ########## Horizontalschnitt MESH ########### |
| 848 ############################################# | 888 ############################################# |
| 849 ############################################# | 889 ############################################# |
| 918 MSV.TIMEVALUE = ? AND \ | 958 MSV.TIMEVALUE = ? AND \ |
| 919 M.OBJECTID = ? AND \ | 959 M.OBJECTID = ? AND \ |
| 920 MEDIAN.MESHPOINT.KPOSITION = ? \ | 960 MEDIAN.MESHPOINT.KPOSITION = ? \ |
| 921 order by MEDIAN.MESHPOINT.JPOSITION , \ | 961 order by MEDIAN.MESHPOINT.JPOSITION , \ |
| 922 MEDIAN.MESHPOINT.IPOSITION | 962 MEDIAN.MESHPOINT.IPOSITION |
| 923 | |
| 924 | |
| 925 | |
| 926 | |
| 927 | |
| 928 select /*+ parallel(timevalue,10) */ \ | |
| 929 SI.NAME CRUISE, \ | |
| 930 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ | |
| 931 '*' TYPE, \ | |
| 932 ST_ASTEXT(SHAPE), \ | |
| 933 0 BOTDEPTH, \ | |
| 934 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ | |
| 935 MSV.TIMEVALUE, \ | |
| 936 MSV.DATAVALUE , \ | |
| 937 MSV.PARAMETERID PARAMETER, \ | |
| 938 from MEDIAN.MESHSCALARVALUE MSV , \ | |
| 939 MEDIAN.MESHPOINT, \ | |
| 940 MEDIAN.MESH M, \ | |
| 941 MEDIAN.SOURCEINFO SI, \ | |
| 942 MEDIAN.MESHLAYER ML \ | |
| 943 where MSV.PARTID >= M.PARTIDMIN AND \ | |
| 944 MSV.PARTID <= M.PARTIDMAX AND \ | |
| 945 m.SOURCEID = SI.SOURCEID AND \ | |
| 946 ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 947 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \ | |
| 948 MSV.PARAMETERID = ? AND \ | |
| 949 MSV.TIMEVALUE = ? AND \ | |
| 950 M.OBJECTID = ? AND \ | |
| 951 MEDIAN.MESHPOINT.KPOSITION = ? \ | |
| 952 order by MEDIAN.MESHPOINT.FEATUREID, \ | |
| 953 msv.FEATUREID, \ | |
| 954 msv.PARAMETERID, \ | |
| 955 msv.TIMEVALUE | |
| 956 | 963 |
| 957 area_filter = SELECT DISTINCT \ | 964 area_filter = SELECT DISTINCT \ |
| 958 FEATUREID KEY ,\ | 965 FEATUREID KEY ,\ |
| 959 DESCRIPTION VALUE \ | 966 DESCRIPTION VALUE \ |
| 960 FROM MEDIAN.FEATUREAREA \ | 967 FROM MEDIAN.FEATUREAREA \ |