Mercurial > dive4elements > gnv-client
diff 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 |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Tue Nov 10 08:35:18 2009 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Tue Nov 10 09:06:35 2009 +0000 @@ -547,7 +547,31 @@ ORDER BY IP.TIMEVALUE, \ MSV.PARAMETERID, \ M.ZLOCATION - + +verticalprofile_instantaneouspoint_odv_data = SELECT S.DESCRIPTION CRUISE, \ + MEDIAN.INSTANTANEOUSPOINT.FEATUREID STATION, \ + '*' TYPE, \ + ST_ASTEXT(SHAPE), \ + 0 BOTDEPTH, \ + (M.ZLOCATION * -1) DEPTH, \ + MSV.DATAVALUE, \ + MSV.PARAMETERID PARAMETER, \ + MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE \ + FROM MEDIAN.SERIES S, \ + MEDIAN.INSTANTANEOUSPOINT, \ + MEDIAN.MEASUREMENT M, \ + MEDIAN.MEASUREDSCALARVALUE MSV \ + WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \ + MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ + M.MEASUREMENTID = MSV.MEASUREMENTID AND \ + MEDIAN.INSTANTANEOUSPOINT.FEATUREID = ? AND \ + MSV.PARAMETERID in (?) AND \ + M.ZLOCATION >= ? AND \ + M.ZLOCATION <= ? \ + ORDER BY MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \ + MSV.PARAMETERID, \ + M.ZLOCATION + ############################################# ############################################# #### Horizontalprofil InstantaneousPoint ####