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 ############################################# |