Mercurial > dive4elements > gnv-client
annotate gnv-artifacts/doc/conf/queries.properties @ 202:d0bad2d374fd
Added separat ConnectionPoolPrperties to this Project.
Moved ConfigurationFiles from /src/test/ressources to doc/conf
gnv-artifacts/trunk@256 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Tim Englich <tim.englich@intevation.de> |
---|---|
date | Wed, 21 Oct 2009 10:36:38 +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 |