Mercurial > dive4elements > gnv-client

annotate gnv-artifacts/doc/conf/queries.properties @ 325:3eff9241ea1e

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