Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 240:76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
gnv-artifacts/trunk@308 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Mon, 09 Nov 2009 14:20:27 +0000 |
| parents | 56dcedc4a96c |
| children | 8500529d82af |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Mon Nov 09 14:11:09 2009 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Mon Nov 09 14:20:27 2009 +0000 @@ -187,6 +187,38 @@ msv.FEATUREID, \ msv.PARAMETERID, \ msv.TIMEVALUE + +timeseries_mesh_odv_data = 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 (m.OBJECTID = ? AND \ + 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.FEATUREID in ( ? ) AND \ + msv.PARAMETERID in (? ) AND \ + MEDIAN.MESHPOINT.FEATUREID in ( ? ) AND \ + msv.TIMEVALUE >= ? AND \ + msv.TIMEVALUE <= ? \ + order by MEDIAN.MESHPOINT.FEATUREID, \ + msv.FEATUREID, \ + msv.PARAMETERID, \ + msv.TIMEVALUE + ############################################# #############################################