Mercurial > dive4elements > gnv-client
diff 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 |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Tue Nov 10 14:10:52 2009 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Tue Nov 10 14:37:42 2009 +0000 @@ -842,6 +842,46 @@ MEDIAN.MESHPOINT.IPOSITION, \ MEDIAN.MESHPOINT.KPOSITION +verticalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \ + M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ + '*' TYPE, \ + ST_ASTEXT(SHAPE), \ + 0 BOTDEPTH, \ + (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ + MSV.TIMEVALUE, \ + MSV.DATAVALUE , \ + MSV.PARAMETERID PARAMETER, \ + MEDIAN.MESHPOINT.JPOSITION, \ + MEDIAN.MESHPOINT.IPOSITION, \ + MEDIAN.MESHPOINT.KPOSITION \ + from MEDIAN.MESHLAYER ml, \ + MEDIAN.MESHPOINT , \ + MEDIAN.MESH m, \ + MEDIAN.SOURCEINFO SI, \ + MEDIAN.MESHSCALARVALUE msv \ + where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ + ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ + ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ + m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ + m.PARTIDMIN <= msv.PARTID AND \ + m.PARTIDMAX >= msv.PARTID AND \ + M.SOURCEID = SI.SOURCEID AND \ + msv.PARAMETERID = ? AND \ + msv.TIMEVALUE = ? AND \ + m.OBJECTID = ? AND \ + MEDIAN.MESHPOINT.FEATUREID in \ + ( select FEATUREID \ + from MEDIAN.MESHPOINT mp, \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + mp.MESHID = m.MESHID AND \ + ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ + order by msv.TIMEVALUE, \ + msv.PARAMETERID, \ + MEDIAN.MESHPOINT.JPOSITION , \ + MEDIAN.MESHPOINT.IPOSITION, \ + MEDIAN.MESHPOINT.KPOSITION + ############################################# ############################################# ########## Horizontalschnitt MESH ########### @@ -920,39 +960,6 @@ MEDIAN.MESHPOINT.KPOSITION = ? \ order by MEDIAN.MESHPOINT.JPOSITION , \ MEDIAN.MESHPOINT.IPOSITION - - - - - -select /*+ parallel(timevalue,10) */ \ - SI.NAME CRUISE, \ - M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ - '*' TYPE, \ - ST_ASTEXT(SHAPE), \ - 0 BOTDEPTH, \ - (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ - MSV.TIMEVALUE, \ - MSV.DATAVALUE , \ - MSV.PARAMETERID PARAMETER, \ - from MEDIAN.MESHSCALARVALUE MSV , \ - MEDIAN.MESHPOINT, \ - MEDIAN.MESH M, \ - MEDIAN.SOURCEINFO SI, \ - MEDIAN.MESHLAYER ML \ - where MSV.PARTID >= M.PARTIDMIN AND \ - MSV.PARTID <= M.PARTIDMAX AND \ - m.SOURCEID = SI.SOURCEID AND \ - ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \ - ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \ - MSV.PARAMETERID = ? AND \ - MSV.TIMEVALUE = ? AND \ - M.OBJECTID = ? AND \ - MEDIAN.MESHPOINT.KPOSITION = ? \ - order by MEDIAN.MESHPOINT.FEATUREID, \ - msv.FEATUREID, \ - msv.PARAMETERID, \ - msv.TIMEVALUE area_filter = SELECT DISTINCT \ FEATUREID KEY ,\