Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 244:9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
gnv-artifacts/trunk@313 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 10 Nov 2009 11:48:41 +0000 |
| parents | b599de3db552 |
| children | 9697a6b8d2c9 |
comparison
equal
deleted
inserted
replaced
| 243:b599de3db552 | 244:9048bc4b17cd |
|---|---|
| 666 M.ZLOCATION IN (?) AND \ | 666 M.ZLOCATION IN (?) AND \ |
| 667 MSV.PARAMETERID in (?) \ | 667 MSV.PARAMETERID in (?) \ |
| 668 ORDER BY MSV.PARAMETERID, \ | 668 ORDER BY MSV.PARAMETERID, \ |
| 669 M.ZLOCATION, \ | 669 M.ZLOCATION, \ |
| 670 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE | 670 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE |
| 671 horizontalprofile_instantaneouspoint_odv_data = SELECT V.NAME || ' ' || C.NAME CRUISE, \ | |
| 672 MEDIAN.InstantaneousPoint.FEATUREID STATION, \ | |
| 673 '*' TYPE, \ | |
| 674 0 BOTDEPTH, \ | |
| 675 (M.ZLOCATION * -1) DEPTH , \ | |
| 676 ST_ASTEXT(SHAPE) , \ | |
| 677 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \ | |
| 678 MSV.DATAVALUE, \ | |
| 679 MSV.PARAMETERID PARAMETER \ | |
| 680 FROM MEDIAN.INSTANTANEOUSPOINT, \ | |
| 681 MEDIAN.VEHICLE V, \ | |
| 682 MEDIAN.CRUISE C, \ | |
| 683 (SELECT TRACKID,CRUISEID FROM MEDIAN.TRACK) T, \ | |
| 684 MEDIAN.SURVEYINFO S, \ | |
| 685 MEDIAN.MEASUREMENT M, \ | |
| 686 MEDIAN.MEASUREDSCALARVALUE MSV \ | |
| 687 WHERE V.VEHICLEID = C.VEHICLEID AND \ | |
| 688 C.CRUISEID = T.CRUISEID AND \ | |
| 689 T.TRACKID = S.TRACKID AND \ | |
| 690 S.SURVEYID = MEDIAN.INSTANTANEOUSPOINT.SURVEYID AND \ | |
| 691 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ | |
| 692 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ | |
| 693 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \ | |
| 694 M.ZLOCATION IN (?) AND \ | |
| 695 MSV.PARAMETERID in (?) \ | |
| 696 ORDER BY MSV.PARAMETERID, \ | |
| 697 M.ZLOCATION, \ | |
| 698 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE | |
| 671 | 699 |
| 672 ############################################# | 700 ############################################# |
| 673 ############################################# | 701 ############################################# |
| 674 ########### Horizontalprofil MESH ########### | 702 ########### Horizontalprofil MESH ########### |
| 675 ############################################# | 703 ############################################# |