Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/doc/conf/queries.properties @ 199:b66e8a6f3907

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Moved Configurationfiles gnv-artifacts/trunk@253 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Wed, 21 Oct 2009 10:16:52 +0000
parents
children 6e7952fd1744
comparison
equal deleted inserted replaced
198:d19259c86b72 199:b66e8a6f3907
1 #############################################
2 #############################################
3 ########## Zeitserie ##############
4 #############################################
5 #############################################
6
7 timeseries_timeseriespoint=SELECT DISTINCT \
8 tsp.FEATUREID KEY, \
9 tsp.NAME VALUE \
10 FROM MEDIAN.TIMESERIESPOINT tsp, \
11 MEDIAN.MEASUREMENT mmt \
12 WHERE tsp.FEATUREID = mmt.FEATUREID AND \
13 mmt.SOURCEID = ? \
14 order by tsp.name
15
16 timeseries_parameter=SELECT DISTINCT \
17 p.PARAMETERID KEY, \
18 p.GERMANNAME VALUE \
19 from MEDIAN.PARAMETER p \
20 where p.PARAMETERID in \
21 (select distinct \
22 ts.PARAMETERID \
23 from MEDIAN.TIMESERIES ts \
24 where ts.TIMESERIESID in \
25 (select distinct \
26 tsv.TIMESERIESID \
27 from MEDIAN.TIMESERIESVALUE tsv \
28 where tsv.MEASUREMENTID in \
29 (select m.MEASUREMENTID \
30 from MEDIAN.MEASUREMENT m, \
31 MEDIAN.TIMESERIESPOINT tsp \
32 where m.FEATUREID = tsp.FEATUREID and \
33 tsp.FEATUREID IN ( ? )\
34 )\
35 )\
36 ) \
37 ORDER BY p.GERMANNAME
38
39 timeseries_depth_height=SELECT DISTINCT \
40 m.MEASUREMENTID KEY, \
41 m.ZLOCATION VALUE \
42 from MEDIAN.MEASUREMENT m \
43 where m.MEASUREMENTID in \
44 (SELECT DISTINCT \
45 t_v.MEASUREMENTID \
46 from MEDIAN.TIMESERIESVALUE t_v \
47 where t_v.TIMESERIESID in \
48 (SELECT DISTINCT \
49 t.TIMESERIESID \
50 from MEDIAN.TIMESERIES t \
51 where t.PARAMETERID in \
52 (SELECT DISTINCT \
53 p.PARAMETERID \
54 from MEDIAN.PARAMETER p \
55 where m.FEATUREID IN ( ? ) and \
56 p.PARAMETERID IN (?)\
57 )\
58 )\
59 )\
60 ORDER BY m.ZLOCATION DESC
61
62 timeseries_interval=select min(tv.TIMEVALUE) MIN, \
63 max(tv.TIMEVALUE) MAX \
64 from MEDIAN.TIMESERIES t , \
65 MEDIAN.TIMESERIESVALUE tv \
66 where tv.TIMESERIESID = t.TIMESERIESID AND \
67 t.PARAMETERID IN ( ? ) AND \
68 tv.MEASUREMENTID IN ( ? )
69
70 timeseries_chart_data=SELECT tv.TIMEVALUE XORDINATE, \
71 tv.DATAVALUE YORDINATE, \
72 t.PARAMETERID GROUP1, \
73 tv.MEASUREMENTID GROUP2, \
74 tv.TIMESERIESID GROUP3 \
75 FROM MEDIAN.TIMESERIESVALUE tv, \
76 MEDIAN.TIMESERIES t \
77 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \
78 t.PARAMETERID IN ( ? ) AND \
79 tv.MEASUREMENTID IN ( ? ) AND \
80 tv.TIMEVALUE >= ? AND \
81 tv.TIMEVALUE <= ? \
82 ORDER BY tv.MEASUREMENTID , \
83 tv.TIMESERIESID , \
84 t.PARAMETERID , \
85 tv.TIMEVALUE
86
87 #############################################
88 #############################################
89 ########## Zeitserie Mesh ##############
90 #############################################
91 #############################################
92
93 timeseries_mesh = SELECT OBJECTID KEY, \
94 m.NAME VALUE \
95 FROM MEDIAN.MESH m \
96 WHERE SOURCEID IN (?) \
97 ORDER BY m.NAME
98 timeseries_meshpoint = SELECT FEATUREID, \
99 ST_ASTEXT(SHAPE) \
100 FROM MEDIAN.MESHPOINT \
101 WHERE MESHID in \
102 (SELECT DISTINCT MESHID \
103 FROM MEDIAN.MESH \
104 WHERE OBJECTID = ?) AND \
105 KPOSITION = 1 AND \
106 INTERSECTS(SHAPE,"?")
107
108 timeseries_meshpoint_depth = select mp.FEATUREID KEY, \
109 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \
110 from MEDIAN.MESHLAYER ml, \
111 MEDIAN.MESHPOINT mp \
112 where ml.KPOSITION = mp.KPOSITION and \
113 ml.MESHID = mp.MESHID and \
114 mp.FEATUREID in \
115 ( select FEATUREID \
116 from MEDIAN.MESHPOINT mp, \
117 MEDIAN.MESH m \
118 where m.OBJECTID = ? AND \
119 mp.MESHID = m.MESHID AND \
120 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
121 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
122 order by ml.UPPERZLOCATION desc
123
124 timeseries_mesh_parameter=SELECT distinct \
125 p.PARAMETERID KEY , \
126 p.GERMANNAME VALUE \
127 from MEDIAN.PARAMETER p, \
128 MEDIAN.MESHSCALARVALUE msc, \
129 MEDIAN.MESH m \
130 where m.OBJECTID = ? AND \
131 msc.PARTID = m.PARTIDMIN AND \
132 msc.PARAMETERID = p.PARAMETERID \
133 order by p.GERMANNAME
134 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \
135 min(TIMEVALUE) MIN, \
136 max(TIMEVALUE) MAX \
137 from MEDIAN.MESHSCALARVALUE msc , \
138 MEDIAN.MESH m \
139 where m.OBJECTID = ? AND \
140 msc.PARTID >= m.PARTIDMIN AND \
141 msc.PARTID <= m.PARTIDMAX AND \
142 msc.PARAMETERID IN (?)
143
144 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \
145 msv.TIMEVALUE XORDINATE, \
146 msv.DATAVALUE YORDINATE, \
147 msv.PARAMETERID GROUP1, \
148 msv.FEATUREID GROUP2, \
149 mp.FEATUREID GROUP3 \
150 from MEDIAN.MESHSCALARVALUE msv , \
151 MEDIAN.MESHPOINT mp, \
152 MEDIAN.MESH m \
153 where (m.OBJECTID = ? AND \
154 msv.PARTID >= m.PARTIDMIN AND \
155 msv.PARTID <= m.PARTIDMAX ) AND \
156 msv.FEATUREID in ( ? ) AND \
157 msv.PARAMETERID in ( ? ) AND \
158 mp.FEATUREID in ( ? ) AND \
159 msv.TIMEVALUE >= ? AND \
160 msv.TIMEVALUE <= ? \
161 order by mp.FEATUREID, \
162 msv.FEATUREID, \
163 msv.PARAMETERID, \
164 msv.TIMEVALUE
165
166 #############################################
167 #############################################
168 ########## Vertikalprofil ##############
169 #############################################
170 #############################################
171
172 verticalprofile_point=SELECT DISTINCT \
173 tsp.FEATUREID KEY, \
174 tsp.NAME VALUE \
175 FROM MEDIAN.TIMESERIESPOINT tsp, \
176 MEDIAN.MEASUREMENT mmt \
177 WHERE tsp.FEATUREID = mmt.FEATUREID AND \
178 mmt.SOURCEID = ? \
179 order by tsp.name
180
181 verticalprofile_parameter=SELECT DISTINCT \
182 p.PARAMETERID KEY, \
183 p.GERMANNAME VALUE \
184 from MEDIAN.PARAMETER p, \
185 MEDIAN.TIMESERIES ts, \
186 MEDIAN.TIMESERIESVALUE tsv, \
187 MEDIAN.MEASUREMENT m \
188 where ts.PARAMETERID = p.PARAMETERID and \
189 ts.TIMESERIESID = tsv.TIMESERIESID and \
190 m.MEASUREMENTID = tsv.MEASUREMENTID and \
191 m.FEATUREID = ? \
192 ORDER BY p.GERMANNAME
193
194 verticalprofile_date=select distinct \
195 tsv.TIMEVALUE KEY, \
196 tsv.TIMEVALUE VALUE \
197 from MEDIAN.TIMESERIES ts , \
198 MEDIAN.TIMESERIESVALUE tsv, \
199 MEDIAN.MEASUREMENT m \
200 where ts.TIMESERIESID = tsv.TIMESERIESID and \
201 m.MEASUREMENTID = tsv.MEASUREMENTID and \
202 m.FEATUREID = ? and \
203 ts.PARAMETERID IN ( ? ) \
204 order by tsv.TIMEVALUE
205
206 verticalprofile_chart_data= SELECT m.ZLOCATION XORDINATE, \
207 tsv.DATAVALUE YORDINATE, \
208 ts.PARAMETERID GROUP1, \
209 tsv.TIMEVALUE GROUP2, \
210 1 GROUP3 \
211 from MEDIAN.TIMESERIES ts, \
212 MEDIAN.TIMESERIESVALUE tsv, \
213 MEDIAN.MEASUREMENT m \
214 where ts.TIMESERIESID = tsv.TIMESERIESID and \
215 m.MEASUREMENTID = tsv.MEASUREMENTID and \
216 m.FEATUREID = ? and \
217 ts.PARAMETERID IN ( ? ) AND \
218 tsv.TIMEVALUE IN (?) \
219 ORDER BY tsv.TIMEVALUE , \
220 tsv.TIMESERIESID , \
221 ts.PARAMETERID , \
222 tsv.TIMEVALUE
223
224 #############################################
225 #############################################
226 ########## Vertikalprofil Mesh ##############
227 #############################################
228 #############################################
229
230 verticalprofile_mesh = SELECT OBJECTID KEY, \
231 m.NAME VALUE \
232 FROM MEDIAN.MESH m \
233 WHERE SOURCEID IN (?) \
234 order by m.NAME
235
236 verticalprofile_mesh_point = SELECT FEATUREID, \
237 ST_ASTEXT(SHAPE) \
238 FROM MEDIAN.MESHPOINT \
239 WHERE MESHID in \
240 (SELECT DISTINCT MESHID \
241 FROM MEDIAN.MESH \
242 WHERE OBJECTID = ?) AND \
243 KPOSITION = 1 AND \
244 INTERSECTS(SHAPE,"?")
245
246 verticalprofile_mesh_parameter=SELECT distinct \
247 p.PARAMETERID KEY , \
248 p.GERMANNAME VALUE \
249 from MEDIAN.PARAMETER p, \
250 MEDIAN.MESHSCALARVALUE msc, \
251 MEDIAN.MESH m \
252 where m.OBJECTID = ? AND \
253 m.PARTIDMIN = msc.PARTID AND \
254 msc.PARAMETERID = p.PARAMETERID \
255 order by p.GERMANNAME
256
257 verticalprofile_mesh_date= select distinct \
258 msv.TIMEVALUE KEY, \
259 msv.TIMEVALUE VALUE \
260 from MEDIAN.MESHSCALARVALUE msv , \
261 MEDIAN.MESH m \
262 where m.OBJECTID = ? AND \
263 msv.PARTID >= m.PARTIDMIN AND \
264 msv.PARTID <= m.PARTIDMAX AND \
265 msv.PARAMETERID in (?) \
266 order by msv.TIMEVALUE
267
268 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \
269 msv.DATAVALUE YORDINATE, \
270 msv.PARAMETERID GROUP1, \
271 msv.TIMEVALUE GROUP2, \
272 1 GROUP3 \
273 from MEDIAN.MESHLAYER ml, \
274 MEDIAN.MESHPOINT mp, \
275 MEDIAN.MESH m, \
276 MEDIAN.MESHSCALARVALUE msv \
277 where msv.FEATUREID = mp. FEATUREID AND \
278 ml.KPOSITION = mp.KPOSITION and \
279 ml.MESHID = mp.MESHID and \
280 m.MESHID = mp.MESHID AND \
281 m.PARTIDMIN <= msv.PARTID AND \
282 m.PARTIDMAX >= msv.PARTID AND \
283 msv.PARAMETERID in (?) AND \
284 msv.TIMEVALUE in (?) AND \
285 m.OBJECTID = ? AND \
286 mp.FEATUREID in \
287 ( select FEATUREID \
288 from MEDIAN.MESHPOINT mp, \
289 MEDIAN.MESH m \
290 where m.OBJECTID = ? AND \
291 mp.MESHID = m.MESHID AND \
292 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
293 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
294 order by msv.PARAMETERID, \
295 msv.TIMEVALUE, \
296 ml.UPPERZLOCATION
297
298 #############################################
299 #############################################
300 ##### Vertikalprofil InstantaneousPoint #####
301 #############################################
302 #############################################
303
304 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \
305 S.SERIESID KEY , \
306 S.DESCRIPTION VALUE \
307 FROM MEDIAN.SERIES S, \
308 MEDIAN.INSTANTANEOUSPOINT I, \
309 MEDIAN.MEASUREMENT M \
310 WHERE S.SERIESID = I.SERIESID AND \
311 I.POINTSPEC = 4 AND \
312 I.FEATUREID = M.FEATUREID AND \
313 M.SOURCEID= ? \
314 ORDER BY S.DESCRIPTION
315
316 verticalprofile_instantaneouspoint_point = SELECT DISTINCT \
317 I.FEATUREID KEY, \
318 to_char(I.TIMEVALUE,'DD.MM.YYYY HH24:MI') || ' - '|| I.SHAPE VALUE, \
319 I.TIMEVALUE \
320 FROM MEDIAN.INSTANTANEOUSPOINT I, \
321 MEDIAN.MEASUREMENT M \
322 WHERE I.SERIESID = ? AND \
323 I.POINTSPEC = 4 AND \
324 I.FEATUREID = M.FEATUREID AND \
325 M.SOURCEID = ? \
326 ORDER BY I.TIMEVALUE
327
328 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
329 P.PARAMETERID KEY , \
330 P.GERMANNAME VALUE \
331 FROM MEDIAN.PARAMETER P, \
332 MEDIAN.INSTANTANEOUSPOINT IP, \
333 MEDIAN.MEASUREMENT M, \
334 MEDIAN.MEASUREDSCALARVALUE MSV \
335 WHERE IP.FEATUREID = M.FEATUREID AND \
336 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
337 MSV.PARAMETERID = P.PARAMETERID AND \
338 IP.FEATUREID = ? \
339 ORDER BY P.GERMANNAME
340
341 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \
342 MSV.DATAVALUE YORDINATE, \
343 MSV.PARAMETERID GROUP1, \
344 IP.TIMEVALUE GROUP2, \
345 1 GROUP3 \
346 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
347 MEDIAN.MEASUREMENT M, \
348 MEDIAN.MEASUREDSCALARVALUE MSV \
349 WHERE IP.FEATUREID = M.FEATUREID AND \
350 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
351 IP.FEATUREID = ? AND \
352 MSV.PARAMETERID in (?) \
353 ORDER BY IP.TIMEVALUE, \
354 MSV.PARAMETERID, \
355 M.ZLOCATION
356
357 #############################################
358 #############################################
359 #### Horizontalprofil InstantaneousPoint ####
360 #############################################
361 #############################################
362 horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \
363 V.VEHICLEID KEY, \
364 V.NAME VALUE \
365 FROM MEDIAN.VEHICLE V, \
366 MEDIAN.CRUISE C, \
367 MEDIAN.TRACK T, \
368 MEDIAN.SURVEYINFO S, \
369 MEDIAN.INSTANTANEOUSPOINT I, \
370 MEDIAN.MEASUREMENT M \
371 WHERE V.VEHICLEID = C.VEHICLEID AND \
372 C.CRUISEID = T.CRUISEID AND \
373 T.TRACKID = S.TRACKID AND \
374 S.SURVEYID = I.SURVEYID AND \
375 I.FEATUREID = M.FEATUREID AND \
376 M.SOURCEID = ? \
377 ORDER BY V.NAME
378 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \
379 C.CRUISEID KEY , \
380 C.NAME VALUE \
381 FROM MEDIAN.CRUISE C, \
382 MEDIAN.TRACK T, \
383 MEDIAN.SURVEYINFO S, \
384 MEDIAN.INSTANTANEOUSPOINT I, \
385 MEDIAN.MEASUREMENT M \
386 WHERE C.CRUISEID = T.CRUISEID AND \
387 T.TRACKID = S.TRACKID AND \
388 S.SURVEYID = I.SURVEYID AND \
389 I.FEATUREID = M.FEATUREID AND \
390 C.VEHICLEID = ? AND \
391 M.SOURCEID = ? AND \
392 C.NAME IS NOT NULL \
393 ORDER BY C.NAME
394 horizontalprofile_instantaneouspoint_track= SELECT \
395 T.TRACKID KEY , \
396 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \
397 FROM MEDIAN.TRACK T \
398 WHERE T.CRUISEID = ? \
399 ORDER BY T.STARTDATE, \
400 T.ENDDATE, \
401 T.NAME
402 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \
403 SURVEYID KEY , \
404 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \
405 FROM MEDIAN.SURVEYINFO \
406 WHERE TRACKID = ? \
407 ORDER BY STARTDATE, \
408 ENDDATE, \
409 DESCRIPTION
410 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
411 P.PARAMETERID KEY , \
412 P.GERMANNAME VALUE \
413 FROM MEDIAN.PARAMETER P , \
414 MEDIAN.MEASUREMENT M , \
415 MEDIAN.INSTANTANEOUSPOINT IP , \
416 MEDIAN.MEASUREDSCALARVALUE MSV \
417 WHERE P.PARAMETERID = MSV.PARAMETERID AND \
418 MSV.MEASUREMENTID = M.MEASUREMENTID AND \
419 M.FEATUREID = IP.FEATUREID AND \
420 IP.SURVEYID = ? \
421 ORDER BY P.GERMANNAME
422 horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \
423 M.ZLOCATION KEY, \
424 M.ZLOCATION VALUE \
425 FROM MEDIAN.MEASUREMENT M , \
426 MEDIAN.INSTANTANEOUSPOINT IP \
427 WHERE M.FEATUREID = IP.FEATUREID AND \
428 IP.SURVEYID = ? \
429 ORDER BY M.ZLOCATION
430 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE) , \
431 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME , \
432 MSV.DATAVALUE YORDINATE , \
433 MSV.PARAMETERID GROUP1 , \
434 ZLOCATION GROUP2 , \
435 1 GROUP3 \
436 FROM MEDIAN.INSTANTANEOUSPOINT, \
437 MEDIAN.MEASUREMENT M, \
438 MEDIAN.MEASUREDSCALARVALUE MSV \
439 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
440 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
441 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \
442 M.ZLOCATION IN (?) AND \
443 MSV.PARAMETERID in (?) \
444 ORDER BY MSV.PARAMETERID, \
445 M.ZLOCATION, \
446 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
447
448 #############################################
449 #############################################
450 ########### Horizontalprofil MESH ###########
451 #############################################
452 #############################################
453 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
454 mp.KPOSITION KEY, \
455 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \
456 from MEDIAN.MESHLAYER ml, \
457 MEDIAN.MESHPOINT mp \
458 where ml.KPOSITION = mp.KPOSITION and \
459 ml.MESHID = mp.MESHID and \
460 mp.FEATUREID in \
461 ( select FEATUREID \
462 from MEDIAN.MESHPOINT mp, \
463 MEDIAN.MESH m \
464 where m.OBJECTID = ? AND \
465 mp.MESHID = m.MESHID AND \
466 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
467 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
468 order by mp.KPOSITION
469
470 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
471 msv.DATAVALUE YORDINATE, \
472 msv.PARAMETERID GROUP1, \
473 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
474 msv.TIMEVALUE GROUP3, \
475 MEDIAN.MESHPOINT.JPOSITION , \
476 MEDIAN.MESHPOINT.IPOSITION \
477 from MEDIAN.MESHLAYER ml, \
478 MEDIAN.MESHPOINT , \
479 MEDIAN.MESH m, \
480 MEDIAN.MESHSCALARVALUE msv \
481 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
482 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
483 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
484 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
485 m.PARTIDMIN <= msv.PARTID AND \
486 m.PARTIDMAX >= msv.PARTID AND \
487 msv.PARAMETERID in (?) AND \
488 msv.TIMEVALUE in (?) AND \
489 m.OBJECTID = ? AND \
490 MEDIAN.MESHPOINT.FEATUREID in \
491 ( select FEATUREID \
492 from MEDIAN.MESHPOINT mp, \
493 MEDIAN.MESH m \
494 where m.OBJECTID = ? AND \
495 mp.MESHID = m.MESHID AND \
496 KPOSITION in ( ? ) and \
497 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
498 order by msv.TIMEVALUE, \
499 MEDIAN.MESHPOINT.KPOSITION, \
500 msv.PARAMETERID, \
501 MEDIAN.MESHPOINT.JPOSITION , \
502 MEDIAN.MESHPOINT.IPOSITION
503
504
505 #############################################
506 #############################################
507 ########### Profilschnitt MESH ###########
508 #############################################
509 #############################################
510 verticalcrosssection_mesh_date = select distinct \
511 msv.TIMEVALUE KEY, \
512 msv.TIMEVALUE VALUE \
513 from MEDIAN.MESHSCALARVALUE msv , \
514 MEDIAN.MESH m \
515 where m.OBJECTID = ? AND \
516 msv.PARTID >= m.PARTIDMIN AND \
517 msv.PARTID <= m.PARTIDMAX AND \
518 msv.PARAMETERID = ? \
519 order by msv.TIMEVALUE
520 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
521 msv.DATAVALUE YORDINATE, \
522 msv.PARAMETERID GROUP1, \
523 msv.TIMEVALUE GROUP2, \
524 MEDIAN.MESHPOINT.JPOSITION, \
525 MEDIAN.MESHPOINT.IPOSITION, \
526 MEDIAN.MESHPOINT.KPOSITION \
527 from MEDIAN.MESHLAYER ml, \
528 MEDIAN.MESHPOINT , \
529 MEDIAN.MESH m, \
530 MEDIAN.MESHSCALARVALUE msv \
531 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
532 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
533 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
534 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
535 m.PARTIDMIN <= msv.PARTID AND \
536 m.PARTIDMAX >= msv.PARTID AND \
537 msv.PARAMETERID = ? AND \
538 msv.TIMEVALUE = ? AND \
539 m.OBJECTID = ? AND \
540 MEDIAN.MESHPOINT.FEATUREID in \
541 ( select FEATUREID \
542 from MEDIAN.MESHPOINT mp, \
543 MEDIAN.MESH m \
544 where m.OBJECTID = ? AND \
545 mp.MESHID = m.MESHID AND \
546 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
547 order by msv.TIMEVALUE, \
548 msv.PARAMETERID, \
549 MEDIAN.MESHPOINT.JPOSITION , \
550 MEDIAN.MESHPOINT.IPOSITION, \
551 MEDIAN.MESHPOINT.KPOSITION
552
http://dive4elements.wald.intevation.org