Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/doc/conf/queries.properties @ 211:310874d3573f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Minimum and Maximum Depth should be entered by the User issue31 gnv-artifacts/trunk@267 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Mon, 26 Oct 2009 15:51:36 +0000
parents d5cef9f17525
children c0a798299efc
comparison
equal deleted inserted replaced
210:7d1f9219d163 211:310874d3573f
167 where ts.PARAMETERID = p.PARAMETERID and \ 167 where ts.PARAMETERID = p.PARAMETERID and \
168 ts.TIMESERIESID = tsv.TIMESERIESID and \ 168 ts.TIMESERIESID = tsv.TIMESERIESID and \
169 m.MEASUREMENTID = tsv.MEASUREMENTID and \ 169 m.MEASUREMENTID = tsv.MEASUREMENTID and \
170 m.FEATUREID = ? \ 170 m.FEATUREID = ? \
171 ORDER BY p.GERMANNAME 171 ORDER BY p.GERMANNAME
172 172
173 verticalprofile_minmaxdepth= SELECT min(M.ZLOCATION) MIN, \
174 max(M.ZLOCATION) MAX \
175 FROM MEDIAN.MEASUREMENT M, \
176 MEDIAN.TIMESERIES TS, \
177 MEDIAN.TIMESERIESVALUE TSV \
178 WHERE TS.TIMESERIESID = TSV.TIMESERIESID and \
179 M.MEASUREMENTID = TSV.MEASUREMENTID and \
180 M.FEATUREID = ? and \
181 TS.PARAMETERID IN ( ? )
182
173 verticalprofile_date=select distinct \ 183 verticalprofile_date=select distinct \
174 tsv.TIMEVALUE KEY, \ 184 tsv.TIMEVALUE KEY, \
175 tsv.TIMEVALUE VALUE \ 185 tsv.TIMEVALUE VALUE \
176 from MEDIAN.TIMESERIES ts , \ 186 from MEDIAN.TIMESERIES ts , \
177 MEDIAN.TIMESERIESVALUE tsv, \ 187 MEDIAN.TIMESERIESVALUE tsv, \
180 m.MEASUREMENTID = tsv.MEASUREMENTID and \ 190 m.MEASUREMENTID = tsv.MEASUREMENTID and \
181 m.FEATUREID = ? and \ 191 m.FEATUREID = ? and \
182 ts.PARAMETERID IN ( ? ) \ 192 ts.PARAMETERID IN ( ? ) \
183 order by tsv.TIMEVALUE 193 order by tsv.TIMEVALUE
184 194
185 verticalprofile_chart_data= SELECT m.ZLOCATION XORDINATE, \ 195 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \
186 tsv.DATAVALUE YORDINATE, \ 196 TSV.DATAVALUE YORDINATE, \
187 ts.PARAMETERID GROUP1, \ 197 TS.PARAMETERID GROUP1, \
188 tsv.TIMEVALUE GROUP2, \ 198 TSV.TIMEVALUE GROUP2, \
189 1 GROUP3 \ 199 1 GROUP3 \
190 from MEDIAN.TIMESERIES ts, \ 200 from MEDIAN.TIMESERIES TS, \
191 MEDIAN.TIMESERIESVALUE tsv, \ 201 MEDIAN.TIMESERIESVALUE TSV, \
192 MEDIAN.MEASUREMENT m \ 202 MEDIAN.MEASUREMENT M \
193 where ts.TIMESERIESID = tsv.TIMESERIESID and \ 203 where TS.TIMESERIESID = TSV.TIMESERIESID AND \
194 m.MEASUREMENTID = tsv.MEASUREMENTID and \ 204 M.MEASUREMENTID = TSV.MEASUREMENTID AND \
195 m.FEATUREID = ? and \ 205 M.FEATUREID = ? AND \
196 ts.PARAMETERID IN ( ? ) AND \ 206 TS.PARAMETERID IN ( ? ) AND \
197 tsv.TIMEVALUE IN (?) \ 207 TSV.TIMEVALUE IN (?) AND \
198 ORDER BY tsv.TIMEVALUE , \ 208 M.ZLOCATION >= ? AND \
199 tsv.TIMESERIESID , \ 209 M.ZLOCATION <= ? \
200 ts.PARAMETERID , \ 210 ORDER BY TSV.TIMEVALUE , \
201 tsv.TIMEVALUE 211 TSV.TIMESERIESID , \
212 TS.PARAMETERID , \
213 TSV.TIMEVALUE
202 214
203 ############################################# 215 #############################################
204 ############################################# 216 #############################################
205 ########## Vertikalprofil Mesh ############## 217 ########## Vertikalprofil Mesh ##############
206 ############################################# 218 #############################################
316 WHERE IP.FEATUREID = M.FEATUREID AND \ 328 WHERE IP.FEATUREID = M.FEATUREID AND \
317 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ 329 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
318 MSV.PARAMETERID = P.PARAMETERID AND \ 330 MSV.PARAMETERID = P.PARAMETERID AND \
319 IP.FEATUREID = ? \ 331 IP.FEATUREID = ? \
320 ORDER BY P.GERMANNAME 332 ORDER BY P.GERMANNAME
321 333
334 verticalprofile_instantaneouspoint_minmaxdepth = SELECT min(M.ZLOCATION) MIN, \
335 max(M.ZLOCATION) MAX \
336 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
337 MEDIAN.MEASUREMENT M, \
338 MEDIAN.MEASUREDSCALARVALUE MSV \
339 WHERE IP.FEATUREID = M.FEATUREID AND \
340 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
341 IP.FEATUREID = ? AND \
342 MSV.PARAMETERID in (?)
343
322 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \ 344 verticalprofile_instantaneouspoint_chart_data = SELECT M.ZLOCATION XORDINATE, \
323 MSV.DATAVALUE YORDINATE, \ 345 MSV.DATAVALUE YORDINATE, \
324 MSV.PARAMETERID GROUP1, \ 346 MSV.PARAMETERID GROUP1, \
325 IP.TIMEVALUE GROUP2, \ 347 IP.TIMEVALUE GROUP2, \
326 1 GROUP3 \ 348 1 GROUP3 \
328 MEDIAN.MEASUREMENT M, \ 350 MEDIAN.MEASUREMENT M, \
329 MEDIAN.MEASUREDSCALARVALUE MSV \ 351 MEDIAN.MEASUREDSCALARVALUE MSV \
330 WHERE IP.FEATUREID = M.FEATUREID AND \ 352 WHERE IP.FEATUREID = M.FEATUREID AND \
331 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ 353 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
332 IP.FEATUREID = ? AND \ 354 IP.FEATUREID = ? AND \
333 MSV.PARAMETERID in (?) \ 355 MSV.PARAMETERID in (?) AND \
356 M.ZLOCATION >= ? AND \
357 M.ZLOCATION <= ? \
334 ORDER BY IP.TIMEVALUE, \ 358 ORDER BY IP.TIMEVALUE, \
335 MSV.PARAMETERID, \ 359 MSV.PARAMETERID, \
336 M.ZLOCATION 360 M.ZLOCATION
337 361
338 ############################################# 362 #############################################
http://dive4elements.wald.intevation.org