Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 1059:174f6eacd595
Added queries for TimeSeriesPoints using vectorvalues for verticalprofiles
gnv-artifacts/trunk@1138 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Mon, 31 May 2010 08:20:17 +0000 |
| parents | 04967dc9c83f |
| children | 9bb1979aabbe |
comparison
equal
deleted
inserted
replaced
| 1058:2b4f1c095468 | 1059:174f6eacd595 |
|---|---|
| 545 M.ZLOCATION >= ? AND \ | 545 M.ZLOCATION >= ? AND \ |
| 546 M.ZLOCATION <= ? \ | 546 M.ZLOCATION <= ? \ |
| 547 ORDER BY TSV.MEASUREMENTID, \ | 547 ORDER BY TSV.MEASUREMENTID, \ |
| 548 TSV.TIMESERIESID, \ | 548 TSV.TIMESERIESID, \ |
| 549 TSV.TIMEVALUE, \ | 549 TSV.TIMEVALUE, \ |
| 550 TS.PARAMETERID | |
| 551 | |
| 552 ############################################# | |
| 553 ############################################# | |
| 554 ########## Vertikalprofil ############## | |
| 555 ########## Vektordaten ############## | |
| 556 ############################################# | |
| 557 ############################################# | |
| 558 | |
| 559 verticalprofile_parameter_vector=SELECT DISTINCT \ | |
| 560 P.PARAMETERID KEY, \ | |
| 561 P.GERMANNAME || ' ['|| P.UNIT ||']' VALUE, \ | |
| 562 P.GERMANNAME \ | |
| 563 from MEDIAN.PARAMETER P, \ | |
| 564 MEDIAN.TIMESERIES TS, \ | |
| 565 MEDIAN.TIMESERIESVECTORVALUE TVV, \ | |
| 566 MEDIAN.MEASUREMENT M \ | |
| 567 where TS.PARAMETERID = P.PARAMETERID AND \ | |
| 568 TS.TIMESERIESID = TVV.TIMESERIESID AND \ | |
| 569 M.MEASUREMENTID = TVV.MEASUREMENTID AND \ | |
| 570 M.FEATUREID = ? \ | |
| 571 ORDER BY P.GERMANNAME | |
| 572 | |
| 573 verticalprofile_minmaxdepth_vector= SELECT MIN(M.ZLOCATION) MIN, \ | |
| 574 MAX(M.ZLOCATION) MAX \ | |
| 575 FROM MEDIAN.MEASUREMENT M, \ | |
| 576 MEDIAN.TIMESERIES TS, \ | |
| 577 MEDIAN.TIMESERIESVECTORVALUE TVV \ | |
| 578 WHERE TS.TIMESERIESID = TVV.TIMESERIESID AND \ | |
| 579 M.MEASUREMENTID = TVV.MEASUREMENTID AND \ | |
| 580 M.FEATUREID = ? AND \ | |
| 581 TS.PARAMETERID = ? | |
| 582 | |
| 583 verticalprofile_year_vector=SELECT DISTINCT \ | |
| 584 TO_CHAR(TVV.TIMEVALUE,'YYYY') KEY, \ | |
| 585 TO_CHAR(TVV.TIMEVALUE,'YYYY') VALUE \ | |
| 586 FROM MEDIAN.TIMESERIES TS, \ | |
| 587 MEDIAN.TIMESERIESVECTORVALUE TVV, \ | |
| 588 MEDIAN.MEASUREMENT M \ | |
| 589 WHERE TS.TIMESERIESID = TVV.TIMESERIESID AND \ | |
| 590 M.MEASUREMENTID = TVV.MEASUREMENTID AND \ | |
| 591 M.FEATUREID = ? AND \ | |
| 592 TS.PARAMETERID = ? \ | |
| 593 ORDER BY to_char(TVV.TIMEVALUE,'YYYY') | |
| 594 | |
| 595 verticalprofile_date_vector=SELECT DISTINCT \ | |
| 596 TVV.TIMEVALUE KEY, \ | |
| 597 TVV.TIMEVALUE VALUE \ | |
| 598 from MEDIAN.TIMESERIES TS, \ | |
| 599 MEDIAN.TIMESERIESVECTORVALUE TVV, \ | |
| 600 MEDIAN.MEASUREMENT M \ | |
| 601 WHERE TS.TIMESERIESID = TVV.TIMESERIESID AND \ | |
| 602 M.MEASUREMENTID = TVV.MEASUREMENTID AND \ | |
| 603 M.FEATUREID = ? AND \ | |
| 604 TS.PARAMETERID = ? AND \ | |
| 605 TO_CHAR(TVV.TIMEVALUE,'YYYY') IN (?) \ | |
| 606 ORDER BY TVV.TIMEVALUE | |
| 607 | |
| 608 verticalprofile_chart_data_vector= SELECT M.ZLOCATION XORDINATE, \ | |
| 609 TS.PARAMETERID GROUP1, \ | |
| 610 TVV.TIMEVALUE, \ | |
| 611 TVV.XCOMPONENT, \ | |
| 612 TVV.YCOMPONENT, \ | |
| 613 TVV.ZCOMPONENT, \ | |
| 614 TVV.SPEED, \ | |
| 615 TVV.DIRECTION, \ | |
| 616 1 GROUP3, \ | |
| 617 1 DATAID, \ | |
| 618 M.FEATUREID, \ | |
| 619 TS.TIMESERIESID \ | |
| 620 FROM MEDIAN.TIMESERIES TS, \ | |
| 621 MEDIAN.TIMESERIESFULLVECTORVALUE TVV, \ | |
| 622 MEDIAN.MEASUREMENT M \ | |
| 623 WHERE TS.TIMESERIESID = TVV.TIMESERIESID AND \ | |
| 624 M.MEASUREMENTID = TVV.MEASUREMENTID AND \ | |
| 625 M.FEATUREID = ? AND \ | |
| 626 TS.PARAMETERID = ? AND \ | |
| 627 TVV.TIMEVALUE = ? AND \ | |
| 628 M.ZLOCATION >= ? AND \ | |
| 629 M.ZLOCATION <= ? \ | |
| 630 ORDER BY TVV.TIMEVALUE, \ | |
| 631 TVV.TIMESERIESID, \ | |
| 632 TS.PARAMETERID, \ | |
| 633 TVV.TIMEVALUE | |
| 634 | |
| 635 verticalprofile_odv_data_vector = SELECT SI.NAME CRUISE, \ | |
| 636 MEDIAN.TIMESERIESPOINT.NAME STATION, \ | |
| 637 '*' TYPE, \ | |
| 638 ST_ASTEXT(SHAPE), \ | |
| 639 0 BOTDEPTH, \ | |
| 640 (M.ZLOCATION *-1) DEPTH, \ | |
| 641 TVV.TIMEVALUE, \ | |
| 642 TVV.XCOMPONENT, \ | |
| 643 TVV.YCOMPONENT, \ | |
| 644 TVV.ZCOMPONENT, \ | |
| 645 TVV.SPEED, \ | |
| 646 TVV.DIRECTION, \ | |
| 647 TS.PARAMETERID PARAMETER, \ | |
| 648 TVV.MEASUREMENTID, \ | |
| 649 TVV.TIMESERIESID, \ | |
| 650 '1' QF \ | |
| 651 FROM MEDIAN.TIMESERIESPOINT, \ | |
| 652 MEDIAN.TIMESERIESFULLVECTORVALUE TVV, \ | |
| 653 MEDIAN.TIMESERIES TS, \ | |
| 654 MEDIAN.MEASUREMENT M, \ | |
| 655 MEDIAN.SOURCEINFO SI \ | |
| 656 WHERE SI.SOURCEID = M.SOURCEID AND \ | |
| 657 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \ | |
| 658 M.MEASUREMENTID = TVV.MEASUREMENTID AND \ | |
| 659 TVV.TIMESERIESID = TS.TIMESERIESID AND \ | |
| 660 M.FEATUREID = ? AND \ | |
| 661 TS.PARAMETERID = ? AND \ | |
| 662 TVV.TIMEVALUE = ? AND \ | |
| 663 M.ZLOCATION >= ? AND \ | |
| 664 M.ZLOCATION <= ? \ | |
| 665 ORDER BY TVV.MEASUREMENTID, \ | |
| 666 TVV.TIMESERIESID, \ | |
| 667 TVV.TIMEVALUE, \ | |
| 550 TS.PARAMETERID | 668 TS.PARAMETERID |
| 551 | 669 |
| 552 ############################################# | 670 ############################################# |
| 553 ############################################# | 671 ############################################# |
| 554 ########## Vertikalprofil Mesh ############## | 672 ########## Vertikalprofil Mesh ############## |