Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/doc/conf/queries.properties @ 875:5e9efdda6894

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merged gnv-artifacts/1.0
author Thomas Arendsen Hein <thomas@intevation.de>
date Fri, 28 Sep 2012 12:13:56 +0200
parents 3fbabd4803d7
children 35c442410738
comparison
equal deleted inserted replaced
722:bb3ffe7d719e 875:5e9efdda6894
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_timeseriespoint_with_wkt=SELECT \
32 MEDIAN.TIMESERIESPOINT.FEATUREID KEY, \
33 MEDIAN.TIMESERIESPOINT.NAME VALUE \
34 FROM MEDIAN.TIMESERIESPOINT, \
35 MEDIAN.MEASUREMENT MMT \
36 WHERE MEDIAN.TIMESERIESPOINT.FEATUREID = MMT.FEATUREID AND \
37 MMT.SOURCEID = ? AND \
38 INTERSECTS(SHAPE,"?")\
39 ORDER BY MEDIAN.TIMESERIESPOINT.NAME
40
41 timeseries_parameter=SELECT DISTINCT \
42 p.PARAMETERID KEY, \
43 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
44 p.GERMANNAME \
45 FROM MEDIAN.PARAMETER P, \
46 MEDIAN.TIMESERIES TS, \
47 MEDIAN.TIMESERIESVALUE TSV, \
48 MEDIAN.MEASUREMENT M, \
49 MEDIAN.TIMESERIESPOINT TSP \
50 WHERE M.FEATUREID = TSP.FEATUREID AND \
51 M.MEASUREMENTID = TSV.MEASUREMENTID AND \
52 TS.TIMESERIESID = TSV.TIMESERIESID AND \
53 P.PARAMETERID = TS.PARAMETERID AND \
54 TSP.FEATUREID = ? \
55 ORDER BY P.GERMANNAME
56
57 timeseries_depth_height=SELECT DISTINCT \
58 M.MEASUREMENTID KEY, \
59 M.ZLOCATION VALUE, \
60 P.PARAMETERID PARAMETERID \
61 FROM MEDIAN.MEASUREMENT M, \
62 MEDIAN.TIMESERIESVALUE TSV, \
63 MEDIAN.TIMESERIES T, \
64 MEDIAN.PARAMETER P \
65 WHERE M.MEASUREMENTID = TSV.MEASUREMENTID AND \
66 TSV.TIMESERIESID = T.TIMESERIESID AND \
67 T.PARAMETERID = P.PARAMETERID AND \
68 M.FEATUREID = ? AND \
69 P.PARAMETERID IN (?)\
70 ORDER BY m.ZLOCATION DESC
71
72 timeseries_interval=select min(tv.TIMEVALUE) MIN, \
73 max(tv.TIMEVALUE) MAX \
74 from MEDIAN.TIMESERIES t, \
75 MEDIAN.TIMESERIESVALUE tv \
76 where tv.TIMESERIESID = t.TIMESERIESID AND \
77 t.PARAMETERID IN ( ? ) AND \
78 tv.MEASUREMENTID IN ( ? )
79
80 timeseries_chart_data=SELECT tv.TIMEVALUE XORDINATE, \
81 tv.DATAVALUE YORDINATE, \
82 t.PARAMETERID GROUP1, \
83 tv.MEASUREMENTID GROUP2, \
84 tv.TIMESERIESID GROUP3, \
85 t.TIMEINTERVAL GAPID \
86 FROM MEDIAN.TIMESERIESVALUE tv, \
87 MEDIAN.TIMESERIES t \
88 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \
89 t.PARAMETERID IN ( ? ) AND \
90 tv.MEASUREMENTID IN ( ? ) AND \
91 tv.TIMEVALUE >= ? AND \
92 tv.TIMEVALUE <= ? \
93 ORDER BY tv.MEASUREMENTID, \
94 tv.TIMESERIESID, \
95 t.PARAMETERID, \
96 tv.TIMEVALUE
97
98 timeseries_odv_data = SELECT SI.NAME CRUISE, \
99 MEDIAN.TIMESERIESPOINT.NAME STATION, \
100 '*' TYPE, \
101 ST_ASTEXT(SHAPE), \
102 0 BOTDEPTH, \
103 (M.ZLOCATION *-1) DEPTH, \
104 TSV.TIMEVALUE, \
105 TSV.DATAVALUE, \
106 TS.PARAMETERID PARAMETER, \
107 TSV.MEASUREMENTID, \
108 TSV.TIMESERIESID, \
109 '1' QF \
110 FROM MEDIAN.TIMESERIESPOINT, \
111 MEDIAN.TIMESERIESVALUE TSV, \
112 MEDIAN.TIMESERIES TS, \
113 MEDIAN.MEASUREMENT M, \
114 MEDIAN.SOURCEINFO SI \
115 WHERE SI.SOURCEID = M.SOURCEID AND \
116 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \
117 M.MEASUREMENTID = TSV.MEASUREMENTID AND \
118 TSV.TIMESERIESID = TS.TIMESERIESID AND \
119 TS.PARAMETERID IN ( ? ) AND \
120 TSV.MEASUREMENTID IN ( ? ) AND \
121 TSV.TIMEVALUE >= ? AND \
122 TSV.TIMEVALUE <= ? \
123 ORDER BY TS.PARAMETERID, \
124 TSV.MEASUREMENTID, \
125 TSV.TIMESERIESID, \
126 TSV.TIMEVALUE
127
128
129 #############################################
130 #############################################
131 ########## Zeitserie Mesh ##############
132 #############################################
133 #############################################
134
135 timeseries_mesh = SELECT OBJECTID KEY, \
136 m.NAME VALUE \
137 FROM MEDIAN.MESH m \
138 WHERE SOURCEID IN (?) \
139 ORDER BY m.NAME
140 timeseries_meshpoint = SELECT MEDIAN.MESHPOINT.FEATUREID, \
141 ST_ASTEXT(SHAPE) \
142 FROM MEDIAN.MESHPOINT, \
143 MEDIAN.MESH M \
144 WHERE MEDIAN.MESHPOINT.MESHID = M.MESHID AND \
145 KPOSITION = 1 AND \
146 M.OBJECTID = ? AND \
147 INTERSECTS(SHAPE,"?")
148
149 timeseries_meshpoint_depth = SELECT MP.FEATUREID KEY, \
150 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \
151 from MEDIAN.MESHLAYER ML, \
152 MEDIAN.MESHPOINT MP, \
153 MEDIAN.MESH M \
154 WHERE ML.KPOSITION = MP.KPOSITION AND \
155 ML.MESHID = MP.MESHID AND \
156 M.OBJECTID = ? AND \
157 MP.MESHID = M.MESHID AND \
158 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
159 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \
160 ORDER BY ML.UPPERZLOCATION DESC
161
162 timeseries_mesh_parameter=SELECT distinct \
163 p.PARAMETERID KEY, \
164 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
165 p.GERMANNAME \
166 from MEDIAN.PARAMETER p, \
167 MEDIAN.MESHSCALARVALUE msc, \
168 MEDIAN.MESH m \
169 where m.OBJECTID = ? AND \
170 msc.PARTID >= m.PARTIDMIN AND \
171 msc.PARTID <= m.PARTIDMAX AND \
172 msc.PARAMETERID = p.PARAMETERID \
173 order by p.GERMANNAME
174 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \
175 min(TIMEVALUE) MIN, \
176 max(TIMEVALUE) MAX \
177 from MEDIAN.MESHSCALARVALUE msc, \
178 MEDIAN.MESH m \
179 where m.OBJECTID = ? AND \
180 msc.PARTID >= m.PARTIDMIN AND \
181 msc.PARTID <= m.PARTIDMAX AND \
182 msc.PARAMETERID IN (?)
183
184 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \
185 msv.TIMEVALUE XORDINATE, \
186 msv.DATAVALUE YORDINATE, \
187 msv.PARAMETERID GROUP1, \
188 msv.FEATUREID GROUP2, \
189 mp.FEATUREID GROUP3, \
190 -1 GAPID \
191 from MEDIAN.MESHSCALARVALUE msv, \
192 MEDIAN.MESHPOINT mp, \
193 MEDIAN.MESH m \
194 where (m.OBJECTID = ? AND \
195 msv.PARTID >= m.PARTIDMIN AND \
196 msv.PARTID <= m.PARTIDMAX ) AND \
197 msv.FEATUREID = mp.FEATUREID AND \
198 msv.PARAMETERID in ( ? ) AND \
199 mp.FEATUREID in ( ? ) AND \
200 msv.TIMEVALUE >= ? AND \
201 msv.TIMEVALUE <= ? \
202 order by mp.FEATUREID, \
203 msv.FEATUREID, \
204 msv.PARAMETERID, \
205 msv.TIMEVALUE
206
207 timeseries_mesh_odv_data = select /*+ parallel(timevalue,10) */ \
208 SI.NAME CRUISE, \
209 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
210 '*' TYPE, \
211 ST_ASTEXT(SHAPE), \
212 0 BOTDEPTH, \
213 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
214 msv.TIMEVALUE, \
215 msv.DATAVALUE, \
216 msv.PARAMETERID PARAMETER, \
217 '1' QF \
218 from MEDIAN.MESHSCALARVALUE msv, \
219 MEDIAN.MESHPOINT, \
220 MEDIAN.MESH m, \
221 MEDIAN.SOURCEINFO SI, \
222 MEDIAN.MESHLAYER ML \
223 where (m.OBJECTID = ? AND \
224 msv.PARTID >= m.PARTIDMIN AND \
225 msv.PARTID <= m.PARTIDMAX ) AND \
226 m.SOURCEID = SI.SOURCEID AND \
227 ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \
228 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \
229 msv.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \
230 msv.PARAMETERID in (? ) AND \
231 MEDIAN.MESHPOINT.FEATUREID in ( ? ) AND \
232 msv.TIMEVALUE >= ? AND \
233 msv.TIMEVALUE <= ? \
234 order by MEDIAN.MESHPOINT.FEATUREID, \
235 msv.FEATUREID, \
236 msv.TIMEVALUE, \
237 msv.PARAMETERID
238
239
240 #############################################
241 #############################################
242 ########## Vertikalprofil ##############
243 #############################################
244 #############################################
245
246 verticalprofile_point=SELECT DISTINCT \
247 tsp.FEATUREID KEY, \
248 tsp.NAME VALUE \
249 FROM MEDIAN.TIMESERIESPOINT tsp, \
250 MEDIAN.MEASUREMENT mmt \
251 WHERE tsp.FEATUREID = mmt.FEATUREID AND \
252 mmt.SOURCEID = ? \
253 order by tsp.name
254
255 verticalprofile_parameter=SELECT DISTINCT \
256 p.PARAMETERID KEY, \
257 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
258 p.GERMANNAME \
259 from MEDIAN.PARAMETER p, \
260 MEDIAN.TIMESERIES ts, \
261 MEDIAN.TIMESERIESVALUE tsv, \
262 MEDIAN.MEASUREMENT m \
263 where ts.PARAMETERID = p.PARAMETERID and \
264 ts.TIMESERIESID = tsv.TIMESERIESID and \
265 m.MEASUREMENTID = tsv.MEASUREMENTID and \
266 m.FEATUREID = ? \
267 ORDER BY p.GERMANNAME
268
269 verticalprofile_minmaxdepth= SELECT min(M.ZLOCATION) MIN, \
270 max(M.ZLOCATION) MAX \
271 FROM MEDIAN.MEASUREMENT M, \
272 MEDIAN.TIMESERIES TS, \
273 MEDIAN.TIMESERIESVALUE TSV \
274 WHERE TS.TIMESERIESID = TSV.TIMESERIESID and \
275 M.MEASUREMENTID = TSV.MEASUREMENTID and \
276 M.FEATUREID = ? and \
277 TS.PARAMETERID IN ( ? )
278
279
280 verticalprofile_year=select distinct \
281 to_char(tsv.TIMEVALUE,'YYYY') KEY, \
282 to_char(tsv.TIMEVALUE,'YYYY') VALUE \
283 from MEDIAN.TIMESERIES ts, \
284 MEDIAN.TIMESERIESVALUE tsv, \
285 MEDIAN.MEASUREMENT m \
286 where ts.TIMESERIESID = tsv.TIMESERIESID and \
287 m.MEASUREMENTID = tsv.MEASUREMENTID and \
288 m.FEATUREID = ? and \
289 ts.PARAMETERID IN ( ? ) \
290 order by to_char(tsv.TIMEVALUE,'YYYY')
291
292 verticalprofile_date=select distinct \
293 tsv.TIMEVALUE KEY, \
294 tsv.TIMEVALUE VALUE \
295 from MEDIAN.TIMESERIES ts, \
296 MEDIAN.TIMESERIESVALUE tsv, \
297 MEDIAN.MEASUREMENT m \
298 where ts.TIMESERIESID = tsv.TIMESERIESID and \
299 m.MEASUREMENTID = tsv.MEASUREMENTID and \
300 m.FEATUREID = ? and \
301 ts.PARAMETERID IN ( ? ) and \
302 to_char(tsv.TIMEVALUE,'YYYY') IN (?) \
303 order by tsv.TIMEVALUE
304
305 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \
306 TSV.DATAVALUE YORDINATE, \
307 TS.PARAMETERID GROUP1, \
308 TSV.TIMEVALUE GROUP2, \
309 1 GROUP3, \
310 1 DATAID, \
311 M.FEATUREID, \
312 TS.TIMESERIESID \
313 from MEDIAN.TIMESERIES TS, \
314 MEDIAN.TIMESERIESVALUE TSV, \
315 MEDIAN.MEASUREMENT M \
316 where TS.TIMESERIESID = TSV.TIMESERIESID AND \
317 M.MEASUREMENTID = TSV.MEASUREMENTID AND \
318 M.FEATUREID = ? AND \
319 TS.PARAMETERID IN ( ? ) AND \
320 TSV.TIMEVALUE IN (?) AND \
321 M.ZLOCATION >= ? AND \
322 M.ZLOCATION <= ? \
323 ORDER BY TSV.TIMEVALUE, \
324 TSV.TIMESERIESID, \
325 TS.PARAMETERID, \
326 TSV.TIMEVALUE
327
328 verticalprofile_odv_data = SELECT SI.NAME CRUISE, \
329 MEDIAN.TIMESERIESPOINT.NAME STATION, \
330 '*' TYPE, \
331 ST_ASTEXT(SHAPE), \
332 0 BOTDEPTH, \
333 (M.ZLOCATION *-1) DEPTH, \
334 TSV.TIMEVALUE, \
335 TSV.DATAVALUE, \
336 TS.PARAMETERID PARAMETER, \
337 TSV.MEASUREMENTID, \
338 TSV.TIMESERIESID, \
339 '1' QF \
340 FROM MEDIAN.TIMESERIESPOINT, \
341 MEDIAN.TIMESERIESVALUE TSV, \
342 MEDIAN.TIMESERIES TS, \
343 MEDIAN.MEASUREMENT M, \
344 MEDIAN.SOURCEINFO SI \
345 WHERE SI.SOURCEID = M.SOURCEID AND \
346 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \
347 M.MEASUREMENTID = TSV.MEASUREMENTID AND \
348 TSV.TIMESERIESID = TS.TIMESERIESID AND \
349 M.FEATUREID = ? AND \
350 TS.PARAMETERID IN ( ? ) AND \
351 TSV.TIMEVALUE IN (?) AND \
352 M.ZLOCATION >= ? AND \
353 M.ZLOCATION <= ? \
354 ORDER BY TSV.MEASUREMENTID, \
355 TSV.TIMESERIESID, \
356 TSV.TIMEVALUE, \
357 TS.PARAMETERID
358
359
360 #############################################
361 #############################################
362 ########## Vertikalprofil Mesh ##############
363 #############################################
364 #############################################
365
366 verticalprofile_mesh = SELECT OBJECTID KEY, \
367 m.NAME VALUE \
368 FROM MEDIAN.MESH m \
369 WHERE SOURCEID IN (?) \
370 order by m.NAME
371
372 verticalprofile_mesh_with_area = SELECT M.OBJECTID KEY, \
373 M.NAME VALUE \
374 FROM MEDIAN.MESHPOINT, \
375 MEDIAN.MESH M \
376 WHERE M.SOURCEID IN (?) AND \
377 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \
378 INTERSECTS(SHAPE, \
379 (SELECT st_astext(SHAPE) \
380 FROM MEDIAN.FEATUREAREA \
381 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
382 FEATURECODE = ? )\
383 ) \
384 order by M.NAME
385
386 verticalprofile_mesh_with_wkt = SELECT M.OBJECTID KEY, \
387 M.NAME VALUE \
388 FROM MEDIAN.MESHPOINT, \
389 MEDIAN.MESH M \
390 WHERE M.SOURCEID IN (?) AND \
391 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \
392 INTERSECTS(SHAPE, "?") \
393 order by M.NAME
394
395 verticalprofile_mesh_point = SELECT FEATUREID, \
396 ST_ASTEXT(SHAPE) \
397 FROM MEDIAN.MESHPOINT \
398 WHERE MESHID in \
399 (SELECT DISTINCT MESHID \
400 FROM MEDIAN.MESH \
401 WHERE OBJECTID = ?) AND \
402 KPOSITION = 1 AND \
403 INTERSECTS(SHAPE,"?")
404
405 verticalprofile_mesh_mindepth = SELECT MP.KPOSITION KEY, \
406 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \
407 from MEDIAN.MESHLAYER ML, \
408 MEDIAN.MESHPOINT MP, \
409 MEDIAN.MESH M \
410 WHERE ML.KPOSITION = MP.KPOSITION AND \
411 ML.MESHID = MP.MESHID AND \
412 M.OBJECTID = ? AND \
413 MP.MESHID = M.MESHID AND \
414 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
415 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \
416 ORDER BY ML.UPPERZLOCATION DESC
417
418 verticalprofile_mesh_maxdepth = SELECT MP.KPOSITION KEY, \
419 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \
420 from MEDIAN.MESHLAYER ML, \
421 MEDIAN.MESHPOINT MP, \
422 MEDIAN.MESH M \
423 WHERE ML.KPOSITION = MP.KPOSITION AND \
424 ML.MESHID = MP.MESHID AND \
425 M.OBJECTID = ? AND \
426 MP.MESHID = M.MESHID AND \
427 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
428 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
429 MP.KPOSITION < ? \
430 ORDER BY ML.UPPERZLOCATION DESC
431
432 verticalprofile_mesh_parameter=SELECT distinct \
433 p.PARAMETERID KEY, \
434 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
435 p.GERMANNAME \
436 from MEDIAN.PARAMETER p, \
437 MEDIAN.MESHSCALARVALUE msc, \
438 MEDIAN.MESH m \
439 where m.OBJECTID = ? AND \
440 msc.PARTID >= m.PARTIDMIN AND \
441 msc.PARTID <= m.PARTIDMAX AND \
442 msc.PARAMETERID = p.PARAMETERID \
443 order by p.GERMANNAME
444
445 verticalprofile_mesh_year= select distinct \
446 to_char(msv.TIMEVALUE,'YYYY') KEY, \
447 to_char(msv.TIMEVALUE,'YYYY') VALUE \
448 from MEDIAN.MESHSCALARVALUE msv, \
449 MEDIAN.MESH m \
450 where m.OBJECTID = ? AND \
451 msv.PARTID >= m.PARTIDMIN AND \
452 msv.PARTID <= m.PARTIDMAX AND \
453 msv.PARAMETERID in (?) \
454 order by to_char(msv.TIMEVALUE, 'YYYY')
455
456 verticalprofile_mesh_date= select distinct \
457 msv.TIMEVALUE KEY, \
458 msv.TIMEVALUE VALUE \
459 from MEDIAN.MESHSCALARVALUE msv, \
460 MEDIAN.MESH m \
461 where m.OBJECTID = ? AND \
462 msv.PARTID >= m.PARTIDMIN AND \
463 msv.PARTID <= m.PARTIDMAX AND \
464 msv.PARAMETERID in (?) AND \
465 to_char(msv.TIMEVALUE,'YYYY') in (?) \
466 order by msv.TIMEVALUE
467
468 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \
469 msv.DATAVALUE YORDINATE, \
470 mp.KPOSITION KPOSITION, \
471 msv.PARAMETERID GROUP1, \
472 msv.TIMEVALUE GROUP2, \
473 1 GROUP3, \
474 2 DATAID, \
475 MP.FEATUREID, \
476 MP.MESHID \
477 from MEDIAN.MESHLAYER ml, \
478 MEDIAN.MESHPOINT mp, \
479 MEDIAN.MESH m, \
480 MEDIAN.MESHSCALARVALUE msv \
481 where msv.FEATUREID = mp. FEATUREID AND \
482 ml.KPOSITION = mp.KPOSITION and \
483 ml.MESHID = mp.MESHID and \
484 m.MESHID = mp.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 mp.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 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
497 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) AND \
498 mp.KPOSITION <= ? AND \
499 mp.KPOSITION >= ? \
500 order by msv.PARAMETERID, \
501 msv.TIMEVALUE, \
502 ml.UPPERZLOCATION
503
504 verticalprofile_mesh_odv_data=select SI.NAME CRUISE, \
505 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
506 '*' TYPE, \
507 ST_ASTEXT(SHAPE), \
508 0 BOTDEPTH, \
509 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
510 msv.DATAVALUE, \
511 msv.PARAMETERID PARAMETER, \
512 msv.TIMEVALUE , \
513 '1' QF \
514 from MEDIAN.MESHLAYER ml, \
515 MEDIAN.MESHPOINT, \
516 MEDIAN.MESH m, \
517 MEDIAN.MESHSCALARVALUE msv, \
518 MEDIAN.SOURCEINFO SI \
519 where m.SOURCEID = SI.SOURCEID AND \
520 msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
521 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
522 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
523 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
524 m.PARTIDMIN <= msv.PARTID AND \
525 m.PARTIDMAX >= msv.PARTID AND \
526 msv.PARAMETERID in (?) AND \
527 msv.TIMEVALUE in (?) AND \
528 m.OBJECTID = ? AND \
529 MEDIAN.MESHPOINT.FEATUREID in \
530 ( select FEATUREID \
531 from MEDIAN.MESHPOINT mp, \
532 MEDIAN.MESH m \
533 where m.OBJECTID = ? AND \
534 mp.MESHID = m.MESHID AND \
535 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
536 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) AND \
537 MEDIAN.MESHPOINT.KPOSITION <= ? AND \
538 MEDIAN.MESHPOINT.KPOSITION >= ? \
539 order by msv.TIMEVALUE, \
540 ml.UPPERZLOCATION, \
541 msv.PARAMETERID
542
543 #############################################
544 #############################################
545 ##### Vertikalprofil InstantaneousPoint #####
546 #############################################
547 #############################################
548
549 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \
550 S.SERIESID KEY, \
551 S.DESCRIPTION VALUE \
552 FROM MEDIAN.SERIES S, \
553 MEDIAN.INSTANTANEOUSPOINT I, \
554 MEDIAN.MEASUREMENT M \
555 WHERE S.SERIESID = I.SERIESID AND \
556 I.POINTSPEC = 4 AND \
557 I.FEATUREID = M.FEATUREID AND \
558 M.SOURCEID= ? \
559 ORDER BY S.DESCRIPTION
560
561 verticalprofile_instantaneouspoint_series_with_area = SELECT \
562 S.SERIESID KEY, \
563 S.DESCRIPTION VALUE \
564 FROM MEDIAN.INSTANTANEOUSPOINT, \
565 MEDIAN.SERIES S, \
566 MEDIAN.MEASUREMENT M \
567 WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \
568 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \
569 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
570 M.SOURCEID= ? AND \
571 INTERSECTS(SHAPE, \
572 (SELECT st_astext(SHAPE) \
573 FROM MEDIAN.FEATUREAREA \
574 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
575 FEATURECODE = ? )\
576 ) \
577 ORDER BY S.DESCRIPTION
578 verticalprofile_instantaneouspoint_series_with_wkt = SELECT \
579 S.SERIESID KEY, \
580 S.DESCRIPTION VALUE \
581 FROM MEDIAN.INSTANTANEOUSPOINT, \
582 MEDIAN.SERIES S, \
583 MEDIAN.MEASUREMENT M \
584 WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \
585 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \
586 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
587 M.SOURCEID= ? AND \
588 INTERSECTS(SHAPE, "?") \
589 ORDER BY S.DESCRIPTION
590
591 verticalprofile_instantaneouspoint_point = SELECT \
592 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
593 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \
594 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \
595 ST_ASTEXT(SHAPE) \
596 FROM MEDIAN.INSTANTANEOUSPOINT, \
597 MEDIAN.MEASUREMENT M \
598 WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \
599 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \
600 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
601 M.SOURCEID = ? \
602 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
603 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
604
605 verticalprofile_instantaneouspoint_point_with_aera = SELECT \
606 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
607 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \
608 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \
609 ST_ASTEXT(SHAPE) \
610 FROM MEDIAN.INSTANTANEOUSPOINT, \
611 MEDIAN.MEASUREMENT M \
612 WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \
613 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \
614 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
615 M.SOURCEID = ? AND \
616 INTERSECTS(SHAPE, \
617 (SELECT st_astext(SHAPE) \
618 FROM MEDIAN.FEATUREAREA \
619 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
620 FEATURECODE = ? )\
621 ) \
622 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
623 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
624
625 verticalprofile_instantaneouspoint_point_with_wkt = SELECT \
626 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
627 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \
628 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \
629 ST_ASTEXT(SHAPE) \
630 FROM MEDIAN.INSTANTANEOUSPOINT, \
631 MEDIAN.MEASUREMENT M \
632 WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \
633 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \
634 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
635 M.SOURCEID = ? AND \
636 INTERSECTS(SHAPE,"?") \
637 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
638 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
639
640 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
641 P.PARAMETERID KEY, \
642 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
643 p.GERMANNAME \
644 FROM MEDIAN.PARAMETER P, \
645 MEDIAN.INSTANTANEOUSPOINT IP, \
646 MEDIAN.MEASUREMENT M, \
647 MEDIAN.MEASUREDSCALARVALUE MSV \
648 WHERE IP.FEATUREID = M.FEATUREID AND \
649 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
650 MSV.PARAMETERID = P.PARAMETERID AND \
651 IP.FEATUREID = ? \
652 ORDER BY P.GERMANNAME
653
654 verticalprofile_instantaneouspoint_minmaxdepth = SELECT min(M.ZLOCATION) MIN, \
655 max(M.ZLOCATION) MAX \
656 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
657 MEDIAN.MEASUREMENT M, \
658 MEDIAN.MEASUREDSCALARVALUE MSV \
659 WHERE IP.FEATUREID = M.FEATUREID AND \
660 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
661 IP.FEATUREID = ? AND \
662 MSV.PARAMETERID in (?)
663
664 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \
665 MSV.DATAVALUE YORDINATE, \
666 MSV.PARAMETERID GROUP1, \
667 IP.TIMEVALUE GROUP2, \
668 1 GROUP3, \
669 3 DATAID, \
670 IP.FEATUREID, \
671 IP.SERIESID \
672 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
673 MEDIAN.MEASUREMENT M, \
674 MEDIAN.MEASUREDSCALARVALUE MSV \
675 WHERE IP.FEATUREID = M.FEATUREID AND \
676 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
677 IP.FEATUREID = ? AND \
678 MSV.PARAMETERID in (?) AND \
679 M.ZLOCATION >= ? AND \
680 M.ZLOCATION <= ? \
681 ORDER BY IP.TIMEVALUE, \
682 MSV.PARAMETERID, \
683 M.ZLOCATION
684
685 verticalprofile_instantaneouspoint_odv_data = SELECT S.DESCRIPTION CRUISE, \
686 MEDIAN.INSTANTANEOUSPOINT.FEATUREID STATION, \
687 '*' TYPE, \
688 ST_ASTEXT(SHAPE), \
689 0 BOTDEPTH, \
690 (M.ZLOCATION * -1) DEPTH, \
691 MSV.DATAVALUE, \
692 MSV.PARAMETERID PARAMETER, \
693 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE , \
694 '1' QF \
695 FROM MEDIAN.SERIES S, \
696 MEDIAN.INSTANTANEOUSPOINT, \
697 MEDIAN.MEASUREMENT M, \
698 MEDIAN.MEASUREDSCALARVALUE MSV \
699 WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \
700 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
701 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
702 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = ? AND \
703 MSV.PARAMETERID in (?) AND \
704 M.ZLOCATION >= ? AND \
705 M.ZLOCATION <= ? \
706 ORDER BY MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \
707 M.ZLOCATION, \
708 MSV.PARAMETERID
709
710 #############################################
711 #############################################
712 #### Horizontalprofil InstantaneousPoint ####
713 #############################################
714 #############################################
715 horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \
716 V.VEHICLEID KEY, \
717 V.NAME VALUE \
718 FROM MEDIAN.VEHICLE V, \
719 MEDIAN.CRUISE C, \
720 MEDIAN.TRACK T, \
721 MEDIAN.SURVEYINFO S, \
722 MEDIAN.INSTANTANEOUSPOINT I, \
723 MEDIAN.MEASUREMENT M \
724 WHERE V.VEHICLEID = C.VEHICLEID AND \
725 C.CRUISEID = T.CRUISEID AND \
726 T.TRACKID = S.TRACKID AND \
727 S.SURVEYID = I.SURVEYID AND \
728 I.FEATUREID = M.FEATUREID AND \
729 M.SOURCEID = ? \
730 ORDER BY V.NAME
731
732 horizontalprofile_instantaneouspoint_vehicle_with_area = SELECT V.VEHICLEID KEY, \
733 V.NAME VALUE \
734 FROM MEDIAN.TRACK, \
735 MEDIAN.VEHICLE V, \
736 MEDIAN.CRUISE C \
737 WHERE V.VEHICLEID = C.VEHICLEID AND \
738 C.CRUISEID = MEDIAN.TRACK.CRUISEID AND \
739 MEDIAN.TRACK.TRACKID IN \
740 (SELECT DISTINCT S.TRACKID \
741 FROM MEDIAN.MEASUREMENT M ,\
742 MEDIAN.INSTANTANEOUSPOINT I, \
743 MEDIAN.SURVEYINFO S \
744 WHERE M.SOURCEID = ? AND \
745 I.FEATUREID = M.FEATUREID AND \
746 S.SURVEYID = I.SURVEYID)AND \
747 INTERSECTS(SHAPE, \
748 (SELECT st_astext(SHAPE) \
749 FROM MEDIAN.FEATUREAREA \
750 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
751 FEATURECODE = ? )\
752 ) \
753 ORDER BY V.NAME
754
755 horizontalprofile_instantaneouspoint_vehicle_with_wkt = SELECT V.VEHICLEID KEY, \
756 V.NAME VALUE \
757 FROM MEDIAN.TRACK, \
758 MEDIAN.VEHICLE V, \
759 MEDIAN.CRUISE C \
760 WHERE V.VEHICLEID = C.VEHICLEID AND \
761 C.CRUISEID = MEDIAN.TRACK.CRUISEID AND \
762 MEDIAN.TRACK.TRACKID IN \
763 (SELECT DISTINCT S.TRACKID \
764 FROM MEDIAN.MEASUREMENT M ,\
765 MEDIAN.INSTANTANEOUSPOINT I, \
766 MEDIAN.SURVEYINFO S \
767 WHERE M.SOURCEID = ? AND \
768 I.FEATUREID = M.FEATUREID AND \
769 S.SURVEYID = I.SURVEYID)AND \
770 INTERSECTS(SHAPE,"?") \
771 ORDER BY V.NAME
772
773 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \
774 C.CRUISEID KEY, \
775 V.NAME || ' ' || \
776 C.NAME || ' ' || \
777 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \
778 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE, \
779 V.NAME, \
780 C.NAME \
781 FROM MEDIAN.CRUISE C, \
782 MEDIAN.VEHICLE V, \
783 MEDIAN.TRACK T, \
784 MEDIAN.SURVEYINFO S, \
785 MEDIAN.INSTANTANEOUSPOINT I, \
786 MEDIAN.MEASUREMENT M \
787 WHERE C.VEHICLEID = V.VEHICLEID AND \
788 C.CRUISEID = T.CRUISEID AND \
789 T.TRACKID = S.TRACKID AND \
790 S.SURVEYID = I.SURVEYID AND \
791 I.FEATUREID = M.FEATUREID AND \
792 C.VEHICLEID = ? AND \
793 M.SOURCEID = ? \
794 ORDER BY V.NAME, C.NAME
795
796 horizontalprofile_instantaneouspoint_cruise_with_area = SELECT C.CRUISEID KEY, \
797 V.NAME || ' ' || \
798 C.NAME || ' ' || \
799 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \
800 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE, \
801 V.NAME, \
802 C.NAME \
803 FROM MEDIAN.TRACK, \
804 MEDIAN.VEHICLE V, \
805 MEDIAN.CRUISE C \
806 WHERE V.VEHICLEID = C.VEHICLEID AND \
807 C.CRUISEID = MEDIAN.TRACK.CRUISEID AND \
808 MEDIAN.TRACK.TRACKID IN \
809 (SELECT DISTINCT S.TRACKID \
810 FROM MEDIAN.MEASUREMENT M ,\
811 MEDIAN.INSTANTANEOUSPOINT I, \
812 MEDIAN.SURVEYINFO S \
813 WHERE M.SOURCEID = ? AND \
814 C.VEHICLEID = ? AND \
815 I.FEATUREID = M.FEATUREID AND \
816 S.SURVEYID = I.SURVEYID)AND \
817 INTERSECTS(SHAPE, \
818 (SELECT st_astext(SHAPE) \
819 FROM MEDIAN.FEATUREAREA \
820 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
821 FEATURECODE = ? )\
822 ) \
823 ORDER BY V.NAME
824
825 horizontalprofile_instantaneouspoint_cruise_with_wkt = SELECT C.CRUISEID KEY, \
826 V.NAME || ' ' || \
827 C.NAME || ' ' || \
828 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \
829 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE, \
830 V.NAME, \
831 C.NAME \
832 FROM MEDIAN.TRACK, \
833 MEDIAN.VEHICLE V, \
834 MEDIAN.CRUISE C \
835 WHERE V.VEHICLEID = C.VEHICLEID AND \
836 C.CRUISEID = MEDIAN.TRACK.CRUISEID AND \
837 MEDIAN.TRACK.TRACKID IN \
838 (SELECT DISTINCT S.TRACKID \
839 FROM MEDIAN.MEASUREMENT M ,\
840 MEDIAN.INSTANTANEOUSPOINT I, \
841 MEDIAN.SURVEYINFO S \
842 WHERE M.SOURCEID = ? AND \
843 C.VEHICLEID = ? AND \
844 I.FEATUREID = M.FEATUREID AND \
845 S.SURVEYID = I.SURVEYID)AND \
846 INTERSECTS(SHAPE,"?") \
847 ORDER BY V.NAME
848
849 horizontalprofile_instantaneouspoint_track= SELECT \
850 T.TRACKID KEY, \
851 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \
852 FROM MEDIAN.TRACK T \
853 WHERE T.CRUISEID = ? \
854 ORDER BY T.STARTDATE, \
855 T.ENDDATE, \
856 T.NAME
857
858 horizontalprofile_instantaneouspoint_track_with_area = SELECT \
859 MEDIAN.TRACK.TRACKID KEY, \
860 to_char(STARTDATE,'DD-MM-YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD-MM-YYYY HH24:MI') || ' - '|| NAME VALUE, \
861 NAME \
862 FROM MEDIAN.TRACK \
863 WHERE MEDIAN.TRACK.CRUISEID = ? AND \
864 INTERSECTS(SHAPE, \
865 (SELECT st_astext(SHAPE) \
866 FROM MEDIAN.FEATUREAREA \
867 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
868 FEATURECODE = ? )\
869 ) \
870 ORDER BY STARTDATE, \
871 ENDDATE, \
872 NAME
873
874 horizontalprofile_instantaneouspoint_track_with_wkt = SELECT \
875 MEDIAN.TRACK.TRACKID KEY, \
876 to_char(STARTDATE,'DD-MM-YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD-MM-YYYY HH24:MI') || ' - '|| NAME VALUE, \
877 NAME \
878 FROM MEDIAN.TRACK \
879 WHERE MEDIAN.TRACK.CRUISEID = ? AND \
880 INTERSECTS(SHAPE, "?") \
881 ORDER BY STARTDATE, \
882 ENDDATE, \
883 NAME
884
885 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \
886 SURVEYID KEY, \
887 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \
888 FROM MEDIAN.SURVEYINFO \
889 WHERE TRACKID = ? \
890 ORDER BY STARTDATE, \
891 ENDDATE, \
892 DESCRIPTION
893 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
894 P.PARAMETERID KEY, \
895 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \
896 p.GERMANNAME \
897 FROM MEDIAN.PARAMETER P, \
898 MEDIAN.MEASUREMENT M, \
899 MEDIAN.INSTANTANEOUSPOINT IP, \
900 MEDIAN.MEASUREDSCALARVALUE MSV \
901 WHERE P.PARAMETERID = MSV.PARAMETERID AND \
902 MSV.MEASUREMENTID = M.MEASUREMENTID AND \
903 M.FEATUREID = IP.FEATUREID AND \
904 IP.SURVEYID = ? \
905 ORDER BY P.GERMANNAME
906 horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \
907 M.ZLOCATION KEY, \
908 M.ZLOCATION VALUE \
909 FROM MEDIAN.MEASUREMENT M, \
910 MEDIAN.INSTANTANEOUSPOINT IP \
911 WHERE M.FEATUREID = IP.FEATUREID AND \
912 IP.SURVEYID = ? \
913 ORDER BY M.ZLOCATION
914 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE), \
915 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME, \
916 MSV.DATAVALUE YORDINATE, \
917 MSV.PARAMETERID GROUP1, \
918 ZLOCATION GROUP2, \
919 1 GROUP3, \
920 3 DATAID, \
921 MEDIAN.INSTANTANEOUSPOINT.SURVEYID \
922 FROM MEDIAN.INSTANTANEOUSPOINT, \
923 MEDIAN.MEASUREMENT M, \
924 MEDIAN.MEASUREDSCALARVALUE MSV \
925 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
926 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
927 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \
928 M.ZLOCATION IN (?) AND \
929 MSV.PARAMETERID in (?) \
930 ORDER BY MSV.PARAMETERID, \
931 M.ZLOCATION, \
932 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
933 horizontalprofile_instantaneouspoint_odv_data = SELECT V.NAME || ' ' || C.NAME CRUISE, \
934 MEDIAN.InstantaneousPoint.FEATUREID STATION, \
935 '*' TYPE, \
936 0 BOTDEPTH, \
937 (M.ZLOCATION * -1) DEPTH, \
938 ST_ASTEXT(SHAPE), \
939 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \
940 MSV.DATAVALUE, \
941 MSV.PARAMETERID PARAMETER , \
942 '1' QF \
943 FROM MEDIAN.INSTANTANEOUSPOINT, \
944 MEDIAN.VEHICLE V, \
945 MEDIAN.CRUISE C, \
946 (SELECT TRACKID,CRUISEID FROM MEDIAN.TRACK) T, \
947 MEDIAN.SURVEYINFO S, \
948 MEDIAN.MEASUREMENT M, \
949 MEDIAN.MEASUREDSCALARVALUE MSV \
950 WHERE V.VEHICLEID = C.VEHICLEID AND \
951 C.CRUISEID = T.CRUISEID AND \
952 T.TRACKID = S.TRACKID AND \
953 S.SURVEYID = MEDIAN.INSTANTANEOUSPOINT.SURVEYID AND \
954 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
955 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
956 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \
957 M.ZLOCATION IN (?) AND \
958 MSV.PARAMETERID in (?) \
959 ORDER BY MSV.PARAMETERID, \
960 M.ZLOCATION, \
961 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
962
963 #############################################
964 #############################################
965 ########### Horizontalprofil MESH ###########
966 #############################################
967 #############################################
968 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
969 mp.KPOSITION KEY, \
970 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \
971 from MEDIAN.MESHLAYER ml, \
972 MEDIAN.MESHPOINT mp \
973 where ml.KPOSITION = mp.KPOSITION and \
974 ml.MESHID = mp.MESHID and \
975 mp.FEATUREID in \
976 ( select FEATUREID \
977 from MEDIAN.MESHPOINT mp, \
978 MEDIAN.MESH m \
979 where m.OBJECTID = ? AND \
980 mp.MESHID = m.MESHID AND \
981 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
982 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
983 order by mp.KPOSITION
984
985 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
986 msv.DATAVALUE YORDINATE, \
987 msv.PARAMETERID GROUP1, \
988 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
989 msv.TIMEVALUE GROUP3, \
990 MEDIAN.MESHPOINT.JPOSITION, \
991 MEDIAN.MESHPOINT.IPOSITION, \
992 2 DATAID, \
993 MEDIAN.MESHPOINT.MESHID \
994 from MEDIAN.MESHLAYER ml, \
995 MEDIAN.MESHPOINT, \
996 MEDIAN.MESH m, \
997 MEDIAN.MESHSCALARVALUE msv \
998 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
999 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
1000 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
1001 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
1002 m.PARTIDMIN <= msv.PARTID AND \
1003 m.PARTIDMAX >= msv.PARTID AND \
1004 msv.PARAMETERID in (?) AND \
1005 msv.TIMEVALUE in (?) AND \
1006 m.OBJECTID = ? AND \
1007 MEDIAN.MESHPOINT.FEATUREID in \
1008 ( select FEATUREID \
1009 from MEDIAN.MESHPOINT mp, \
1010 MEDIAN.MESH m \
1011 where m.OBJECTID = ? AND \
1012 mp.MESHID = m.MESHID AND \
1013 KPOSITION in ( ? ) and \
1014 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
1015 order by msv.TIMEVALUE, \
1016 MEDIAN.MESHPOINT.KPOSITION, \
1017 msv.PARAMETERID, \
1018 MEDIAN.MESHPOINT.JPOSITION, \
1019 MEDIAN.MESHPOINT.IPOSITION
1020
1021 horizontalprofile_mesh_odv_data = SELECT SI.NAME CRUISE, \
1022 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
1023 '*' TYPE, \
1024 ST_ASTEXT(SHAPE), \
1025 0 BOTDEPTH, \
1026 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
1027 msv.DATAVALUE, \
1028 msv.PARAMETERID PARAMETER, \
1029 msv.TIMEVALUE, \
1030 MEDIAN.MESHPOINT.JPOSITION, \
1031 MEDIAN.MESHPOINT.IPOSITION , \
1032 '1' QF \
1033 from MEDIAN.MESHLAYER ml, \
1034 MEDIAN.MESHPOINT, \
1035 MEDIAN.MESH m, \
1036 MEDIAN.MESHSCALARVALUE msv, \
1037 MEDIAN.SOURCEINFO SI \
1038 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
1039 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
1040 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
1041 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
1042 m.SOURCEID = SI.SOURCEID AND \
1043 m.PARTIDMIN <= msv.PARTID AND \
1044 m.PARTIDMAX >= msv.PARTID AND \
1045 msv.PARAMETERID in (?) AND \
1046 msv.TIMEVALUE in (?) AND \
1047 m.OBJECTID = ? AND \
1048 MEDIAN.MESHPOINT.FEATUREID in \
1049 ( select FEATUREID \
1050 from MEDIAN.MESHPOINT mp, \
1051 MEDIAN.MESH m \
1052 where m.OBJECTID = ? AND \
1053 mp.MESHID = m.MESHID AND \
1054 KPOSITION in ( ? ) and \
1055 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
1056 order by msv.TIMEVALUE, \
1057 MEDIAN.MESHPOINT.KPOSITION, \
1058 MEDIAN.MESHPOINT.JPOSITION, \
1059 MEDIAN.MESHPOINT.IPOSITION, \
1060 msv.PARAMETERID
1061
1062 #############################################
1063 #############################################
1064 ########### Horizontalprofil MESH ###########
1065 ########### Schnittprofil ###########
1066 #############################################
1067 #############################################
1068 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
1069 mp.KPOSITION KEY, \
1070 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \
1071 from MEDIAN.MESHLAYER ml, \
1072 MEDIAN.MESHPOINT mp \
1073 where ml.KPOSITION = mp.KPOSITION and \
1074 ml.MESHID = mp.MESHID and \
1075 mp.FEATUREID in \
1076 ( select FEATUREID \
1077 from MEDIAN.MESHPOINT mp, \
1078 MEDIAN.MESH m \
1079 where m.OBJECTID = ? AND \
1080 mp.MESHID = m.MESHID )\
1081 order by mp.KPOSITION
1082
1083 horizontalprofile_meshpoint_cross_ij=SELECT MEDIAN.MESHFACE.JPOSITION, \
1084 MEDIAN.MESHFACE.IPOSITION \
1085 FROM MEDIAN.MESHFACE, \
1086 MEDIAN.MESH M \
1087 WHERE MEDIAN.MESHFACE.KPOSITION = 1 AND \
1088 M.MESHID = MEDIAN.MESHFACE.MESHID AND \
1089 M.OBJECTID = ? AND \
1090 INTERSECTS(SHAPE, "?")
1091 horizontalprofile_mesh_cross_chart_data = SELECT ST_ASTEXT(SHAPE), \
1092 msv.DATAVALUE YORDINATE, \
1093 msv.PARAMETERID GROUP1, \
1094 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
1095 msv.TIMEVALUE GROUP3, \
1096 MEDIAN.MESHPOINT.JPOSITION, \
1097 MEDIAN.MESHPOINT.IPOSITION, \
1098 2 DATAID \
1099 from MEDIAN.MESHLAYER ml, \
1100 MEDIAN.MESHPOINT, \
1101 MEDIAN.MESH m, \
1102 MEDIAN.MESHSCALARVALUE msv \
1103 where msv.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \
1104 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
1105 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
1106 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
1107 m.PARTIDMIN <= msv.PARTID AND \
1108 m.PARTIDMAX >= msv.PARTID AND \
1109 msv.PARAMETERID in (?) AND \
1110 msv.TIMEVALUE in (?) AND \
1111 m.OBJECTID = ? AND \
1112 ml.KPOSITION in (?) AND \
1113 MEDIAN.MESHPOINT.FEATUREID in \
1114 ( \
1115 SELECT distinct FEATUREID \
1116 FROM MEDIAN.MESHPOINT \
1117 WHERE ? \
1118 ) \
1119 order by msv.TIMEVALUE, \
1120 MEDIAN.MESHPOINT.KPOSITION, \
1121 msv.PARAMETERID, \
1122 MEDIAN.MESHPOINT.JPOSITION, \
1123 MEDIAN.MESHPOINT.IPOSITION
1124 #############################################
1125 #############################################
1126 ############# Profilschnitt MESH ############
1127 #############################################
1128 #############################################
1129 verticalcrosssection_mesh_year = select distinct \
1130 to_char(msv.TIMEVALUE,'YYYY') KEY, \
1131 to_char(msv.TIMEVALUE,'YYYY') VALUE \
1132 from MEDIAN.MESHSCALARVALUE msv, \
1133 MEDIAN.MESH m \
1134 where m.OBJECTID = ? AND \
1135 msv.PARTID >= m.PARTIDMIN AND \
1136 msv.PARTID <= m.PARTIDMAX AND \
1137 msv.PARAMETERID = ? \
1138 order by to_char(msv.TIMEVALUE,'YYYY')
1139 verticalcrosssection_mesh_date = select distinct \
1140 msv.TIMEVALUE KEY, \
1141 msv.TIMEVALUE VALUE \
1142 from MEDIAN.MESHSCALARVALUE msv, \
1143 MEDIAN.MESH m \
1144 where m.OBJECTID = ? AND \
1145 msv.PARTID >= m.PARTIDMIN AND \
1146 msv.PARTID <= m.PARTIDMAX AND \
1147 msv.PARAMETERID = ? AND \
1148 to_char(msv.TIMEVALUE,'YYYY') in (?) \
1149 order by msv.TIMEVALUE
1150 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
1151 ((ml.UPPERZLOCATION + ml.LOWERZLOCATION) / 2) Z, \
1152 msv.DATAVALUE YORDINATE, \
1153 msv.PARAMETERID GROUP1, \
1154 msv.TIMEVALUE GROUP2, \
1155 MEDIAN.MESHPOINT.JPOSITION, \
1156 MEDIAN.MESHPOINT.IPOSITION, \
1157 MEDIAN.MESHPOINT.KPOSITION \
1158 from MEDIAN.MESHLAYER ml, \
1159 MEDIAN.MESHPOINT, \
1160 MEDIAN.MESH m, \
1161 MEDIAN.MESHSCALARVALUE msv \
1162 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
1163 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
1164 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
1165 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
1166 m.PARTIDMIN <= msv.PARTID AND \
1167 m.PARTIDMAX >= msv.PARTID AND \
1168 msv.PARAMETERID = ? AND \
1169 msv.TIMEVALUE = ? AND \
1170 m.OBJECTID = ? AND \
1171 MEDIAN.MESHPOINT.FEATUREID in \
1172 ( \
1173 SELECT distinct FEATUREID \
1174 FROM MEDIAN.MESHPOINT \
1175 WHERE ? \
1176 ) \
1177 order by msv.TIMEVALUE, \
1178 msv.PARAMETERID, \
1179 MEDIAN.MESHPOINT.JPOSITION, \
1180 MEDIAN.MESHPOINT.IPOSITION, \
1181 MEDIAN.MESHPOINT.KPOSITION
1182
1183 verticalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \
1184 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
1185 '*' TYPE, \
1186 ST_ASTEXT(SHAPE), \
1187 0 BOTDEPTH, \
1188 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
1189 MSV.TIMEVALUE, \
1190 MSV.DATAVALUE, \
1191 MSV.PARAMETERID PARAMETER, \
1192 MEDIAN.MESHPOINT.JPOSITION, \
1193 MEDIAN.MESHPOINT.IPOSITION, \
1194 MEDIAN.MESHPOINT.KPOSITION, \
1195 2 DATAID , \
1196 '1' QF \
1197 from MEDIAN.MESHLAYER ml, \
1198 MEDIAN.MESHPOINT, \
1199 MEDIAN.MESH m, \
1200 MEDIAN.SOURCEINFO SI, \
1201 MEDIAN.MESHSCALARVALUE msv \
1202 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
1203 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
1204 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
1205 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
1206 m.PARTIDMIN <= msv.PARTID AND \
1207 m.PARTIDMAX >= msv.PARTID AND \
1208 M.SOURCEID = SI.SOURCEID AND \
1209 msv.PARAMETERID = ? AND \
1210 msv.TIMEVALUE = ? AND \
1211 m.OBJECTID = ? AND \
1212 MEDIAN.MESHPOINT.FEATUREID in \
1213 ( select FEATUREID \
1214 from MEDIAN.MESHPOINT mp, \
1215 MEDIAN.MESH m \
1216 where m.OBJECTID = ? AND \
1217 mp.MESHID = m.MESHID AND \
1218 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
1219 order by msv.TIMEVALUE, \
1220 MEDIAN.MESHPOINT.JPOSITION, \
1221 MEDIAN.MESHPOINT.IPOSITION, \
1222 MEDIAN.MESHPOINT.KPOSITION, \
1223 msv.PARAMETERID
1224
1225 #############################################
1226 #############################################
1227 ########## Horizontalschnitt MESH ###########
1228 #############################################
1229 #############################################
1230 horizontalcrosssection_meshpoint_depth = SELECT DISTINCT MP.KPOSITION KEY, \
1231 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \
1232 from MEDIAN.MESHLAYER ML, \
1233 MEDIAN.MESHPOINT MP, \
1234 MEDIAN.MESH M \
1235 WHERE ML.KPOSITION = MP.KPOSITION AND \
1236 ML.MESHID = MP.MESHID AND \
1237 M.OBJECTID = ? AND \
1238 MP.MESHID = M.MESHID \
1239 ORDER BY MP.KPOSITION
1240
1241 horizontalcrosssection_mesh_year = select distinct \
1242 to_char(msv.TIMEVALUE,'YYYY') KEY, \
1243 to_char(msv.TIMEVALUE,'YYYY') VALUE \
1244 from MEDIAN.MESHSCALARVALUE msv, \
1245 MEDIAN.MESH m \
1246 where m.OBJECTID = ? AND \
1247 msv.PARTID >= m.PARTIDMIN AND \
1248 msv.PARTID <= m.PARTIDMAX AND \
1249 msv.PARAMETERID = ? \
1250 order by to_char(msv.TIMEVALUE,'YYYY')
1251 horizontalcrosssection_mesh_date = select distinct \
1252 msv.TIMEVALUE KEY, \
1253 msv.TIMEVALUE VALUE \
1254 from MEDIAN.MESHSCALARVALUE msv, \
1255 MEDIAN.MESH m \
1256 where m.OBJECTID = ? AND \
1257 msv.PARTID >= m.PARTIDMIN AND \
1258 msv.PARTID <= m.PARTIDMAX AND \
1259 msv.PARAMETERID = ? AND \
1260 to_char(msv.TIMEVALUE,'YYYY') in (?) \
1261 order by msv.TIMEVALUE
1262
1263 horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \
1264 MSV.DATAVALUE YORDINATE, \
1265 MEDIAN.MESHPOINT.JPOSITION, \
1266 MEDIAN.MESHPOINT.IPOSITION, \
1267 MEDIAN.MESHPOINT.KPOSITION, \
1268 MSV.PARAMETERID, \
1269 MSV.TIMEVALUE, \
1270 2 DATAID \
1271 from MEDIAN.MESHLAYER ML, \
1272 MEDIAN.MESHPOINT, \
1273 MEDIAN.MESH M, \
1274 MEDIAN.MESHSCALARVALUE MSV \
1275 where MSV.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \
1276 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
1277 ML.MESHID = MEDIAN.MESHPOINT.MESHID and \
1278 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \
1279 M.PARTIDMIN <= MSV.PARTID AND \
1280 M.PARTIDMAX >= MSV.PARTID AND \
1281 MSV.PARAMETERID = ? AND \
1282 MSV.TIMEVALUE = ? AND \
1283 M.OBJECTID = ? AND \
1284 MEDIAN.MESHPOINT.KPOSITION = ? \
1285 order by MEDIAN.MESHPOINT.JPOSITION, \
1286 MEDIAN.MESHPOINT.IPOSITION
1287 horizontalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \
1288 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
1289 '*' TYPE, \
1290 ST_ASTEXT(SHAPE), \
1291 0 BOTDEPTH, \
1292 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
1293 MSV.TIMEVALUE, \
1294 MSV.DATAVALUE, \
1295 MSV.PARAMETERID PARAMETER, \
1296 MEDIAN.MESHPOINT.JPOSITION, \
1297 MEDIAN.MESHPOINT.IPOSITION, \
1298 MEDIAN.MESHPOINT.KPOSITION \
1299 from MEDIAN.MESHLAYER ML, \
1300 MEDIAN.MESHPOINT, \
1301 MEDIAN.MESH M, \
1302 MEDIAN.SOURCEINFO SI, \
1303 MEDIAN.MESHSCALARVALUE MSV \
1304 where MSV.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \
1305 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
1306 ML.MESHID = MEDIAN.MESHPOINT.MESHID and \
1307 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \
1308 M.PARTIDMIN <= MSV.PARTID AND \
1309 M.PARTIDMAX >= MSV.PARTID AND \
1310 M.SOURCEID = SI.SOURCEID AND \
1311 MSV.PARAMETERID = ? AND \
1312 MSV.TIMEVALUE = ? AND \
1313 M.OBJECTID = ? AND \
1314 MEDIAN.MESHPOINT.KPOSITION = ? \
1315 order by MEDIAN.MESHPOINT.JPOSITION, \
1316 MEDIAN.MESHPOINT.IPOSITION, \
1317 MSV.PARAMETERID
1318
1319 area_filter = SELECT DISTINCT \
1320 FEATUREID KEY ,\
1321 DESCRIPTION VALUE \
1322 FROM MEDIAN.FEATUREAREA \
1323 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
1324 FEATUREID > 0 \
1325 ORDER BY FEATUREID
1326
1327 subarea_filter = SELECT \
1328 FEATURECODE KEY, \
1329 NAME VALUE \
1330 FROM MEDIAN.FEATUREAREA \
1331 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
1332 FEATUREID = ? \
1333 ORDER BY NAME
1334
1335 rasterQuery = SELECT ST_ASTEXT(RASTER) \
1336 FROM MEDIAN.TOPO_WORLD_2MIN \
1337 WHERE INTERSECTS(RASTER, "?")
1338
1339 mapviewer_interface_fis_region = SELECT ID_FIS \
1340 FROM MEDIAN.FEATUREAREA, \
1341 MEDIAN.FIS_HAS_REGION FHR \
1342 WHERE FHR.FEATUREID = MEDIAN.FEATUREAREA.FEATUREID AND \
1343 FHR.FEATURETYPE = MEDIAN.FEATUREAREA.FEATURETYPE AND \
1344 FHR.FEATURECODE = MEDIAN.FEATUREAREA.FEATURECODE AND \
1345 INTERSECTS(SHAPE,"?")
1346
1347 mapviewer_interface_mapservices_has_fis = SELECT DISTINCT ID_FIS, \
1348 ID_MAPSERVICE \
1349 FROM MEDIAN.FIS_HAS_MAPSERVICE \
1350 WHERE ID_MAPSERVICE IN (?)
1351
1352 mapviewer_interface_mapservices_has_parameter = SELECT DISTINCT ID_PARAMETER \
1353 FROM MEDIAN.MAPSERVICE_HAS_PARAMETER \
1354 WHERE ID_MAPSERVICE = ?
1355
1356 mapviewer_interface_mapservices_has_parameter_using_layer = SELECT DISTINCT ID_PARAMETER \
1357 FROM MEDIAN.LAYER_HAS_PARAMETER \
1358 WHERE ID_MAPSERVICE = ? AND \
1359 ID_LAYER IN (?)
1360
1361 #############################################
1362 #############################################
1363 # Layer Contis, Nauthis and Marinefeatures #
1364 #############################################
1365 #############################################
1366
1367 layer = SELECT ROW_ID KEY, \
1368 TITLE || '-' || LAYER_NAME || '-' || BAND VALUE \
1369 FROM MEDIAN.LAYER_HAS_SUBTYPES \
1370 WHERE ID_FEATURECLASS LIKE ? AND \
1371 ITEMS > 0 \
1372 ORDER BY LAYER_NAME
1373
1374 layer_request_data = SELECT ID_FEATURECLASS, \
1375 QUERY_STRING, \
1376 ID_MAPSERVICE || '_' ||ID_LAYER \
1377 FROM MEDIAN.LAYER_HAS_SUBTYPES \
1378 WHERE ROW_ID IN (?)
1379
1380 layer_data = SELECT ST_ASTEXT(SHAPE), ? \
1381 FROM ? \
1382 WHERE ?
1383
1384 layer_data_with_geom = SELECT ST_ASTEXT(SHAPE), ? \
1385 FROM ? \
1386 WHERE ? AND \
1387 INTERSECTS(SHAPE,"?")
1388
1389 geometry_for_subareafilter=SELECT st_astext(SHAPE) \
1390 FROM MEDIAN.FEATUREAREA \
1391 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
1392 FEATURECODE = ?
1393
1394 layer_colums= SELECT OWNER || '.' || TABLE_NAME || '.' || COLUMN_NAME \
1395 FROM SDE.COLUMN_REGISTRY \
1396 WHERE COLUMN_NAME NOT LIKE 'SHAPE' AND \
1397 OWNER = '?' AND \
1398 TABLE_NAME = '?'
1399
1400 geometry_type = select geometry_type \
1401 from sde.geometry_columns \
1402 where f_table_schema = '?' and \
1403 f_table_name = '?' and \
1404 f_geometry_column='SHAPE'
1405
1406 updated_tables = SELECT FULLTABLENAME \
1407 FROM MEDIAN.LASTUPDATED \
1408 WHERE LASTUPDATE >= to_date('?', 'YYYY.MM.DD HH24:MI:SS')
http://dive4elements.wald.intevation.org