Mercurial > dive4elements > gnv-client

annotate gnv-artifacts/src/test/ressources/queries.properties @ 119:4841808819d9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added the new FIS FIS GTS FIS CTD FIS XBT to the Configuration. This three FIS uses Data from InstantaneousPoint Some CodeCleanup done gnv-artifacts/trunk@182 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Mon, 05 Oct 2009 10:15:15 +0000
parents 820238357bab
children 5134266f00e7
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
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
97 timeseries_meshpoint = SELECT FEATUREID KEY, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
98 SHAPE VALUE \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
99 FROM MEDIAN.MESHPOINT mp , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
100 MEDIAN.MESH m \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
101 WHERE m.OBJECTID = ? AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
102 mp.MESHID = m.MESHID AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
103 KPOSITION = 1 AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
104 rownum < 10
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
105
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
106 timeseries_meshpoint_depth = select mp.FEATUREID KEY, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
107 -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
108 from MEDIAN.MESHLAYER ml, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
109 MEDIAN.MESHPOINT mp \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
110 where ml.KPOSITION = mp.KPOSITION and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
111 ml.MESHID = mp.MESHID and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
112 mp.FEATUREID in \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
113 ( select FEATUREID \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
114 from MEDIAN.MESHPOINT mp, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
115 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
116 where m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
117 mp.MESHID = m.MESHID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
118 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
119 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
120 order by ml.UPPERZLOCATION desc
87
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
121
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
122 timeseries_mesh_parameter=SELECT distinct \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
123 p.PARAMETERID KEY , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
124 p.GERMANNAME VALUE \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
125 from MEDIAN.PARAMETER p, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
126 MEDIAN.MESHSCALARVALUE msc, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
127 MEDIAN.MESH m \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
128 where m.OBJECTID = ? AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
129 msc.PARTID = m.PARTIDMIN AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
130 msc.PARAMETERID = p.PARAMETERID \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
131 order by p.GERMANNAME
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
132 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
133 min(TIMEVALUE) MIN, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
134 max(TIMEVALUE) MAX \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
135 from MEDIAN.MESHSCALARVALUE msc , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
136 MEDIAN.MESH m \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
137 where m.OBJECTID = ? AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
138 msc.PARTID >= m.PARTIDMIN AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
139 msc.PARTID <= m.PARTIDMAX
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
140
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
141 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
142 msv.TIMEVALUE XORDINATE, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
143 msv.DATAVALUE YORDINATE, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
144 msv.PARAMETERID GROUP1, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
145 msv.FEATUREID GROUP2, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
146 mp.FEATUREID GROUP3 \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
147 from MEDIAN.MESHSCALARVALUE msv , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
148 MEDIAN.MESHPOINT mp, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
149 MEDIAN.MESH m \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
150 where (m.OBJECTID = ? AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
151 msv.PARTID >= m.PARTIDMIN AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
152 msv.PARTID <= m.PARTIDMAX ) AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
153 msv.FEATUREID in ( ? ) AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
154 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
155 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
156 msv.TIMEVALUE >= ? AND \
994a39b084d6 Imporved JUnitTest and Bugfixing as a Result of this Improvement.
Tim Englich <tim.englich@intevation.de>
parents: 87
diff changeset
157 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
158 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
159 msv.FEATUREID, \
87
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
160 msv.PARAMETERID, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
161 msv.TIMEVALUE
81
9b41f3688610 Added Support for TimeSeriesMesh
Tim Englich <tim.englich@intevation.de>
parents: 69
diff changeset
162
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
163 #############################################
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 ########## Vertikalprofil ##############
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
166 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
167 #############################################
82
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
168
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
169 verticalprofile_point=SELECT DISTINCT \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
170 tsp.FEATUREID KEY, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
171 tsp.NAME VALUE \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
172 FROM MEDIAN.TIMESERIESPOINT tsp, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
173 MEDIAN.MEASUREMENT mmt \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
174 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
175 mmt.SOURCEID = ? \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
176 order by tsp.name
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
177
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
178 verticalprofile_parameter=SELECT DISTINCT \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
179 p.PARAMETERID KEY, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
180 p.GERMANNAME VALUE \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
181 from MEDIAN.PARAMETER p, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
182 MEDIAN.TIMESERIES ts, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
183 MEDIAN.TIMESERIESVALUE tsv, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
184 MEDIAN.MEASUREMENT m \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
185 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
186 ts.TIMESERIESID = tsv.TIMESERIESID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
187 m.MEASUREMENTID = tsv.MEASUREMENTID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
188 m.FEATUREID = ? \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
189 ORDER BY p.GERMANNAME
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
190
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
191 verticalprofile_date=select distinct \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
192 tsv.TIMEVALUE KEY, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
193 tsv.TIMEVALUE VALUE \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
194 from MEDIAN.TIMESERIES ts , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
195 MEDIAN.TIMESERIESVALUE tsv, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
196 MEDIAN.MEASUREMENT m \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
197 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
198 m.MEASUREMENTID = tsv.MEASUREMENTID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
199 m.FEATUREID = ? and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
200 ts.PARAMETERID IN ( ? ) \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
201 order by tsv.TIMEVALUE
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
202
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
203 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
204 tsv.DATAVALUE YORDINATE, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
205 ts.PARAMETERID GROUP1, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
206 tsv.TIMEVALUE GROUP2, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
207 1 GROUP3 \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
208 from MEDIAN.TIMESERIES ts, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
209 MEDIAN.TIMESERIESVALUE tsv, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
210 MEDIAN.MEASUREMENT m \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
211 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
212 m.MEASUREMENTID = tsv.MEASUREMENTID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
213 m.FEATUREID = ? and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
214 ts.PARAMETERID IN ( ? ) AND \
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
215 tsv.TIMEVALUE IN (?) \
82
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
216 ORDER BY tsv.TIMEVALUE , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
217 tsv.TIMESERIESID , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
218 ts.PARAMETERID , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
219 tsv.TIMEVALUE
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
220
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 ########## Vertikalprofil Mesh ##############
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
224 #############################################
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 verticalprofile_mesh = SELECT OBJECTID KEY, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
228 m.NAME VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
229 FROM MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
230 order by m.NAME
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
231
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
232 verticalprofile_mesh_point = SELECT FEATUREID KEY, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
233 SHAPE VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
234 FROM MEDIAN.MESHPOINT mp , \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
235 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
236 WHERE m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
237 m.MESHID = mp.MESHID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
238 mp.KPOSITION = 1 AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
239 rownum < 10
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
240
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
241 verticalprofile_mesh_parameter=SELECT distinct \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
242 p.PARAMETERID KEY , \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
243 p.GERMANNAME VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
244 from MEDIAN.PARAMETER p, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
245 MEDIAN.MESHSCALARVALUE msc, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
246 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
247 where m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
248 m.PARTIDMIN = msc.PARTID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
249 msc.PARAMETERID = p.PARAMETERID \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
250 order by p.GERMANNAME
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
251
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
252 verticalprofile_mesh_date= select distinct \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
253 msv.TIMEVALUE KEY, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
254 msv.TIMEVALUE VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
255 from MEDIAN.MESHSCALARVALUE msv , \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
256 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
257 where m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
258 msv.PARTID >= m.PARTIDMIN AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
259 msv.PARTID <= m.PARTIDMAX \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
260 order by msv.TIMEVALUE
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
261
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
262 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
263 msv.DATAVALUE YORDINATE, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
264 msv.PARAMETERID GROUP1, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
265 msv.TIMEVALUE GROUP2, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
266 1 GROUP3 \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
267 from MEDIAN.MESHLAYER ml, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
268 MEDIAN.MESHPOINT mp, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
269 MEDIAN.MESH m, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
270 MEDIAN.MESHSCALARVALUE msv \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
271 where msv.FEATUREID = mp. FEATUREID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
272 ml.KPOSITION = mp.KPOSITION and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
273 ml.MESHID = mp.MESHID and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
274 m.MESHID = mp.MESHID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
275 m.PARTIDMIN <= msv.PARTID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
276 m.PARTIDMAX >= msv.PARTID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
277 msv.PARAMETERID in (?) AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
278 msv.TIMEVALUE in (?) AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
279 m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
280 mp.FEATUREID in \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
281 ( select FEATUREID \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
282 from MEDIAN.MESHPOINT mp, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
283 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
284 where m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
285 mp.MESHID = m.MESHID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
286 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
287 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
288 order by msv.PARAMETERID, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
289 msv.TIMEVALUE, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
290 ml.UPPERZLOCATION
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
291
85
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
292 #############################################
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
293 #############################################
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
294 ##### Vertikalprofil InstantaneousPoint #####
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 #############################################
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
297
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
298 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
299 S.SERIESID KEY , \
85
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
300 S.DESCRIPTION VALUE \
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
301 FROM MEDIAN.SERIES S, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
302 MEDIAN.INSTANTANEOUSPOINT I, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
303 MEDIAN.MEASUREMENT M \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
304 WHERE S.SERIESID = I.SERIESID AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
305 I.POINTSPEC = 4 AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
306 I.FEATUREID = M.FEATUREID AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
307 M.SOURCEID= ? \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
308 ORDER BY S.DESCRIPTION
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
309
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
310 verticalprofile_instantaneouspoint_point = SELECT DISTINCT \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
311 I.FEATUREID KEY, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
312 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
313 I.TIMEVALUE \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
314 FROM MEDIAN.INSTANTANEOUSPOINT I, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
315 MEDIAN.MEASUREMENT M \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
316 WHERE I.SERIESID = ? AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
317 I.POINTSPEC = 4 AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
318 I.FEATUREID = M.FEATUREID AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
319 M.SOURCEID = ? \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
320 ORDER BY I.TIMEVALUE
85
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
321
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
322 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
323 P.PARAMETERID KEY , \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
324 P.GERMANNAME VALUE \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
325 FROM MEDIAN.PARAMETER P, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
326 MEDIAN.INSTANTANEOUSPOINT IP, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
327 MEDIAN.MEASUREMENT M, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
328 MEDIAN.MEASUREDSCALARVALUE MSV \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
329 WHERE IP.FEATUREID = M.FEATUREID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
330 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
331 MSV.PARAMETERID = P.PARAMETERID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
332 IP.FEATUREID = ? \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
333 ORDER BY P.GERMANNAME
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
334
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
335 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
336 MSV.DATAVALUE YORDINATE, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
337 MSV.PARAMETERID GROUP1, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
338 IP.TIMEVALUE GROUP2, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
339 1 GROUP3 \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
340 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
341 MEDIAN.MEASUREMENT M, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
342 MEDIAN.MEASUREDSCALARVALUE MSV \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
343 WHERE IP.FEATUREID = M.FEATUREID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
344 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
345 IP.FEATUREID = ? AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
346 MSV.PARAMETERID in (?) \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
347 ORDER BY IP.TIMEVALUE, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
348 MSV.PARAMETERID, \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
349 M.ZLOCATION
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
350
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
351 #############################################
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 #### Horizontalprofil InstantaneousPoint ####
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 #############################################
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
356 horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
357 V.VEHICLEID KEY, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
358 V.NAME VALUE \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
359 FROM MEDIAN.VEHICLE V, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
360 MEDIAN.CRUISE C, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
361 MEDIAN.TRACK T, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
362 MEDIAN.SURVEYINFO S, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
363 MEDIAN.INSTANTANEOUSPOINT I, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
364 MEDIAN.MEASUREMENT M \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
365 WHERE V.VEHICLEID = C.VEHICLEID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
366 C.CRUISEID = T.CRUISEID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
367 T.TRACKID = S.TRACKID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
368 S.SURVEYID = I.SURVEYID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
369 I.FEATUREID = M.FEATUREID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
370 M.SOURCEID = ? \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
371 ORDER BY V.NAME
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
372 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
373 C.CRUISEID KEY , \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
374 C.NAME VALUE \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
375 FROM MEDIAN.CRUISE C, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
376 MEDIAN.TRACK T, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
377 MEDIAN.SURVEYINFO S, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
378 MEDIAN.INSTANTANEOUSPOINT I, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
379 MEDIAN.MEASUREMENT M \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
380 WHERE C.CRUISEID = T.CRUISEID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
381 T.TRACKID = S.TRACKID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
382 S.SURVEYID = I.SURVEYID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
383 I.FEATUREID = M.FEATUREID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
384 C.VEHICLEID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
385 M.SOURCEID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
386 C.NAME IS NOT NULL \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
387 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
388 horizontalprofile_instantaneouspoint_track= SELECT \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
389 T.TRACKID KEY , \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
390 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
391 FROM MEDIAN.TRACK T \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
392 WHERE T.CRUISEID = ? \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
393 ORDER BY T.STARTDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
394 T.ENDDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
395 T.NAME
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
396 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
397 SURVEYID KEY , \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
398 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
399 FROM MEDIAN.SURVEYINFO \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
400 WHERE TRACKID = ? \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
401 ORDER BY STARTDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
402 ENDDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
403 DESCRIPTION
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
404 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
405 P.PARAMETERID KEY , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
406 P.GERMANNAME VALUE \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
407 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
408 MEDIAN.MEASUREMENT M , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
409 MEDIAN.INSTANTANEOUSPOINT IP , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
410 MEDIAN.MEASUREDSCALARVALUE MSV \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
411 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
412 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
413 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
414 IP.SURVEYID = ? \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
415 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
416 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
417 M.ZLOCATION KEY, \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
418 M.ZLOCATION VALUE \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
419 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
420 MEDIAN.INSTANTANEOUSPOINT IP \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
421 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
422 IP.SURVEYID = ? \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
423 ORDER BY M.ZLOCATION
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
424 horizontalprofile_instantaneouspoint_chart_data = SELECT M.XLOCATION XORDINATE_XCOORD , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
425 M.YLOCATION XORDINATE_YCOORD , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
426 MSV.DATAVALUE YORDINATE , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
427 MSV.PARAMETERID GROUP1 , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
428 IP.TIMEVALUE GROUP2 , \
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
429 ZLOCATION GROUP3 \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
430 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
431 MEDIAN.MEASUREMENT M, \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
432 MEDIAN.MEASUREDSCALARVALUE MSV \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
433 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
434 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
435 IP.SURVEYID = ? AND \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
436 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
437 MSV.PARAMETERID in (?) \
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
438 ORDER BY M.ZLOCATION, \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
439 MSV.PARAMETERID, \
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
440 IP.TIMEVALUE
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
441
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
442 #############################################
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 ########### Horizontalprofil MESH ###########
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
445 #############################################
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 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
448 mp.KPOSITION KEY, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
449 -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
450 from MEDIAN.MESHLAYER ml, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
451 MEDIAN.MESHPOINT mp \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
452 where ml.KPOSITION = mp.KPOSITION and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
453 ml.MESHID = mp.MESHID and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
454 mp.FEATUREID in \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
455 ( select FEATUREID \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
456 from MEDIAN.MESHPOINT mp, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
457 MEDIAN.MESH m \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
458 where m.OBJECTID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
459 mp.MESHID = m.MESHID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
460 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
461 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
462 order by mp.KPOSITION
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
463
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
464 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
465 msv.DATAVALUE YORDINATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
466 msv.PARAMETERID GROUP1, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
467 msv.TIMEVALUE GROUP2, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
468 mp.KPOSITION GROUP3 \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
469 from MEDIAN.MESHLAYER ml, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
470 MEDIAN.MESHPOINT mp, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
471 MEDIAN.MESH m, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
472 MEDIAN.MESHSCALARVALUE msv \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
473 where msv.FEATUREID = mp. FEATUREID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
474 ml.KPOSITION = mp.KPOSITION and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
475 ml.MESHID = mp.MESHID and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
476 m.MESHID = mp.MESHID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
477 m.PARTIDMIN <= msv.PARTID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
478 m.PARTIDMAX >= msv.PARTID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
479 msv.PARAMETERID in (?) AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
480 msv.TIMEVALUE in (?) AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
481 m.OBJECTID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
482 mp.FEATUREID in \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
483 ( select FEATUREID \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
484 from MEDIAN.MESHPOINT mp, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
485 MEDIAN.MESH m \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
486 where m.OBJECTID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
487 mp.MESHID = m.MESHID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
488 KPOSITION in ( ? ) and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
489 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
490 order by mp.KPOSITION, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
491 msv.TIMEVALUE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
492 msv.PARAMETERID, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
493 mp.JPOSITION , \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
494 mp.IPOSITION
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
495
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
496
http://dive4elements.wald.intevation.org