Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 239:75da91eca29f | 240:76897b73db4e |
|---|---|
| 185 msv.TIMEVALUE <= ? \ | 185 msv.TIMEVALUE <= ? \ |
| 186 order by mp.FEATUREID, \ | 186 order by mp.FEATUREID, \ |
| 187 msv.FEATUREID, \ | 187 msv.FEATUREID, \ |
| 188 msv.PARAMETERID, \ | 188 msv.PARAMETERID, \ |
| 189 msv.TIMEVALUE | 189 msv.TIMEVALUE |
| 190 | |
| 191 timeseries_mesh_odv_data = select /*+ parallel(timevalue,10) */ \ | |
| 192 SI.NAME CRUISE, \ | |
| 193 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ | |
| 194 '*' TYPE, \ | |
| 195 ST_ASTEXT(SHAPE), \ | |
| 196 0 BOTDEPTH, \ | |
| 197 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ | |
| 198 msv.TIMEVALUE, \ | |
| 199 msv.DATAVALUE , \ | |
| 200 msv.PARAMETERID PARAMETER \ | |
| 201 from MEDIAN.MESHSCALARVALUE msv , \ | |
| 202 MEDIAN.MESHPOINT, \ | |
| 203 MEDIAN.MESH m, \ | |
| 204 MEDIAN.SOURCEINFO SI, \ | |
| 205 MEDIAN.MESHLAYER ML \ | |
| 206 where (m.OBJECTID = ? AND \ | |
| 207 msv.PARTID >= m.PARTIDMIN AND \ | |
| 208 msv.PARTID <= m.PARTIDMAX ) AND \ | |
| 209 m.SOURCEID = SI.SOURCEID AND \ | |
| 210 ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 211 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \ | |
| 212 msv.FEATUREID in ( ? ) AND \ | |
| 213 msv.PARAMETERID in (? ) AND \ | |
| 214 MEDIAN.MESHPOINT.FEATUREID in ( ? ) AND \ | |
| 215 msv.TIMEVALUE >= ? AND \ | |
| 216 msv.TIMEVALUE <= ? \ | |
| 217 order by MEDIAN.MESHPOINT.FEATUREID, \ | |
| 218 msv.FEATUREID, \ | |
| 219 msv.PARAMETERID, \ | |
| 220 msv.TIMEVALUE | |
| 221 | |
| 190 | 222 |
| 191 ############################################# | 223 ############################################# |
| 192 ############################################# | 224 ############################################# |
| 193 ########## Vertikalprofil ############## | 225 ########## Vertikalprofil ############## |
| 194 ############################################# | 226 ############################################# |