Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 84:c8d1f7b9e5a8 | 85:dbd141c6bb97 |
|---|---|
| 164 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ | 164 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ |
| 165 order by msv.PARAMETERID, \ | 165 order by msv.PARAMETERID, \ |
| 166 msv.TIMEVALUE, \ | 166 msv.TIMEVALUE, \ |
| 167 ml.UPPERZLOCATION | 167 ml.UPPERZLOCATION |
| 168 | 168 |
| 169 | 169 ############################################# |
| 170 ############################################# | |
| 171 ##### Vertikalprofil InstantaneousPoint ##### | |
| 172 ############################################# | |
| 173 ############################################# | |
| 174 | |
| 175 verticalprofile_instantaneouspoint_series = SELECT S.SERIESID KEY, \ | |
| 176 S.DESCRIPTION VALUE \ | |
| 177 FROM MEDIAN.SERIES S | |
| 178 | |
| 179 verticalprofile_instantaneouspoint_point = SELECT IP.FEATUREID KEY, \ | |
| 180 IP.SHAPE VALUE \ | |
| 181 FROM MEDIAN.INSTANTANEOUSPOINT IP \ | |
| 182 WHERE IP.POINTSPEC = 4 AND \ | |
| 183 IP.SERIESID = ? | |
| 184 | |
| 185 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ | |
| 186 P.PARAMETERID KEY , \ | |
| 187 P.GERMANNAME VALUE \ | |
| 188 FROM MEDIAN.PARAMETER P, \ | |
| 189 MEDIAN.INSTANTANEOUSPOINT IP, \ | |
| 190 MEDIAN.MEASUREMENT M, \ | |
| 191 MEDIAN.MEASUREDSCALARVALUE MSV \ | |
| 192 WHERE IP.FEATUREID = M.FEATUREID AND \ | |
| 193 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ | |
| 194 MSV.PARAMETERID = P.PARAMETERID AND \ | |
| 195 IP.FEATUREID = ? \ | |
| 196 ORDER BY P.GERMANNAME | |
| 197 | |
| 198 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \ | |
| 199 MSV.DATAVALUE YORDINATE, \ | |
| 200 MSV.PARAMETERID GROUP1, \ | |
| 201 IP.TIMEVALUE GROUP2, \ | |
| 202 1 GROUP3 \ | |
| 203 FROM MEDIAN.INSTANTANEOUSPOINT IP, \ | |
| 204 MEDIAN.MEASUREMENT M, \ | |
| 205 MEDIAN.MEASUREDSCALARVALUE MSV \ | |
| 206 WHERE IP.FEATUREID = M.FEATUREID AND \ | |
| 207 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ | |
| 208 IP.FEATUREID = ? AND \ | |
| 209 MSV.PARAMETERID in (?) \ | |
| 210 ORDER BY IP.TIMEVALUE, \ | |
| 211 MSV.PARAMETERID, \ | |
| 212 M.ZLOCATION |