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 ############################################# |