Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/doc/conf/queries.properties @ 319:251f16a083f8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint gnv-artifacts/trunk@378 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 27 Nov 2009 13:00:00 +0000
parents e7f1c79bf9cd
children 3eff9241ea1e
comparison
equal deleted inserted replaced
318:5f2820e821e0 319:251f16a083f8
57 P.PARAMETERID IN (?)\ 57 P.PARAMETERID IN (?)\
58 ORDER BY m.ZLOCATION DESC 58 ORDER BY m.ZLOCATION DESC
59 59
60 timeseries_interval=select min(tv.TIMEVALUE) MIN, \ 60 timeseries_interval=select min(tv.TIMEVALUE) MIN, \
61 max(tv.TIMEVALUE) MAX \ 61 max(tv.TIMEVALUE) MAX \
62 from MEDIAN.TIMESERIES t , \ 62 from MEDIAN.TIMESERIES t, \
63 MEDIAN.TIMESERIESVALUE tv \ 63 MEDIAN.TIMESERIESVALUE tv \
64 where tv.TIMESERIESID = t.TIMESERIESID AND \ 64 where tv.TIMESERIESID = t.TIMESERIESID AND \
65 t.PARAMETERID IN ( ? ) AND \ 65 t.PARAMETERID IN ( ? ) AND \
66 tv.MEASUREMENTID IN ( ? ) 66 tv.MEASUREMENTID IN ( ? )
67 67
76 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ 76 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \
77 t.PARAMETERID IN ( ? ) AND \ 77 t.PARAMETERID IN ( ? ) AND \
78 tv.MEASUREMENTID IN ( ? ) AND \ 78 tv.MEASUREMENTID IN ( ? ) AND \
79 tv.TIMEVALUE >= ? AND \ 79 tv.TIMEVALUE >= ? AND \
80 tv.TIMEVALUE <= ? \ 80 tv.TIMEVALUE <= ? \
81 ORDER BY tv.MEASUREMENTID , \ 81 ORDER BY tv.MEASUREMENTID, \
82 tv.TIMESERIESID , \ 82 tv.TIMESERIESID, \
83 t.PARAMETERID , \ 83 t.PARAMETERID, \
84 tv.TIMEVALUE 84 tv.TIMEVALUE
85 85
86 timeseries_odv_data = SELECT SI.NAME CRUISE, \ 86 timeseries_odv_data = SELECT SI.NAME CRUISE, \
87 MEDIAN.TIMESERIESPOINT.NAME STATION, \ 87 MEDIAN.TIMESERIESPOINT.NAME STATION, \
88 '*' TYPE, \ 88 '*' TYPE, \
92 TSV.TIMEVALUE, \ 92 TSV.TIMEVALUE, \
93 TSV.DATAVALUE, \ 93 TSV.DATAVALUE, \
94 TS.PARAMETERID PARAMETER, \ 94 TS.PARAMETERID PARAMETER, \
95 TSV.MEASUREMENTID, \ 95 TSV.MEASUREMENTID, \
96 TSV.TIMESERIESID \ 96 TSV.TIMESERIESID \
97 FROM MEDIAN.TIMESERIESPOINT , \ 97 FROM MEDIAN.TIMESERIESPOINT, \
98 MEDIAN.TIMESERIESVALUE TSV, \ 98 MEDIAN.TIMESERIESVALUE TSV, \
99 MEDIAN.TIMESERIES TS, \ 99 MEDIAN.TIMESERIES TS, \
100 MEDIAN.MEASUREMENT M, \ 100 MEDIAN.MEASUREMENT M, \
101 MEDIAN.SOURCEINFO SI \ 101 MEDIAN.SOURCEINFO SI \
102 WHERE SI.SOURCEID = M.SOURCEID AND \ 102 WHERE SI.SOURCEID = M.SOURCEID AND \
105 TSV.TIMESERIESID = TS.TIMESERIESID AND \ 105 TSV.TIMESERIESID = TS.TIMESERIESID AND \
106 TS.PARAMETERID IN ( ? ) AND \ 106 TS.PARAMETERID IN ( ? ) AND \
107 TSV.MEASUREMENTID IN ( ? ) AND \ 107 TSV.MEASUREMENTID IN ( ? ) AND \
108 TSV.TIMEVALUE >= ? AND \ 108 TSV.TIMEVALUE >= ? AND \
109 TSV.TIMEVALUE <= ? \ 109 TSV.TIMEVALUE <= ? \
110 ORDER BY TSV.MEASUREMENTID , \ 110 ORDER BY TSV.MEASUREMENTID, \
111 TSV.TIMESERIESID , \ 111 TSV.TIMESERIESID, \
112 TS.PARAMETERID , \ 112 TS.PARAMETERID, \
113 TSV.TIMEVALUE 113 TSV.TIMEVALUE
114 114
115 ############################################# 115 #############################################
116 ############################################# 116 #############################################
117 ########## Zeitserie Mesh ############## 117 ########## Zeitserie Mesh ##############
144 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \ 144 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
145 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \ 145 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \
146 ORDER BY ML.UPPERZLOCATION DESC 146 ORDER BY ML.UPPERZLOCATION DESC
147 147
148 timeseries_mesh_parameter=SELECT distinct \ 148 timeseries_mesh_parameter=SELECT distinct \
149 p.PARAMETERID KEY , \ 149 p.PARAMETERID KEY, \
150 p.GERMANNAME VALUE \ 150 p.GERMANNAME VALUE \
151 from MEDIAN.PARAMETER p, \ 151 from MEDIAN.PARAMETER p, \
152 MEDIAN.MESHSCALARVALUE msc, \ 152 MEDIAN.MESHSCALARVALUE msc, \
153 MEDIAN.MESH m \ 153 MEDIAN.MESH m \
154 where m.OBJECTID = ? AND \ 154 where m.OBJECTID = ? AND \
156 msc.PARAMETERID = p.PARAMETERID \ 156 msc.PARAMETERID = p.PARAMETERID \
157 order by p.GERMANNAME 157 order by p.GERMANNAME
158 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \ 158 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \
159 min(TIMEVALUE) MIN, \ 159 min(TIMEVALUE) MIN, \
160 max(TIMEVALUE) MAX \ 160 max(TIMEVALUE) MAX \
161 from MEDIAN.MESHSCALARVALUE msc , \ 161 from MEDIAN.MESHSCALARVALUE msc, \
162 MEDIAN.MESH m \ 162 MEDIAN.MESH m \
163 where m.OBJECTID = ? AND \ 163 where m.OBJECTID = ? AND \
164 msc.PARTID >= m.PARTIDMIN AND \ 164 msc.PARTID >= m.PARTIDMIN AND \
165 msc.PARTID <= m.PARTIDMAX AND \ 165 msc.PARTID <= m.PARTIDMAX AND \
166 msc.PARAMETERID IN (?) 166 msc.PARAMETERID IN (?)
170 msv.DATAVALUE YORDINATE, \ 170 msv.DATAVALUE YORDINATE, \
171 msv.PARAMETERID GROUP1, \ 171 msv.PARAMETERID GROUP1, \
172 msv.FEATUREID GROUP2, \ 172 msv.FEATUREID GROUP2, \
173 mp.FEATUREID GROUP3, \ 173 mp.FEATUREID GROUP3, \
174 -1 GAPID \ 174 -1 GAPID \
175 from MEDIAN.MESHSCALARVALUE msv , \ 175 from MEDIAN.MESHSCALARVALUE msv, \
176 MEDIAN.MESHPOINT mp, \ 176 MEDIAN.MESHPOINT mp, \
177 MEDIAN.MESH m \ 177 MEDIAN.MESH m \
178 where (m.OBJECTID = ? AND \ 178 where (m.OBJECTID = ? AND \
179 msv.PARTID >= m.PARTIDMIN AND \ 179 msv.PARTID >= m.PARTIDMIN AND \
180 msv.PARTID <= m.PARTIDMAX ) AND \ 180 msv.PARTID <= m.PARTIDMAX ) AND \
194 '*' TYPE, \ 194 '*' TYPE, \
195 ST_ASTEXT(SHAPE), \ 195 ST_ASTEXT(SHAPE), \
196 0 BOTDEPTH, \ 196 0 BOTDEPTH, \
197 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ 197 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
198 msv.TIMEVALUE, \ 198 msv.TIMEVALUE, \
199 msv.DATAVALUE , \ 199 msv.DATAVALUE, \
200 msv.PARAMETERID PARAMETER \ 200 msv.PARAMETERID PARAMETER \
201 from MEDIAN.MESHSCALARVALUE msv , \ 201 from MEDIAN.MESHSCALARVALUE msv, \
202 MEDIAN.MESHPOINT, \ 202 MEDIAN.MESHPOINT, \
203 MEDIAN.MESH m, \ 203 MEDIAN.MESH m, \
204 MEDIAN.SOURCEINFO SI, \ 204 MEDIAN.SOURCEINFO SI, \
205 MEDIAN.MESHLAYER ML \ 205 MEDIAN.MESHLAYER ML \
206 where (m.OBJECTID = ? AND \ 206 where (m.OBJECTID = ? AND \
259 TS.PARAMETERID IN ( ? ) 259 TS.PARAMETERID IN ( ? )
260 260
261 verticalprofile_date=select distinct \ 261 verticalprofile_date=select distinct \
262 tsv.TIMEVALUE KEY, \ 262 tsv.TIMEVALUE KEY, \
263 tsv.TIMEVALUE VALUE \ 263 tsv.TIMEVALUE VALUE \
264 from MEDIAN.TIMESERIES ts , \ 264 from MEDIAN.TIMESERIES ts, \
265 MEDIAN.TIMESERIESVALUE tsv, \ 265 MEDIAN.TIMESERIESVALUE tsv, \
266 MEDIAN.MEASUREMENT m \ 266 MEDIAN.MEASUREMENT m \
267 where ts.TIMESERIESID = tsv.TIMESERIESID and \ 267 where ts.TIMESERIESID = tsv.TIMESERIESID and \
268 m.MEASUREMENTID = tsv.MEASUREMENTID and \ 268 m.MEASUREMENTID = tsv.MEASUREMENTID and \
269 m.FEATUREID = ? and \ 269 m.FEATUREID = ? and \
283 M.FEATUREID = ? AND \ 283 M.FEATUREID = ? AND \
284 TS.PARAMETERID IN ( ? ) AND \ 284 TS.PARAMETERID IN ( ? ) AND \
285 TSV.TIMEVALUE IN (?) AND \ 285 TSV.TIMEVALUE IN (?) AND \
286 M.ZLOCATION >= ? AND \ 286 M.ZLOCATION >= ? AND \
287 M.ZLOCATION <= ? \ 287 M.ZLOCATION <= ? \
288 ORDER BY TSV.TIMEVALUE , \ 288 ORDER BY TSV.TIMEVALUE, \
289 TSV.TIMESERIESID , \ 289 TSV.TIMESERIESID, \
290 TS.PARAMETERID , \ 290 TS.PARAMETERID, \
291 TSV.TIMEVALUE 291 TSV.TIMEVALUE
292 292
293 verticalprofile_odv_data = SELECT SI.NAME CRUISE, \ 293 verticalprofile_odv_data = SELECT SI.NAME CRUISE, \
294 MEDIAN.TIMESERIESPOINT.NAME STATION, \ 294 MEDIAN.TIMESERIESPOINT.NAME STATION, \
295 '*' TYPE, \ 295 '*' TYPE, \
299 TSV.TIMEVALUE, \ 299 TSV.TIMEVALUE, \
300 TSV.DATAVALUE, \ 300 TSV.DATAVALUE, \
301 TS.PARAMETERID PARAMETER, \ 301 TS.PARAMETERID PARAMETER, \
302 TSV.MEASUREMENTID, \ 302 TSV.MEASUREMENTID, \
303 TSV.TIMESERIESID \ 303 TSV.TIMESERIESID \
304 FROM MEDIAN.TIMESERIESPOINT , \ 304 FROM MEDIAN.TIMESERIESPOINT, \
305 MEDIAN.TIMESERIESVALUE TSV, \ 305 MEDIAN.TIMESERIESVALUE TSV, \
306 MEDIAN.TIMESERIES TS, \ 306 MEDIAN.TIMESERIES TS, \
307 MEDIAN.MEASUREMENT M, \ 307 MEDIAN.MEASUREMENT M, \
308 MEDIAN.SOURCEINFO SI \ 308 MEDIAN.SOURCEINFO SI \
309 WHERE SI.SOURCEID = M.SOURCEID AND \ 309 WHERE SI.SOURCEID = M.SOURCEID AND \
313 M.FEATUREID = ? AND \ 313 M.FEATUREID = ? AND \
314 TS.PARAMETERID IN ( ? ) AND \ 314 TS.PARAMETERID IN ( ? ) AND \
315 TSV.TIMEVALUE IN (?) AND \ 315 TSV.TIMEVALUE IN (?) AND \
316 M.ZLOCATION >= ? AND \ 316 M.ZLOCATION >= ? AND \
317 M.ZLOCATION <= ? \ 317 M.ZLOCATION <= ? \
318 ORDER BY TSV.MEASUREMENTID , \ 318 ORDER BY TSV.MEASUREMENTID, \
319 TSV.TIMESERIESID , \ 319 TSV.TIMESERIESID, \
320 TS.PARAMETERID , \ 320 TS.PARAMETERID, \
321 TSV.TIMEVALUE 321 TSV.TIMEVALUE
322 322
323 ############################################# 323 #############################################
324 ############################################# 324 #############################################
325 ########## Vertikalprofil Mesh ############## 325 ########## Vertikalprofil Mesh ##############
382 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \ 382 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
383 MP.KPOSITION < ? \ 383 MP.KPOSITION < ? \
384 ORDER BY ML.UPPERZLOCATION DESC 384 ORDER BY ML.UPPERZLOCATION DESC
385 385
386 verticalprofile_mesh_parameter=SELECT distinct \ 386 verticalprofile_mesh_parameter=SELECT distinct \
387 p.PARAMETERID KEY , \ 387 p.PARAMETERID KEY, \
388 p.GERMANNAME VALUE \ 388 p.GERMANNAME VALUE \
389 from MEDIAN.PARAMETER p, \ 389 from MEDIAN.PARAMETER p, \
390 MEDIAN.MESHSCALARVALUE msc, \ 390 MEDIAN.MESHSCALARVALUE msc, \
391 MEDIAN.MESH m \ 391 MEDIAN.MESH m \
392 where m.OBJECTID = ? AND \ 392 where m.OBJECTID = ? AND \
395 order by p.GERMANNAME 395 order by p.GERMANNAME
396 396
397 verticalprofile_mesh_date= select distinct \ 397 verticalprofile_mesh_date= select distinct \
398 msv.TIMEVALUE KEY, \ 398 msv.TIMEVALUE KEY, \
399 msv.TIMEVALUE VALUE \ 399 msv.TIMEVALUE VALUE \
400 from MEDIAN.MESHSCALARVALUE msv , \ 400 from MEDIAN.MESHSCALARVALUE msv, \
401 MEDIAN.MESH m \ 401 MEDIAN.MESH m \
402 where m.OBJECTID = ? AND \ 402 where m.OBJECTID = ? AND \
403 msv.PARTID >= m.PARTIDMIN AND \ 403 msv.PARTID >= m.PARTIDMIN AND \
404 msv.PARTID <= m.PARTIDMAX AND \ 404 msv.PARTID <= m.PARTIDMAX AND \
405 msv.PARAMETERID in (?) \ 405 msv.PARAMETERID in (?) \
441 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ 441 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
442 '*' TYPE, \ 442 '*' TYPE, \
443 ST_ASTEXT(SHAPE), \ 443 ST_ASTEXT(SHAPE), \
444 0 BOTDEPTH, \ 444 0 BOTDEPTH, \
445 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ 445 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
446 msv.DATAVALUE , \ 446 msv.DATAVALUE, \
447 msv.PARAMETERID PARAMETER, \ 447 msv.PARAMETERID PARAMETER, \
448 msv.TIMEVALUE , \ 448 msv.TIMEVALUE \
449 from MEDIAN.MESHLAYER ml, \ 449 from MEDIAN.MESHLAYER ml, \
450 MEDIAN.MESHPOINT, \ 450 MEDIAN.MESHPOINT, \
451 MEDIAN.MESH m, \ 451 MEDIAN.MESH m, \
452 MEDIAN.MESHSCALARVALUE msv, \ 452 MEDIAN.MESHSCALARVALUE msv, \
453 MEDIAN.SOURCEINFO SI \ 453 MEDIAN.SOURCEINFO SI \
480 ##### Vertikalprofil InstantaneousPoint ##### 480 ##### Vertikalprofil InstantaneousPoint #####
481 ############################################# 481 #############################################
482 ############################################# 482 #############################################
483 483
484 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \ 484 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \
485 S.SERIESID KEY , \ 485 S.SERIESID KEY, \
486 S.DESCRIPTION VALUE \ 486 S.DESCRIPTION VALUE \
487 FROM MEDIAN.SERIES S, \ 487 FROM MEDIAN.SERIES S, \
488 MEDIAN.INSTANTANEOUSPOINT I, \ 488 MEDIAN.INSTANTANEOUSPOINT I, \
489 MEDIAN.MEASUREMENT M \ 489 MEDIAN.MEASUREMENT M \
490 WHERE S.SERIESID = I.SERIESID AND \ 490 WHERE S.SERIESID = I.SERIESID AND \
506 M.SOURCEID = ? \ 506 M.SOURCEID = ? \
507 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ 507 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
508 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE 508 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
509 509
510 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ 510 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
511 P.PARAMETERID KEY , \ 511 P.PARAMETERID KEY, \
512 P.GERMANNAME VALUE \ 512 P.GERMANNAME VALUE \
513 FROM MEDIAN.PARAMETER P, \ 513 FROM MEDIAN.PARAMETER P, \
514 MEDIAN.INSTANTANEOUSPOINT IP, \ 514 MEDIAN.INSTANTANEOUSPOINT IP, \
515 MEDIAN.MEASUREMENT M, \ 515 MEDIAN.MEASUREMENT M, \
516 MEDIAN.MEASUREDSCALARVALUE MSV \ 516 MEDIAN.MEASUREDSCALARVALUE MSV \
591 T.TRACKID = S.TRACKID AND \ 591 T.TRACKID = S.TRACKID AND \
592 S.SURVEYID = I.SURVEYID AND \ 592 S.SURVEYID = I.SURVEYID AND \
593 I.FEATUREID = M.FEATUREID AND \ 593 I.FEATUREID = M.FEATUREID AND \
594 M.SOURCEID = ? \ 594 M.SOURCEID = ? \
595 ORDER BY V.NAME 595 ORDER BY V.NAME
596
597 horizontalprofile_instantaneouspoint_vehicle_with_area = SELECT V.VEHICLEID KEY, \
598 V.NAME VALUE \
599 FROM MEDIAN.TRACK, \
600 MEDIAN.VEHICLE V, \
601 MEDIAN.CRUISE C \
602 WHERE V.VEHICLEID = C.VEHICLEID AND \
603 C.CRUISEID = MEDIAN.TRACK.CRUISEID AND \
604 MEDIAN.TRACK.TRACKID IN \
605 (SELECT DISTINCT S.TRACKID \
606 FROM MEDIAN.MEASUREMENT M ,\
607 MEDIAN.INSTANTANEOUSPOINT I, \
608 MEDIAN.SURVEYINFO S \
609 WHERE M.SOURCEID = ? AND \
610 I.FEATUREID = M.FEATUREID AND \
611 S.SURVEYID = I.SURVEYID)AND \
612 INTERSECTS(SHAPE, \
613 (SELECT st_astext(SHAPE) \
614 FROM MEDIAN.FEATUREAREA \
615 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
616 FEATURECODE = ? )\
617 ) \
618 ORDER BY V.NAME
596 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \ 619 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \
597 C.CRUISEID KEY , \ 620 C.CRUISEID KEY, \
598 V.NAME || ' ' || \ 621 V.NAME || ' ' || \
599 C.NAME || ' ' || \ 622 C.NAME || ' ' || \
600 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \ 623 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \
601 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE , \ 624 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE, \
602 V.NAME , \ 625 V.NAME, \
603 C.NAME \ 626 C.NAME \
604 FROM MEDIAN.CRUISE C, \ 627 FROM MEDIAN.CRUISE C, \
605 MEDIAN.VEHICLE V, \ 628 MEDIAN.VEHICLE V, \
606 MEDIAN.TRACK T, \ 629 MEDIAN.TRACK T, \
607 MEDIAN.SURVEYINFO S, \ 630 MEDIAN.SURVEYINFO S, \
613 S.SURVEYID = I.SURVEYID AND \ 636 S.SURVEYID = I.SURVEYID AND \
614 I.FEATUREID = M.FEATUREID AND \ 637 I.FEATUREID = M.FEATUREID AND \
615 C.VEHICLEID = ? AND \ 638 C.VEHICLEID = ? AND \
616 M.SOURCEID = ? \ 639 M.SOURCEID = ? \
617 ORDER BY V.NAME, C.NAME 640 ORDER BY V.NAME, C.NAME
641
642 horizontalprofile_instantaneouspoint_cruise_with_area = SELECT C.CRUISEID KEY, \
643 V.NAME || ' ' || \
644 C.NAME || ' ' || \
645 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \
646 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE, \
647 V.NAME, \
648 C.NAME \
649 FROM MEDIAN.TRACK, \
650 MEDIAN.VEHICLE V, \
651 MEDIAN.CRUISE C \
652 WHERE V.VEHICLEID = C.VEHICLEID AND \
653 C.CRUISEID = MEDIAN.TRACK.CRUISEID AND \
654 MEDIAN.TRACK.TRACKID IN \
655 (SELECT DISTINCT S.TRACKID \
656 FROM MEDIAN.MEASUREMENT M ,\
657 MEDIAN.INSTANTANEOUSPOINT I, \
658 MEDIAN.SURVEYINFO S \
659 WHERE M.SOURCEID = ? AND \
660 C.VEHICLEID = ? AND \
661 I.FEATUREID = M.FEATUREID AND \
662 S.SURVEYID = I.SURVEYID)AND \
663 INTERSECTS(SHAPE, \
664 (SELECT st_astext(SHAPE) \
665 FROM MEDIAN.FEATUREAREA \
666 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
667 FEATURECODE = ? )\
668 ) \
669 ORDER BY V.NAME
618 horizontalprofile_instantaneouspoint_track= SELECT \ 670 horizontalprofile_instantaneouspoint_track= SELECT \
619 T.TRACKID KEY , \ 671 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 \ 672 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 \ 673 FROM MEDIAN.TRACK T \
622 WHERE T.CRUISEID = ? \ 674 WHERE T.CRUISEID = ? \
623 ORDER BY T.STARTDATE, \ 675 ORDER BY T.STARTDATE, \
624 T.ENDDATE, \ 676 T.ENDDATE, \
625 T.NAME 677 T.NAME
678
679 horizontalprofile_instantaneouspoint_track_with_area = SELECT \
680 MEDIAN.TRACK.TRACKID KEY, \
681 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| NAME VALUE, \
682 NAME \
683 FROM MEDIAN.TRACK \
684 WHERE MEDIAN.TRACK.CRUISEID = ? AND \
685 INTERSECTS(SHAPE, \
686 (SELECT st_astext(SHAPE) \
687 FROM MEDIAN.FEATUREAREA \
688 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
689 FEATURECODE = ? )\
690 ) \
691 ORDER BY STARTDATE, \
692 ENDDATE, \
693 NAME
626 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \ 694 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \
627 SURVEYID KEY , \ 695 SURVEYID KEY, \
628 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \ 696 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \
629 FROM MEDIAN.SURVEYINFO \ 697 FROM MEDIAN.SURVEYINFO \
630 WHERE TRACKID = ? \ 698 WHERE TRACKID = ? \
631 ORDER BY STARTDATE, \ 699 ORDER BY STARTDATE, \
632 ENDDATE, \ 700 ENDDATE, \
633 DESCRIPTION 701 DESCRIPTION
634 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ 702 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
635 P.PARAMETERID KEY , \ 703 P.PARAMETERID KEY, \
636 P.GERMANNAME VALUE \ 704 P.GERMANNAME VALUE \
637 FROM MEDIAN.PARAMETER P , \ 705 FROM MEDIAN.PARAMETER P, \
638 MEDIAN.MEASUREMENT M , \ 706 MEDIAN.MEASUREMENT M, \
639 MEDIAN.INSTANTANEOUSPOINT IP , \ 707 MEDIAN.INSTANTANEOUSPOINT IP, \
640 MEDIAN.MEASUREDSCALARVALUE MSV \ 708 MEDIAN.MEASUREDSCALARVALUE MSV \
641 WHERE P.PARAMETERID = MSV.PARAMETERID AND \ 709 WHERE P.PARAMETERID = MSV.PARAMETERID AND \
642 MSV.MEASUREMENTID = M.MEASUREMENTID AND \ 710 MSV.MEASUREMENTID = M.MEASUREMENTID AND \
643 M.FEATUREID = IP.FEATUREID AND \ 711 M.FEATUREID = IP.FEATUREID AND \
644 IP.SURVEYID = ? \ 712 IP.SURVEYID = ? \
645 ORDER BY P.GERMANNAME 713 ORDER BY P.GERMANNAME
646 horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \ 714 horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \
647 M.ZLOCATION KEY, \ 715 M.ZLOCATION KEY, \
648 M.ZLOCATION VALUE \ 716 M.ZLOCATION VALUE \
649 FROM MEDIAN.MEASUREMENT M , \ 717 FROM MEDIAN.MEASUREMENT M, \
650 MEDIAN.INSTANTANEOUSPOINT IP \ 718 MEDIAN.INSTANTANEOUSPOINT IP \
651 WHERE M.FEATUREID = IP.FEATUREID AND \ 719 WHERE M.FEATUREID = IP.FEATUREID AND \
652 IP.SURVEYID = ? \ 720 IP.SURVEYID = ? \
653 ORDER BY M.ZLOCATION 721 ORDER BY M.ZLOCATION
654 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE) , \ 722 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE), \
655 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME , \ 723 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME, \
656 MSV.DATAVALUE YORDINATE , \ 724 MSV.DATAVALUE YORDINATE, \
657 MSV.PARAMETERID GROUP1 , \ 725 MSV.PARAMETERID GROUP1, \
658 ZLOCATION GROUP2 , \ 726 ZLOCATION GROUP2, \
659 1 GROUP3 \ 727 1 GROUP3 \
660 FROM MEDIAN.INSTANTANEOUSPOINT, \ 728 FROM MEDIAN.INSTANTANEOUSPOINT, \
661 MEDIAN.MEASUREMENT M, \ 729 MEDIAN.MEASUREMENT M, \
662 MEDIAN.MEASUREDSCALARVALUE MSV \ 730 MEDIAN.MEASUREDSCALARVALUE MSV \
663 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ 731 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
670 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE 738 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
671 horizontalprofile_instantaneouspoint_odv_data = SELECT V.NAME || ' ' || C.NAME CRUISE, \ 739 horizontalprofile_instantaneouspoint_odv_data = SELECT V.NAME || ' ' || C.NAME CRUISE, \
672 MEDIAN.InstantaneousPoint.FEATUREID STATION, \ 740 MEDIAN.InstantaneousPoint.FEATUREID STATION, \
673 '*' TYPE, \ 741 '*' TYPE, \
674 0 BOTDEPTH, \ 742 0 BOTDEPTH, \
675 (M.ZLOCATION * -1) DEPTH , \ 743 (M.ZLOCATION * -1) DEPTH, \
676 ST_ASTEXT(SHAPE) , \ 744 ST_ASTEXT(SHAPE), \
677 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \ 745 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \
678 MSV.DATAVALUE, \ 746 MSV.DATAVALUE, \
679 MSV.PARAMETERID PARAMETER \ 747 MSV.PARAMETERID PARAMETER \
680 FROM MEDIAN.INSTANTANEOUSPOINT, \ 748 FROM MEDIAN.INSTANTANEOUSPOINT, \
681 MEDIAN.VEHICLE V, \ 749 MEDIAN.VEHICLE V, \
722 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ 790 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
723 msv.DATAVALUE YORDINATE, \ 791 msv.DATAVALUE YORDINATE, \
724 msv.PARAMETERID GROUP1, \ 792 msv.PARAMETERID GROUP1, \
725 MEDIAN.MESHPOINT.KPOSITION GROUP2, \ 793 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
726 msv.TIMEVALUE GROUP3, \ 794 msv.TIMEVALUE GROUP3, \
727 MEDIAN.MESHPOINT.JPOSITION , \ 795 MEDIAN.MESHPOINT.JPOSITION, \
728 MEDIAN.MESHPOINT.IPOSITION \ 796 MEDIAN.MESHPOINT.IPOSITION \
729 from MEDIAN.MESHLAYER ml, \ 797 from MEDIAN.MESHLAYER ml, \
730 MEDIAN.MESHPOINT , \ 798 MEDIAN.MESHPOINT, \
731 MEDIAN.MESH m, \ 799 MEDIAN.MESH m, \
732 MEDIAN.MESHSCALARVALUE msv \ 800 MEDIAN.MESHSCALARVALUE msv \
733 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ 801 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
734 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ 802 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
735 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ 803 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
748 KPOSITION in ( ? ) and \ 816 KPOSITION in ( ? ) and \
749 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ 817 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
750 order by msv.TIMEVALUE, \ 818 order by msv.TIMEVALUE, \
751 MEDIAN.MESHPOINT.KPOSITION, \ 819 MEDIAN.MESHPOINT.KPOSITION, \
752 msv.PARAMETERID, \ 820 msv.PARAMETERID, \
753 MEDIAN.MESHPOINT.JPOSITION , \ 821 MEDIAN.MESHPOINT.JPOSITION, \
754 MEDIAN.MESHPOINT.IPOSITION 822 MEDIAN.MESHPOINT.IPOSITION
755 823
756 horizontalprofile_mesh_odv_data = SELECT SI.NAME CRUISE, \ 824 horizontalprofile_mesh_odv_data = SELECT SI.NAME CRUISE, \
757 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ 825 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
758 '*' TYPE, \ 826 '*' TYPE, \
759 ST_ASTEXT(SHAPE), \ 827 ST_ASTEXT(SHAPE), \
760 0 BOTDEPTH, \ 828 0 BOTDEPTH, \
761 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ 829 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
762 msv.DATAVALUE , \ 830 msv.DATAVALUE, \
763 msv.PARAMETERID PARAMETER, \ 831 msv.PARAMETERID PARAMETER, \
764 msv.TIMEVALUE, \ 832 msv.TIMEVALUE, \
765 MEDIAN.MESHPOINT.JPOSITION , \ 833 MEDIAN.MESHPOINT.JPOSITION, \
766 MEDIAN.MESHPOINT.IPOSITION \ 834 MEDIAN.MESHPOINT.IPOSITION \
767 from MEDIAN.MESHLAYER ml, \ 835 from MEDIAN.MESHLAYER ml, \
768 MEDIAN.MESHPOINT , \ 836 MEDIAN.MESHPOINT, \
769 MEDIAN.MESH m, \ 837 MEDIAN.MESH m, \
770 MEDIAN.MESHSCALARVALUE msv, \ 838 MEDIAN.MESHSCALARVALUE msv, \
771 MEDIAN.SOURCEINFO SI \ 839 MEDIAN.SOURCEINFO SI \
772 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ 840 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
773 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ 841 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
788 KPOSITION in ( ? ) and \ 856 KPOSITION in ( ? ) and \
789 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ 857 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
790 order by msv.TIMEVALUE, \ 858 order by msv.TIMEVALUE, \
791 MEDIAN.MESHPOINT.KPOSITION, \ 859 MEDIAN.MESHPOINT.KPOSITION, \
792 msv.PARAMETERID, \ 860 msv.PARAMETERID, \
793 MEDIAN.MESHPOINT.JPOSITION , \ 861 MEDIAN.MESHPOINT.JPOSITION, \
794 MEDIAN.MESHPOINT.IPOSITION 862 MEDIAN.MESHPOINT.IPOSITION
795 863
796 864
797 ############################################# 865 #############################################
798 ############################################# 866 #############################################
800 ############################################# 868 #############################################
801 ############################################# 869 #############################################
802 verticalcrosssection_mesh_date = select distinct \ 870 verticalcrosssection_mesh_date = select distinct \
803 msv.TIMEVALUE KEY, \ 871 msv.TIMEVALUE KEY, \
804 msv.TIMEVALUE VALUE \ 872 msv.TIMEVALUE VALUE \
805 from MEDIAN.MESHSCALARVALUE msv , \ 873 from MEDIAN.MESHSCALARVALUE msv, \
806 MEDIAN.MESH m \ 874 MEDIAN.MESH m \
807 where m.OBJECTID = ? AND \ 875 where m.OBJECTID = ? AND \
808 msv.PARTID >= m.PARTIDMIN AND \ 876 msv.PARTID >= m.PARTIDMIN AND \
809 msv.PARTID <= m.PARTIDMAX AND \ 877 msv.PARTID <= m.PARTIDMAX AND \
810 msv.PARAMETERID = ? \ 878 msv.PARAMETERID = ? \
815 msv.TIMEVALUE GROUP2, \ 883 msv.TIMEVALUE GROUP2, \
816 MEDIAN.MESHPOINT.JPOSITION, \ 884 MEDIAN.MESHPOINT.JPOSITION, \
817 MEDIAN.MESHPOINT.IPOSITION, \ 885 MEDIAN.MESHPOINT.IPOSITION, \
818 MEDIAN.MESHPOINT.KPOSITION \ 886 MEDIAN.MESHPOINT.KPOSITION \
819 from MEDIAN.MESHLAYER ml, \ 887 from MEDIAN.MESHLAYER ml, \
820 MEDIAN.MESHPOINT , \ 888 MEDIAN.MESHPOINT, \
821 MEDIAN.MESH m, \ 889 MEDIAN.MESH m, \
822 MEDIAN.MESHSCALARVALUE msv \ 890 MEDIAN.MESHSCALARVALUE msv \
823 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ 891 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
824 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ 892 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
825 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ 893 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
836 where m.OBJECTID = ? AND \ 904 where m.OBJECTID = ? AND \
837 mp.MESHID = m.MESHID AND \ 905 mp.MESHID = m.MESHID AND \
838 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ 906 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
839 order by msv.TIMEVALUE, \ 907 order by msv.TIMEVALUE, \
840 msv.PARAMETERID, \ 908 msv.PARAMETERID, \
841 MEDIAN.MESHPOINT.JPOSITION , \ 909 MEDIAN.MESHPOINT.JPOSITION, \
842 MEDIAN.MESHPOINT.IPOSITION, \ 910 MEDIAN.MESHPOINT.IPOSITION, \
843 MEDIAN.MESHPOINT.KPOSITION 911 MEDIAN.MESHPOINT.KPOSITION
844 912
845 verticalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \ 913 verticalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \
846 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ 914 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
847 '*' TYPE, \ 915 '*' TYPE, \
848 ST_ASTEXT(SHAPE), \ 916 ST_ASTEXT(SHAPE), \
849 0 BOTDEPTH, \ 917 0 BOTDEPTH, \
850 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ 918 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
851 MSV.TIMEVALUE, \ 919 MSV.TIMEVALUE, \
852 MSV.DATAVALUE , \ 920 MSV.DATAVALUE, \
853 MSV.PARAMETERID PARAMETER, \ 921 MSV.PARAMETERID PARAMETER, \
854 MEDIAN.MESHPOINT.JPOSITION, \ 922 MEDIAN.MESHPOINT.JPOSITION, \
855 MEDIAN.MESHPOINT.IPOSITION, \ 923 MEDIAN.MESHPOINT.IPOSITION, \
856 MEDIAN.MESHPOINT.KPOSITION \ 924 MEDIAN.MESHPOINT.KPOSITION \
857 from MEDIAN.MESHLAYER ml, \ 925 from MEDIAN.MESHLAYER ml, \
858 MEDIAN.MESHPOINT , \ 926 MEDIAN.MESHPOINT, \
859 MEDIAN.MESH m, \ 927 MEDIAN.MESH m, \
860 MEDIAN.SOURCEINFO SI, \ 928 MEDIAN.SOURCEINFO SI, \
861 MEDIAN.MESHSCALARVALUE msv \ 929 MEDIAN.MESHSCALARVALUE msv \
862 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ 930 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
863 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ 931 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
876 where m.OBJECTID = ? AND \ 944 where m.OBJECTID = ? AND \
877 mp.MESHID = m.MESHID AND \ 945 mp.MESHID = m.MESHID AND \
878 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ 946 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
879 order by msv.TIMEVALUE, \ 947 order by msv.TIMEVALUE, \
880 msv.PARAMETERID, \ 948 msv.PARAMETERID, \
881 MEDIAN.MESHPOINT.JPOSITION , \ 949 MEDIAN.MESHPOINT.JPOSITION, \
882 MEDIAN.MESHPOINT.IPOSITION, \ 950 MEDIAN.MESHPOINT.IPOSITION, \
883 MEDIAN.MESHPOINT.KPOSITION 951 MEDIAN.MESHPOINT.KPOSITION
884 952
885 ############################################# 953 #############################################
886 ############################################# 954 #############################################
899 ORDER BY MP.KPOSITION 967 ORDER BY MP.KPOSITION
900 968
901 horizontalcrosssection_mesh_date = select distinct \ 969 horizontalcrosssection_mesh_date = select distinct \
902 msv.TIMEVALUE KEY, \ 970 msv.TIMEVALUE KEY, \
903 msv.TIMEVALUE VALUE \ 971 msv.TIMEVALUE VALUE \
904 from MEDIAN.MESHSCALARVALUE msv , \ 972 from MEDIAN.MESHSCALARVALUE msv, \
905 MEDIAN.MESH m \ 973 MEDIAN.MESH m \
906 where m.OBJECTID = ? AND \ 974 where m.OBJECTID = ? AND \
907 msv.PARTID >= m.PARTIDMIN AND \ 975 msv.PARTID >= m.PARTIDMIN AND \
908 msv.PARTID <= m.PARTIDMAX AND \ 976 msv.PARTID <= m.PARTIDMAX AND \
909 msv.PARAMETERID = ? \ 977 msv.PARAMETERID = ? \
926 M.PARTIDMAX >= MSV.PARTID AND \ 994 M.PARTIDMAX >= MSV.PARTID AND \
927 MSV.PARAMETERID = ? AND \ 995 MSV.PARAMETERID = ? AND \
928 MSV.TIMEVALUE = ? AND \ 996 MSV.TIMEVALUE = ? AND \
929 M.OBJECTID = ? AND \ 997 M.OBJECTID = ? AND \
930 MEDIAN.MESHFACE.KPOSITION = ? \ 998 MEDIAN.MESHFACE.KPOSITION = ? \
931 order by MEDIAN.MESHFACE.JPOSITION , \ 999 order by MEDIAN.MESHFACE.JPOSITION, \
932 MEDIAN.MESHFACE.IPOSITION 1000 MEDIAN.MESHFACE.IPOSITION
933 horizontalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \ 1001 horizontalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \
934 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ 1002 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
935 '*' TYPE, \ 1003 '*' TYPE, \
936 ST_ASTEXT(SHAPE), \ 1004 ST_ASTEXT(SHAPE), \
937 0 BOTDEPTH, \ 1005 0 BOTDEPTH, \
938 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ 1006 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
939 MSV.TIMEVALUE, \ 1007 MSV.TIMEVALUE, \
940 MSV.DATAVALUE , \ 1008 MSV.DATAVALUE, \
941 MSV.PARAMETERID PARAMETER, \ 1009 MSV.PARAMETERID PARAMETER, \
942 MEDIAN.MESHPOINT.JPOSITION, \ 1010 MEDIAN.MESHPOINT.JPOSITION, \
943 MEDIAN.MESHPOINT.IPOSITION, \ 1011 MEDIAN.MESHPOINT.IPOSITION, \
944 MEDIAN.MESHPOINT.KPOSITION \ 1012 MEDIAN.MESHPOINT.KPOSITION \
945 from MEDIAN.MESHLAYER ML, \ 1013 from MEDIAN.MESHLAYER ML, \
956 M.SOURCEID = SI.SOURCEID AND \ 1024 M.SOURCEID = SI.SOURCEID AND \
957 MSV.PARAMETERID = ? AND \ 1025 MSV.PARAMETERID = ? AND \
958 MSV.TIMEVALUE = ? AND \ 1026 MSV.TIMEVALUE = ? AND \
959 M.OBJECTID = ? AND \ 1027 M.OBJECTID = ? AND \
960 MEDIAN.MESHPOINT.KPOSITION = ? \ 1028 MEDIAN.MESHPOINT.KPOSITION = ? \
961 order by MEDIAN.MESHPOINT.JPOSITION , \ 1029 order by MEDIAN.MESHPOINT.JPOSITION, \
962 MEDIAN.MESHPOINT.IPOSITION 1030 MEDIAN.MESHPOINT.IPOSITION
963 1031
964 area_filter = SELECT DISTINCT \ 1032 area_filter = SELECT DISTINCT \
965 FEATUREID KEY ,\ 1033 FEATUREID KEY ,\
966 DESCRIPTION VALUE \ 1034 DESCRIPTION VALUE \
http://dive4elements.wald.intevation.org