Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 232:3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
gnv-artifacts/trunk@300 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Mon, 09 Nov 2009 08:55:01 +0000 |
| parents | 2b7a40b5b535 |
| children | 56dcedc4a96c |
comparison
equal
deleted
inserted
replaced
| 231:74255064a4c5 | 232:3d6d89bcbf42 |
|---|---|
| 80 tv.TIMEVALUE <= ? \ | 80 tv.TIMEVALUE <= ? \ |
| 81 ORDER BY tv.MEASUREMENTID , \ | 81 ORDER BY tv.MEASUREMENTID , \ |
| 82 tv.TIMESERIESID , \ | 82 tv.TIMESERIESID , \ |
| 83 t.PARAMETERID , \ | 83 t.PARAMETERID , \ |
| 84 tv.TIMEVALUE | 84 tv.TIMEVALUE |
| 85 | |
| 86 timeseries_odv_data = SELECT SI.NAME CRUISE, \ | |
| 87 MEDIAN.TIMESERIESPOINT.NAME STATION, \ | |
| 88 '*' TYPE, \ | |
| 89 ST_ASTEXT(SHAPE), \ | |
| 90 0 BOTDEPTH, \ | |
| 91 (M.ZLOCATION *-1) DEPTH, \ | |
| 92 TSV.TIMEVALUE, \ | |
| 93 TSV.DATAVALUE, \ | |
| 94 TS.PARAMETERID PARAMETER, \ | |
| 95 TSV.MEASUREMENTID, \ | |
| 96 TSV.TIMESERIESID \ | |
| 97 FROM MEDIAN.TIMESERIESPOINT , \ | |
| 98 MEDIAN.TIMESERIESVALUE TSV, \ | |
| 99 MEDIAN.TIMESERIES TS, \ | |
| 100 MEDIAN.MEASUREMENT M, \ | |
| 101 MEDIAN.SOURCEINFO SI \ | |
| 102 WHERE SI.SOURCEID = M.SOURCEID AND \ | |
| 103 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \ | |
| 104 M.MEASUREMENTID = TSV.MEASUREMENTID AND \ | |
| 105 TSV.TIMESERIESID = TS.TIMESERIESID AND \ | |
| 106 TS.PARAMETERID IN ( ? ) AND \ | |
| 107 TSV.MEASUREMENTID IN ( ? ) AND \ | |
| 108 TSV.TIMEVALUE >= ? AND \ | |
| 109 TSV.TIMEVALUE <= ? \ | |
| 110 ORDER BY TSV.MEASUREMENTID , \ | |
| 111 TSV.TIMESERIESID , \ | |
| 112 TS.PARAMETERID , \ | |
| 113 TSV.TIMEVALUE | |
| 85 | 114 |
| 86 ############################################# | 115 ############################################# |
| 87 ############################################# | 116 ############################################# |
| 88 ########## Zeitserie Mesh ############## | 117 ########## Zeitserie Mesh ############## |
| 89 ############################################# | 118 ############################################# |
| 684 NAME VALUE \ | 713 NAME VALUE \ |
| 685 FROM MEDIAN.FEATUREAREA \ | 714 FROM MEDIAN.FEATUREAREA \ |
| 686 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | 715 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
| 687 FEATUREID = ? \ | 716 FEATUREID = ? \ |
| 688 ORDER BY NAME | 717 ORDER BY NAME |
| 689 |