Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 245:9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
gnv-artifacts/trunk@314 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 10 Nov 2009 14:10:52 +0000 |
| parents | 9048bc4b17cd |
| children | b7f69809239c |
comparison
equal
deleted
inserted
replaced
| 244:9048bc4b17cd | 245:9697a6b8d2c9 |
|---|---|
| 888 MSV.TIMEVALUE = ? AND \ | 888 MSV.TIMEVALUE = ? AND \ |
| 889 M.OBJECTID = ? AND \ | 889 M.OBJECTID = ? AND \ |
| 890 MEDIAN.MESHFACE.KPOSITION = ? \ | 890 MEDIAN.MESHFACE.KPOSITION = ? \ |
| 891 order by MEDIAN.MESHFACE.JPOSITION , \ | 891 order by MEDIAN.MESHFACE.JPOSITION , \ |
| 892 MEDIAN.MESHFACE.IPOSITION | 892 MEDIAN.MESHFACE.IPOSITION |
| 893 | 893 horizontalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \ |
| 894 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ | |
| 895 '*' TYPE, \ | |
| 896 ST_ASTEXT(SHAPE), \ | |
| 897 0 BOTDEPTH, \ | |
| 898 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ | |
| 899 MSV.TIMEVALUE, \ | |
| 900 MSV.DATAVALUE , \ | |
| 901 MSV.PARAMETERID PARAMETER, \ | |
| 902 MEDIAN.MESHPOINT.JPOSITION, \ | |
| 903 MEDIAN.MESHPOINT.IPOSITION, \ | |
| 904 MEDIAN.MESHPOINT.KPOSITION \ | |
| 905 from MEDIAN.MESHLAYER ML, \ | |
| 906 MEDIAN.MESHPOINT, \ | |
| 907 MEDIAN.MESH M, \ | |
| 908 MEDIAN.SOURCEINFO SI, \ | |
| 909 MEDIAN.MESHSCALARVALUE MSV \ | |
| 910 where MSV.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ | |
| 911 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ | |
| 912 ML.MESHID = MEDIAN.MESHPOINT.MESHID and \ | |
| 913 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 914 M.PARTIDMIN <= MSV.PARTID AND \ | |
| 915 M.PARTIDMAX >= MSV.PARTID AND \ | |
| 916 M.SOURCEID = SI.SOURCEID AND \ | |
| 917 MSV.PARAMETERID = ? AND \ | |
| 918 MSV.TIMEVALUE = ? AND \ | |
| 919 M.OBJECTID = ? AND \ | |
| 920 MEDIAN.MESHPOINT.KPOSITION = ? \ | |
| 921 order by MEDIAN.MESHPOINT.JPOSITION , \ | |
| 922 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 | |
| 894 | 956 |
| 895 area_filter = SELECT DISTINCT \ | 957 area_filter = SELECT DISTINCT \ |
| 896 FEATUREID KEY ,\ | 958 FEATUREID KEY ,\ |
| 897 DESCRIPTION VALUE \ | 959 DESCRIPTION VALUE \ |
| 898 FROM MEDIAN.FEATUREAREA \ | 960 FROM MEDIAN.FEATUREAREA \ |