Mercurial > dive4elements > gnv-client

annotate gnv-artifacts/src/test/ressources/queries.properties @ 173:1b2fc94766c9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added real Coordinate-Query to TimeSeries-Mesh gnv-artifacts/trunk@212 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 13 Oct 2009 09:11:23 +0000
parents 7be22e76c270
children dbf68950b4d9
rev   line source
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
1 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
2 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
3 ########## Zeitserie ##############
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
4 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
5 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
6
87
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
7 timeseries_timeseriespoint=SELECT DISTINCT \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
8 tsp.FEATUREID KEY, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
9 tsp.NAME VALUE \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
10 FROM MEDIAN.TIMESERIESPOINT tsp, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
11 MEDIAN.MEASUREMENT mmt \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
12 WHERE tsp.FEATUREID = mmt.FEATUREID AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
13 mmt.SOURCEID = ? \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
14 order by tsp.name
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
15
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
16 timeseries_parameter=SELECT DISTINCT \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
17 p.PARAMETERID KEY, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
18 p.GERMANNAME VALUE \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
19 from MEDIAN.PARAMETER p \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
20 where p.PARAMETERID in \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
21 (select distinct \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
22 ts.PARAMETERID \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
23 from MEDIAN.TIMESERIES ts \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
24 where ts.TIMESERIESID in \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
25 (select distinct \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
26 tsv.TIMESERIESID \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
27 from MEDIAN.TIMESERIESVALUE tsv \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
28 where tsv.MEASUREMENTID in \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
29 (select m.MEASUREMENTID \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
30 from MEDIAN.MEASUREMENT m, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
31 MEDIAN.TIMESERIESPOINT tsp \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
32 where m.FEATUREID = tsp.FEATUREID and \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
33 tsp.FEATUREID IN ( ? )\
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
34 )\
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
35 )\
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
36 ) \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
37 ORDER BY p.GERMANNAME
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
38
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
39 timeseries_depth_height=SELECT DISTINCT \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
40 m.MEASUREMENTID KEY, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
41 m.ZLOCATION VALUE \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
42 from MEDIAN.MEASUREMENT m \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
43 where m.MEASUREMENTID in \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
44 (SELECT DISTINCT \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
45 t_v.MEASUREMENTID \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
46 from MEDIAN.TIMESERIESVALUE t_v \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
47 where t_v.TIMESERIESID in \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
48 (SELECT DISTINCT \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
49 t.TIMESERIESID \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
50 from MEDIAN.TIMESERIES t \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
51 where t.PARAMETERID in \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
52 (SELECT DISTINCT \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
53 p.PARAMETERID \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
54 from MEDIAN.PARAMETER p \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
55 where m.FEATUREID IN ( ? ) and \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
56 p.PARAMETERID IN (?)\
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
57 )\
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
58 )\
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
59 )\
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
60 ORDER BY m.ZLOCATION DESC
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
61
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
62 timeseries_interval=select min(tv.TIMEVALUE) MIN, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
63 max(tv.TIMEVALUE) MAX \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
64 from MEDIAN.TIMESERIES t , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
65 MEDIAN.TIMESERIESVALUE tv \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
66 where tv.TIMESERIESID = t.TIMESERIESID AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
67 t.PARAMETERID IN ( ? ) AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
68 tv.MEASUREMENTID IN ( ? )
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
69
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
70 timeseries_chart_data=SELECT tv.TIMEVALUE XORDINATE, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
71 tv.DATAVALUE YORDINATE, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
72 t.PARAMETERID GROUP1, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
73 tv.MEASUREMENTID GROUP2, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
74 tv.TIMESERIESID GROUP3 \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
75 FROM MEDIAN.TIMESERIESVALUE tv, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
76 MEDIAN.TIMESERIES t \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
77 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
78 t.PARAMETERID IN ( ? ) AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
79 tv.MEASUREMENTID IN ( ? ) AND \
102
994a39b084d6 Imporved JUnitTest and Bugfixing as a Result of this Improvement.
Tim Englich <tim.englich@intevation.de>
parents: 87
diff changeset
80 tv.TIMEVALUE > ? AND \
994a39b084d6 Imporved JUnitTest and Bugfixing as a Result of this Improvement.
Tim Englich <tim.englich@intevation.de>
parents: 87
diff changeset
81 tv.TIMEVALUE < ? \
87
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
82 ORDER BY tv.MEASUREMENTID , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
83 tv.TIMESERIESID , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
84 t.PARAMETERID , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
85 tv.TIMEVALUE
81
9b41f3688610 Added Support for TimeSeriesMesh
Tim Englich <tim.englich@intevation.de>
parents: 69
diff changeset
86
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
87 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
88 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
89 ########## Zeitserie Mesh ##############
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
90 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
91 #############################################
81
9b41f3688610 Added Support for TimeSeriesMesh
Tim Englich <tim.englich@intevation.de>
parents: 69
diff changeset
92
87
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
93 timeseries_mesh = SELECT OBJECTID KEY, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
94 m.NAME VALUE \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
95 FROM MEDIAN.MESH m \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
96 order by m.NAME
173
1b2fc94766c9 Added real Coordinate-Query to TimeSeries-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 170
diff changeset
97 timeseries_meshpoint = SELECT FEATUREID, \
1b2fc94766c9 Added real Coordinate-Query to TimeSeries-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 170
diff changeset
98 ST_ASTEXT(SHAPE) \
1b2fc94766c9 Added real Coordinate-Query to TimeSeries-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 170
diff changeset
99 FROM MEDIAN.MESHPOINT \
1b2fc94766c9 Added real Coordinate-Query to TimeSeries-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 170
diff changeset
100 WHERE MESHID in \
1b2fc94766c9 Added real Coordinate-Query to TimeSeries-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 170
diff changeset
101 (SELECT DISTINCT MESHID \
1b2fc94766c9 Added real Coordinate-Query to TimeSeries-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 170
diff changeset
102 FROM MEDIAN.MESH \
1b2fc94766c9 Added real Coordinate-Query to TimeSeries-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 170
diff changeset
103 WHERE OBJECTID = ?) AND \
1b2fc94766c9 Added real Coordinate-Query to TimeSeries-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 170
diff changeset
104 KPOSITION = 1 AND \
1b2fc94766c9 Added real Coordinate-Query to TimeSeries-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 170
diff changeset
105 INTERSECTS(SHAPE,"?")
87
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
106
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
107 timeseries_meshpoint_depth = select mp.FEATUREID KEY, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
108 -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
109 from MEDIAN.MESHLAYER ml, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
110 MEDIAN.MESHPOINT mp \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
111 where ml.KPOSITION = mp.KPOSITION and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
112 ml.MESHID = mp.MESHID and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
113 mp.FEATUREID in \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
114 ( select FEATUREID \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
115 from MEDIAN.MESHPOINT mp, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
116 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
117 where m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
118 mp.MESHID = m.MESHID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
119 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
120 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
121 order by ml.UPPERZLOCATION desc
87
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
122
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
123 timeseries_mesh_parameter=SELECT distinct \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
124 p.PARAMETERID KEY , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
125 p.GERMANNAME VALUE \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
126 from MEDIAN.PARAMETER p, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
127 MEDIAN.MESHSCALARVALUE msc, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
128 MEDIAN.MESH m \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
129 where m.OBJECTID = ? AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
130 msc.PARTID = m.PARTIDMIN AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
131 msc.PARAMETERID = p.PARAMETERID \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
132 order by p.GERMANNAME
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
133 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
134 min(TIMEVALUE) MIN, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
135 max(TIMEVALUE) MAX \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
136 from MEDIAN.MESHSCALARVALUE msc , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
137 MEDIAN.MESH m \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
138 where m.OBJECTID = ? AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
139 msc.PARTID >= m.PARTIDMIN AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
140 msc.PARTID <= m.PARTIDMAX
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
141
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
142 timeseries_mesh_chart_data=select /*+ parallel(timevalue,10) */ \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
143 msv.TIMEVALUE XORDINATE, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
144 msv.DATAVALUE YORDINATE, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
145 msv.PARAMETERID GROUP1, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
146 msv.FEATUREID GROUP2, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
147 mp.FEATUREID GROUP3 \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
148 from MEDIAN.MESHSCALARVALUE msv , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
149 MEDIAN.MESHPOINT mp, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
150 MEDIAN.MESH m \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
151 where (m.OBJECTID = ? AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
152 msv.PARTID >= m.PARTIDMIN AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
153 msv.PARTID <= m.PARTIDMAX ) AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
154 msv.FEATUREID in ( ? ) AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
155 msv.PARAMETERID in ( ? ) AND \
108
2aae4a78e555 Bug fixed: Mesh TimeSeries will now Handle Charts with multiple Depth-Values properly.
Tim Englich <tim.englich@intevation.de>
parents: 102
diff changeset
156 mp.FEATUREID in ( ? ) AND \
102
994a39b084d6 Imporved JUnitTest and Bugfixing as a Result of this Improvement.
Tim Englich <tim.englich@intevation.de>
parents: 87
diff changeset
157 msv.TIMEVALUE >= ? AND \
994a39b084d6 Imporved JUnitTest and Bugfixing as a Result of this Improvement.
Tim Englich <tim.englich@intevation.de>
parents: 87
diff changeset
158 msv.TIMEVALUE <= ? \
108
2aae4a78e555 Bug fixed: Mesh TimeSeries will now Handle Charts with multiple Depth-Values properly.
Tim Englich <tim.englich@intevation.de>
parents: 102
diff changeset
159 order by mp.FEATUREID, \
2aae4a78e555 Bug fixed: Mesh TimeSeries will now Handle Charts with multiple Depth-Values properly.
Tim Englich <tim.englich@intevation.de>
parents: 102
diff changeset
160 msv.FEATUREID, \
87
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
161 msv.PARAMETERID, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
162 msv.TIMEVALUE
81
9b41f3688610 Added Support for TimeSeriesMesh
Tim Englich <tim.englich@intevation.de>
parents: 69
diff changeset
163
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
164 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
165 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
166 ########## Vertikalprofil ##############
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
167 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
168 #############################################
82
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
169
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
170 verticalprofile_point=SELECT DISTINCT \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
171 tsp.FEATUREID KEY, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
172 tsp.NAME VALUE \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
173 FROM MEDIAN.TIMESERIESPOINT tsp, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
174 MEDIAN.MEASUREMENT mmt \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
175 WHERE tsp.FEATUREID = mmt.FEATUREID AND \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
176 mmt.SOURCEID = ? \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
177 order by tsp.name
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
178
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
179 verticalprofile_parameter=SELECT DISTINCT \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
180 p.PARAMETERID KEY, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
181 p.GERMANNAME VALUE \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
182 from MEDIAN.PARAMETER p, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
183 MEDIAN.TIMESERIES ts, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
184 MEDIAN.TIMESERIESVALUE tsv, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
185 MEDIAN.MEASUREMENT m \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
186 where ts.PARAMETERID = p.PARAMETERID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
187 ts.TIMESERIESID = tsv.TIMESERIESID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
188 m.MEASUREMENTID = tsv.MEASUREMENTID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
189 m.FEATUREID = ? \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
190 ORDER BY p.GERMANNAME
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
191
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
192 verticalprofile_date=select distinct \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
193 tsv.TIMEVALUE KEY, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
194 tsv.TIMEVALUE VALUE \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
195 from MEDIAN.TIMESERIES ts , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
196 MEDIAN.TIMESERIESVALUE tsv, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
197 MEDIAN.MEASUREMENT m \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
198 where ts.TIMESERIESID = tsv.TIMESERIESID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
199 m.MEASUREMENTID = tsv.MEASUREMENTID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
200 m.FEATUREID = ? and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
201 ts.PARAMETERID IN ( ? ) \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
202 order by tsv.TIMEVALUE
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
203
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
204 verticalprofile_chart_data= SELECT m.ZLOCATION XORDINATE, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
205 tsv.DATAVALUE YORDINATE, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
206 ts.PARAMETERID GROUP1, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
207 tsv.TIMEVALUE GROUP2, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
208 1 GROUP3 \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
209 from MEDIAN.TIMESERIES ts, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
210 MEDIAN.TIMESERIESVALUE tsv, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
211 MEDIAN.MEASUREMENT m \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
212 where ts.TIMESERIESID = tsv.TIMESERIESID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
213 m.MEASUREMENTID = tsv.MEASUREMENTID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
214 m.FEATUREID = ? and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
215 ts.PARAMETERID IN ( ? ) AND \
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
216 tsv.TIMEVALUE IN (?) \
82
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
217 ORDER BY tsv.TIMEVALUE , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
218 tsv.TIMESERIESID , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
219 ts.PARAMETERID , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
220 tsv.TIMEVALUE
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
221
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
222 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
223 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
224 ########## Vertikalprofil Mesh ##############
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
225 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
226 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
227
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
228 verticalprofile_mesh = SELECT OBJECTID KEY, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
229 m.NAME VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
230 FROM MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
231 order by m.NAME
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
232
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
233 verticalprofile_mesh_point = SELECT FEATUREID KEY, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
234 SHAPE VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
235 FROM MEDIAN.MESHPOINT mp , \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
236 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
237 WHERE m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
238 m.MESHID = mp.MESHID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
239 mp.KPOSITION = 1 AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
240 rownum < 10
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
241
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
242 verticalprofile_mesh_parameter=SELECT distinct \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
243 p.PARAMETERID KEY , \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
244 p.GERMANNAME VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
245 from MEDIAN.PARAMETER p, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
246 MEDIAN.MESHSCALARVALUE msc, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
247 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
248 where m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
249 m.PARTIDMIN = msc.PARTID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
250 msc.PARAMETERID = p.PARAMETERID \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
251 order by p.GERMANNAME
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
252
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
253 verticalprofile_mesh_date= select distinct \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
254 msv.TIMEVALUE KEY, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
255 msv.TIMEVALUE VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
256 from MEDIAN.MESHSCALARVALUE msv , \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
257 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
258 where m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
259 msv.PARTID >= m.PARTIDMIN AND \
170
7be22e76c270 Added parameter to the DateQueroes of Meshes
Tim Englich <tim.englich@intevation.de>
parents: 120
diff changeset
260 msv.PARTID <= m.PARTIDMAX AND \
7be22e76c270 Added parameter to the DateQueroes of Meshes
Tim Englich <tim.englich@intevation.de>
parents: 120
diff changeset
261 msv.PARAMETERID in (?) \
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
262 order by msv.TIMEVALUE
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
263
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
264 verticalprofile_mesh_chart_data=select ml.UPPERZLOCATION XORDINATE, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
265 msv.DATAVALUE YORDINATE, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
266 msv.PARAMETERID GROUP1, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
267 msv.TIMEVALUE GROUP2, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
268 1 GROUP3 \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
269 from MEDIAN.MESHLAYER ml, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
270 MEDIAN.MESHPOINT mp, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
271 MEDIAN.MESH m, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
272 MEDIAN.MESHSCALARVALUE msv \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
273 where msv.FEATUREID = mp. FEATUREID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
274 ml.KPOSITION = mp.KPOSITION and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
275 ml.MESHID = mp.MESHID and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
276 m.MESHID = mp.MESHID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
277 m.PARTIDMIN <= msv.PARTID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
278 m.PARTIDMAX >= msv.PARTID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
279 msv.PARAMETERID in (?) AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
280 msv.TIMEVALUE in (?) AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
281 m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
282 mp.FEATUREID in \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
283 ( select FEATUREID \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
284 from MEDIAN.MESHPOINT mp, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
285 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
286 where m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
287 mp.MESHID = m.MESHID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
288 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
289 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
290 order by msv.PARAMETERID, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
291 msv.TIMEVALUE, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
292 ml.UPPERZLOCATION
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
293
85
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
294 #############################################
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
295 #############################################
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
296 ##### Vertikalprofil InstantaneousPoint #####
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
297 #############################################
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
298 #############################################
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
299
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
300 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
301 S.SERIESID KEY , \
85
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
302 S.DESCRIPTION VALUE \
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
303 FROM MEDIAN.SERIES S, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
304 MEDIAN.INSTANTANEOUSPOINT I, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
305 MEDIAN.MEASUREMENT M \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
306 WHERE S.SERIESID = I.SERIESID AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
307 I.POINTSPEC = 4 AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
308 I.FEATUREID = M.FEATUREID AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
309 M.SOURCEID= ? \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
310 ORDER BY S.DESCRIPTION
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
311
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
312 verticalprofile_instantaneouspoint_point = SELECT DISTINCT \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
313 I.FEATUREID KEY, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
314 to_char(I.TIMEVALUE,'DD.MM.YYYY HH24:MI') || ' - '|| I.SHAPE VALUE, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
315 I.TIMEVALUE \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
316 FROM MEDIAN.INSTANTANEOUSPOINT I, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
317 MEDIAN.MEASUREMENT M \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
318 WHERE I.SERIESID = ? AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
319 I.POINTSPEC = 4 AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
320 I.FEATUREID = M.FEATUREID AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
321 M.SOURCEID = ? \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
322 ORDER BY I.TIMEVALUE
85
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
323
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
324 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
325 P.PARAMETERID KEY , \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
326 P.GERMANNAME VALUE \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
327 FROM MEDIAN.PARAMETER P, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
328 MEDIAN.INSTANTANEOUSPOINT IP, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
329 MEDIAN.MEASUREMENT M, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
330 MEDIAN.MEASUREDSCALARVALUE MSV \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
331 WHERE IP.FEATUREID = M.FEATUREID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
332 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
333 MSV.PARAMETERID = P.PARAMETERID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
334 IP.FEATUREID = ? \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
335 ORDER BY P.GERMANNAME
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
336
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
337 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
338 MSV.DATAVALUE YORDINATE, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
339 MSV.PARAMETERID GROUP1, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
340 IP.TIMEVALUE GROUP2, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
341 1 GROUP3 \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
342 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
343 MEDIAN.MEASUREMENT M, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
344 MEDIAN.MEASUREDSCALARVALUE MSV \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
345 WHERE IP.FEATUREID = M.FEATUREID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
346 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
347 IP.FEATUREID = ? AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
348 MSV.PARAMETERID in (?) \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
349 ORDER BY IP.TIMEVALUE, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
350 MSV.PARAMETERID, \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
351 M.ZLOCATION
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
352
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
353 #############################################
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
354 #############################################
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
355 #### Horizontalprofil InstantaneousPoint ####
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
356 #############################################
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
357 #############################################
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
358 horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
359 V.VEHICLEID KEY, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
360 V.NAME VALUE \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
361 FROM MEDIAN.VEHICLE V, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
362 MEDIAN.CRUISE C, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
363 MEDIAN.TRACK T, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
364 MEDIAN.SURVEYINFO S, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
365 MEDIAN.INSTANTANEOUSPOINT I, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
366 MEDIAN.MEASUREMENT M \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
367 WHERE V.VEHICLEID = C.VEHICLEID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
368 C.CRUISEID = T.CRUISEID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
369 T.TRACKID = S.TRACKID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
370 S.SURVEYID = I.SURVEYID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
371 I.FEATUREID = M.FEATUREID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
372 M.SOURCEID = ? \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
373 ORDER BY V.NAME
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
374 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
375 C.CRUISEID KEY , \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
376 C.NAME VALUE \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
377 FROM MEDIAN.CRUISE C, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
378 MEDIAN.TRACK T, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
379 MEDIAN.SURVEYINFO S, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
380 MEDIAN.INSTANTANEOUSPOINT I, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
381 MEDIAN.MEASUREMENT M \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
382 WHERE C.CRUISEID = T.CRUISEID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
383 T.TRACKID = S.TRACKID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
384 S.SURVEYID = I.SURVEYID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
385 I.FEATUREID = M.FEATUREID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
386 C.VEHICLEID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
387 M.SOURCEID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
388 C.NAME IS NOT NULL \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
389 ORDER BY C.NAME
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
390 horizontalprofile_instantaneouspoint_track= SELECT \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
391 T.TRACKID KEY , \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
392 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
393 FROM MEDIAN.TRACK T \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
394 WHERE T.CRUISEID = ? \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
395 ORDER BY T.STARTDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
396 T.ENDDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
397 T.NAME
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
398 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
399 SURVEYID KEY , \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
400 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
401 FROM MEDIAN.SURVEYINFO \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
402 WHERE TRACKID = ? \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
403 ORDER BY STARTDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
404 ENDDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
405 DESCRIPTION
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
406 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
407 P.PARAMETERID KEY , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
408 P.GERMANNAME VALUE \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
409 FROM MEDIAN.PARAMETER P , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
410 MEDIAN.MEASUREMENT M , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
411 MEDIAN.INSTANTANEOUSPOINT IP , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
412 MEDIAN.MEASUREDSCALARVALUE MSV \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
413 WHERE P.PARAMETERID = MSV.PARAMETERID AND \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
414 MSV.MEASUREMENTID = M.MEASUREMENTID AND \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
415 M.FEATUREID = IP.FEATUREID AND \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
416 IP.SURVEYID = ? \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
417 ORDER BY P.GERMANNAME
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
418 horizontalprofile_instantaneouspoint_depth = SELECT DISTINCT \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
419 M.ZLOCATION KEY, \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
420 M.ZLOCATION VALUE \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
421 FROM MEDIAN.MEASUREMENT M , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
422 MEDIAN.INSTANTANEOUSPOINT IP \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
423 WHERE M.FEATUREID = IP.FEATUREID AND \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
424 IP.SURVEYID = ? \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
425 ORDER BY M.ZLOCATION
120
5134266f00e7 Resolved gnv/issue21 No NPE will be thrown.
Tim Englich <tim.englich@intevation.de>
parents: 119
diff changeset
426 horizontalprofile_instantaneouspoint_chart_data = SELECT MSV.OBJECTID XORDINATE_XCOORD , \
5134266f00e7 Resolved gnv/issue21 No NPE will be thrown.
Tim Englich <tim.englich@intevation.de>
parents: 119
diff changeset
427 MSV.OBJECTID XORDINATE_YCOORD , \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
428 MSV.DATAVALUE YORDINATE , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
429 MSV.PARAMETERID GROUP1 , \
120
5134266f00e7 Resolved gnv/issue21 No NPE will be thrown.
Tim Englich <tim.englich@intevation.de>
parents: 119
diff changeset
430 ZLOCATION GROUP2 , \
5134266f00e7 Resolved gnv/issue21 No NPE will be thrown.
Tim Englich <tim.englich@intevation.de>
parents: 119
diff changeset
431 1 GROUP3 \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
432 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
433 MEDIAN.MEASUREMENT M, \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
434 MEDIAN.MEASUREDSCALARVALUE MSV \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
435 WHERE IP.FEATUREID = M.FEATUREID AND \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
436 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
437 IP.SURVEYID = ? AND \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
438 M.ZLOCATION IN (?) AND \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
439 MSV.PARAMETERID in (?) \
120
5134266f00e7 Resolved gnv/issue21 No NPE will be thrown.
Tim Englich <tim.englich@intevation.de>
parents: 119
diff changeset
440 ORDER BY MSV.PARAMETERID, \
5134266f00e7 Resolved gnv/issue21 No NPE will be thrown.
Tim Englich <tim.englich@intevation.de>
parents: 119
diff changeset
441 M.ZLOCATION
5134266f00e7 Resolved gnv/issue21 No NPE will be thrown.
Tim Englich <tim.englich@intevation.de>
parents: 119
diff changeset
442
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
443 #############################################
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
444 #############################################
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
445 ########### Horizontalprofil MESH ###########
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
446 #############################################
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
447 #############################################
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
448 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
449 mp.KPOSITION KEY, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
450 -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
451 from MEDIAN.MESHLAYER ml, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
452 MEDIAN.MESHPOINT mp \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
453 where ml.KPOSITION = mp.KPOSITION and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
454 ml.MESHID = mp.MESHID and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
455 mp.FEATUREID in \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
456 ( select FEATUREID \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
457 from MEDIAN.MESHPOINT mp, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
458 MEDIAN.MESH m \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
459 where m.OBJECTID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
460 mp.MESHID = m.MESHID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
461 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
462 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
463 order by mp.KPOSITION
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
464
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
465 horizontalprofile_mesh_chart_data = select mp.IPOSITION XORDINATE_XCOORD, mp.JPOSITION XORDINATE_YCOORD, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
466 msv.DATAVALUE YORDINATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
467 msv.PARAMETERID GROUP1, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
468 msv.TIMEVALUE GROUP2, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
469 mp.KPOSITION GROUP3 \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
470 from MEDIAN.MESHLAYER ml, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
471 MEDIAN.MESHPOINT mp, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
472 MEDIAN.MESH m, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
473 MEDIAN.MESHSCALARVALUE msv \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
474 where msv.FEATUREID = mp. FEATUREID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
475 ml.KPOSITION = mp.KPOSITION and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
476 ml.MESHID = mp.MESHID and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
477 m.MESHID = mp.MESHID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
478 m.PARTIDMIN <= msv.PARTID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
479 m.PARTIDMAX >= msv.PARTID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
480 msv.PARAMETERID in (?) AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
481 msv.TIMEVALUE in (?) AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
482 m.OBJECTID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
483 mp.FEATUREID in \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
484 ( select FEATUREID \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
485 from MEDIAN.MESHPOINT mp, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
486 MEDIAN.MESH m \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
487 where m.OBJECTID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
488 mp.MESHID = m.MESHID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
489 KPOSITION in ( ? ) and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
490 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
491 order by mp.KPOSITION, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
492 msv.TIMEVALUE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
493 msv.PARAMETERID, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
494 mp.JPOSITION , \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
495 mp.IPOSITION
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
496
http://dive4elements.wald.intevation.org