Mercurial > dive4elements > gnv-client

annotate gnv-artifacts/doc/conf/queries.properties @ 231:74255064a4c5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added the Region-Filter to the Workflow of the Artifacttescases to be able to test it automatically. Checkin laer because of trouble with checksum of these file gnv-artifacts/trunk@299 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 06 Nov 2009 11:12:45 +0000
parents 2b7a40b5b535
children 3d6d89bcbf42
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 \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
62 from MEDIAN.TIMESERIES t , \
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 <= ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
81 ORDER BY tv.MEASUREMENTID , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
82 tv.TIMESERIESID , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
83 t.PARAMETERID , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
84 tv.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
85
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
86 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
87 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
88 ########## Zeitserie Mesh ##############
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
89 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
90 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
91
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
92 timeseries_mesh = SELECT OBJECTID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
93 m.NAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
94 FROM MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
95 WHERE SOURCEID IN (?) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
96 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
97 timeseries_meshpoint = SELECT MEDIAN.MESHPOINT.FEATUREID, \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
98 ST_ASTEXT(SHAPE) \
209
d5cef9f17525 gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents: 206
diff changeset
99 FROM MEDIAN.MESHPOINT, \
d5cef9f17525 gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents: 206
diff changeset
100 MEDIAN.MESH M \
d5cef9f17525 gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents: 206
diff changeset
101 WHERE MEDIAN.MESHPOINT.MESHID = M.MESHID AND \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
102 KPOSITION = 1 AND \
209
d5cef9f17525 gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents: 206
diff changeset
103 M.OBJECTID = ? AND \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
104 INTERSECTS(SHAPE,"?")
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
105
209
d5cef9f17525 gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents: 206
diff changeset
106 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
107 '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
108 from MEDIAN.MESHLAYER ML, \
d5cef9f17525 gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents: 206
diff changeset
109 MEDIAN.MESHPOINT MP, \
d5cef9f17525 gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents: 206
diff changeset
110 MEDIAN.MESH M \
d5cef9f17525 gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents: 206
diff changeset
111 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
112 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
113 M.OBJECTID = ? AND \
d5cef9f17525 gnv-artifacts/trunk@265 c6561f87-3c4e-4783-a992-168aeb5c3f6f
Tim Englich <tim.englich@intevation.de>
parents: 206
diff changeset
114 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
115 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
116 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
117 ORDER BY ML.UPPERZLOCATION DESC
199
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 timeseries_mesh_parameter=SELECT distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
120 p.PARAMETERID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
121 p.GERMANNAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
122 from MEDIAN.PARAMETER p, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
123 MEDIAN.MESHSCALARVALUE msc, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
124 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
125 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
126 msc.PARTID = m.PARTIDMIN AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
127 msc.PARAMETERID = p.PARAMETERID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
128 order by p.GERMANNAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
129 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
130 min(TIMEVALUE) MIN, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
131 max(TIMEVALUE) MAX \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
132 from MEDIAN.MESHSCALARVALUE msc , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
133 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
134 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
135 msc.PARTID >= m.PARTIDMIN AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
136 msc.PARTID <= m.PARTIDMAX AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
137 msc.PARAMETERID IN (?)
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
138
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
139 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
140 msv.TIMEVALUE XORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
141 msv.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
142 msv.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
143 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
144 mp.FEATUREID GROUP3, \
3dcd2b0b456e Added configurable TimeGap Support to the TimeSeries-Chart-Generation. issu45
Tim Englich <tim.englich@intevation.de>
parents: 216
diff changeset
145 -1 GAPID \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
146 from MEDIAN.MESHSCALARVALUE msv , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
147 MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
148 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
149 where (m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
150 msv.PARTID >= m.PARTIDMIN AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
151 msv.PARTID <= m.PARTIDMAX ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
152 msv.FEATUREID in ( ? ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
153 msv.PARAMETERID in ( ? ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
154 mp.FEATUREID in ( ? ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
155 msv.TIMEVALUE >= ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
156 msv.TIMEVALUE <= ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
157 order by mp.FEATUREID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
158 msv.FEATUREID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
159 msv.PARAMETERID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
160 msv.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
161
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
162 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
163 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
164 ########## Vertikalprofil ##############
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
165 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
166 #############################################
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 verticalprofile_point=SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
169 tsp.FEATUREID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
170 tsp.NAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
171 FROM MEDIAN.TIMESERIESPOINT tsp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
172 MEDIAN.MEASUREMENT mmt \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
173 WHERE tsp.FEATUREID = mmt.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
174 mmt.SOURCEID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
175 order by tsp.name
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
176
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
177 verticalprofile_parameter=SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
178 p.PARAMETERID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
179 p.GERMANNAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
180 from MEDIAN.PARAMETER p, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
181 MEDIAN.TIMESERIES ts, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
182 MEDIAN.TIMESERIESVALUE tsv, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
183 MEDIAN.MEASUREMENT m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
184 where ts.PARAMETERID = p.PARAMETERID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
185 ts.TIMESERIESID = tsv.TIMESERIESID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
186 m.MEASUREMENTID = tsv.MEASUREMENTID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
187 m.FEATUREID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
188 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
189
310874d3573f Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents: 209
diff changeset
190 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
191 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
192 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
193 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
194 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
195 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
196 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
197 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
198 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
199
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
200 verticalprofile_date=select distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
201 tsv.TIMEVALUE KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
202 tsv.TIMEVALUE VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
203 from MEDIAN.TIMESERIES ts , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
204 MEDIAN.TIMESERIESVALUE tsv, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
205 MEDIAN.MEASUREMENT m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
206 where ts.TIMESERIESID = tsv.TIMESERIESID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
207 m.MEASUREMENTID = tsv.MEASUREMENTID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
208 m.FEATUREID = ? and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
209 ts.PARAMETERID IN ( ? ) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
210 order by tsv.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
211
211
310874d3573f Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents: 209
diff changeset
212 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
213 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
214 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
215 TSV.TIMEVALUE GROUP2, \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
216 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
217 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
218 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
219 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
220 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
221 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
222 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
223 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
224 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
225 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
226 M.ZLOCATION <= ? \
310874d3573f Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents: 209
diff changeset
227 ORDER BY TSV.TIMEVALUE , \
310874d3573f Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents: 209
diff changeset
228 TSV.TIMESERIESID , \
310874d3573f Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents: 209
diff changeset
229 TS.PARAMETERID , \
310874d3573f Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents: 209
diff changeset
230 TSV.TIMEVALUE
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
231
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
232 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
233 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
234 ########## Vertikalprofil Mesh ##############
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
235 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
236 #############################################
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_mesh = SELECT OBJECTID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
239 m.NAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
240 FROM MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
241 WHERE SOURCEID IN (?) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
242 order by m.NAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
243
223
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
244 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
245 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
246 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
247 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
248 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
249 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
250 INTERSECTS(SHAPE, \
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
251 (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
252 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
253 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
254 FEATURECODE = ? )\
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
255 ) \
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
256 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
257
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
258 verticalprofile_mesh_point = SELECT FEATUREID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
259 ST_ASTEXT(SHAPE) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
260 FROM MEDIAN.MESHPOINT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
261 WHERE MESHID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
262 (SELECT DISTINCT MESHID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
263 FROM MEDIAN.MESH \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
264 WHERE OBJECTID = ?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
265 KPOSITION = 1 AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
266 INTERSECTS(SHAPE,"?")
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
267
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
268 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
269 '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
270 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
271 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
272 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
273 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
274 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
275 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
276 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
277 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
278 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
279 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
280
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
281 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
282 '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
283 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
284 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
285 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
286 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
287 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
288 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
289 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
290 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
291 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
292 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
293 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
294
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
295 verticalprofile_mesh_parameter=SELECT distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
296 p.PARAMETERID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
297 p.GERMANNAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
298 from MEDIAN.PARAMETER p, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
299 MEDIAN.MESHSCALARVALUE msc, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
300 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
301 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
302 m.PARTIDMIN = msc.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
303 msc.PARAMETERID = p.PARAMETERID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
304 order by p.GERMANNAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
305
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
306 verticalprofile_mesh_date= select distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
307 msv.TIMEVALUE KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
308 msv.TIMEVALUE VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
309 from MEDIAN.MESHSCALARVALUE msv , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
310 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
311 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
312 msv.PARTID >= m.PARTIDMIN AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
313 msv.PARTID <= m.PARTIDMAX AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
314 msv.PARAMETERID in (?) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
315 order by msv.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
316
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
317 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
318 msv.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
319 msv.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
320 msv.TIMEVALUE GROUP2, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
321 1 GROUP3 \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
322 from MEDIAN.MESHLAYER ml, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
323 MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
324 MEDIAN.MESH m, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
325 MEDIAN.MESHSCALARVALUE msv \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
326 where msv.FEATUREID = mp. FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
327 ml.KPOSITION = mp.KPOSITION and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
328 ml.MESHID = mp.MESHID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
329 m.MESHID = mp.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
330 m.PARTIDMIN <= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
331 m.PARTIDMAX >= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
332 msv.PARAMETERID in (?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
333 msv.TIMEVALUE in (?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
334 m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
335 mp.FEATUREID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
336 ( select FEATUREID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
337 from MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
338 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
339 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
340 mp.MESHID = m.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
341 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
342 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
343 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
344 mp.KPOSITION >= ? \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
345 order by msv.PARAMETERID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
346 msv.TIMEVALUE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
347 ml.UPPERZLOCATION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
348
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
349 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
350 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
351 ##### Vertikalprofil InstantaneousPoint #####
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
352 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
353 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
354
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
355 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
356 S.SERIESID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
357 S.DESCRIPTION VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
358 FROM MEDIAN.SERIES S, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
359 MEDIAN.INSTANTANEOUSPOINT I, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
360 MEDIAN.MEASUREMENT M \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
361 WHERE S.SERIESID = I.SERIESID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
362 I.POINTSPEC = 4 AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
363 I.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
364 M.SOURCEID= ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
365 ORDER BY S.DESCRIPTION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
366
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
367 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
368 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
369 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
370 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
371 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
372 FROM MEDIAN.INSTANTANEOUSPOINT, \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
373 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
374 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
375 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
376 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
377 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
378 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
379 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
380
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
381 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
382 P.PARAMETERID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
383 P.GERMANNAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
384 FROM MEDIAN.PARAMETER P, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
385 MEDIAN.INSTANTANEOUSPOINT IP, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
386 MEDIAN.MEASUREMENT M, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
387 MEDIAN.MEASUREDSCALARVALUE MSV \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
388 WHERE IP.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
389 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
390 MSV.PARAMETERID = P.PARAMETERID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
391 IP.FEATUREID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
392 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
393
310874d3573f Minimum and Maximum Depth should be entered by the User issue31
Tim Englich <tim.englich@intevation.de>
parents: 209
diff changeset
394 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
395 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
396 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
397 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
398 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
399 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
400 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
401 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
402 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
403
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
404 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
405 MSV.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
406 MSV.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
407 IP.TIMEVALUE GROUP2, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
408 1 GROUP3 \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
409 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
410 MEDIAN.MEASUREMENT M, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
411 MEDIAN.MEASUREDSCALARVALUE MSV \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
412 WHERE IP.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
413 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
414 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
415 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
416 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
417 M.ZLOCATION <= ? \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
418 ORDER BY IP.TIMEVALUE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
419 MSV.PARAMETERID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
420 M.ZLOCATION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
421
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
422 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
423 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
424 #### Horizontalprofil InstantaneousPoint ####
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
425 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
426 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
427 horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
428 V.VEHICLEID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
429 V.NAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
430 FROM MEDIAN.VEHICLE V, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
431 MEDIAN.CRUISE C, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
432 MEDIAN.TRACK T, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
433 MEDIAN.SURVEYINFO S, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
434 MEDIAN.INSTANTANEOUSPOINT I, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
435 MEDIAN.MEASUREMENT M \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
436 WHERE V.VEHICLEID = C.VEHICLEID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
437 C.CRUISEID = T.CRUISEID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
438 T.TRACKID = S.TRACKID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
439 S.SURVEYID = I.SURVEYID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
440 I.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
441 M.SOURCEID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
442 ORDER BY V.NAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
443 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
444 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
445 V.NAME || ' ' || \
01ac348ac4a4 Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents: 205
diff changeset
446 C.NAME || ' ' || \
01ac348ac4a4 Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents: 205
diff changeset
447 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \
01ac348ac4a4 Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents: 205
diff changeset
448 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE , \
01ac348ac4a4 Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents: 205
diff changeset
449 V.NAME , \
01ac348ac4a4 Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents: 205
diff changeset
450 C.NAME \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
451 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
452 MEDIAN.VEHICLE V, \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
453 MEDIAN.TRACK T, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
454 MEDIAN.SURVEYINFO S, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
455 MEDIAN.INSTANTANEOUSPOINT I, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
456 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
457 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
458 C.CRUISEID = T.CRUISEID AND \
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
459 T.TRACKID = S.TRACKID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
460 S.SURVEYID = I.SURVEYID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
461 I.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
462 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
463 M.SOURCEID = ? \
206
01ac348ac4a4 Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
Tim Englich <tim.englich@intevation.de>
parents: 205
diff changeset
464 ORDER BY V.NAME, C.NAME
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
465 horizontalprofile_instantaneouspoint_track= SELECT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
466 T.TRACKID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
467 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
468 FROM MEDIAN.TRACK T \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
469 WHERE T.CRUISEID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
470 ORDER BY T.STARTDATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
471 T.ENDDATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
472 T.NAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
473 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
474 SURVEYID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
475 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
476 FROM MEDIAN.SURVEYINFO \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
477 WHERE TRACKID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
478 ORDER BY STARTDATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
479 ENDDATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
480 DESCRIPTION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
481 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
482 P.PARAMETERID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
483 P.GERMANNAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
484 FROM MEDIAN.PARAMETER P , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
485 MEDIAN.MEASUREMENT M , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
486 MEDIAN.INSTANTANEOUSPOINT IP , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
487 MEDIAN.MEASUREDSCALARVALUE MSV \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
488 WHERE P.PARAMETERID = MSV.PARAMETERID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
489 MSV.MEASUREMENTID = M.MEASUREMENTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
490 M.FEATUREID = IP.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
491 IP.SURVEYID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
492 ORDER BY P.GERMANNAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
493 horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
494 M.ZLOCATION KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
495 M.ZLOCATION VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
496 FROM MEDIAN.MEASUREMENT M , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
497 MEDIAN.INSTANTANEOUSPOINT IP \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
498 WHERE M.FEATUREID = IP.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
499 IP.SURVEYID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
500 ORDER BY M.ZLOCATION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
501 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE) , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
502 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
503 MSV.DATAVALUE YORDINATE , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
504 MSV.PARAMETERID GROUP1 , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
505 ZLOCATION GROUP2 , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
506 1 GROUP3 \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
507 FROM MEDIAN.INSTANTANEOUSPOINT, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
508 MEDIAN.MEASUREMENT M, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
509 MEDIAN.MEASUREDSCALARVALUE MSV \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
510 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
511 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
512 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
513 M.ZLOCATION IN (?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
514 MSV.PARAMETERID in (?) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
515 ORDER BY MSV.PARAMETERID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
516 M.ZLOCATION, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
517 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
518
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
519 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
520 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
521 ########### Horizontalprofil MESH ###########
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
522 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
523 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
524 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
525 mp.KPOSITION KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
526 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
527 from MEDIAN.MESHLAYER ml, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
528 MEDIAN.MESHPOINT mp \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
529 where ml.KPOSITION = mp.KPOSITION and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
530 ml.MESHID = mp.MESHID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
531 mp.FEATUREID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
532 ( select FEATUREID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
533 from MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
534 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
535 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
536 mp.MESHID = m.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
537 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
538 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
539 order by mp.KPOSITION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
540
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
541 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
542 msv.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
543 msv.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
544 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
545 msv.TIMEVALUE GROUP3, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
546 MEDIAN.MESHPOINT.JPOSITION , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
547 MEDIAN.MESHPOINT.IPOSITION \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
548 from MEDIAN.MESHLAYER ml, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
549 MEDIAN.MESHPOINT , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
550 MEDIAN.MESH m, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
551 MEDIAN.MESHSCALARVALUE msv \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
552 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
553 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
554 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
555 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
556 m.PARTIDMIN <= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
557 m.PARTIDMAX >= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
558 msv.PARAMETERID in (?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
559 msv.TIMEVALUE in (?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
560 m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
561 MEDIAN.MESHPOINT.FEATUREID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
562 ( select FEATUREID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
563 from MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
564 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
565 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
566 mp.MESHID = m.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
567 KPOSITION in ( ? ) and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
568 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
569 order by msv.TIMEVALUE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
570 MEDIAN.MESHPOINT.KPOSITION, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
571 msv.PARAMETERID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
572 MEDIAN.MESHPOINT.JPOSITION , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
573 MEDIAN.MESHPOINT.IPOSITION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
574
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
575
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
576 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
577 #############################################
216
9db263ee2678 Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents: 213
diff changeset
578 ############# Profilschnitt MESH ############
199
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
579 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
580 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
581 verticalcrosssection_mesh_date = select distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
582 msv.TIMEVALUE KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
583 msv.TIMEVALUE VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
584 from MEDIAN.MESHSCALARVALUE msv , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
585 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
586 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
587 msv.PARTID >= m.PARTIDMIN AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
588 msv.PARTID <= m.PARTIDMAX AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
589 msv.PARAMETERID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
590 order by msv.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
591 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
592 msv.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
593 msv.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
594 msv.TIMEVALUE GROUP2, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
595 MEDIAN.MESHPOINT.JPOSITION, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
596 MEDIAN.MESHPOINT.IPOSITION, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
597 MEDIAN.MESHPOINT.KPOSITION \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
598 from MEDIAN.MESHLAYER ml, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
599 MEDIAN.MESHPOINT , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
600 MEDIAN.MESH m, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
601 MEDIAN.MESHSCALARVALUE msv \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
602 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
603 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
604 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
605 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
606 m.PARTIDMIN <= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
607 m.PARTIDMAX >= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
608 msv.PARAMETERID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
609 msv.TIMEVALUE = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
610 m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
611 MEDIAN.MESHPOINT.FEATUREID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
612 ( select FEATUREID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
613 from MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
614 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
615 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
616 mp.MESHID = m.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
617 ? = (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
618 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
619 msv.PARAMETERID, \
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
620 MEDIAN.MESHPOINT.JPOSITION , \
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
621 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
622 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
623
9db263ee2678 Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents: 213
diff changeset
624 #############################################
9db263ee2678 Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents: 213
diff changeset
625 #############################################
9db263ee2678 Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents: 213
diff changeset
626 ########## Horizontalschnitt MESH ###########
9db263ee2678 Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents: 213
diff changeset
627 #############################################
9db263ee2678 Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents: 213
diff changeset
628 #############################################
9db263ee2678 Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents: 213
diff changeset
629 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
630 '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
631 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
632 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
633 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
634 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
635 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
636 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
637 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
638 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
639
9db263ee2678 Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents: 213
diff changeset
640 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
641 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
642 msv.TIMEVALUE VALUE \
9db263ee2678 Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents: 213
diff changeset
643 from MEDIAN.MESHSCALARVALUE msv , \
9db263ee2678 Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents: 213
diff changeset
644 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
645 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
646 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
647 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
648 msv.PARAMETERID = ? \
9db263ee2678 Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
Tim Englich <tim.englich@intevation.de>
parents: 213
diff changeset
649 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
650
218
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
651 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
652 MSV.DATAVALUE YORDINATE, \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
653 MEDIAN.MESHFACE.JPOSITION, \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
654 MEDIAN.MESHFACE.IPOSITION, \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
655 MEDIAN.MESHFACE.KPOSITION \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
656 from MEDIAN.MESHLAYER ML, \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
657 MEDIAN.MESHFACE, \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
658 MEDIAN.MESH M, \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
659 MEDIAN.MESHSCALARVALUE MSV \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
660 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
661 ML.KPOSITION = MEDIAN.MESHFACE.KPOSITION and \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
662 ML.MESHID = MEDIAN.MESHFACE.MESHID and \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
663 M.MESHID = MEDIAN.MESHFACE.MESHID AND \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
664 M.PARTIDMIN <= MSV.PARTID AND \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
665 M.PARTIDMAX >= MSV.PARTID AND \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
666 MSV.PARAMETERID = ? AND \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
667 MSV.TIMEVALUE = ? AND \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
668 M.OBJECTID = ? AND \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
669 MEDIAN.MESHFACE.KPOSITION = ? \
926530bda1a7 Integrated the OutputTransition for Horizontal Cross-Sections
Tim Englich <tim.englich@intevation.de>
parents: 217
diff changeset
670 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
671 MEDIAN.MESHFACE.IPOSITION
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
672
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
673
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
674 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
675 FEATUREID KEY ,\
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
676 DESCRIPTION VALUE \
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
677 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
678 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
679 FEATUREID > 0 \
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
680 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
681
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
682 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
683 FEATURECODE KEY, \
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
684 NAME VALUE \
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
685 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
686 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
687 FEATUREID = ? \
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
688 ORDER BY NAME
05663e307495 Added the RegionFilters into the configuration of the Products for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 218
diff changeset
689
http://dive4elements.wald.intevation.org