Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 223:05663e307495 | 224:2b7a40b5b535 |
|---|---|
| 10 FROM MEDIAN.TIMESERIESPOINT tsp, \ | 10 FROM MEDIAN.TIMESERIESPOINT tsp, \ |
| 11 MEDIAN.MEASUREMENT mmt \ | 11 MEDIAN.MEASUREMENT mmt \ |
| 12 WHERE tsp.FEATUREID = mmt.FEATUREID AND \ | 12 WHERE tsp.FEATUREID = mmt.FEATUREID AND \ |
| 13 mmt.SOURCEID = ? \ | 13 mmt.SOURCEID = ? \ |
| 14 order by tsp.name | 14 order by tsp.name |
| 15 | |
| 16 timeseries_timeseriespoint_with_area=SELECT \ | |
| 17 MEDIAN.TIMESERIESPOINT.FEATUREID KEY, \ | |
| 18 MEDIAN.TIMESERIESPOINT.NAME VALUE \ | |
| 19 FROM MEDIAN.TIMESERIESPOINT, \ | |
| 20 MEDIAN.MEASUREMENT MMT \ | |
| 21 WHERE MEDIAN.TIMESERIESPOINT.FEATUREID = MMT.FEATUREID AND \ | |
| 22 MMT.SOURCEID = ? AND \ | |
| 23 INTERSECTS(SHAPE, \ | |
| 24 (SELECT st_astext(SHAPE) \ | |
| 25 FROM MEDIAN.FEATUREAREA \ | |
| 26 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | |
| 27 FEATURECODE = ? )\ | |
| 28 )\ | |
| 29 ORDER BY MEDIAN.TIMESERIESPOINT.NAME | |
| 15 | 30 |
| 16 timeseries_parameter=SELECT DISTINCT \ | 31 timeseries_parameter=SELECT DISTINCT \ |
| 17 p.PARAMETERID KEY, \ | 32 p.PARAMETERID KEY, \ |
| 18 p.GERMANNAME VALUE \ | 33 p.GERMANNAME VALUE \ |
| 19 FROM MEDIAN.PARAMETER P, \ | 34 FROM MEDIAN.PARAMETER P, \ |