comparison gnv-artifacts/doc/conf/queries.properties @ 469:62fc63d0f71d

Added a new State in Product Verticalprofile in Timeseriespoints. Now it will be displayed the Years where measurements happened and than only the dates of the chosen Year will be fetched and displayed. gnv-artifacts/trunk@532 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 12 Jan 2010 12:42:53 +0000
parents 363236fc462d
children 64e65daa65e9
comparison
equal deleted inserted replaced
468:7ba4c7222265 469:62fc63d0f71d
259 WHERE TS.TIMESERIESID = TSV.TIMESERIESID and \ 259 WHERE TS.TIMESERIESID = TSV.TIMESERIESID and \
260 M.MEASUREMENTID = TSV.MEASUREMENTID and \ 260 M.MEASUREMENTID = TSV.MEASUREMENTID and \
261 M.FEATUREID = ? and \ 261 M.FEATUREID = ? and \
262 TS.PARAMETERID IN ( ? ) 262 TS.PARAMETERID IN ( ? )
263 263
264
265 verticalprofile_year=select distinct \
266 to_char(tsv.TIMEVALUE,'YYYY') KEY, \
267 to_char(tsv.TIMEVALUE,'YYYY') VALUE \
268 from MEDIAN.TIMESERIES ts, \
269 MEDIAN.TIMESERIESVALUE tsv, \
270 MEDIAN.MEASUREMENT m \
271 where ts.TIMESERIESID = tsv.TIMESERIESID and \
272 m.MEASUREMENTID = tsv.MEASUREMENTID and \
273 m.FEATUREID = ? and \
274 ts.PARAMETERID IN ( ? ) \
275 order by to_char(tsv.TIMEVALUE,'YYYY')
276
264 verticalprofile_date=select distinct \ 277 verticalprofile_date=select distinct \
265 tsv.TIMEVALUE KEY, \ 278 tsv.TIMEVALUE KEY, \
266 tsv.TIMEVALUE VALUE \ 279 tsv.TIMEVALUE VALUE \
267 from MEDIAN.TIMESERIES ts, \ 280 from MEDIAN.TIMESERIES ts, \
268 MEDIAN.TIMESERIESVALUE tsv, \ 281 MEDIAN.TIMESERIESVALUE tsv, \
269 MEDIAN.MEASUREMENT m \ 282 MEDIAN.MEASUREMENT m \
270 where ts.TIMESERIESID = tsv.TIMESERIESID and \ 283 where ts.TIMESERIESID = tsv.TIMESERIESID and \
271 m.MEASUREMENTID = tsv.MEASUREMENTID and \ 284 m.MEASUREMENTID = tsv.MEASUREMENTID and \
272 m.FEATUREID = ? and \ 285 m.FEATUREID = ? and \
273 ts.PARAMETERID IN ( ? ) \ 286 ts.PARAMETERID IN ( ? ) and \
287 to_char(tsv.TIMEVALUE,'YYYY') IN (?) \
274 order by tsv.TIMEVALUE 288 order by tsv.TIMEVALUE
275 289
276 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \ 290 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \
277 TSV.DATAVALUE YORDINATE, \ 291 TSV.DATAVALUE YORDINATE, \
278 TS.PARAMETERID GROUP1, \ 292 TS.PARAMETERID GROUP1, \

http://dive4elements.wald.intevation.org