Mercurial > dive4elements > gnv-client

annotate gnv-artifacts/doc/conf/queries.properties @ 200:2f6a96610cb9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Changed Configuration Folder to doc/conf gnv-artifacts/trunk@254 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Wed, 21 Oct 2009 10:27:16 +0000
parents b66e8a6f3907
children 6e7952fd1744
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
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
16 timeseries_parameter=SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
17 p.PARAMETERID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
18 p.GERMANNAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
19 from MEDIAN.PARAMETER p \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
20 where p.PARAMETERID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
21 (select distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
22 ts.PARAMETERID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
23 from MEDIAN.TIMESERIES ts \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
24 where ts.TIMESERIESID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
25 (select distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
26 tsv.TIMESERIESID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
27 from MEDIAN.TIMESERIESVALUE tsv \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
28 where tsv.MEASUREMENTID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
29 (select m.MEASUREMENTID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
30 from MEDIAN.MEASUREMENT m, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
31 MEDIAN.TIMESERIESPOINT tsp \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
32 where m.FEATUREID = tsp.FEATUREID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
33 tsp.FEATUREID IN ( ? )\
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
34 )\
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
35 )\
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
36 ) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
37 ORDER BY p.GERMANNAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
38
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
39 timeseries_depth_height=SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
40 m.MEASUREMENTID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
41 m.ZLOCATION VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
42 from MEDIAN.MEASUREMENT m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
43 where m.MEASUREMENTID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
44 (SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
45 t_v.MEASUREMENTID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
46 from MEDIAN.TIMESERIESVALUE t_v \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
47 where t_v.TIMESERIESID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
48 (SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
49 t.TIMESERIESID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
50 from MEDIAN.TIMESERIES t \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
51 where t.PARAMETERID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
52 (SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
53 p.PARAMETERID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
54 from MEDIAN.PARAMETER p \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
55 where m.FEATUREID IN ( ? ) and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
56 p.PARAMETERID IN (?)\
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
57 )\
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
58 )\
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 ORDER BY m.ZLOCATION DESC
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
61
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
62 timeseries_interval=select min(tv.TIMEVALUE) MIN, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
63 max(tv.TIMEVALUE) MAX \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
64 from MEDIAN.TIMESERIES t , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
65 MEDIAN.TIMESERIESVALUE tv \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
66 where tv.TIMESERIESID = t.TIMESERIESID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
67 t.PARAMETERID IN ( ? ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
68 tv.MEASUREMENTID IN ( ? )
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
69
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
70 timeseries_chart_data=SELECT tv.TIMEVALUE XORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
71 tv.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
72 t.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
73 tv.MEASUREMENTID GROUP2, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
74 tv.TIMESERIESID GROUP3 \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
75 FROM MEDIAN.TIMESERIESVALUE tv, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
76 MEDIAN.TIMESERIES t \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
77 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
78 t.PARAMETERID IN ( ? ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
79 tv.MEASUREMENTID IN ( ? ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
80 tv.TIMEVALUE >= ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
81 tv.TIMEVALUE <= ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
82 ORDER BY tv.MEASUREMENTID , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
83 tv.TIMESERIESID , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
84 t.PARAMETERID , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
85 tv.TIMEVALUE
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 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
89 ########## Zeitserie Mesh ##############
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
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
93 timeseries_mesh = SELECT OBJECTID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
94 m.NAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
95 FROM MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
96 WHERE SOURCEID IN (?) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
97 ORDER BY m.NAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
98 timeseries_meshpoint = SELECT FEATUREID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
99 ST_ASTEXT(SHAPE) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
100 FROM MEDIAN.MESHPOINT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
101 WHERE MESHID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
102 (SELECT DISTINCT MESHID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
103 FROM MEDIAN.MESH \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
104 WHERE OBJECTID = ?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
105 KPOSITION = 1 AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
106 INTERSECTS(SHAPE,"?")
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
107
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
108 timeseries_meshpoint_depth = select mp.FEATUREID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
109 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
110 from MEDIAN.MESHLAYER ml, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
111 MEDIAN.MESHPOINT mp \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
112 where ml.KPOSITION = mp.KPOSITION and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
113 ml.MESHID = mp.MESHID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
114 mp.FEATUREID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
115 ( select FEATUREID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
116 from MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
117 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
118 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
119 mp.MESHID = m.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
120 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
121 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
122 order by ml.UPPERZLOCATION desc
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
123
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
124 timeseries_mesh_parameter=SELECT distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
125 p.PARAMETERID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
126 p.GERMANNAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
127 from MEDIAN.PARAMETER p, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
128 MEDIAN.MESHSCALARVALUE msc, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
129 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
130 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
131 msc.PARTID = m.PARTIDMIN AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
132 msc.PARAMETERID = p.PARAMETERID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
133 order by p.GERMANNAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
134 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
135 min(TIMEVALUE) MIN, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
136 max(TIMEVALUE) MAX \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
137 from MEDIAN.MESHSCALARVALUE msc , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
138 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
139 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
140 msc.PARTID >= m.PARTIDMIN AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
141 msc.PARTID <= m.PARTIDMAX AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
142 msc.PARAMETERID IN (?)
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
143
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
144 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
145 msv.TIMEVALUE XORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
146 msv.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
147 msv.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
148 msv.FEATUREID GROUP2, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
149 mp.FEATUREID GROUP3 \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
150 from MEDIAN.MESHSCALARVALUE msv , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
151 MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
152 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
153 where (m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
154 msv.PARTID >= m.PARTIDMIN AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
155 msv.PARTID <= m.PARTIDMAX ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
156 msv.FEATUREID in ( ? ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
157 msv.PARAMETERID in ( ? ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
158 mp.FEATUREID in ( ? ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
159 msv.TIMEVALUE >= ? AND \
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 order by mp.FEATUREID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
162 msv.FEATUREID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
163 msv.PARAMETERID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
164 msv.TIMEVALUE
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 ########## Vertikalprofil ##############
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
169 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
170 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
171
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
172 verticalprofile_point=SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
173 tsp.FEATUREID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
174 tsp.NAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
175 FROM MEDIAN.TIMESERIESPOINT tsp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
176 MEDIAN.MEASUREMENT mmt \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
177 WHERE tsp.FEATUREID = mmt.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
178 mmt.SOURCEID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
179 order by tsp.name
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
180
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
181 verticalprofile_parameter=SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
182 p.PARAMETERID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
183 p.GERMANNAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
184 from MEDIAN.PARAMETER p, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
185 MEDIAN.TIMESERIES ts, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
186 MEDIAN.TIMESERIESVALUE tsv, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
187 MEDIAN.MEASUREMENT m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
188 where ts.PARAMETERID = p.PARAMETERID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
189 ts.TIMESERIESID = tsv.TIMESERIESID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
190 m.MEASUREMENTID = tsv.MEASUREMENTID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
191 m.FEATUREID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
192 ORDER BY p.GERMANNAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
193
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
194 verticalprofile_date=select distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
195 tsv.TIMEVALUE KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
196 tsv.TIMEVALUE VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
197 from MEDIAN.TIMESERIES ts , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
198 MEDIAN.TIMESERIESVALUE tsv, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
199 MEDIAN.MEASUREMENT m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
200 where ts.TIMESERIESID = tsv.TIMESERIESID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
201 m.MEASUREMENTID = tsv.MEASUREMENTID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
202 m.FEATUREID = ? and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
203 ts.PARAMETERID IN ( ? ) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
204 order by tsv.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
205
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
206 verticalprofile_chart_data= SELECT m.ZLOCATION XORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
207 tsv.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
208 ts.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
209 tsv.TIMEVALUE GROUP2, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
210 1 GROUP3 \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
211 from MEDIAN.TIMESERIES ts, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
212 MEDIAN.TIMESERIESVALUE tsv, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
213 MEDIAN.MEASUREMENT m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
214 where ts.TIMESERIESID = tsv.TIMESERIESID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
215 m.MEASUREMENTID = tsv.MEASUREMENTID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
216 m.FEATUREID = ? and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
217 ts.PARAMETERID IN ( ? ) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
218 tsv.TIMEVALUE IN (?) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
219 ORDER BY tsv.TIMEVALUE , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
220 tsv.TIMESERIESID , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
221 ts.PARAMETERID , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
222 tsv.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
223
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
224 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
225 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
226 ########## Vertikalprofil Mesh ##############
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
227 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
228 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
229
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
230 verticalprofile_mesh = SELECT OBJECTID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
231 m.NAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
232 FROM MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
233 WHERE SOURCEID IN (?) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
234 order by m.NAME
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 verticalprofile_mesh_point = SELECT FEATUREID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
237 ST_ASTEXT(SHAPE) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
238 FROM MEDIAN.MESHPOINT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
239 WHERE MESHID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
240 (SELECT DISTINCT MESHID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
241 FROM MEDIAN.MESH \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
242 WHERE OBJECTID = ?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
243 KPOSITION = 1 AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
244 INTERSECTS(SHAPE,"?")
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
245
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
246 verticalprofile_mesh_parameter=SELECT distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
247 p.PARAMETERID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
248 p.GERMANNAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
249 from MEDIAN.PARAMETER p, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
250 MEDIAN.MESHSCALARVALUE msc, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
251 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
252 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
253 m.PARTIDMIN = msc.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
254 msc.PARAMETERID = p.PARAMETERID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
255 order by p.GERMANNAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
256
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
257 verticalprofile_mesh_date= select distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
258 msv.TIMEVALUE KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
259 msv.TIMEVALUE VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
260 from MEDIAN.MESHSCALARVALUE msv , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
261 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
262 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
263 msv.PARTID >= m.PARTIDMIN AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
264 msv.PARTID <= m.PARTIDMAX AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
265 msv.PARAMETERID in (?) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
266 order by msv.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
267
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
268 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
269 msv.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
270 msv.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
271 msv.TIMEVALUE GROUP2, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
272 1 GROUP3 \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
273 from MEDIAN.MESHLAYER ml, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
274 MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
275 MEDIAN.MESH m, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
276 MEDIAN.MESHSCALARVALUE msv \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
277 where msv.FEATUREID = mp. FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
278 ml.KPOSITION = mp.KPOSITION and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
279 ml.MESHID = mp.MESHID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
280 m.MESHID = mp.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
281 m.PARTIDMIN <= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
282 m.PARTIDMAX >= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
283 msv.PARAMETERID in (?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
284 msv.TIMEVALUE in (?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
285 m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
286 mp.FEATUREID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
287 ( select FEATUREID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
288 from MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
289 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
290 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
291 mp.MESHID = m.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
292 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
293 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
294 order by msv.PARAMETERID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
295 msv.TIMEVALUE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
296 ml.UPPERZLOCATION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
297
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
298 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
299 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
300 ##### Vertikalprofil InstantaneousPoint #####
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
301 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
302 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
303
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
304 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
305 S.SERIESID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
306 S.DESCRIPTION VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
307 FROM MEDIAN.SERIES S, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
308 MEDIAN.INSTANTANEOUSPOINT I, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
309 MEDIAN.MEASUREMENT M \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
310 WHERE S.SERIESID = I.SERIESID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
311 I.POINTSPEC = 4 AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
312 I.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
313 M.SOURCEID= ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
314 ORDER BY S.DESCRIPTION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
315
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
316 verticalprofile_instantaneouspoint_point = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
317 I.FEATUREID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
318 to_char(I.TIMEVALUE,'DD.MM.YYYY HH24:MI') || ' - '|| I.SHAPE VALUE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
319 I.TIMEVALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
320 FROM MEDIAN.INSTANTANEOUSPOINT I, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
321 MEDIAN.MEASUREMENT M \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
322 WHERE I.SERIESID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
323 I.POINTSPEC = 4 AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
324 I.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
325 M.SOURCEID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
326 ORDER BY I.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
327
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
328 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
329 P.PARAMETERID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
330 P.GERMANNAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
331 FROM MEDIAN.PARAMETER P, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
332 MEDIAN.INSTANTANEOUSPOINT IP, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
333 MEDIAN.MEASUREMENT M, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
334 MEDIAN.MEASUREDSCALARVALUE MSV \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
335 WHERE IP.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
336 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
337 MSV.PARAMETERID = P.PARAMETERID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
338 IP.FEATUREID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
339 ORDER BY P.GERMANNAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
340
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
341 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
342 MSV.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
343 MSV.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
344 IP.TIMEVALUE GROUP2, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
345 1 GROUP3 \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
346 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
347 MEDIAN.MEASUREMENT M, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
348 MEDIAN.MEASUREDSCALARVALUE MSV \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
349 WHERE IP.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
350 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
351 IP.FEATUREID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
352 MSV.PARAMETERID in (?) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
353 ORDER BY IP.TIMEVALUE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
354 MSV.PARAMETERID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
355 M.ZLOCATION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
356
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
357 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
358 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
359 #### Horizontalprofil InstantaneousPoint ####
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
360 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
361 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
362 horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
363 V.VEHICLEID KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
364 V.NAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
365 FROM MEDIAN.VEHICLE V, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
366 MEDIAN.CRUISE C, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
367 MEDIAN.TRACK T, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
368 MEDIAN.SURVEYINFO S, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
369 MEDIAN.INSTANTANEOUSPOINT I, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
370 MEDIAN.MEASUREMENT M \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
371 WHERE V.VEHICLEID = C.VEHICLEID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
372 C.CRUISEID = T.CRUISEID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
373 T.TRACKID = S.TRACKID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
374 S.SURVEYID = I.SURVEYID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
375 I.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
376 M.SOURCEID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
377 ORDER BY V.NAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
378 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
379 C.CRUISEID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
380 C.NAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
381 FROM MEDIAN.CRUISE C, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
382 MEDIAN.TRACK T, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
383 MEDIAN.SURVEYINFO S, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
384 MEDIAN.INSTANTANEOUSPOINT I, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
385 MEDIAN.MEASUREMENT M \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
386 WHERE C.CRUISEID = T.CRUISEID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
387 T.TRACKID = S.TRACKID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
388 S.SURVEYID = I.SURVEYID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
389 I.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
390 C.VEHICLEID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
391 M.SOURCEID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
392 C.NAME IS NOT NULL \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
393 ORDER BY C.NAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
394 horizontalprofile_instantaneouspoint_track= SELECT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
395 T.TRACKID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
396 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
397 FROM MEDIAN.TRACK T \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
398 WHERE T.CRUISEID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
399 ORDER BY T.STARTDATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
400 T.ENDDATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
401 T.NAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
402 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
403 SURVEYID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
404 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
405 FROM MEDIAN.SURVEYINFO \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
406 WHERE TRACKID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
407 ORDER BY STARTDATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
408 ENDDATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
409 DESCRIPTION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
410 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
411 P.PARAMETERID KEY , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
412 P.GERMANNAME VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
413 FROM MEDIAN.PARAMETER P , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
414 MEDIAN.MEASUREMENT M , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
415 MEDIAN.INSTANTANEOUSPOINT IP , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
416 MEDIAN.MEASUREDSCALARVALUE MSV \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
417 WHERE P.PARAMETERID = MSV.PARAMETERID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
418 MSV.MEASUREMENTID = M.MEASUREMENTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
419 M.FEATUREID = IP.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
420 IP.SURVEYID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
421 ORDER BY P.GERMANNAME
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
422 horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
423 M.ZLOCATION KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
424 M.ZLOCATION VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
425 FROM MEDIAN.MEASUREMENT M , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
426 MEDIAN.INSTANTANEOUSPOINT IP \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
427 WHERE M.FEATUREID = IP.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
428 IP.SURVEYID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
429 ORDER BY M.ZLOCATION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
430 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE) , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
431 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
432 MSV.DATAVALUE YORDINATE , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
433 MSV.PARAMETERID GROUP1 , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
434 ZLOCATION GROUP2 , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
435 1 GROUP3 \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
436 FROM MEDIAN.INSTANTANEOUSPOINT, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
437 MEDIAN.MEASUREMENT M, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
438 MEDIAN.MEASUREDSCALARVALUE MSV \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
439 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
440 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
441 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
442 M.ZLOCATION IN (?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
443 MSV.PARAMETERID in (?) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
444 ORDER BY MSV.PARAMETERID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
445 M.ZLOCATION, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
446 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
447
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
448 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
449 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
450 ########### Horizontalprofil MESH ###########
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
451 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
452 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
453 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
454 mp.KPOSITION KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
455 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
456 from MEDIAN.MESHLAYER ml, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
457 MEDIAN.MESHPOINT mp \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
458 where ml.KPOSITION = mp.KPOSITION and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
459 ml.MESHID = mp.MESHID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
460 mp.FEATUREID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
461 ( select FEATUREID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
462 from MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
463 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
464 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
465 mp.MESHID = m.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
466 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
467 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
468 order by mp.KPOSITION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
469
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
470 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
471 msv.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
472 msv.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
473 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
474 msv.TIMEVALUE GROUP3, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
475 MEDIAN.MESHPOINT.JPOSITION , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
476 MEDIAN.MESHPOINT.IPOSITION \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
477 from MEDIAN.MESHLAYER ml, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
478 MEDIAN.MESHPOINT , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
479 MEDIAN.MESH m, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
480 MEDIAN.MESHSCALARVALUE msv \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
481 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
482 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
483 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
484 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
485 m.PARTIDMIN <= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
486 m.PARTIDMAX >= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
487 msv.PARAMETERID in (?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
488 msv.TIMEVALUE in (?) AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
489 m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
490 MEDIAN.MESHPOINT.FEATUREID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
491 ( select FEATUREID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
492 from MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
493 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
494 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
495 mp.MESHID = m.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
496 KPOSITION in ( ? ) and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
497 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
498 order by msv.TIMEVALUE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
499 MEDIAN.MESHPOINT.KPOSITION, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
500 msv.PARAMETERID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
501 MEDIAN.MESHPOINT.JPOSITION , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
502 MEDIAN.MESHPOINT.IPOSITION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
503
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
504
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
505 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
506 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
507 ########### Profilschnitt MESH ###########
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
508 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
509 #############################################
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
510 verticalcrosssection_mesh_date = select distinct \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
511 msv.TIMEVALUE KEY, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
512 msv.TIMEVALUE VALUE \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
513 from MEDIAN.MESHSCALARVALUE msv , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
514 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
515 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
516 msv.PARTID >= m.PARTIDMIN AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
517 msv.PARTID <= m.PARTIDMAX AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
518 msv.PARAMETERID = ? \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
519 order by msv.TIMEVALUE
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
520 verticalcrosssection_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
521 msv.DATAVALUE YORDINATE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
522 msv.PARAMETERID GROUP1, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
523 msv.TIMEVALUE GROUP2, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
524 MEDIAN.MESHPOINT.JPOSITION, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
525 MEDIAN.MESHPOINT.IPOSITION, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
526 MEDIAN.MESHPOINT.KPOSITION \
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 , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
529 MEDIAN.MESH m, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
530 MEDIAN.MESHSCALARVALUE msv \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
531 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
532 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
533 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
534 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
535 m.PARTIDMIN <= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
536 m.PARTIDMAX >= msv.PARTID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
537 msv.PARAMETERID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
538 msv.TIMEVALUE = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
539 m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
540 MEDIAN.MESHPOINT.FEATUREID in \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
541 ( select FEATUREID \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
542 from MEDIAN.MESHPOINT mp, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
543 MEDIAN.MESH m \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
544 where m.OBJECTID = ? AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
545 mp.MESHID = m.MESHID AND \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
546 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
547 order by msv.TIMEVALUE, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
548 msv.PARAMETERID, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
549 MEDIAN.MESHPOINT.JPOSITION , \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
550 MEDIAN.MESHPOINT.IPOSITION, \
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
551 MEDIAN.MESHPOINT.KPOSITION
b66e8a6f3907 Moved Configurationfiles
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
552
http://dive4elements.wald.intevation.org