Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/doc/conf/queries.properties @ 262:8b634333f935

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merged gnv-artifacts/0.2
author Thomas Arendsen Hein <thomas@intevation.de>
date Fri, 28 Sep 2012 12:13:44 +0200
parents af474a541f74
children e7f1c79bf9cd
comparison
equal deleted inserted replaced
169:6cf73f5ea4a9 262:8b634333f935
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_timeseriespoint_with_area=SELECT \
17 MEDIAN.TIMESERIESPOINT.FEATUREID KEY, \
18 MEDIAN.TIMESERIESPOINT.NAME VALUE \
19 FROM MEDIAN.TIMESERIESPOINT, \
20 MEDIAN.MEASUREMENT MMT \
21 WHERE MEDIAN.TIMESERIESPOINT.FEATUREID = MMT.FEATUREID AND \
22 MMT.SOURCEID = ? AND \
23 INTERSECTS(SHAPE, \
24 (SELECT st_astext(SHAPE) \
25 FROM MEDIAN.FEATUREAREA \
26 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
27 FEATURECODE = ? )\
28 )\
29 ORDER BY MEDIAN.TIMESERIESPOINT.NAME
30
31 timeseries_parameter=SELECT DISTINCT \
32 p.PARAMETERID KEY, \
33 p.GERMANNAME VALUE \
34 FROM MEDIAN.PARAMETER P, \
35 MEDIAN.TIMESERIES TS, \
36 MEDIAN.TIMESERIESVALUE TSV, \
37 MEDIAN.MEASUREMENT M, \
38 MEDIAN.TIMESERIESPOINT TSP \
39 WHERE M.FEATUREID = TSP.FEATUREID AND \
40 M.MEASUREMENTID = TSV.MEASUREMENTID AND \
41 TS.TIMESERIESID = TSV.TIMESERIESID AND \
42 P.PARAMETERID = TS.PARAMETERID AND \
43 TSP.FEATUREID = ? \
44 ORDER BY P.GERMANNAME
45
46 timeseries_depth_height=SELECT DISTINCT \
47 M.MEASUREMENTID KEY, \
48 M.ZLOCATION VALUE \
49 FROM MEDIAN.MEASUREMENT M, \
50 MEDIAN.TIMESERIESVALUE TSV, \
51 MEDIAN.TIMESERIES T, \
52 MEDIAN.PARAMETER P \
53 WHERE M.MEASUREMENTID = TSV.MEASUREMENTID AND \
54 TSV.TIMESERIESID = T.TIMESERIESID AND \
55 T.PARAMETERID = P.PARAMETERID AND \
56 M.FEATUREID = ? AND \
57 P.PARAMETERID IN (?)\
58 ORDER BY m.ZLOCATION DESC
59
60 timeseries_interval=select min(tv.TIMEVALUE) MIN, \
61 max(tv.TIMEVALUE) MAX \
62 from MEDIAN.TIMESERIES t , \
63 MEDIAN.TIMESERIESVALUE tv \
64 where tv.TIMESERIESID = t.TIMESERIESID AND \
65 t.PARAMETERID IN ( ? ) AND \
66 tv.MEASUREMENTID IN ( ? )
67
68 timeseries_chart_data=SELECT tv.TIMEVALUE XORDINATE, \
69 tv.DATAVALUE YORDINATE, \
70 t.PARAMETERID GROUP1, \
71 tv.MEASUREMENTID GROUP2, \
72 tv.TIMESERIESID GROUP3, \
73 t.TIMEINTERVAL GAPID \
74 FROM MEDIAN.TIMESERIESVALUE tv, \
75 MEDIAN.TIMESERIES t \
76 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \
77 t.PARAMETERID IN ( ? ) AND \
78 tv.MEASUREMENTID IN ( ? ) AND \
79 tv.TIMEVALUE >= ? AND \
80 tv.TIMEVALUE <= ? \
81 ORDER BY tv.MEASUREMENTID , \
82 tv.TIMESERIESID , \
83 t.PARAMETERID , \
84 tv.TIMEVALUE
85
86 timeseries_odv_data = SELECT SI.NAME CRUISE, \
87 MEDIAN.TIMESERIESPOINT.NAME STATION, \
88 '*' TYPE, \
89 ST_ASTEXT(SHAPE), \
90 0 BOTDEPTH, \
91 (M.ZLOCATION *-1) DEPTH, \
92 TSV.TIMEVALUE, \
93 TSV.DATAVALUE, \
94 TS.PARAMETERID PARAMETER, \
95 TSV.MEASUREMENTID, \
96 TSV.TIMESERIESID \
97 FROM MEDIAN.TIMESERIESPOINT , \
98 MEDIAN.TIMESERIESVALUE TSV, \
99 MEDIAN.TIMESERIES TS, \
100 MEDIAN.MEASUREMENT M, \
101 MEDIAN.SOURCEINFO SI \
102 WHERE SI.SOURCEID = M.SOURCEID AND \
103 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \
104 M.MEASUREMENTID = TSV.MEASUREMENTID AND \
105 TSV.TIMESERIESID = TS.TIMESERIESID AND \
106 TS.PARAMETERID IN ( ? ) AND \
107 TSV.MEASUREMENTID IN ( ? ) AND \
108 TSV.TIMEVALUE >= ? AND \
109 TSV.TIMEVALUE <= ? \
110 ORDER BY TSV.MEASUREMENTID , \
111 TSV.TIMESERIESID , \
112 TS.PARAMETERID , \
113 TSV.TIMEVALUE
114
115 #############################################
116 #############################################
117 ########## Zeitserie Mesh ##############
118 #############################################
119 #############################################
120
121 timeseries_mesh = SELECT OBJECTID KEY, \
122 m.NAME VALUE \
123 FROM MEDIAN.MESH m \
124 WHERE SOURCEID IN (?) \
125 ORDER BY m.NAME
126 timeseries_meshpoint = SELECT MEDIAN.MESHPOINT.FEATUREID, \
127 ST_ASTEXT(SHAPE) \
128 FROM MEDIAN.MESHPOINT, \
129 MEDIAN.MESH M \
130 WHERE MEDIAN.MESHPOINT.MESHID = M.MESHID AND \
131 KPOSITION = 1 AND \
132 M.OBJECTID = ? AND \
133 INTERSECTS(SHAPE,"?")
134
135 timeseries_meshpoint_depth = SELECT MP.FEATUREID KEY, \
136 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \
137 from MEDIAN.MESHLAYER ML, \
138 MEDIAN.MESHPOINT MP, \
139 MEDIAN.MESH M \
140 WHERE ML.KPOSITION = MP.KPOSITION AND \
141 ML.MESHID = MP.MESHID AND \
142 M.OBJECTID = ? AND \
143 MP.MESHID = M.MESHID AND \
144 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
145 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \
146 ORDER BY ML.UPPERZLOCATION DESC
147
148 timeseries_mesh_parameter=SELECT distinct \
149 p.PARAMETERID KEY , \
150 p.GERMANNAME VALUE \
151 from MEDIAN.PARAMETER p, \
152 MEDIAN.MESHSCALARVALUE msc, \
153 MEDIAN.MESH m \
154 where m.OBJECTID = ? AND \
155 msc.PARTID = m.PARTIDMIN AND \
156 msc.PARAMETERID = p.PARAMETERID \
157 order by p.GERMANNAME
158 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \
159 min(TIMEVALUE) MIN, \
160 max(TIMEVALUE) MAX \
161 from MEDIAN.MESHSCALARVALUE msc , \
162 MEDIAN.MESH m \
163 where m.OBJECTID = ? AND \
164 msc.PARTID >= m.PARTIDMIN AND \
165 msc.PARTID <= m.PARTIDMAX AND \
166 msc.PARAMETERID IN (?)
167
168 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \
169 msv.TIMEVALUE XORDINATE, \
170 msv.DATAVALUE YORDINATE, \
171 msv.PARAMETERID GROUP1, \
172 msv.FEATUREID GROUP2, \
173 mp.FEATUREID GROUP3, \
174 -1 GAPID \
175 from MEDIAN.MESHSCALARVALUE msv , \
176 MEDIAN.MESHPOINT mp, \
177 MEDIAN.MESH m \
178 where (m.OBJECTID = ? AND \
179 msv.PARTID >= m.PARTIDMIN AND \
180 msv.PARTID <= m.PARTIDMAX ) AND \
181 msv.FEATUREID in ( ? ) AND \
182 msv.PARAMETERID in ( ? ) AND \
183 mp.FEATUREID in ( ? ) AND \
184 msv.TIMEVALUE >= ? AND \
185 msv.TIMEVALUE <= ? \
186 order by mp.FEATUREID, \
187 msv.FEATUREID, \
188 msv.PARAMETERID, \
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
222
223 #############################################
224 #############################################
225 ########## Vertikalprofil ##############
226 #############################################
227 #############################################
228
229 verticalprofile_point=SELECT DISTINCT \
230 tsp.FEATUREID KEY, \
231 tsp.NAME VALUE \
232 FROM MEDIAN.TIMESERIESPOINT tsp, \
233 MEDIAN.MEASUREMENT mmt \
234 WHERE tsp.FEATUREID = mmt.FEATUREID AND \
235 mmt.SOURCEID = ? \
236 order by tsp.name
237
238 verticalprofile_parameter=SELECT DISTINCT \
239 p.PARAMETERID KEY, \
240 p.GERMANNAME VALUE \
241 from MEDIAN.PARAMETER p, \
242 MEDIAN.TIMESERIES ts, \
243 MEDIAN.TIMESERIESVALUE tsv, \
244 MEDIAN.MEASUREMENT m \
245 where ts.PARAMETERID = p.PARAMETERID and \
246 ts.TIMESERIESID = tsv.TIMESERIESID and \
247 m.MEASUREMENTID = tsv.MEASUREMENTID and \
248 m.FEATUREID = ? \
249 ORDER BY p.GERMANNAME
250
251 verticalprofile_minmaxdepth= SELECT min(M.ZLOCATION) MIN, \
252 max(M.ZLOCATION) MAX \
253 FROM MEDIAN.MEASUREMENT M, \
254 MEDIAN.TIMESERIES TS, \
255 MEDIAN.TIMESERIESVALUE TSV \
256 WHERE TS.TIMESERIESID = TSV.TIMESERIESID and \
257 M.MEASUREMENTID = TSV.MEASUREMENTID and \
258 M.FEATUREID = ? and \
259 TS.PARAMETERID IN ( ? )
260
261 verticalprofile_date=select distinct \
262 tsv.TIMEVALUE KEY, \
263 tsv.TIMEVALUE VALUE \
264 from MEDIAN.TIMESERIES ts , \
265 MEDIAN.TIMESERIESVALUE tsv, \
266 MEDIAN.MEASUREMENT m \
267 where ts.TIMESERIESID = tsv.TIMESERIESID and \
268 m.MEASUREMENTID = tsv.MEASUREMENTID and \
269 m.FEATUREID = ? and \
270 ts.PARAMETERID IN ( ? ) \
271 order by tsv.TIMEVALUE
272
273 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \
274 TSV.DATAVALUE YORDINATE, \
275 TS.PARAMETERID GROUP1, \
276 TSV.TIMEVALUE GROUP2, \
277 1 GROUP3 \
278 from MEDIAN.TIMESERIES TS, \
279 MEDIAN.TIMESERIESVALUE TSV, \
280 MEDIAN.MEASUREMENT M \
281 where TS.TIMESERIESID = TSV.TIMESERIESID AND \
282 M.MEASUREMENTID = TSV.MEASUREMENTID AND \
283 M.FEATUREID = ? AND \
284 TS.PARAMETERID IN ( ? ) AND \
285 TSV.TIMEVALUE IN (?) AND \
286 M.ZLOCATION >= ? AND \
287 M.ZLOCATION <= ? \
288 ORDER BY TSV.TIMEVALUE , \
289 TSV.TIMESERIESID , \
290 TS.PARAMETERID , \
291 TSV.TIMEVALUE
292
293 verticalprofile_odv_data = SELECT SI.NAME CRUISE, \
294 MEDIAN.TIMESERIESPOINT.NAME STATION, \
295 '*' TYPE, \
296 ST_ASTEXT(SHAPE), \
297 0 BOTDEPTH, \
298 (M.ZLOCATION *-1) DEPTH, \
299 TSV.TIMEVALUE, \
300 TSV.DATAVALUE, \
301 TS.PARAMETERID PARAMETER, \
302 TSV.MEASUREMENTID, \
303 TSV.TIMESERIESID \
304 FROM MEDIAN.TIMESERIESPOINT , \
305 MEDIAN.TIMESERIESVALUE TSV, \
306 MEDIAN.TIMESERIES TS, \
307 MEDIAN.MEASUREMENT M, \
308 MEDIAN.SOURCEINFO SI \
309 WHERE SI.SOURCEID = M.SOURCEID AND \
310 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \
311 M.MEASUREMENTID = TSV.MEASUREMENTID AND \
312 TSV.TIMESERIESID = TS.TIMESERIESID AND \
313 M.FEATUREID = ? AND \
314 TS.PARAMETERID IN ( ? ) AND \
315 TSV.TIMEVALUE IN (?) AND \
316 M.ZLOCATION >= ? AND \
317 M.ZLOCATION <= ? \
318 ORDER BY TSV.MEASUREMENTID , \
319 TSV.TIMESERIESID , \
320 TS.PARAMETERID , \
321 TSV.TIMEVALUE
322
323 #############################################
324 #############################################
325 ########## Vertikalprofil Mesh ##############
326 #############################################
327 #############################################
328
329 verticalprofile_mesh = SELECT OBJECTID KEY, \
330 m.NAME VALUE \
331 FROM MEDIAN.MESH m \
332 WHERE SOURCEID IN (?) \
333 order by m.NAME
334
335 verticalprofile_mesh_with_area = SELECT M.OBJECTID KEY, \
336 M.NAME VALUE \
337 FROM MEDIAN.MESHPOINT, \
338 MEDIAN.MESH M \
339 WHERE M.SOURCEID IN (?) AND \
340 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \
341 INTERSECTS(SHAPE, \
342 (SELECT st_astext(SHAPE) \
343 FROM MEDIAN.FEATUREAREA \
344 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
345 FEATURECODE = ? )\
346 ) \
347 order by M.NAME
348
349 verticalprofile_mesh_point = SELECT FEATUREID, \
350 ST_ASTEXT(SHAPE) \
351 FROM MEDIAN.MESHPOINT \
352 WHERE MESHID in \
353 (SELECT DISTINCT MESHID \
354 FROM MEDIAN.MESH \
355 WHERE OBJECTID = ?) AND \
356 KPOSITION = 1 AND \
357 INTERSECTS(SHAPE,"?")
358
359 verticalprofile_mesh_mindepth = SELECT MP.KPOSITION KEY, \
360 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \
361 from MEDIAN.MESHLAYER ML, \
362 MEDIAN.MESHPOINT MP, \
363 MEDIAN.MESH M \
364 WHERE ML.KPOSITION = MP.KPOSITION AND \
365 ML.MESHID = MP.MESHID AND \
366 M.OBJECTID = ? AND \
367 MP.MESHID = M.MESHID AND \
368 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
369 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \
370 ORDER BY ML.UPPERZLOCATION DESC
371
372 verticalprofile_mesh_maxdepth = SELECT MP.KPOSITION KEY, \
373 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \
374 from MEDIAN.MESHLAYER ML, \
375 MEDIAN.MESHPOINT MP, \
376 MEDIAN.MESH M \
377 WHERE ML.KPOSITION = MP.KPOSITION AND \
378 ML.MESHID = MP.MESHID AND \
379 M.OBJECTID = ? AND \
380 MP.MESHID = M.MESHID AND \
381 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
382 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
383 MP.KPOSITION < ? \
384 ORDER BY ML.UPPERZLOCATION DESC
385
386 verticalprofile_mesh_parameter=SELECT distinct \
387 p.PARAMETERID KEY , \
388 p.GERMANNAME VALUE \
389 from MEDIAN.PARAMETER p, \
390 MEDIAN.MESHSCALARVALUE msc, \
391 MEDIAN.MESH m \
392 where m.OBJECTID = ? AND \
393 m.PARTIDMIN = msc.PARTID AND \
394 msc.PARAMETERID = p.PARAMETERID \
395 order by p.GERMANNAME
396
397 verticalprofile_mesh_date= select distinct \
398 msv.TIMEVALUE KEY, \
399 msv.TIMEVALUE VALUE \
400 from MEDIAN.MESHSCALARVALUE msv , \
401 MEDIAN.MESH m \
402 where m.OBJECTID = ? AND \
403 msv.PARTID >= m.PARTIDMIN AND \
404 msv.PARTID <= m.PARTIDMAX AND \
405 msv.PARAMETERID in (?) \
406 order by msv.TIMEVALUE
407
408 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \
409 msv.DATAVALUE YORDINATE, \
410 msv.PARAMETERID GROUP1, \
411 msv.TIMEVALUE GROUP2, \
412 1 GROUP3 \
413 from MEDIAN.MESHLAYER ml, \
414 MEDIAN.MESHPOINT mp, \
415 MEDIAN.MESH m, \
416 MEDIAN.MESHSCALARVALUE msv \
417 where msv.FEATUREID = mp. FEATUREID AND \
418 ml.KPOSITION = mp.KPOSITION and \
419 ml.MESHID = mp.MESHID and \
420 m.MESHID = mp.MESHID AND \
421 m.PARTIDMIN <= msv.PARTID AND \
422 m.PARTIDMAX >= msv.PARTID AND \
423 msv.PARAMETERID in (?) AND \
424 msv.TIMEVALUE in (?) AND \
425 m.OBJECTID = ? AND \
426 mp.FEATUREID in \
427 ( select FEATUREID \
428 from MEDIAN.MESHPOINT mp, \
429 MEDIAN.MESH m \
430 where m.OBJECTID = ? AND \
431 mp.MESHID = m.MESHID AND \
432 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
433 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) AND \
434 mp.KPOSITION <= ? AND \
435 mp.KPOSITION >= ? \
436 order by msv.PARAMETERID, \
437 msv.TIMEVALUE, \
438 ml.UPPERZLOCATION
439
440 verticalprofile_mesh_odv_data=select SI.NAME CRUISE, \
441 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
442 '*' TYPE, \
443 ST_ASTEXT(SHAPE), \
444 0 BOTDEPTH, \
445 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
446 msv.DATAVALUE , \
447 msv.PARAMETERID PARAMETER, \
448 msv.TIMEVALUE , \
449 from MEDIAN.MESHLAYER ml, \
450 MEDIAN.MESHPOINT, \
451 MEDIAN.MESH m, \
452 MEDIAN.MESHSCALARVALUE msv, \
453 MEDIAN.SOURCEINFO SI \
454 where m.SOURCEID = SI.SOURCEID AND \
455 msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
456 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
457 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
458 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
459 m.PARTIDMIN <= msv.PARTID AND \
460 m.PARTIDMAX >= msv.PARTID AND \
461 msv.PARAMETERID in (?) AND \
462 msv.TIMEVALUE in (?) AND \
463 m.OBJECTID = ? AND \
464 MEDIAN.MESHPOINT.FEATUREID in \
465 ( select FEATUREID \
466 from MEDIAN.MESHPOINT mp, \
467 MEDIAN.MESH m \
468 where m.OBJECTID = ? AND \
469 mp.MESHID = m.MESHID AND \
470 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
471 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) AND \
472 MEDIAN.MESHPOINT.KPOSITION <= ? AND \
473 MEDIAN.MESHPOINT.KPOSITION >= ? \
474 order by msv.PARAMETERID, \
475 msv.TIMEVALUE, \
476 ml.UPPERZLOCATION
477
478 #############################################
479 #############################################
480 ##### Vertikalprofil InstantaneousPoint #####
481 #############################################
482 #############################################
483
484 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \
485 S.SERIESID KEY , \
486 S.DESCRIPTION VALUE \
487 FROM MEDIAN.SERIES S, \
488 MEDIAN.INSTANTANEOUSPOINT I, \
489 MEDIAN.MEASUREMENT M \
490 WHERE S.SERIESID = I.SERIESID AND \
491 I.POINTSPEC = 4 AND \
492 I.FEATUREID = M.FEATUREID AND \
493 M.SOURCEID= ? \
494 ORDER BY S.DESCRIPTION
495
496 verticalprofile_instantaneouspoint_point = SELECT \
497 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
498 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \
499 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \
500 ST_ASTEXT(SHAPE) \
501 FROM MEDIAN.INSTANTANEOUSPOINT, \
502 MEDIAN.MEASUREMENT M \
503 WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \
504 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \
505 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
506 M.SOURCEID = ? \
507 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
508 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
509
510 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
511 P.PARAMETERID KEY , \
512 P.GERMANNAME VALUE \
513 FROM MEDIAN.PARAMETER P, \
514 MEDIAN.INSTANTANEOUSPOINT IP, \
515 MEDIAN.MEASUREMENT M, \
516 MEDIAN.MEASUREDSCALARVALUE MSV \
517 WHERE IP.FEATUREID = M.FEATUREID AND \
518 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
519 MSV.PARAMETERID = P.PARAMETERID AND \
520 IP.FEATUREID = ? \
521 ORDER BY P.GERMANNAME
522
523 verticalprofile_instantaneouspoint_minmaxdepth = SELECT min(M.ZLOCATION) MIN, \
524 max(M.ZLOCATION) MAX \
525 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
526 MEDIAN.MEASUREMENT M, \
527 MEDIAN.MEASUREDSCALARVALUE MSV \
528 WHERE IP.FEATUREID = M.FEATUREID AND \
529 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
530 IP.FEATUREID = ? AND \
531 MSV.PARAMETERID in (?)
532
533 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \
534 MSV.DATAVALUE YORDINATE, \
535 MSV.PARAMETERID GROUP1, \
536 IP.TIMEVALUE GROUP2, \
537 1 GROUP3 \
538 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
539 MEDIAN.MEASUREMENT M, \
540 MEDIAN.MEASUREDSCALARVALUE MSV \
541 WHERE IP.FEATUREID = M.FEATUREID AND \
542 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
543 IP.FEATUREID = ? AND \
544 MSV.PARAMETERID in (?) AND \
545 M.ZLOCATION >= ? AND \
546 M.ZLOCATION <= ? \
547 ORDER BY IP.TIMEVALUE, \
548 MSV.PARAMETERID, \
549 M.ZLOCATION
550
551 verticalprofile_instantaneouspoint_odv_data = SELECT S.DESCRIPTION CRUISE, \
552 MEDIAN.INSTANTANEOUSPOINT.FEATUREID STATION, \
553 '*' TYPE, \
554 ST_ASTEXT(SHAPE), \
555 0 BOTDEPTH, \
556 (M.ZLOCATION * -1) DEPTH, \
557 MSV.DATAVALUE, \
558 MSV.PARAMETERID PARAMETER, \
559 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE \
560 FROM MEDIAN.SERIES S, \
561 MEDIAN.INSTANTANEOUSPOINT, \
562 MEDIAN.MEASUREMENT M, \
563 MEDIAN.MEASUREDSCALARVALUE MSV \
564 WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \
565 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
566 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
567 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = ? AND \
568 MSV.PARAMETERID in (?) AND \
569 M.ZLOCATION >= ? AND \
570 M.ZLOCATION <= ? \
571 ORDER BY MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \
572 MSV.PARAMETERID, \
573 M.ZLOCATION
574
575 #############################################
576 #############################################
577 #### Horizontalprofil InstantaneousPoint ####
578 #############################################
579 #############################################
580 horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \
581 V.VEHICLEID KEY, \
582 V.NAME VALUE \
583 FROM MEDIAN.VEHICLE V, \
584 MEDIAN.CRUISE C, \
585 MEDIAN.TRACK T, \
586 MEDIAN.SURVEYINFO S, \
587 MEDIAN.INSTANTANEOUSPOINT I, \
588 MEDIAN.MEASUREMENT M \
589 WHERE V.VEHICLEID = C.VEHICLEID AND \
590 C.CRUISEID = T.CRUISEID AND \
591 T.TRACKID = S.TRACKID AND \
592 S.SURVEYID = I.SURVEYID AND \
593 I.FEATUREID = M.FEATUREID AND \
594 M.SOURCEID = ? \
595 ORDER BY V.NAME
596 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \
597 C.CRUISEID KEY , \
598 V.NAME || ' ' || \
599 C.NAME || ' ' || \
600 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \
601 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE , \
602 V.NAME , \
603 C.NAME \
604 FROM MEDIAN.CRUISE C, \
605 MEDIAN.VEHICLE V, \
606 MEDIAN.TRACK T, \
607 MEDIAN.SURVEYINFO S, \
608 MEDIAN.INSTANTANEOUSPOINT I, \
609 MEDIAN.MEASUREMENT M \
610 WHERE C.VEHICLEID = V.VEHICLEID AND \
611 C.CRUISEID = T.CRUISEID AND \
612 T.TRACKID = S.TRACKID AND \
613 S.SURVEYID = I.SURVEYID AND \
614 I.FEATUREID = M.FEATUREID AND \
615 C.VEHICLEID = ? AND \
616 M.SOURCEID = ? \
617 ORDER BY V.NAME, C.NAME
618 horizontalprofile_instantaneouspoint_track= SELECT \
619 T.TRACKID KEY , \
620 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \
621 FROM MEDIAN.TRACK T \
622 WHERE T.CRUISEID = ? \
623 ORDER BY T.STARTDATE, \
624 T.ENDDATE, \
625 T.NAME
626 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \
627 SURVEYID KEY , \
628 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \
629 FROM MEDIAN.SURVEYINFO \
630 WHERE TRACKID = ? \
631 ORDER BY STARTDATE, \
632 ENDDATE, \
633 DESCRIPTION
634 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
635 P.PARAMETERID KEY , \
636 P.GERMANNAME VALUE \
637 FROM MEDIAN.PARAMETER P , \
638 MEDIAN.MEASUREMENT M , \
639 MEDIAN.INSTANTANEOUSPOINT IP , \
640 MEDIAN.MEASUREDSCALARVALUE MSV \
641 WHERE P.PARAMETERID = MSV.PARAMETERID AND \
642 MSV.MEASUREMENTID = M.MEASUREMENTID AND \
643 M.FEATUREID = IP.FEATUREID AND \
644 IP.SURVEYID = ? \
645 ORDER BY P.GERMANNAME
646 horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \
647 M.ZLOCATION KEY, \
648 M.ZLOCATION VALUE \
649 FROM MEDIAN.MEASUREMENT M , \
650 MEDIAN.INSTANTANEOUSPOINT IP \
651 WHERE M.FEATUREID = IP.FEATUREID AND \
652 IP.SURVEYID = ? \
653 ORDER BY M.ZLOCATION
654 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE) , \
655 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME , \
656 MSV.DATAVALUE YORDINATE , \
657 MSV.PARAMETERID GROUP1 , \
658 ZLOCATION GROUP2 , \
659 1 GROUP3 \
660 FROM MEDIAN.INSTANTANEOUSPOINT, \
661 MEDIAN.MEASUREMENT M, \
662 MEDIAN.MEASUREDSCALARVALUE MSV \
663 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
664 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
665 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \
666 M.ZLOCATION IN (?) AND \
667 MSV.PARAMETERID in (?) \
668 ORDER BY MSV.PARAMETERID, \
669 M.ZLOCATION, \
670 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
671 horizontalprofile_instantaneouspoint_odv_data = SELECT V.NAME || ' ' || C.NAME CRUISE, \
672 MEDIAN.InstantaneousPoint.FEATUREID STATION, \
673 '*' TYPE, \
674 0 BOTDEPTH, \
675 (M.ZLOCATION * -1) DEPTH , \
676 ST_ASTEXT(SHAPE) , \
677 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \
678 MSV.DATAVALUE, \
679 MSV.PARAMETERID PARAMETER \
680 FROM MEDIAN.INSTANTANEOUSPOINT, \
681 MEDIAN.VEHICLE V, \
682 MEDIAN.CRUISE C, \
683 (SELECT TRACKID,CRUISEID FROM MEDIAN.TRACK) T, \
684 MEDIAN.SURVEYINFO S, \
685 MEDIAN.MEASUREMENT M, \
686 MEDIAN.MEASUREDSCALARVALUE MSV \
687 WHERE V.VEHICLEID = C.VEHICLEID AND \
688 C.CRUISEID = T.CRUISEID AND \
689 T.TRACKID = S.TRACKID AND \
690 S.SURVEYID = MEDIAN.INSTANTANEOUSPOINT.SURVEYID AND \
691 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
692 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
693 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \
694 M.ZLOCATION IN (?) AND \
695 MSV.PARAMETERID in (?) \
696 ORDER BY MSV.PARAMETERID, \
697 M.ZLOCATION, \
698 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
699
700 #############################################
701 #############################################
702 ########### Horizontalprofil MESH ###########
703 #############################################
704 #############################################
705 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
706 mp.KPOSITION KEY, \
707 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \
708 from MEDIAN.MESHLAYER ml, \
709 MEDIAN.MESHPOINT mp \
710 where ml.KPOSITION = mp.KPOSITION and \
711 ml.MESHID = mp.MESHID and \
712 mp.FEATUREID in \
713 ( select FEATUREID \
714 from MEDIAN.MESHPOINT mp, \
715 MEDIAN.MESH m \
716 where m.OBJECTID = ? AND \
717 mp.MESHID = m.MESHID AND \
718 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
719 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
720 order by mp.KPOSITION
721
722 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
723 msv.DATAVALUE YORDINATE, \
724 msv.PARAMETERID GROUP1, \
725 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
726 msv.TIMEVALUE GROUP3, \
727 MEDIAN.MESHPOINT.JPOSITION , \
728 MEDIAN.MESHPOINT.IPOSITION \
729 from MEDIAN.MESHLAYER ml, \
730 MEDIAN.MESHPOINT , \
731 MEDIAN.MESH m, \
732 MEDIAN.MESHSCALARVALUE msv \
733 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
734 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
735 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
736 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
737 m.PARTIDMIN <= msv.PARTID AND \
738 m.PARTIDMAX >= msv.PARTID AND \
739 msv.PARAMETERID in (?) AND \
740 msv.TIMEVALUE in (?) AND \
741 m.OBJECTID = ? AND \
742 MEDIAN.MESHPOINT.FEATUREID in \
743 ( select FEATUREID \
744 from MEDIAN.MESHPOINT mp, \
745 MEDIAN.MESH m \
746 where m.OBJECTID = ? AND \
747 mp.MESHID = m.MESHID AND \
748 KPOSITION in ( ? ) and \
749 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
750 order by msv.TIMEVALUE, \
751 MEDIAN.MESHPOINT.KPOSITION, \
752 msv.PARAMETERID, \
753 MEDIAN.MESHPOINT.JPOSITION , \
754 MEDIAN.MESHPOINT.IPOSITION
755
756 horizontalprofile_mesh_odv_data = SELECT SI.NAME CRUISE, \
757 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
758 '*' TYPE, \
759 ST_ASTEXT(SHAPE), \
760 0 BOTDEPTH, \
761 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
762 msv.DATAVALUE , \
763 msv.PARAMETERID PARAMETER, \
764 msv.TIMEVALUE, \
765 MEDIAN.MESHPOINT.JPOSITION , \
766 MEDIAN.MESHPOINT.IPOSITION \
767 from MEDIAN.MESHLAYER ml, \
768 MEDIAN.MESHPOINT , \
769 MEDIAN.MESH m, \
770 MEDIAN.MESHSCALARVALUE msv, \
771 MEDIAN.SOURCEINFO SI \
772 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
773 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
774 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
775 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
776 m.SOURCEID = SI.SOURCEID AND \
777 m.PARTIDMIN <= msv.PARTID AND \
778 m.PARTIDMAX >= msv.PARTID AND \
779 msv.PARAMETERID in (?) AND \
780 msv.TIMEVALUE in (?) AND \
781 m.OBJECTID = ? AND \
782 MEDIAN.MESHPOINT.FEATUREID in \
783 ( select FEATUREID \
784 from MEDIAN.MESHPOINT mp, \
785 MEDIAN.MESH m \
786 where m.OBJECTID = ? AND \
787 mp.MESHID = m.MESHID AND \
788 KPOSITION in ( ? ) and \
789 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
790 order by msv.TIMEVALUE, \
791 MEDIAN.MESHPOINT.KPOSITION, \
792 msv.PARAMETERID, \
793 MEDIAN.MESHPOINT.JPOSITION , \
794 MEDIAN.MESHPOINT.IPOSITION
795
796
797 #############################################
798 #############################################
799 ############# Profilschnitt MESH ############
800 #############################################
801 #############################################
802 verticalcrosssection_mesh_date = select distinct \
803 msv.TIMEVALUE KEY, \
804 msv.TIMEVALUE VALUE \
805 from MEDIAN.MESHSCALARVALUE msv , \
806 MEDIAN.MESH m \
807 where m.OBJECTID = ? AND \
808 msv.PARTID >= m.PARTIDMIN AND \
809 msv.PARTID <= m.PARTIDMAX AND \
810 msv.PARAMETERID = ? \
811 order by msv.TIMEVALUE
812 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
813 msv.DATAVALUE YORDINATE, \
814 msv.PARAMETERID GROUP1, \
815 msv.TIMEVALUE GROUP2, \
816 MEDIAN.MESHPOINT.JPOSITION, \
817 MEDIAN.MESHPOINT.IPOSITION, \
818 MEDIAN.MESHPOINT.KPOSITION \
819 from MEDIAN.MESHLAYER ml, \
820 MEDIAN.MESHPOINT , \
821 MEDIAN.MESH m, \
822 MEDIAN.MESHSCALARVALUE msv \
823 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
824 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
825 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
826 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
827 m.PARTIDMIN <= msv.PARTID AND \
828 m.PARTIDMAX >= msv.PARTID AND \
829 msv.PARAMETERID = ? AND \
830 msv.TIMEVALUE = ? AND \
831 m.OBJECTID = ? AND \
832 MEDIAN.MESHPOINT.FEATUREID in \
833 ( select FEATUREID \
834 from MEDIAN.MESHPOINT mp, \
835 MEDIAN.MESH m \
836 where m.OBJECTID = ? AND \
837 mp.MESHID = m.MESHID AND \
838 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
839 order by msv.TIMEVALUE, \
840 msv.PARAMETERID, \
841 MEDIAN.MESHPOINT.JPOSITION , \
842 MEDIAN.MESHPOINT.IPOSITION, \
843 MEDIAN.MESHPOINT.KPOSITION
844
845 verticalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \
846 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
847 '*' TYPE, \
848 ST_ASTEXT(SHAPE), \
849 0 BOTDEPTH, \
850 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
851 MSV.TIMEVALUE, \
852 MSV.DATAVALUE , \
853 MSV.PARAMETERID PARAMETER, \
854 MEDIAN.MESHPOINT.JPOSITION, \
855 MEDIAN.MESHPOINT.IPOSITION, \
856 MEDIAN.MESHPOINT.KPOSITION \
857 from MEDIAN.MESHLAYER ml, \
858 MEDIAN.MESHPOINT , \
859 MEDIAN.MESH m, \
860 MEDIAN.SOURCEINFO SI, \
861 MEDIAN.MESHSCALARVALUE msv \
862 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
863 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
864 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
865 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
866 m.PARTIDMIN <= msv.PARTID AND \
867 m.PARTIDMAX >= msv.PARTID AND \
868 M.SOURCEID = SI.SOURCEID AND \
869 msv.PARAMETERID = ? AND \
870 msv.TIMEVALUE = ? AND \
871 m.OBJECTID = ? AND \
872 MEDIAN.MESHPOINT.FEATUREID in \
873 ( select FEATUREID \
874 from MEDIAN.MESHPOINT mp, \
875 MEDIAN.MESH m \
876 where m.OBJECTID = ? AND \
877 mp.MESHID = m.MESHID AND \
878 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
879 order by msv.TIMEVALUE, \
880 msv.PARAMETERID, \
881 MEDIAN.MESHPOINT.JPOSITION , \
882 MEDIAN.MESHPOINT.IPOSITION, \
883 MEDIAN.MESHPOINT.KPOSITION
884
885 #############################################
886 #############################################
887 ########## Horizontalschnitt MESH ###########
888 #############################################
889 #############################################
890 horizontalcrosssection_meshpoint_depth = SELECT DISTINCT MP.KPOSITION KEY, \
891 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \
892 from MEDIAN.MESHLAYER ML, \
893 MEDIAN.MESHPOINT MP, \
894 MEDIAN.MESH M \
895 WHERE ML.KPOSITION = MP.KPOSITION AND \
896 ML.MESHID = MP.MESHID AND \
897 M.OBJECTID = ? AND \
898 MP.MESHID = M.MESHID \
899 ORDER BY MP.KPOSITION
900
901 horizontalcrosssection_mesh_date = select distinct \
902 msv.TIMEVALUE KEY, \
903 msv.TIMEVALUE VALUE \
904 from MEDIAN.MESHSCALARVALUE msv , \
905 MEDIAN.MESH m \
906 where m.OBJECTID = ? AND \
907 msv.PARTID >= m.PARTIDMIN AND \
908 msv.PARTID <= m.PARTIDMAX AND \
909 msv.PARAMETERID = ? \
910 order by msv.TIMEVALUE
911
912 horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \
913 MSV.DATAVALUE YORDINATE, \
914 MEDIAN.MESHFACE.JPOSITION, \
915 MEDIAN.MESHFACE.IPOSITION, \
916 MEDIAN.MESHFACE.KPOSITION \
917 from MEDIAN.MESHLAYER ML, \
918 MEDIAN.MESHFACE, \
919 MEDIAN.MESH M, \
920 MEDIAN.MESHSCALARVALUE MSV \
921 where MSV.FEATUREID = MEDIAN.MESHFACE.FEATUREID AND \
922 ML.KPOSITION = MEDIAN.MESHFACE.KPOSITION and \
923 ML.MESHID = MEDIAN.MESHFACE.MESHID and \
924 M.MESHID = MEDIAN.MESHFACE.MESHID AND \
925 M.PARTIDMIN <= MSV.PARTID AND \
926 M.PARTIDMAX >= MSV.PARTID AND \
927 MSV.PARAMETERID = ? AND \
928 MSV.TIMEVALUE = ? AND \
929 M.OBJECTID = ? AND \
930 MEDIAN.MESHFACE.KPOSITION = ? \
931 order by MEDIAN.MESHFACE.JPOSITION , \
932 MEDIAN.MESHFACE.IPOSITION
933 horizontalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \
934 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
935 '*' TYPE, \
936 ST_ASTEXT(SHAPE), \
937 0 BOTDEPTH, \
938 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
939 MSV.TIMEVALUE, \
940 MSV.DATAVALUE , \
941 MSV.PARAMETERID PARAMETER, \
942 MEDIAN.MESHPOINT.JPOSITION, \
943 MEDIAN.MESHPOINT.IPOSITION, \
944 MEDIAN.MESHPOINT.KPOSITION \
945 from MEDIAN.MESHLAYER ML, \
946 MEDIAN.MESHPOINT, \
947 MEDIAN.MESH M, \
948 MEDIAN.SOURCEINFO SI, \
949 MEDIAN.MESHSCALARVALUE MSV \
950 where MSV.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \
951 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
952 ML.MESHID = MEDIAN.MESHPOINT.MESHID and \
953 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \
954 M.PARTIDMIN <= MSV.PARTID AND \
955 M.PARTIDMAX >= MSV.PARTID AND \
956 M.SOURCEID = SI.SOURCEID AND \
957 MSV.PARAMETERID = ? AND \
958 MSV.TIMEVALUE = ? AND \
959 M.OBJECTID = ? AND \
960 MEDIAN.MESHPOINT.KPOSITION = ? \
961 order by MEDIAN.MESHPOINT.JPOSITION , \
962 MEDIAN.MESHPOINT.IPOSITION
963
964 area_filter = SELECT DISTINCT \
965 FEATUREID KEY ,\
966 DESCRIPTION VALUE \
967 FROM MEDIAN.FEATUREAREA \
968 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
969 FEATUREID > 0 \
970 ORDER BY FEATUREID
971
972 subarea_filter = SELECT \
973 FEATURECODE KEY, \
974 NAME VALUE \
975 FROM MEDIAN.FEATUREAREA \
976 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
977 FEATUREID = ? \
978 ORDER BY NAME
http://dive4elements.wald.intevation.org