Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 224:2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
gnv-artifacts/trunk@288 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Thu, 05 Nov 2009 16:02:36 +0000 |
| parents | 05663e307495 |
| children | 3d6d89bcbf42 |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Thu Nov 05 15:16:51 2009 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Thu Nov 05 16:02:36 2009 +0000 @@ -13,6 +13,21 @@ mmt.SOURCEID = ? \ order by tsp.name +timeseries_timeseriespoint_with_area=SELECT \ + MEDIAN.TIMESERIESPOINT.FEATUREID KEY, \ + MEDIAN.TIMESERIESPOINT.NAME VALUE \ + FROM MEDIAN.TIMESERIESPOINT, \ + MEDIAN.MEASUREMENT MMT \ + WHERE MEDIAN.TIMESERIESPOINT.FEATUREID = MMT.FEATUREID AND \ + MMT.SOURCEID = ? AND \ + INTERSECTS(SHAPE, \ + (SELECT st_astext(SHAPE) \ + FROM MEDIAN.FEATUREAREA \ + WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ + FEATURECODE = ? )\ + )\ + ORDER BY MEDIAN.TIMESERIESPOINT.NAME + timeseries_parameter=SELECT DISTINCT \ p.PARAMETERID KEY, \ p.GERMANNAME VALUE \