Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 737:3f8f71e88587 | 738:40c9a48f51ea |
|---|---|
| 24 (SELECT st_astext(SHAPE) \ | 24 (SELECT st_astext(SHAPE) \ |
| 25 FROM MEDIAN.FEATUREAREA \ | 25 FROM MEDIAN.FEATUREAREA \ |
| 26 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | 26 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
| 27 FEATURECODE = ? )\ | 27 FEATURECODE = ? )\ |
| 28 )\ | 28 )\ |
| 29 ORDER BY MEDIAN.TIMESERIESPOINT.NAME | |
| 30 | |
| 31 timeseries_timeseriespoint_with_wkt=SELECT \ | |
| 32 MEDIAN.TIMESERIESPOINT.FEATUREID KEY, \ | |
| 33 MEDIAN.TIMESERIESPOINT.NAME VALUE \ | |
| 34 FROM MEDIAN.TIMESERIESPOINT, \ | |
| 35 MEDIAN.MEASUREMENT MMT \ | |
| 36 WHERE MEDIAN.TIMESERIESPOINT.FEATUREID = MMT.FEATUREID AND \ | |
| 37 MMT.SOURCEID = ? AND \ | |
| 38 INTERSECTS(SHAPE,"?")\ | |
| 29 ORDER BY MEDIAN.TIMESERIESPOINT.NAME | 39 ORDER BY MEDIAN.TIMESERIESPOINT.NAME |
| 30 | 40 |
| 31 timeseries_parameter=SELECT DISTINCT \ | 41 timeseries_parameter=SELECT DISTINCT \ |
| 32 p.PARAMETERID KEY, \ | 42 p.PARAMETERID KEY, \ |
| 33 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ | 43 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |