Mercurial > dive4elements > gnv-client
annotate gnv-artifacts/doc/conf/queries.properties @ 497:75306d856004
Fixed import error.
gnv-artifacts/trunk@577 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Tue, 19 Jan 2010 17:55:08 +0000 |
parents | 64e65daa65e9 |
children | c6249cb631df |
rev | line source |
---|---|
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
1 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
2 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
3 ########## Zeitserie ############## |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
4 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
5 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
6 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
7 timeseries_timeseriespoint=SELECT DISTINCT \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
8 tsp.FEATUREID KEY, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
9 tsp.NAME VALUE \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
10 FROM MEDIAN.TIMESERIESPOINT tsp, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
11 MEDIAN.MEASUREMENT mmt \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
12 WHERE tsp.FEATUREID = mmt.FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
13 mmt.SOURCEID = ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
14 order by tsp.name |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
15 |
224
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
16 timeseries_timeseriespoint_with_area=SELECT \ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
17 MEDIAN.TIMESERIESPOINT.FEATUREID KEY, \ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
18 MEDIAN.TIMESERIESPOINT.NAME VALUE \ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
19 FROM MEDIAN.TIMESERIESPOINT, \ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
20 MEDIAN.MEASUREMENT MMT \ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
21 WHERE MEDIAN.TIMESERIESPOINT.FEATUREID = MMT.FEATUREID AND \ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
22 MMT.SOURCEID = ? AND \ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
23 INTERSECTS(SHAPE, \ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
24 (SELECT st_astext(SHAPE) \ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
25 FROM MEDIAN.FEATUREAREA \ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
26 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
27 FEATURECODE = ? )\ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
28 )\ |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
29 ORDER BY MEDIAN.TIMESERIESPOINT.NAME |
2b7a40b5b535
Added the RegionFilters into the configuration of the Products for TimeSeriesPoints.
Tim Englich <tim.englich@intevation.de>
parents:
223
diff
changeset
|
30 |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
31 timeseries_parameter=SELECT DISTINCT \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
32 p.PARAMETERID KEY, \ |
338
c94936b1f4ba
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
336
diff
changeset
|
33 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
c94936b1f4ba
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
336
diff
changeset
|
34 p.GERMANNAME \ |
209
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
35 FROM MEDIAN.PARAMETER P, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
36 MEDIAN.TIMESERIES TS, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
37 MEDIAN.TIMESERIESVALUE TSV, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
38 MEDIAN.MEASUREMENT M, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
39 MEDIAN.TIMESERIESPOINT TSP \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
40 WHERE M.FEATUREID = TSP.FEATUREID AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
41 M.MEASUREMENTID = TSV.MEASUREMENTID AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
42 TS.TIMESERIESID = TSV.TIMESERIESID AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
43 P.PARAMETERID = TS.PARAMETERID AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
44 TSP.FEATUREID = ? \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
45 ORDER BY P.GERMANNAME |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
46 |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
47 timeseries_depth_height=SELECT DISTINCT \ |
209
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
48 M.MEASUREMENTID KEY, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
49 M.ZLOCATION VALUE \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
50 FROM MEDIAN.MEASUREMENT M, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
51 MEDIAN.TIMESERIESVALUE TSV, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
52 MEDIAN.TIMESERIES T, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
53 MEDIAN.PARAMETER P \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
54 WHERE M.MEASUREMENTID = TSV.MEASUREMENTID AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
55 TSV.TIMESERIESID = T.TIMESERIESID AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
56 T.PARAMETERID = P.PARAMETERID AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
57 M.FEATUREID = ? AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
58 P.PARAMETERID IN (?)\ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
59 ORDER BY m.ZLOCATION DESC |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
60 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
61 timeseries_interval=select min(tv.TIMEVALUE) MIN, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
62 max(tv.TIMEVALUE) MAX \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
63 from MEDIAN.TIMESERIES t, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
64 MEDIAN.TIMESERIESVALUE tv \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
65 where tv.TIMESERIESID = t.TIMESERIESID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
66 t.PARAMETERID IN ( ? ) AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
67 tv.MEASUREMENTID IN ( ? ) |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
68 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
69 timeseries_chart_data=SELECT tv.TIMEVALUE XORDINATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
70 tv.DATAVALUE YORDINATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
71 t.PARAMETERID GROUP1, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
72 tv.MEASUREMENTID GROUP2, \ |
217
3dcd2b0b456e
Added configurable TimeGap Support to the TimeSeries-Chart-Generation. issu45
Tim Englich <tim.englich@intevation.de>
parents:
216
diff
changeset
|
73 tv.TIMESERIESID GROUP3, \ |
3dcd2b0b456e
Added configurable TimeGap Support to the TimeSeries-Chart-Generation. issu45
Tim Englich <tim.englich@intevation.de>
parents:
216
diff
changeset
|
74 t.TIMEINTERVAL GAPID \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
75 FROM MEDIAN.TIMESERIESVALUE tv, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
76 MEDIAN.TIMESERIES t \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
77 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
78 t.PARAMETERID IN ( ? ) AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
79 tv.MEASUREMENTID IN ( ? ) AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
80 tv.TIMEVALUE >= ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
81 tv.TIMEVALUE <= ? \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
82 ORDER BY tv.MEASUREMENTID, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
83 tv.TIMESERIESID, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
84 t.PARAMETERID, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
85 tv.TIMEVALUE |
232
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
86 |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
87 timeseries_odv_data = SELECT SI.NAME CRUISE, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
88 MEDIAN.TIMESERIESPOINT.NAME STATION, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
89 '*' TYPE, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
90 ST_ASTEXT(SHAPE), \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
91 0 BOTDEPTH, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
92 (M.ZLOCATION *-1) DEPTH, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
93 TSV.TIMEVALUE, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
94 TSV.DATAVALUE, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
95 TS.PARAMETERID PARAMETER, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
96 TSV.MEASUREMENTID, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
97 TSV.TIMESERIESID \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
98 FROM MEDIAN.TIMESERIESPOINT, \ |
232
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
99 MEDIAN.TIMESERIESVALUE TSV, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
100 MEDIAN.TIMESERIES TS, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
101 MEDIAN.MEASUREMENT M, \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
102 MEDIAN.SOURCEINFO SI \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
103 WHERE SI.SOURCEID = M.SOURCEID AND \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
104 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
105 M.MEASUREMENTID = TSV.MEASUREMENTID AND \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
106 TSV.TIMESERIESID = TS.TIMESERIESID AND \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
107 TS.PARAMETERID IN ( ? ) AND \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
108 TSV.MEASUREMENTID IN ( ? ) AND \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
109 TSV.TIMEVALUE >= ? AND \ |
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
110 TSV.TIMEVALUE <= ? \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
111 ORDER BY TSV.MEASUREMENTID, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
112 TSV.TIMESERIESID, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
113 TS.PARAMETERID, \ |
232
3d6d89bcbf42
Added special Data-Selection to the ODV-Exports of TimeSeries on TimeSeriesPoints. issue68
Tim Englich <tim.englich@intevation.de>
parents:
224
diff
changeset
|
114 TSV.TIMEVALUE |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
115 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
116 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
117 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
118 ########## Zeitserie Mesh ############## |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
119 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
120 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
121 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
122 timeseries_mesh = SELECT OBJECTID KEY, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
123 m.NAME VALUE \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
124 FROM MEDIAN.MESH m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
125 WHERE SOURCEID IN (?) \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
126 ORDER BY m.NAME |
209
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
127 timeseries_meshpoint = SELECT MEDIAN.MESHPOINT.FEATUREID, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
128 ST_ASTEXT(SHAPE) \ |
209
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
129 FROM MEDIAN.MESHPOINT, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
130 MEDIAN.MESH M \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
131 WHERE MEDIAN.MESHPOINT.MESHID = M.MESHID AND \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
132 KPOSITION = 1 AND \ |
209
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
133 M.OBJECTID = ? AND \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
134 INTERSECTS(SHAPE,"?") |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
135 |
209
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
136 timeseries_meshpoint_depth = SELECT MP.FEATUREID KEY, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
137 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
138 from MEDIAN.MESHLAYER ML, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
139 MEDIAN.MESHPOINT MP, \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
140 MEDIAN.MESH M \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
141 WHERE ML.KPOSITION = MP.KPOSITION AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
142 ML.MESHID = MP.MESHID AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
143 M.OBJECTID = ? AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
144 MP.MESHID = M.MESHID AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
145 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
146 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \ |
d5cef9f17525
gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents:
206
diff
changeset
|
147 ORDER BY ML.UPPERZLOCATION DESC |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
148 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
149 timeseries_mesh_parameter=SELECT distinct \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
150 p.PARAMETERID KEY, \ |
356
3eee1369c79b
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
352
diff
changeset
|
151 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
3eee1369c79b
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
352
diff
changeset
|
152 p.GERMANNAME \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
153 from MEDIAN.PARAMETER p, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
154 MEDIAN.MESHSCALARVALUE msc, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
155 MEDIAN.MESH m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
156 where m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
157 msc.PARTID = m.PARTIDMIN AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
158 msc.PARAMETERID = p.PARAMETERID \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
159 order by p.GERMANNAME |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
160 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
161 min(TIMEVALUE) MIN, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
162 max(TIMEVALUE) MAX \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
163 from MEDIAN.MESHSCALARVALUE msc, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
164 MEDIAN.MESH m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
165 where m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
166 msc.PARTID >= m.PARTIDMIN AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
167 msc.PARTID <= m.PARTIDMAX AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
168 msc.PARAMETERID IN (?) |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
169 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
170 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
171 msv.TIMEVALUE XORDINATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
172 msv.DATAVALUE YORDINATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
173 msv.PARAMETERID GROUP1, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
174 msv.FEATUREID GROUP2, \ |
217
3dcd2b0b456e
Added configurable TimeGap Support to the TimeSeries-Chart-Generation. issu45
Tim Englich <tim.englich@intevation.de>
parents:
216
diff
changeset
|
175 mp.FEATUREID GROUP3, \ |
3dcd2b0b456e
Added configurable TimeGap Support to the TimeSeries-Chart-Generation. issu45
Tim Englich <tim.englich@intevation.de>
parents:
216
diff
changeset
|
176 -1 GAPID \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
177 from MEDIAN.MESHSCALARVALUE msv, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
178 MEDIAN.MESHPOINT mp, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
179 MEDIAN.MESH m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
180 where (m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
181 msv.PARTID >= m.PARTIDMIN AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
182 msv.PARTID <= m.PARTIDMAX ) AND \ |
306
e7f1c79bf9cd
Bugfix for issue91, wrong depth will be drawn in TimeseriesCharts in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
247
diff
changeset
|
183 msv.FEATUREID = mp.FEATUREID AND \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
184 msv.PARAMETERID in ( ? ) AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
185 mp.FEATUREID in ( ? ) AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
186 msv.TIMEVALUE >= ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
187 msv.TIMEVALUE <= ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
188 order by mp.FEATUREID, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
189 msv.FEATUREID, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
190 msv.PARAMETERID, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
191 msv.TIMEVALUE |
240
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
192 |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
193 timeseries_mesh_odv_data = select /*+ parallel(timevalue,10) */ \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
194 SI.NAME CRUISE, \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
195 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
196 '*' TYPE, \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
197 ST_ASTEXT(SHAPE), \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
198 0 BOTDEPTH, \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
199 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
200 msv.TIMEVALUE, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
201 msv.DATAVALUE, \ |
240
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
202 msv.PARAMETERID PARAMETER \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
203 from MEDIAN.MESHSCALARVALUE msv, \ |
240
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
204 MEDIAN.MESHPOINT, \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
205 MEDIAN.MESH m, \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
206 MEDIAN.SOURCEINFO SI, \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
207 MEDIAN.MESHLAYER ML \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
208 where (m.OBJECTID = ? AND \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
209 msv.PARTID >= m.PARTIDMIN AND \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
210 msv.PARTID <= m.PARTIDMAX ) AND \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
211 m.SOURCEID = SI.SOURCEID AND \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
212 ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
213 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \ |
306
e7f1c79bf9cd
Bugfix for issue91, wrong depth will be drawn in TimeseriesCharts in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
247
diff
changeset
|
214 msv.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ |
240
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
215 msv.PARAMETERID in (? ) AND \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
216 MEDIAN.MESHPOINT.FEATUREID in ( ? ) AND \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
217 msv.TIMEVALUE >= ? AND \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
218 msv.TIMEVALUE <= ? \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
219 order by MEDIAN.MESHPOINT.FEATUREID, \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
220 msv.FEATUREID, \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
221 msv.PARAMETERID, \ |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
222 msv.TIMEVALUE |
76897b73db4e
Added ODV-Export-Support to TimeSeries Mesh
Tim Englich <tim.englich@intevation.de>
parents:
237
diff
changeset
|
223 |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
224 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
225 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
226 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
227 ########## Vertikalprofil ############## |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
228 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
229 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
230 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
231 verticalprofile_point=SELECT DISTINCT \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
232 tsp.FEATUREID KEY, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
233 tsp.NAME VALUE \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
234 FROM MEDIAN.TIMESERIESPOINT tsp, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
235 MEDIAN.MEASUREMENT mmt \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
236 WHERE tsp.FEATUREID = mmt.FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
237 mmt.SOURCEID = ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
238 order by tsp.name |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
239 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
240 verticalprofile_parameter=SELECT DISTINCT \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
241 p.PARAMETERID KEY, \ |
356
3eee1369c79b
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
352
diff
changeset
|
242 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
3eee1369c79b
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
352
diff
changeset
|
243 p.GERMANNAME \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
244 from MEDIAN.PARAMETER p, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
245 MEDIAN.TIMESERIES ts, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
246 MEDIAN.TIMESERIESVALUE tsv, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
247 MEDIAN.MEASUREMENT m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
248 where ts.PARAMETERID = p.PARAMETERID and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
249 ts.TIMESERIESID = tsv.TIMESERIESID and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
250 m.MEASUREMENTID = tsv.MEASUREMENTID and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
251 m.FEATUREID = ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
252 ORDER BY p.GERMANNAME |
211
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
253 |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
254 verticalprofile_minmaxdepth= SELECT min(M.ZLOCATION) MIN, \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
255 max(M.ZLOCATION) MAX \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
256 FROM MEDIAN.MEASUREMENT M, \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
257 MEDIAN.TIMESERIES TS, \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
258 MEDIAN.TIMESERIESVALUE TSV \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
259 WHERE TS.TIMESERIESID = TSV.TIMESERIESID and \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
260 M.MEASUREMENTID = TSV.MEASUREMENTID and \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
261 M.FEATUREID = ? and \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
262 TS.PARAMETERID IN ( ? ) |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
263 |
469
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
264 |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
265 verticalprofile_year=select distinct \ |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
266 to_char(tsv.TIMEVALUE,'YYYY') KEY, \ |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
267 to_char(tsv.TIMEVALUE,'YYYY') VALUE \ |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
268 from MEDIAN.TIMESERIES ts, \ |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
269 MEDIAN.TIMESERIESVALUE tsv, \ |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
270 MEDIAN.MEASUREMENT m \ |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
271 where ts.TIMESERIESID = tsv.TIMESERIESID and \ |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
272 m.MEASUREMENTID = tsv.MEASUREMENTID and \ |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
273 m.FEATUREID = ? and \ |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
274 ts.PARAMETERID IN ( ? ) \ |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
275 order by to_char(tsv.TIMEVALUE,'YYYY') |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
276 |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
277 verticalprofile_date=select distinct \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
278 tsv.TIMEVALUE KEY, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
279 tsv.TIMEVALUE VALUE \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
280 from MEDIAN.TIMESERIES ts, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
281 MEDIAN.TIMESERIESVALUE tsv, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
282 MEDIAN.MEASUREMENT m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
283 where ts.TIMESERIESID = tsv.TIMESERIESID and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
284 m.MEASUREMENTID = tsv.MEASUREMENTID and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
285 m.FEATUREID = ? and \ |
469
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
286 ts.PARAMETERID IN ( ? ) and \ |
62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Tim Englich <tim.englich@intevation.de>
parents:
455
diff
changeset
|
287 to_char(tsv.TIMEVALUE,'YYYY') IN (?) \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
288 order by tsv.TIMEVALUE |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
289 |
211
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
290 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
291 TSV.DATAVALUE YORDINATE, \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
292 TS.PARAMETERID GROUP1, \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
293 TSV.TIMEVALUE GROUP2, \ |
336
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
294 1 GROUP3, \ |
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
295 1 DATAID \ |
211
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
296 from MEDIAN.TIMESERIES TS, \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
297 MEDIAN.TIMESERIESVALUE TSV, \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
298 MEDIAN.MEASUREMENT M \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
299 where TS.TIMESERIESID = TSV.TIMESERIESID AND \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
300 M.MEASUREMENTID = TSV.MEASUREMENTID AND \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
301 M.FEATUREID = ? AND \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
302 TS.PARAMETERID IN ( ? ) AND \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
303 TSV.TIMEVALUE IN (?) AND \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
304 M.ZLOCATION >= ? AND \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
305 M.ZLOCATION <= ? \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
306 ORDER BY TSV.TIMEVALUE, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
307 TSV.TIMESERIESID, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
308 TS.PARAMETERID, \ |
211
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
309 TSV.TIMEVALUE |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
310 |
237
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
311 verticalprofile_odv_data = SELECT SI.NAME CRUISE, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
312 MEDIAN.TIMESERIESPOINT.NAME STATION, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
313 '*' TYPE, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
314 ST_ASTEXT(SHAPE), \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
315 0 BOTDEPTH, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
316 (M.ZLOCATION *-1) DEPTH, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
317 TSV.TIMEVALUE, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
318 TSV.DATAVALUE, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
319 TS.PARAMETERID PARAMETER, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
320 TSV.MEASUREMENTID, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
321 TSV.TIMESERIESID \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
322 FROM MEDIAN.TIMESERIESPOINT, \ |
237
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
323 MEDIAN.TIMESERIESVALUE TSV, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
324 MEDIAN.TIMESERIES TS, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
325 MEDIAN.MEASUREMENT M, \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
326 MEDIAN.SOURCEINFO SI \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
327 WHERE SI.SOURCEID = M.SOURCEID AND \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
328 M.FEATUREID = MEDIAN.TIMESERIESPOINT.FEATUREID AND \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
329 M.MEASUREMENTID = TSV.MEASUREMENTID AND \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
330 TSV.TIMESERIESID = TS.TIMESERIESID AND \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
331 M.FEATUREID = ? AND \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
332 TS.PARAMETERID IN ( ? ) AND \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
333 TSV.TIMEVALUE IN (?) AND \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
334 M.ZLOCATION >= ? AND \ |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
335 M.ZLOCATION <= ? \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
336 ORDER BY TSV.MEASUREMENTID, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
337 TSV.TIMESERIESID, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
338 TS.PARAMETERID, \ |
237
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
339 TSV.TIMEVALUE |
56dcedc4a96c
Added SQL-Statement for ODV-Exports on Verticalprofiles TimeSeriesPoints
Tim Englich <tim.englich@intevation.de>
parents:
232
diff
changeset
|
340 |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
341 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
342 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
343 ########## Vertikalprofil Mesh ############## |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
344 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
345 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
346 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
347 verticalprofile_mesh = SELECT OBJECTID KEY, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
348 m.NAME VALUE \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
349 FROM MEDIAN.MESH m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
350 WHERE SOURCEID IN (?) \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
351 order by m.NAME |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
352 |
223
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
353 verticalprofile_mesh_with_area = SELECT M.OBJECTID KEY, \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
354 M.NAME VALUE \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
355 FROM MEDIAN.MESHPOINT, \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
356 MEDIAN.MESH M \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
357 WHERE M.SOURCEID IN (?) AND \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
358 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
359 INTERSECTS(SHAPE, \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
360 (SELECT st_astext(SHAPE) \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
361 FROM MEDIAN.FEATUREAREA \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
362 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
363 FEATURECODE = ? )\ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
364 ) \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
365 order by M.NAME |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
366 |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
367 verticalprofile_mesh_point = SELECT FEATUREID, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
368 ST_ASTEXT(SHAPE) \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
369 FROM MEDIAN.MESHPOINT \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
370 WHERE MESHID in \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
371 (SELECT DISTINCT MESHID \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
372 FROM MEDIAN.MESH \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
373 WHERE OBJECTID = ?) AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
374 KPOSITION = 1 AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
375 INTERSECTS(SHAPE,"?") |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
376 |
213
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
377 verticalprofile_mesh_mindepth = SELECT MP.KPOSITION KEY, \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
378 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
379 from MEDIAN.MESHLAYER ML, \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
380 MEDIAN.MESHPOINT MP, \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
381 MEDIAN.MESH M \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
382 WHERE ML.KPOSITION = MP.KPOSITION AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
383 ML.MESHID = MP.MESHID AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
384 M.OBJECTID = ? AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
385 MP.MESHID = M.MESHID AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
386 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
387 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
388 ORDER BY ML.UPPERZLOCATION DESC |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
389 |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
390 verticalprofile_mesh_maxdepth = SELECT MP.KPOSITION KEY, \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
391 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
392 from MEDIAN.MESHLAYER ML, \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
393 MEDIAN.MESHPOINT MP, \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
394 MEDIAN.MESH M \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
395 WHERE ML.KPOSITION = MP.KPOSITION AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
396 ML.MESHID = MP.MESHID AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
397 M.OBJECTID = ? AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
398 MP.MESHID = M.MESHID AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
399 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
400 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
401 MP.KPOSITION < ? \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
402 ORDER BY ML.UPPERZLOCATION DESC |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
403 |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
404 verticalprofile_mesh_parameter=SELECT distinct \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
405 p.PARAMETERID KEY, \ |
356
3eee1369c79b
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
352
diff
changeset
|
406 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
3eee1369c79b
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
352
diff
changeset
|
407 p.GERMANNAME \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
408 from MEDIAN.PARAMETER p, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
409 MEDIAN.MESHSCALARVALUE msc, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
410 MEDIAN.MESH m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
411 where m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
412 m.PARTIDMIN = msc.PARTID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
413 msc.PARAMETERID = p.PARAMETERID \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
414 order by p.GERMANNAME |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
415 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
416 verticalprofile_mesh_date= select distinct \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
417 msv.TIMEVALUE KEY, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
418 msv.TIMEVALUE VALUE \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
419 from MEDIAN.MESHSCALARVALUE msv, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
420 MEDIAN.MESH m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
421 where m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
422 msv.PARTID >= m.PARTIDMIN AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
423 msv.PARTID <= m.PARTIDMAX AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
424 msv.PARAMETERID in (?) \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
425 order by msv.TIMEVALUE |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
426 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
427 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
428 msv.DATAVALUE YORDINATE, \ |
370
061355435075
Changed depending value for gap detection in verticalprofile charts on meshes.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
356
diff
changeset
|
429 mp.KPOSITION KPOSITION, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
430 msv.PARAMETERID GROUP1, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
431 msv.TIMEVALUE GROUP2, \ |
336
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
432 1 GROUP3, \ |
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
433 2 DATAID \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
434 from MEDIAN.MESHLAYER ml, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
435 MEDIAN.MESHPOINT mp, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
436 MEDIAN.MESH m, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
437 MEDIAN.MESHSCALARVALUE msv \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
438 where msv.FEATUREID = mp. FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
439 ml.KPOSITION = mp.KPOSITION and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
440 ml.MESHID = mp.MESHID and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
441 m.MESHID = mp.MESHID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
442 m.PARTIDMIN <= msv.PARTID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
443 m.PARTIDMAX >= msv.PARTID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
444 msv.PARAMETERID in (?) AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
445 msv.TIMEVALUE in (?) AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
446 m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
447 mp.FEATUREID in \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
448 ( select FEATUREID \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
449 from MEDIAN.MESHPOINT mp, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
450 MEDIAN.MESH m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
451 where m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
452 mp.MESHID = m.MESHID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
453 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ |
213
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
454 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
455 mp.KPOSITION <= ? AND \ |
c0a798299efc
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61
Tim Englich <tim.englich@intevation.de>
parents:
211
diff
changeset
|
456 mp.KPOSITION >= ? \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
457 order by msv.PARAMETERID, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
458 msv.TIMEVALUE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
459 ml.UPPERZLOCATION |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
460 |
241
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
461 verticalprofile_mesh_odv_data=select SI.NAME CRUISE, \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
462 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
463 '*' TYPE, \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
464 ST_ASTEXT(SHAPE), \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
465 0 BOTDEPTH, \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
466 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
467 msv.DATAVALUE, \ |
241
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
468 msv.PARAMETERID PARAMETER, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
469 msv.TIMEVALUE \ |
241
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
470 from MEDIAN.MESHLAYER ml, \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
471 MEDIAN.MESHPOINT, \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
472 MEDIAN.MESH m, \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
473 MEDIAN.MESHSCALARVALUE msv, \ |
242
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
474 MEDIAN.SOURCEINFO SI \ |
241
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
475 where m.SOURCEID = SI.SOURCEID AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
476 msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
477 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
478 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
479 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
480 m.PARTIDMIN <= msv.PARTID AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
481 m.PARTIDMAX >= msv.PARTID AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
482 msv.PARAMETERID in (?) AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
483 msv.TIMEVALUE in (?) AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
484 m.OBJECTID = ? AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
485 MEDIAN.MESHPOINT.FEATUREID in \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
486 ( select FEATUREID \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
487 from MEDIAN.MESHPOINT mp, \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
488 MEDIAN.MESH m \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
489 where m.OBJECTID = ? AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
490 mp.MESHID = m.MESHID AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
491 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
492 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
493 MEDIAN.MESHPOINT.KPOSITION <= ? AND \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
494 MEDIAN.MESHPOINT.KPOSITION >= ? \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
495 order by msv.PARAMETERID, \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
496 msv.TIMEVALUE, \ |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
497 ml.UPPERZLOCATION |
8500529d82af
Added ODV-Export to VerticalProfiles
Tim Englich <tim.englich@intevation.de>
parents:
240
diff
changeset
|
498 |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
499 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
500 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
501 ##### Vertikalprofil InstantaneousPoint ##### |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
502 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
503 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
504 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
505 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
506 S.SERIESID KEY, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
507 S.DESCRIPTION VALUE \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
508 FROM MEDIAN.SERIES S, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
509 MEDIAN.INSTANTANEOUSPOINT I, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
510 MEDIAN.MEASUREMENT M \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
511 WHERE S.SERIESID = I.SERIESID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
512 I.POINTSPEC = 4 AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
513 I.FEATUREID = M.FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
514 M.SOURCEID= ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
515 ORDER BY S.DESCRIPTION |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
516 |
325
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
517 verticalprofile_instantaneouspoint_series_with_area = SELECT \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
518 S.SERIESID KEY, \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
519 S.DESCRIPTION VALUE \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
520 FROM MEDIAN.INSTANTANEOUSPOINT, \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
521 MEDIAN.SERIES S, \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
522 MEDIAN.MEASUREMENT M \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
523 WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
524 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
525 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
526 M.SOURCEID= ? AND \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
527 INTERSECTS(SHAPE, \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
528 (SELECT st_astext(SHAPE) \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
529 FROM MEDIAN.FEATUREAREA \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
530 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
531 FEATURECODE = ? )\ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
532 ) \ |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
533 ORDER BY S.DESCRIPTION |
3eff9241ea1e
Refactoring of the Transitionmodel.
Tim Englich <tim.englich@intevation.de>
parents:
319
diff
changeset
|
534 |
205
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
535 verticalprofile_instantaneouspoint_point = SELECT \ |
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
536 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ |
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
537 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \ |
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
538 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \ |
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
539 ST_ASTEXT(SHAPE) \ |
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
540 FROM MEDIAN.INSTANTANEOUSPOINT, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
541 MEDIAN.MEASUREMENT M \ |
205
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
542 WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \ |
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
543 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ |
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
544 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
545 M.SOURCEID = ? \ |
205
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
546 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ |
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
547 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
548 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
549 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
550 P.PARAMETERID KEY, \ |
356
3eee1369c79b
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
352
diff
changeset
|
551 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
3eee1369c79b
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
352
diff
changeset
|
552 p.GERMANNAME \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
553 FROM MEDIAN.PARAMETER P, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
554 MEDIAN.INSTANTANEOUSPOINT IP, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
555 MEDIAN.MEASUREMENT M, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
556 MEDIAN.MEASUREDSCALARVALUE MSV \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
557 WHERE IP.FEATUREID = M.FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
558 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
559 MSV.PARAMETERID = P.PARAMETERID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
560 IP.FEATUREID = ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
561 ORDER BY P.GERMANNAME |
211
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
562 |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
563 verticalprofile_instantaneouspoint_minmaxdepth = SELECT min(M.ZLOCATION) MIN, \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
564 max(M.ZLOCATION) MAX \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
565 FROM MEDIAN.INSTANTANEOUSPOINT IP, \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
566 MEDIAN.MEASUREMENT M, \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
567 MEDIAN.MEASUREDSCALARVALUE MSV \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
568 WHERE IP.FEATUREID = M.FEATUREID AND \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
569 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
570 IP.FEATUREID = ? AND \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
571 MSV.PARAMETERID in (?) |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
572 |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
573 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
574 MSV.DATAVALUE YORDINATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
575 MSV.PARAMETERID GROUP1, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
576 IP.TIMEVALUE GROUP2, \ |
336
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
577 1 GROUP3, \ |
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
578 3 DATAID \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
579 FROM MEDIAN.INSTANTANEOUSPOINT IP, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
580 MEDIAN.MEASUREMENT M, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
581 MEDIAN.MEASUREDSCALARVALUE MSV \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
582 WHERE IP.FEATUREID = M.FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
583 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
584 IP.FEATUREID = ? AND \ |
211
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
585 MSV.PARAMETERID in (?) AND \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
586 M.ZLOCATION >= ? AND \ |
310874d3573f
Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents:
209
diff
changeset
|
587 M.ZLOCATION <= ? \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
588 ORDER BY IP.TIMEVALUE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
589 MSV.PARAMETERID, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
590 M.ZLOCATION |
243
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
591 |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
592 verticalprofile_instantaneouspoint_odv_data = SELECT S.DESCRIPTION CRUISE, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
593 MEDIAN.INSTANTANEOUSPOINT.FEATUREID STATION, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
594 '*' TYPE, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
595 ST_ASTEXT(SHAPE), \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
596 0 BOTDEPTH, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
597 (M.ZLOCATION * -1) DEPTH, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
598 MSV.DATAVALUE, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
599 MSV.PARAMETERID PARAMETER, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
600 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
601 FROM MEDIAN.SERIES S, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
602 MEDIAN.INSTANTANEOUSPOINT, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
603 MEDIAN.MEASUREMENT M, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
604 MEDIAN.MEASUREDSCALARVALUE MSV \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
605 WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
606 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
607 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
608 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = ? AND \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
609 MSV.PARAMETERID in (?) AND \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
610 M.ZLOCATION >= ? AND \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
611 M.ZLOCATION <= ? \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
612 ORDER BY MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
613 MSV.PARAMETERID, \ |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
614 M.ZLOCATION |
b599de3db552
Added ODV-Export to VerticalProfiles in InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
242
diff
changeset
|
615 |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
616 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
617 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
618 #### Horizontalprofil InstantaneousPoint #### |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
619 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
620 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
621 horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
622 V.VEHICLEID KEY, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
623 V.NAME VALUE \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
624 FROM MEDIAN.VEHICLE V, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
625 MEDIAN.CRUISE C, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
626 MEDIAN.TRACK T, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
627 MEDIAN.SURVEYINFO S, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
628 MEDIAN.INSTANTANEOUSPOINT I, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
629 MEDIAN.MEASUREMENT M \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
630 WHERE V.VEHICLEID = C.VEHICLEID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
631 C.CRUISEID = T.CRUISEID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
632 T.TRACKID = S.TRACKID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
633 S.SURVEYID = I.SURVEYID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
634 I.FEATUREID = M.FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
635 M.SOURCEID = ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
636 ORDER BY V.NAME |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
637 |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
638 horizontalprofile_instantaneouspoint_vehicle_with_area = SELECT V.VEHICLEID KEY, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
639 V.NAME VALUE \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
640 FROM MEDIAN.TRACK, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
641 MEDIAN.VEHICLE V, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
642 MEDIAN.CRUISE C \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
643 WHERE V.VEHICLEID = C.VEHICLEID AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
644 C.CRUISEID = MEDIAN.TRACK.CRUISEID AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
645 MEDIAN.TRACK.TRACKID IN \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
646 (SELECT DISTINCT S.TRACKID \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
647 FROM MEDIAN.MEASUREMENT M ,\ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
648 MEDIAN.INSTANTANEOUSPOINT I, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
649 MEDIAN.SURVEYINFO S \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
650 WHERE M.SOURCEID = ? AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
651 I.FEATUREID = M.FEATUREID AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
652 S.SURVEYID = I.SURVEYID)AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
653 INTERSECTS(SHAPE, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
654 (SELECT st_astext(SHAPE) \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
655 FROM MEDIAN.FEATUREAREA \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
656 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
657 FEATURECODE = ? )\ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
658 ) \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
659 ORDER BY V.NAME |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
660 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
661 C.CRUISEID KEY, \ |
206
01ac348ac4a4
Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents:
205
diff
changeset
|
662 V.NAME || ' ' || \ |
01ac348ac4a4
Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents:
205
diff
changeset
|
663 C.NAME || ' ' || \ |
01ac348ac4a4
Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents:
205
diff
changeset
|
664 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
665 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
666 V.NAME, \ |
206
01ac348ac4a4
Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents:
205
diff
changeset
|
667 C.NAME \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
668 FROM MEDIAN.CRUISE C, \ |
206
01ac348ac4a4
Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents:
205
diff
changeset
|
669 MEDIAN.VEHICLE V, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
670 MEDIAN.TRACK T, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
671 MEDIAN.SURVEYINFO S, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
672 MEDIAN.INSTANTANEOUSPOINT I, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
673 MEDIAN.MEASUREMENT M \ |
206
01ac348ac4a4
Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents:
205
diff
changeset
|
674 WHERE C.VEHICLEID = V.VEHICLEID AND \ |
01ac348ac4a4
Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents:
205
diff
changeset
|
675 C.CRUISEID = T.CRUISEID AND \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
676 T.TRACKID = S.TRACKID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
677 S.SURVEYID = I.SURVEYID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
678 I.FEATUREID = M.FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
679 C.VEHICLEID = ? AND \ |
205
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
680 M.SOURCEID = ? \ |
206
01ac348ac4a4
Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents:
205
diff
changeset
|
681 ORDER BY V.NAME, C.NAME |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
682 |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
683 horizontalprofile_instantaneouspoint_cruise_with_area = SELECT C.CRUISEID KEY, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
684 V.NAME || ' ' || \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
685 C.NAME || ' ' || \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
686 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
687 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
688 V.NAME, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
689 C.NAME \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
690 FROM MEDIAN.TRACK, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
691 MEDIAN.VEHICLE V, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
692 MEDIAN.CRUISE C \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
693 WHERE V.VEHICLEID = C.VEHICLEID AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
694 C.CRUISEID = MEDIAN.TRACK.CRUISEID AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
695 MEDIAN.TRACK.TRACKID IN \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
696 (SELECT DISTINCT S.TRACKID \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
697 FROM MEDIAN.MEASUREMENT M ,\ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
698 MEDIAN.INSTANTANEOUSPOINT I, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
699 MEDIAN.SURVEYINFO S \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
700 WHERE M.SOURCEID = ? AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
701 C.VEHICLEID = ? AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
702 I.FEATUREID = M.FEATUREID AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
703 S.SURVEYID = I.SURVEYID)AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
704 INTERSECTS(SHAPE, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
705 (SELECT st_astext(SHAPE) \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
706 FROM MEDIAN.FEATUREAREA \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
707 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
708 FEATURECODE = ? )\ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
709 ) \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
710 ORDER BY V.NAME |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
711 horizontalprofile_instantaneouspoint_track= SELECT \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
712 T.TRACKID KEY, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
713 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
714 FROM MEDIAN.TRACK T \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
715 WHERE T.CRUISEID = ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
716 ORDER BY T.STARTDATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
717 T.ENDDATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
718 T.NAME |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
719 |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
720 horizontalprofile_instantaneouspoint_track_with_area = SELECT \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
721 MEDIAN.TRACK.TRACKID KEY, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
722 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| NAME VALUE, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
723 NAME \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
724 FROM MEDIAN.TRACK \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
725 WHERE MEDIAN.TRACK.CRUISEID = ? AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
726 INTERSECTS(SHAPE, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
727 (SELECT st_astext(SHAPE) \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
728 FROM MEDIAN.FEATUREAREA \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
729 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
730 FEATURECODE = ? )\ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
731 ) \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
732 ORDER BY STARTDATE, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
733 ENDDATE, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
734 NAME |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
735 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
736 SURVEYID KEY, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
737 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
738 FROM MEDIAN.SURVEYINFO \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
739 WHERE TRACKID = ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
740 ORDER BY STARTDATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
741 ENDDATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
742 DESCRIPTION |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
743 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
744 P.PARAMETERID KEY, \ |
356
3eee1369c79b
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
352
diff
changeset
|
745 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
3eee1369c79b
Added the Unit of the Parameter to the Query for Parameters in
Tim Englich <tim.englich@intevation.de>
parents:
352
diff
changeset
|
746 p.GERMANNAME \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
747 FROM MEDIAN.PARAMETER P, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
748 MEDIAN.MEASUREMENT M, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
749 MEDIAN.INSTANTANEOUSPOINT IP, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
750 MEDIAN.MEASUREDSCALARVALUE MSV \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
751 WHERE P.PARAMETERID = MSV.PARAMETERID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
752 MSV.MEASUREMENTID = M.MEASUREMENTID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
753 M.FEATUREID = IP.FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
754 IP.SURVEYID = ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
755 ORDER BY P.GERMANNAME |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
756 horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
757 M.ZLOCATION KEY, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
758 M.ZLOCATION VALUE \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
759 FROM MEDIAN.MEASUREMENT M, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
760 MEDIAN.INSTANTANEOUSPOINT IP \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
761 WHERE M.FEATUREID = IP.FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
762 IP.SURVEYID = ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
763 ORDER BY M.ZLOCATION |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
764 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE), \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
765 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
766 MSV.DATAVALUE YORDINATE, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
767 MSV.PARAMETERID GROUP1, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
768 ZLOCATION GROUP2, \ |
336
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
769 1 GROUP3, \ |
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
770 3 DATAID \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
771 FROM MEDIAN.INSTANTANEOUSPOINT, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
772 MEDIAN.MEASUREMENT M, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
773 MEDIAN.MEASUREDSCALARVALUE MSV \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
774 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
775 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
776 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
777 M.ZLOCATION IN (?) AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
778 MSV.PARAMETERID in (?) \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
779 ORDER BY MSV.PARAMETERID, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
780 M.ZLOCATION, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
781 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE |
244
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
782 horizontalprofile_instantaneouspoint_odv_data = SELECT V.NAME || ' ' || C.NAME CRUISE, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
783 MEDIAN.InstantaneousPoint.FEATUREID STATION, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
784 '*' TYPE, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
785 0 BOTDEPTH, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
786 (M.ZLOCATION * -1) DEPTH, \ |
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
787 ST_ASTEXT(SHAPE), \ |
244
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
788 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
789 MSV.DATAVALUE, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
790 MSV.PARAMETERID PARAMETER \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
791 FROM MEDIAN.INSTANTANEOUSPOINT, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
792 MEDIAN.VEHICLE V, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
793 MEDIAN.CRUISE C, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
794 (SELECT TRACKID,CRUISEID FROM MEDIAN.TRACK) T, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
795 MEDIAN.SURVEYINFO S, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
796 MEDIAN.MEASUREMENT M, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
797 MEDIAN.MEASUREDSCALARVALUE MSV \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
798 WHERE V.VEHICLEID = C.VEHICLEID AND \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
799 C.CRUISEID = T.CRUISEID AND \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
800 T.TRACKID = S.TRACKID AND \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
801 S.SURVEYID = MEDIAN.INSTANTANEOUSPOINT.SURVEYID AND \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
802 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
803 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
804 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
805 M.ZLOCATION IN (?) AND \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
806 MSV.PARAMETERID in (?) \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
807 ORDER BY MSV.PARAMETERID, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
808 M.ZLOCATION, \ |
9048bc4b17cd
Added ODV-Export to HorizontalProfiles on InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
243
diff
changeset
|
809 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
810 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
811 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
812 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
813 ########### Horizontalprofil MESH ########### |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
814 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
815 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
816 horizontalprofile_meshpoint_depth = SELECT DISTINCT \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
817 mp.KPOSITION KEY, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
818 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
819 from MEDIAN.MESHLAYER ml, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
820 MEDIAN.MESHPOINT mp \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
821 where ml.KPOSITION = mp.KPOSITION and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
822 ml.MESHID = mp.MESHID and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
823 mp.FEATUREID in \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
824 ( select FEATUREID \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
825 from MEDIAN.MESHPOINT mp, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
826 MEDIAN.MESH m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
827 where m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
828 mp.MESHID = m.MESHID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
829 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
830 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
831 order by mp.KPOSITION |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
832 |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
833 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
834 msv.DATAVALUE YORDINATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
835 msv.PARAMETERID GROUP1, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
836 MEDIAN.MESHPOINT.KPOSITION GROUP2, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
837 msv.TIMEVALUE GROUP3, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
838 MEDIAN.MESHPOINT.JPOSITION, \ |
336
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
839 MEDIAN.MESHPOINT.IPOSITION, \ |
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
840 2 DATAID \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
841 from MEDIAN.MESHLAYER ml, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
842 MEDIAN.MESHPOINT, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
843 MEDIAN.MESH m, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
844 MEDIAN.MESHSCALARVALUE msv \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
845 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
846 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
847 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
848 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
849 m.PARTIDMIN <= msv.PARTID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
850 m.PARTIDMAX >= msv.PARTID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
851 msv.PARAMETERID in (?) AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
852 msv.TIMEVALUE in (?) AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
853 m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
854 MEDIAN.MESHPOINT.FEATUREID in \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
855 ( select FEATUREID \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
856 from MEDIAN.MESHPOINT mp, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
857 MEDIAN.MESH m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
858 where m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
859 mp.MESHID = m.MESHID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
860 KPOSITION in ( ? ) and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
861 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
862 order by msv.TIMEVALUE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
863 MEDIAN.MESHPOINT.KPOSITION, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
864 msv.PARAMETERID, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
865 MEDIAN.MESHPOINT.JPOSITION, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
866 MEDIAN.MESHPOINT.IPOSITION |
242
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
867 |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
868 horizontalprofile_mesh_odv_data = SELECT SI.NAME CRUISE, \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
869 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
870 '*' TYPE, \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
871 ST_ASTEXT(SHAPE), \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
872 0 BOTDEPTH, \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
873 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
874 msv.DATAVALUE, \ |
247
af474a541f74
Sort Columns to the given order of the ODV-Specification
Tim Englich <tim.englich@intevation.de>
parents:
246
diff
changeset
|
875 msv.PARAMETERID PARAMETER, \ |
242
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
876 msv.TIMEVALUE, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
877 MEDIAN.MESHPOINT.JPOSITION, \ |
242
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
878 MEDIAN.MESHPOINT.IPOSITION \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
879 from MEDIAN.MESHLAYER ml, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
880 MEDIAN.MESHPOINT, \ |
242
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
881 MEDIAN.MESH m, \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
882 MEDIAN.MESHSCALARVALUE msv, \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
883 MEDIAN.SOURCEINFO SI \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
884 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
885 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
886 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
887 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
888 m.SOURCEID = SI.SOURCEID AND \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
889 m.PARTIDMIN <= msv.PARTID AND \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
890 m.PARTIDMAX >= msv.PARTID AND \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
891 msv.PARAMETERID in (?) AND \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
892 msv.TIMEVALUE in (?) AND \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
893 m.OBJECTID = ? AND \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
894 MEDIAN.MESHPOINT.FEATUREID in \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
895 ( select FEATUREID \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
896 from MEDIAN.MESHPOINT mp, \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
897 MEDIAN.MESH m \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
898 where m.OBJECTID = ? AND \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
899 mp.MESHID = m.MESHID AND \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
900 KPOSITION in ( ? ) and \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
901 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
902 order by msv.TIMEVALUE, \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
903 MEDIAN.MESHPOINT.KPOSITION, \ |
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
904 msv.PARAMETERID, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
905 MEDIAN.MESHPOINT.JPOSITION, \ |
242
5925739d25ac
Added ODV-Export to HorizontalProfiles in Meshes
Tim Englich <tim.englich@intevation.de>
parents:
241
diff
changeset
|
906 MEDIAN.MESHPOINT.IPOSITION |
352
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
907 |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
908 ############################################# |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
909 ############################################# |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
910 ########### Horizontalprofil MESH ########### |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
911 ########### Schnittprofil ########### |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
912 ############################################# |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
913 ############################################# |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
914 horizontalprofile_meshpoint_depth = SELECT DISTINCT \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
915 mp.KPOSITION KEY, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
916 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
917 from MEDIAN.MESHLAYER ml, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
918 MEDIAN.MESHPOINT mp \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
919 where ml.KPOSITION = mp.KPOSITION and \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
920 ml.MESHID = mp.MESHID and \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
921 mp.FEATUREID in \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
922 ( select FEATUREID \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
923 from MEDIAN.MESHPOINT mp, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
924 MEDIAN.MESH m \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
925 where m.OBJECTID = ? AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
926 mp.MESHID = m.MESHID )\ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
927 order by mp.KPOSITION |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
928 |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
929 horizontalprofile_meshpoint_cross_ij=SELECT MEDIAN.MESHFACE.JPOSITION, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
930 MEDIAN.MESHFACE.IPOSITION \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
931 FROM MEDIAN.MESHFACE, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
932 MEDIAN.MESH M \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
933 WHERE MEDIAN.MESHFACE.KPOSITION = 1 AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
934 M.MESHID = MEDIAN.MESHFACE.MESHID AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
935 M.OBJECTID = ? AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
936 INTERSECTS(SHAPE, "?") |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
937 horizontalprofile_mesh_cross_chart_data = SELECT ST_ASTEXT(SHAPE), \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
938 msv.DATAVALUE YORDINATE, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
939 msv.PARAMETERID GROUP1, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
940 MEDIAN.MESHPOINT.KPOSITION GROUP2, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
941 msv.TIMEVALUE GROUP3, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
942 MEDIAN.MESHPOINT.JPOSITION, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
943 MEDIAN.MESHPOINT.IPOSITION, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
944 2 DATAID \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
945 from MEDIAN.MESHLAYER ml, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
946 MEDIAN.MESHPOINT, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
947 MEDIAN.MESH m, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
948 MEDIAN.MESHSCALARVALUE msv \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
949 where msv.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
950 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
951 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
952 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
953 m.PARTIDMIN <= msv.PARTID AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
954 m.PARTIDMAX >= msv.PARTID AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
955 msv.PARAMETERID in (?) AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
956 msv.TIMEVALUE in (?) AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
957 m.OBJECTID = ? AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
958 ml.KPOSITION in (?) AND \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
959 MEDIAN.MESHPOINT.FEATUREID in \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
960 ( \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
961 SELECT distinct FEATUREID \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
962 FROM MEDIAN.MESHPOINT \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
963 WHERE ? \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
964 ) \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
965 order by msv.TIMEVALUE, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
966 MEDIAN.MESHPOINT.KPOSITION, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
967 msv.PARAMETERID, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
968 MEDIAN.MESHPOINT.JPOSITION, \ |
24c21a720aa5
Added Support for "horizontale Schnittprofile"
Tim Englich <tim.englich@intevation.de>
parents:
346
diff
changeset
|
969 MEDIAN.MESHPOINT.IPOSITION |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
970 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
971 ############################################# |
216
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
972 ############# Profilschnitt MESH ############ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
973 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
974 ############################################# |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
975 verticalcrosssection_mesh_date = select distinct \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
976 msv.TIMEVALUE KEY, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
977 msv.TIMEVALUE VALUE \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
978 from MEDIAN.MESHSCALARVALUE msv, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
979 MEDIAN.MESH m \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
980 where m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
981 msv.PARTID >= m.PARTIDMIN AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
982 msv.PARTID <= m.PARTIDMAX AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
983 msv.PARAMETERID = ? \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
984 order by msv.TIMEVALUE |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
985 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \ |
346
8f168e12a963
Added Z-Value to verticalcrosssection_mesh_chart_data.
Tim Englich <tim.englich@intevation.de>
parents:
338
diff
changeset
|
986 ((ml.UPPERZLOCATION + ml.LOWERZLOCATION) / 2) Z, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
987 msv.DATAVALUE YORDINATE, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
988 msv.PARAMETERID GROUP1, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
989 msv.TIMEVALUE GROUP2, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
990 MEDIAN.MESHPOINT.JPOSITION, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
991 MEDIAN.MESHPOINT.IPOSITION, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
992 MEDIAN.MESHPOINT.KPOSITION \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
993 from MEDIAN.MESHLAYER ml, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
994 MEDIAN.MESHPOINT, \ |
199
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
995 MEDIAN.MESH m, \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
996 MEDIAN.MESHSCALARVALUE msv \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
997 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
998 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
999 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
1000 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
1001 m.PARTIDMIN <= msv.PARTID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
1002 m.PARTIDMAX >= msv.PARTID AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
1003 msv.PARAMETERID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
1004 msv.TIMEVALUE = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
1005 m.OBJECTID = ? AND \ |
b66e8a6f3907
Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
1006 MEDIAN.MESHPOINT.FEATUREID in \ |
428
88cd37c3b5e4
Adjusted sql queries and configuration for verticalcrosssection products. Some code refactoring and improved error handling.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
370
diff
changeset
|
1007 ( \ |
88cd37c3b5e4
Adjusted sql queries and configuration for verticalcrosssection products. Some code refactoring and improved error handling.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
370
diff
changeset
|
1008 SELECT distinct FEATUREID \ |
88cd37c3b5e4
Adjusted sql queries and configuration for verticalcrosssection products. Some code refactoring and improved error handling.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
370
diff
changeset
|
1009 FROM MEDIAN.MESHPOINT \ |
88cd37c3b5e4
Adjusted sql queries and configuration for verticalcrosssection products. Some code refactoring and improved error handling.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
370
diff
changeset
|
1010 WHERE ? \ |
88cd37c3b5e4
Adjusted sql queries and configuration for verticalcrosssection products. Some code refactoring and improved error handling.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
370
diff
changeset
|
1011 ) \ |
205
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
1012 order by msv.TIMEVALUE, \ |
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
1013 msv.PARAMETERID, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
1014 MEDIAN.MESHPOINT.JPOSITION, \ |
205
6e7952fd1744
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point
Tim Englich <tim.englich@intevation.de>
parents:
199
diff
changeset
|
1015 MEDIAN.MESHPOINT.IPOSITION, \ |
216
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1016 MEDIAN.MESHPOINT.KPOSITION |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1017 |
246
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1018 verticalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1019 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1020 '*' TYPE, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1021 ST_ASTEXT(SHAPE), \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1022 0 BOTDEPTH, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1023 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1024 MSV.TIMEVALUE, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
1025 MSV.DATAVALUE, \ |
246
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1026 MSV.PARAMETERID PARAMETER, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1027 MEDIAN.MESHPOINT.JPOSITION, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1028 MEDIAN.MESHPOINT.IPOSITION, \ |
336
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
1029 MEDIAN.MESHPOINT.KPOSITION, \ |
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
1030 2 DATAID \ |
246
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1031 from MEDIAN.MESHLAYER ml, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
1032 MEDIAN.MESHPOINT, \ |
246
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1033 MEDIAN.MESH m, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1034 MEDIAN.SOURCEINFO SI, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1035 MEDIAN.MESHSCALARVALUE msv \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1036 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1037 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1038 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1039 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1040 m.PARTIDMIN <= msv.PARTID AND \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1041 m.PARTIDMAX >= msv.PARTID AND \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1042 M.SOURCEID = SI.SOURCEID AND \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1043 msv.PARAMETERID = ? AND \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1044 msv.TIMEVALUE = ? AND \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1045 m.OBJECTID = ? AND \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1046 MEDIAN.MESHPOINT.FEATUREID in \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1047 ( select FEATUREID \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1048 from MEDIAN.MESHPOINT mp, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1049 MEDIAN.MESH m \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1050 where m.OBJECTID = ? AND \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1051 mp.MESHID = m.MESHID AND \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1052 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1053 order by msv.TIMEVALUE, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1054 msv.PARAMETERID, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
1055 MEDIAN.MESHPOINT.JPOSITION, \ |
246
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1056 MEDIAN.MESHPOINT.IPOSITION, \ |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1057 MEDIAN.MESHPOINT.KPOSITION |
b7f69809239c
Added ODV-Export to VerticalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
245
diff
changeset
|
1058 |
216
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1059 ############################################# |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1060 ############################################# |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1061 ########## Horizontalschnitt MESH ########### |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1062 ############################################# |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1063 ############################################# |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1064 horizontalcrosssection_meshpoint_depth = SELECT DISTINCT MP.KPOSITION KEY, \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1065 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1066 from MEDIAN.MESHLAYER ML, \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1067 MEDIAN.MESHPOINT MP, \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1068 MEDIAN.MESH M \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1069 WHERE ML.KPOSITION = MP.KPOSITION AND \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1070 ML.MESHID = MP.MESHID AND \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1071 M.OBJECTID = ? AND \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1072 MP.MESHID = M.MESHID \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1073 ORDER BY MP.KPOSITION |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1074 |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1075 horizontalcrosssection_mesh_date = select distinct \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1076 msv.TIMEVALUE KEY, \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1077 msv.TIMEVALUE VALUE \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
1078 from MEDIAN.MESHSCALARVALUE msv, \ |
216
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1079 MEDIAN.MESH m \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1080 where m.OBJECTID = ? AND \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1081 msv.PARTID >= m.PARTIDMIN AND \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1082 msv.PARTID <= m.PARTIDMAX AND \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1083 msv.PARAMETERID = ? \ |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1084 order by msv.TIMEVALUE |
9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents:
213
diff
changeset
|
1085 |
218
926530bda1a7
Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents:
217
diff
changeset
|
1086 horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \ |
926530bda1a7
Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents:
217
diff
changeset
|
1087 MSV.DATAVALUE YORDINATE, \ |
482
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1088 MEDIAN.MESHPOINT.JPOSITION, \ |
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1089 MEDIAN.MESHPOINT.IPOSITION, \ |
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1090 MEDIAN.MESHPOINT.KPOSITION, \ |
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1091 MSV.PARAMETERID, \ |
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1092 MSV.TIMEVALUE, \ |
336
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
1093 2 DATAID \ |
218
926530bda1a7
Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents:
217
diff
changeset
|
1094 from MEDIAN.MESHLAYER ML, \ |
482
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1095 MEDIAN.MESHPOINT, \ |
218
926530bda1a7
Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents:
217
diff
changeset
|
1096 MEDIAN.MESH M, \ |
926530bda1a7
Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents:
217
diff
changeset
|
1097 MEDIAN.MESHSCALARVALUE MSV \ |
482
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1098 where MSV.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ |
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1099 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ |
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1100 ML.MESHID = MEDIAN.MESHPOINT.MESHID and \ |
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1101 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
218
926530bda1a7
Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents:
217
diff
changeset
|
1102 M.PARTIDMIN <= MSV.PARTID AND \ |
926530bda1a7
Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents:
217
diff
changeset
|
1103 M.PARTIDMAX >= MSV.PARTID AND \ |
926530bda1a7
Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents:
217
diff
changeset
|
1104 MSV.PARAMETERID = ? AND \ |
926530bda1a7
Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents:
217
diff
changeset
|
1105 MSV.TIMEVALUE = ? AND \ |
926530bda1a7
Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents:
217
diff
changeset
|
1106 M.OBJECTID = ? AND \ |
482
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1107 MEDIAN.MESHPOINT.KPOSITION = ? \ |
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1108 order by MEDIAN.MESHPOINT.JPOSITION, \ |
64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
469
diff
changeset
|
1109 MEDIAN.MESHPOINT.IPOSITION |
245
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1110 horizontalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1111 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1112 '*' TYPE, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1113 ST_ASTEXT(SHAPE), \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1114 0 BOTDEPTH, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1115 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1116 MSV.TIMEVALUE, \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
1117 MSV.DATAVALUE, \ |
245
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1118 MSV.PARAMETERID PARAMETER, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1119 MEDIAN.MESHPOINT.JPOSITION, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1120 MEDIAN.MESHPOINT.IPOSITION, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1121 MEDIAN.MESHPOINT.KPOSITION \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1122 from MEDIAN.MESHLAYER ML, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1123 MEDIAN.MESHPOINT, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1124 MEDIAN.MESH M, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1125 MEDIAN.SOURCEINFO SI, \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1126 MEDIAN.MESHSCALARVALUE MSV \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1127 where MSV.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1128 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1129 ML.MESHID = MEDIAN.MESHPOINT.MESHID and \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1130 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1131 M.PARTIDMIN <= MSV.PARTID AND \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1132 M.PARTIDMAX >= MSV.PARTID AND \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1133 M.SOURCEID = SI.SOURCEID AND \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1134 MSV.PARAMETERID = ? AND \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1135 MSV.TIMEVALUE = ? AND \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1136 M.OBJECTID = ? AND \ |
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1137 MEDIAN.MESHPOINT.KPOSITION = ? \ |
319
251f16a083f8
Added RegionFilter-Support to HorizontalProfile InstantaneousPoint
Tim Englich <tim.englich@intevation.de>
parents:
306
diff
changeset
|
1138 order by MEDIAN.MESHPOINT.JPOSITION, \ |
245
9697a6b8d2c9
Added ODV-Export to HorizontalCrossSection on Meshes
Tim Englich <tim.englich@intevation.de>
parents:
244
diff
changeset
|
1139 MEDIAN.MESHPOINT.IPOSITION |
223
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1140 |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1141 area_filter = SELECT DISTINCT \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1142 FEATUREID KEY ,\ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1143 DESCRIPTION VALUE \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1144 FROM MEDIAN.FEATUREAREA \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1145 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1146 FEATUREID > 0 \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1147 ORDER BY FEATUREID |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1148 |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1149 subarea_filter = SELECT \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1150 FEATURECODE KEY, \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1151 NAME VALUE \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1152 FROM MEDIAN.FEATUREAREA \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1153 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
05663e307495
Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents:
218
diff
changeset
|
1154 FEATUREID = ? \ |
336
1b9ca0f2d498
Added marker for different data sources in sql queries.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
325
diff
changeset
|
1155 ORDER BY NAME |
455
363236fc462d
Added Rasterdatasupport to VerticalCrossSections
Tim Englich <tim.englich@intevation.de>
parents:
428
diff
changeset
|
1156 |
363236fc462d
Added Rasterdatasupport to VerticalCrossSections
Tim Englich <tim.englich@intevation.de>
parents:
428
diff
changeset
|
1157 rasterQuery = SELECT ST_ASTEXT(RASTER) \ |
363236fc462d
Added Rasterdatasupport to VerticalCrossSections
Tim Englich <tim.englich@intevation.de>
parents:
428
diff
changeset
|
1158 FROM MEDIAN.TOPO_WORLD_2MIN \ |
363236fc462d
Added Rasterdatasupport to VerticalCrossSections
Tim Englich <tim.englich@intevation.de>
parents:
428
diff
changeset
|
1159 WHERE INTERSECTS(RASTER, "?") |