Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 243:b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
gnv-artifacts/trunk@311 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 10 Nov 2009 09:06:35 +0000 |
| parents | 5925739d25ac |
| children | 9048bc4b17cd |
comparison
equal
deleted
inserted
replaced
| 242:5925739d25ac | 243:b599de3db552 |
|---|---|
| 545 M.ZLOCATION >= ? AND \ | 545 M.ZLOCATION >= ? AND \ |
| 546 M.ZLOCATION <= ? \ | 546 M.ZLOCATION <= ? \ |
| 547 ORDER BY IP.TIMEVALUE, \ | 547 ORDER BY IP.TIMEVALUE, \ |
| 548 MSV.PARAMETERID, \ | 548 MSV.PARAMETERID, \ |
| 549 M.ZLOCATION | 549 M.ZLOCATION |
| 550 | 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 | |
| 551 ############################################# | 575 ############################################# |
| 552 ############################################# | 576 ############################################# |
| 553 #### Horizontalprofil InstantaneousPoint #### | 577 #### Horizontalprofil InstantaneousPoint #### |
| 554 ############################################# | 578 ############################################# |
| 555 ############################################# | 579 ############################################# |