Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 738:40c9a48f51ea
Modified the Workflow of TimeSeries on TimeSeriespoints that the Data that was sent by the Mapviewer-Interface take effect.
gnv-artifacts/trunk@777 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Mon, 15 Mar 2010 15:15:56 +0000 |
| parents | 3f8f71e88587 |
| children | 2dc0666db49a |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Mon Mar 15 13:49:50 2010 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Mon Mar 15 15:15:56 2010 +0000 @@ -28,6 +28,16 @@ )\ ORDER BY MEDIAN.TIMESERIESPOINT.NAME +timeseries_timeseriespoint_with_wkt=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,"?")\ + ORDER BY MEDIAN.TIMESERIESPOINT.NAME + timeseries_parameter=SELECT DISTINCT \ p.PARAMETERID KEY, \ p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \