Mercurial > dive4elements > gnv-client

annotate gnv-artifacts/src/test/ressources/queries.properties @ 184:5d050f6de41d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
The Levelnumber of Meshes will also be visualized in the choose of depth GT_0020.0020 gnv-artifacts/trunk@228 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 16 Oct 2009 09:31:25 +0000
parents f2c76f35da5a
children 693f7b676ade
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, \
184
5d050f6de41d The Levelnumber of Meshes will also be visualized in the choose of depth GT_0020.0020
Tim Englich <tim.englich@intevation.de>
parents: 179
diff changeset
108 mp.KPOSITION || ' ( '|| -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION || ' )' as VALUE \
83
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 \
175
14263534255b Added Parameter-Usage in Time-Interval-Query ISSUE-33
Tim Englich <tim.englich@intevation.de>
parents: 174
diff changeset
140 msc.PARTID <= m.PARTIDMAX AND \
14263534255b Added Parameter-Usage in Time-Interval-Query ISSUE-33
Tim Englich <tim.englich@intevation.de>
parents: 174
diff changeset
141 msc.PARAMETERID IN (?)
87
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
142
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
143 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
144 msv.TIMEVALUE XORDINATE, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
145 msv.DATAVALUE YORDINATE, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
146 msv.PARAMETERID GROUP1, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
147 msv.FEATUREID GROUP2, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
148 mp.FEATUREID GROUP3 \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
149 from MEDIAN.MESHSCALARVALUE msv , \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
150 MEDIAN.MESHPOINT mp, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
151 MEDIAN.MESH m \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
152 where (m.OBJECTID = ? AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
153 msv.PARTID >= m.PARTIDMIN AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
154 msv.PARTID <= m.PARTIDMAX ) AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
155 msv.FEATUREID in ( ? ) AND \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
156 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
157 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
158 msv.TIMEVALUE >= ? AND \
994a39b084d6 Imporved JUnitTest and Bugfixing as a Result of this Improvement.
Tim Englich <tim.englich@intevation.de>
parents: 87
diff changeset
159 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
160 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
161 msv.FEATUREID, \
87
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
162 msv.PARAMETERID, \
ce398a7a99fc SQL-Queries formatted, Some Bugs fixed
Tim Englich <tim.englich@intevation.de>
parents: 85
diff changeset
163 msv.TIMEVALUE
81
9b41f3688610 Added Support for TimeSeriesMesh
Tim Englich <tim.englich@intevation.de>
parents: 69
diff changeset
164
83
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 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
167 ########## Vertikalprofil ##############
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
168 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
169 #############################################
82
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
170
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
171 verticalprofile_point=SELECT DISTINCT \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
172 tsp.FEATUREID KEY, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
173 tsp.NAME VALUE \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
174 FROM MEDIAN.TIMESERIESPOINT tsp, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
175 MEDIAN.MEASUREMENT mmt \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
176 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
177 mmt.SOURCEID = ? \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
178 order by tsp.name
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
179
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
180 verticalprofile_parameter=SELECT DISTINCT \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
181 p.PARAMETERID KEY, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
182 p.GERMANNAME VALUE \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
183 from MEDIAN.PARAMETER p, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
184 MEDIAN.TIMESERIES ts, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
185 MEDIAN.TIMESERIESVALUE tsv, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
186 MEDIAN.MEASUREMENT m \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
187 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
188 ts.TIMESERIESID = tsv.TIMESERIESID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
189 m.MEASUREMENTID = tsv.MEASUREMENTID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
190 m.FEATUREID = ? \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
191 ORDER BY p.GERMANNAME
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
192
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
193 verticalprofile_date=select distinct \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
194 tsv.TIMEVALUE KEY, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
195 tsv.TIMEVALUE VALUE \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
196 from MEDIAN.TIMESERIES ts , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
197 MEDIAN.TIMESERIESVALUE tsv, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
198 MEDIAN.MEASUREMENT m \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
199 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
200 m.MEASUREMENTID = tsv.MEASUREMENTID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
201 m.FEATUREID = ? and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
202 ts.PARAMETERID IN ( ? ) \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
203 order by tsv.TIMEVALUE
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
204
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
205 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
206 tsv.DATAVALUE YORDINATE, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
207 ts.PARAMETERID GROUP1, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
208 tsv.TIMEVALUE GROUP2, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
209 1 GROUP3 \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
210 from MEDIAN.TIMESERIES ts, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
211 MEDIAN.TIMESERIESVALUE tsv, \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
212 MEDIAN.MEASUREMENT m \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
213 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
214 m.MEASUREMENTID = tsv.MEASUREMENTID and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
215 m.FEATUREID = ? and \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
216 ts.PARAMETERID IN ( ? ) AND \
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
217 tsv.TIMEVALUE IN (?) \
82
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
218 ORDER BY tsv.TIMEVALUE , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
219 tsv.TIMESERIESID , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
220 ts.PARAMETERID , \
5eb62df21f9a Added Support for Vertical Profiles Marnet, STAUN, IMIS
Tim Englich <tim.englich@intevation.de>
parents: 81
diff changeset
221 tsv.TIMEVALUE
83
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 #############################################
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
225 ########## Vertikalprofil Mesh ##############
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
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
229 verticalprofile_mesh = SELECT OBJECTID KEY, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
230 m.NAME VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
231 FROM MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
232 order by m.NAME
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
233
174
dbf68950b4d9 Added real Coordinate-Query to HorizontalProfile- and VerticalProfile-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 173
diff changeset
234 verticalprofile_mesh_point = SELECT FEATUREID, \
dbf68950b4d9 Added real Coordinate-Query to HorizontalProfile- and VerticalProfile-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 173
diff changeset
235 ST_ASTEXT(SHAPE) \
dbf68950b4d9 Added real Coordinate-Query to HorizontalProfile- and VerticalProfile-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 173
diff changeset
236 FROM MEDIAN.MESHPOINT \
dbf68950b4d9 Added real Coordinate-Query to HorizontalProfile- and VerticalProfile-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 173
diff changeset
237 WHERE MESHID in \
dbf68950b4d9 Added real Coordinate-Query to HorizontalProfile- and VerticalProfile-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 173
diff changeset
238 (SELECT DISTINCT MESHID \
dbf68950b4d9 Added real Coordinate-Query to HorizontalProfile- and VerticalProfile-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 173
diff changeset
239 FROM MEDIAN.MESH \
dbf68950b4d9 Added real Coordinate-Query to HorizontalProfile- and VerticalProfile-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 173
diff changeset
240 WHERE OBJECTID = ?) AND \
dbf68950b4d9 Added real Coordinate-Query to HorizontalProfile- and VerticalProfile-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 173
diff changeset
241 KPOSITION = 1 AND \
dbf68950b4d9 Added real Coordinate-Query to HorizontalProfile- and VerticalProfile-Mesh
Tim Englich <tim.englich@intevation.de>
parents: 173
diff changeset
242 INTERSECTS(SHAPE,"?")
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
243
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
244 verticalprofile_mesh_parameter=SELECT distinct \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
245 p.PARAMETERID KEY , \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
246 p.GERMANNAME VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
247 from MEDIAN.PARAMETER p, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
248 MEDIAN.MESHSCALARVALUE msc, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
249 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
250 where m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
251 m.PARTIDMIN = msc.PARTID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
252 msc.PARAMETERID = p.PARAMETERID \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
253 order by p.GERMANNAME
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
254
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
255 verticalprofile_mesh_date= select distinct \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
256 msv.TIMEVALUE KEY, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
257 msv.TIMEVALUE VALUE \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
258 from MEDIAN.MESHSCALARVALUE msv , \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
259 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
260 where m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
261 msv.PARTID >= m.PARTIDMIN AND \
170
7be22e76c270 Added parameter to the DateQueroes of Meshes
Tim Englich <tim.englich@intevation.de>
parents: 120
diff changeset
262 msv.PARTID <= m.PARTIDMAX AND \
7be22e76c270 Added parameter to the DateQueroes of Meshes
Tim Englich <tim.englich@intevation.de>
parents: 120
diff changeset
263 msv.PARAMETERID in (?) \
83
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
264 order by msv.TIMEVALUE
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
265
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
266 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
267 msv.DATAVALUE YORDINATE, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
268 msv.PARAMETERID GROUP1, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
269 msv.TIMEVALUE GROUP2, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
270 1 GROUP3 \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
271 from MEDIAN.MESHLAYER ml, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
272 MEDIAN.MESHPOINT mp, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
273 MEDIAN.MESH m, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
274 MEDIAN.MESHSCALARVALUE msv \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
275 where msv.FEATUREID = mp. FEATUREID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
276 ml.KPOSITION = mp.KPOSITION and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
277 ml.MESHID = mp.MESHID and \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
278 m.MESHID = mp.MESHID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
279 m.PARTIDMIN <= msv.PARTID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
280 m.PARTIDMAX >= msv.PARTID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
281 msv.PARAMETERID in (?) AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
282 msv.TIMEVALUE in (?) AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
283 m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
284 mp.FEATUREID in \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
285 ( select FEATUREID \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
286 from MEDIAN.MESHPOINT mp, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
287 MEDIAN.MESH m \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
288 where m.OBJECTID = ? AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
289 mp.MESHID = m.MESHID AND \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
290 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
291 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
292 order by msv.PARAMETERID, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
293 msv.TIMEVALUE, \
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
294 ml.UPPERZLOCATION
5c8e54726a58 Added Support for Vertical Profiles Mesh
Tim Englich <tim.englich@intevation.de>
parents: 82
diff changeset
295
85
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 #############################################
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
298 ##### Vertikalprofil InstantaneousPoint #####
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
299 #############################################
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
300 #############################################
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
301
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
302 verticalprofile_instantaneouspoint_series = SELECT DISTINCT \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
303 S.SERIESID KEY , \
85
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
304 S.DESCRIPTION VALUE \
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
305 FROM MEDIAN.SERIES S, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
306 MEDIAN.INSTANTANEOUSPOINT I, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
307 MEDIAN.MEASUREMENT M \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
308 WHERE S.SERIESID = I.SERIESID AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
309 I.POINTSPEC = 4 AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
310 I.FEATUREID = M.FEATUREID AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
311 M.SOURCEID= ? \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
312 ORDER BY S.DESCRIPTION
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
313
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
314 verticalprofile_instantaneouspoint_point = SELECT DISTINCT \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
315 I.FEATUREID KEY, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
316 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
317 I.TIMEVALUE \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
318 FROM MEDIAN.INSTANTANEOUSPOINT I, \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
319 MEDIAN.MEASUREMENT M \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
320 WHERE I.SERIESID = ? AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
321 I.POINTSPEC = 4 AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
322 I.FEATUREID = M.FEATUREID AND \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
323 M.SOURCEID = ? \
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
324 ORDER BY I.TIMEVALUE
85
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
325
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
326 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
327 P.PARAMETERID KEY , \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
328 P.GERMANNAME VALUE \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
329 FROM MEDIAN.PARAMETER P, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
330 MEDIAN.INSTANTANEOUSPOINT IP, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
331 MEDIAN.MEASUREMENT M, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
332 MEDIAN.MEASUREDSCALARVALUE MSV \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
333 WHERE IP.FEATUREID = M.FEATUREID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
334 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
335 MSV.PARAMETERID = P.PARAMETERID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
336 IP.FEATUREID = ? \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
337 ORDER BY P.GERMANNAME
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
338
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
339 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
340 MSV.DATAVALUE YORDINATE, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
341 MSV.PARAMETERID GROUP1, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
342 IP.TIMEVALUE GROUP2, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
343 1 GROUP3 \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
344 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
345 MEDIAN.MEASUREMENT M, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
346 MEDIAN.MEASUREDSCALARVALUE MSV \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
347 WHERE IP.FEATUREID = M.FEATUREID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
348 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
349 IP.FEATUREID = ? AND \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
350 MSV.PARAMETERID in (?) \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
351 ORDER BY IP.TIMEVALUE, \
dbd141c6bb97 Added Support for VerticalProfiles for InstantaneousPoints
Tim Englich <tim.englich@intevation.de>
parents: 83
diff changeset
352 MSV.PARAMETERID, \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
353 M.ZLOCATION
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 #############################################
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 #### Horizontalprofil InstantaneousPoint ####
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
358 #############################################
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
359 #############################################
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
360 horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
361 V.VEHICLEID KEY, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
362 V.NAME VALUE \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
363 FROM MEDIAN.VEHICLE V, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
364 MEDIAN.CRUISE C, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
365 MEDIAN.TRACK T, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
366 MEDIAN.SURVEYINFO S, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
367 MEDIAN.INSTANTANEOUSPOINT I, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
368 MEDIAN.MEASUREMENT M \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
369 WHERE V.VEHICLEID = C.VEHICLEID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
370 C.CRUISEID = T.CRUISEID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
371 T.TRACKID = S.TRACKID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
372 S.SURVEYID = I.SURVEYID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
373 I.FEATUREID = M.FEATUREID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
374 M.SOURCEID = ? \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
375 ORDER BY V.NAME
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
376 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
377 C.CRUISEID KEY , \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
378 C.NAME VALUE \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
379 FROM MEDIAN.CRUISE C, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
380 MEDIAN.TRACK T, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
381 MEDIAN.SURVEYINFO S, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
382 MEDIAN.INSTANTANEOUSPOINT I, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
383 MEDIAN.MEASUREMENT M \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
384 WHERE C.CRUISEID = T.CRUISEID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
385 T.TRACKID = S.TRACKID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
386 S.SURVEYID = I.SURVEYID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
387 I.FEATUREID = M.FEATUREID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
388 C.VEHICLEID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
389 M.SOURCEID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
390 C.NAME IS NOT NULL \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
391 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
392 horizontalprofile_instantaneouspoint_track= SELECT \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
393 T.TRACKID KEY , \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
394 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
395 FROM MEDIAN.TRACK T \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
396 WHERE T.CRUISEID = ? \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
397 ORDER BY T.STARTDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
398 T.ENDDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
399 T.NAME
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
400 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
401 SURVEYID KEY , \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
402 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
403 FROM MEDIAN.SURVEYINFO \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
404 WHERE TRACKID = ? \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
405 ORDER BY STARTDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
406 ENDDATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
407 DESCRIPTION
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
408 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
409 P.PARAMETERID KEY , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
410 P.GERMANNAME VALUE \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
411 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
412 MEDIAN.MEASUREMENT M , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
413 MEDIAN.INSTANTANEOUSPOINT IP , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
414 MEDIAN.MEASUREDSCALARVALUE MSV \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
415 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
416 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
417 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
418 IP.SURVEYID = ? \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
419 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
420 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
421 M.ZLOCATION KEY, \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
422 M.ZLOCATION VALUE \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
423 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
424 MEDIAN.INSTANTANEOUSPOINT IP \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
425 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
426 IP.SURVEYID = ? \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
427 ORDER BY M.ZLOCATION
176
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
428 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE) , \
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
429 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME , \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
430 MSV.DATAVALUE YORDINATE , \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
431 MSV.PARAMETERID GROUP1 , \
120
5134266f00e7 Resolved gnv/issue21 No NPE will be thrown.
Tim Englich <tim.englich@intevation.de>
parents: 119
diff changeset
432 ZLOCATION GROUP2 , \
5134266f00e7 Resolved gnv/issue21 No NPE will be thrown.
Tim Englich <tim.englich@intevation.de>
parents: 119
diff changeset
433 1 GROUP3 \
176
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
434 FROM MEDIAN.INSTANTANEOUSPOINT, \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
435 MEDIAN.MEASUREMENT M, \
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
436 MEDIAN.MEASUREDSCALARVALUE MSV \
176
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
437 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
438 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
176
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
439 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \
114
d8d38a4dd965 Added TestCase for HorizontalProfiles of InstataneousPoints and the required Configuration
Tim Englich <tim.englich@intevation.de>
parents: 108
diff changeset
440 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
441 MSV.PARAMETERID in (?) \
120
5134266f00e7 Resolved gnv/issue21 No NPE will be thrown.
Tim Englich <tim.englich@intevation.de>
parents: 119
diff changeset
442 ORDER BY MSV.PARAMETERID, \
176
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
443 M.ZLOCATION, \
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
444 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
120
5134266f00e7 Resolved gnv/issue21 No NPE will be thrown.
Tim Englich <tim.englich@intevation.de>
parents: 119
diff changeset
445
116
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 ########### Horizontalprofil MESH ###########
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
449 #############################################
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
450 #############################################
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
451 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
452 mp.KPOSITION KEY, \
184
5d050f6de41d The Levelnumber of Meshes will also be visualized in the choose of depth GT_0020.0020
Tim Englich <tim.englich@intevation.de>
parents: 179
diff changeset
453 mp.KPOSITION || ' ( '||-ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION || ' ) ' VALUE \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
454 from MEDIAN.MESHLAYER ml, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
455 MEDIAN.MESHPOINT mp \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
456 where ml.KPOSITION = mp.KPOSITION and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
457 ml.MESHID = mp.MESHID and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
458 mp.FEATUREID in \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
459 ( select FEATUREID \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
460 from MEDIAN.MESHPOINT mp, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
461 MEDIAN.MESH m \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
462 where m.OBJECTID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
463 mp.MESHID = m.MESHID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
464 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
465 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
466 order by mp.KPOSITION
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
467
176
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
468 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
469 msv.DATAVALUE YORDINATE, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
470 msv.PARAMETERID GROUP1, \
179
f2c76f35da5a Added missing Class Description Values to the Horizontal Profile Charts
Tim Englich <tim.englich@intevation.de>
parents: 176
diff changeset
471 MEDIAN.MESHPOINT.KPOSITION GROUP2, \
f2c76f35da5a Added missing Class Description Values to the Horizontal Profile Charts
Tim Englich <tim.englich@intevation.de>
parents: 176
diff changeset
472 msv.TIMEVALUE GROUP3, \
176
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
473 MEDIAN.MESHPOINT.JPOSITION , \
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
474 MEDIAN.MESHPOINT.IPOSITION \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
475 from MEDIAN.MESHLAYER ml, \
176
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
476 MEDIAN.MESHPOINT , \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
477 MEDIAN.MESH m, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
478 MEDIAN.MESHSCALARVALUE msv \
176
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
479 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
480 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
481 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
482 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
483 m.PARTIDMIN <= msv.PARTID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
484 m.PARTIDMAX >= msv.PARTID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
485 msv.PARAMETERID in (?) AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
486 msv.TIMEVALUE in (?) AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
487 m.OBJECTID = ? AND \
176
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
488 MEDIAN.MESHPOINT.FEATUREID in \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
489 ( select FEATUREID \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
490 from MEDIAN.MESHPOINT mp, \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
491 MEDIAN.MESH m \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
492 where m.OBJECTID = ? AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
493 mp.MESHID = m.MESHID AND \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
494 KPOSITION in ( ? ) and \
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
495 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
179
f2c76f35da5a Added missing Class Description Values to the Horizontal Profile Charts
Tim Englich <tim.englich@intevation.de>
parents: 176
diff changeset
496 order by msv.TIMEVALUE, \
f2c76f35da5a Added missing Class Description Values to the Horizontal Profile Charts
Tim Englich <tim.englich@intevation.de>
parents: 176
diff changeset
497 MEDIAN.MESHPOINT.KPOSITION, \
116
820238357bab Added Horizontal-Profile-Support for Meshes.
Tim Englich <tim.englich@intevation.de>
parents: 114
diff changeset
498 msv.PARAMETERID, \
176
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
499 MEDIAN.MESHPOINT.JPOSITION , \
bff7bbb7c6f0 Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart.
Tim Englich <tim.englich@intevation.de>
parents: 175
diff changeset
500 MEDIAN.MESHPOINT.IPOSITION
119
4841808819d9 Added the new FIS
Tim Englich <tim.englich@intevation.de>
parents: 116
diff changeset
501
http://dive4elements.wald.intevation.org