Mercurial > dive4elements > gnv-client
diff gnv-artifacts/src/test/ressources/queries.properties @ 85:dbd141c6bb97
Added Support for VerticalProfiles for InstantaneousPoints
gnv-artifacts/trunk@115 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Wed, 23 Sep 2009 14:32:55 +0000 |
| parents | 5c8e54726a58 |
| children | ce398a7a99fc |
line wrap: on
line diff
--- a/gnv-artifacts/src/test/ressources/queries.properties Wed Sep 23 12:39:48 2009 +0000 +++ b/gnv-artifacts/src/test/ressources/queries.properties Wed Sep 23 14:32:55 2009 +0000 @@ -166,4 +166,47 @@ msv.TIMEVALUE, \ ml.UPPERZLOCATION - \ No newline at end of file +############################################# +############################################# +##### Vertikalprofil InstantaneousPoint ##### +############################################# +############################################# + +verticalprofile_instantaneouspoint_series = SELECT S.SERIESID KEY, \ + S.DESCRIPTION VALUE \ + FROM MEDIAN.SERIES S + +verticalprofile_instantaneouspoint_point = SELECT IP.FEATUREID KEY, \ + IP.SHAPE VALUE \ + FROM MEDIAN.INSTANTANEOUSPOINT IP \ + WHERE IP.POINTSPEC = 4 AND \ + IP.SERIESID = ? + +verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ + P.PARAMETERID KEY , \ + P.GERMANNAME VALUE \ + FROM MEDIAN.PARAMETER P, \ + MEDIAN.INSTANTANEOUSPOINT IP, \ + MEDIAN.MEASUREMENT M, \ + MEDIAN.MEASUREDSCALARVALUE MSV \ + WHERE IP.FEATUREID = M.FEATUREID AND \ + M.MEASUREMENTID = MSV.MEASUREMENTID AND \ + MSV.PARAMETERID = P.PARAMETERID AND \ + IP.FEATUREID = ? \ + ORDER BY P.GERMANNAME + +verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \ + MSV.DATAVALUE YORDINATE, \ + MSV.PARAMETERID GROUP1, \ + IP.TIMEVALUE GROUP2, \ + 1 GROUP3 \ + FROM MEDIAN.INSTANTANEOUSPOINT IP, \ + MEDIAN.MEASUREMENT M, \ + MEDIAN.MEASUREDSCALARVALUE MSV \ + WHERE IP.FEATUREID = M.FEATUREID AND \ + M.MEASUREMENTID = MSV.MEASUREMENTID AND \ + IP.FEATUREID = ? AND \ + MSV.PARAMETERID in (?) \ + ORDER BY IP.TIMEVALUE, \ + MSV.PARAMETERID, \ + M.ZLOCATION \ No newline at end of file