Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/doc/conf/queries.properties @ 213:c0a798299efc

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Integration of the selection of the min and max Layer used in Verticalprofiles of Meshes. issue61 gnv-artifacts/trunk@269 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 27 Oct 2009 12:03:32 +0000
parents 310874d3573f
children 9db263ee2678
comparison
equal deleted inserted replaced
212:3dac84194db4 213:c0a798299efc
232 FROM MEDIAN.MESH \ 232 FROM MEDIAN.MESH \
233 WHERE OBJECTID = ?) AND \ 233 WHERE OBJECTID = ?) AND \
234 KPOSITION = 1 AND \ 234 KPOSITION = 1 AND \
235 INTERSECTS(SHAPE,"?") 235 INTERSECTS(SHAPE,"?")
236 236
237 verticalprofile_mesh_mindepth = SELECT MP.KPOSITION KEY, \
238 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \
239 from MEDIAN.MESHLAYER ML, \
240 MEDIAN.MESHPOINT MP, \
241 MEDIAN.MESH M \
242 WHERE ML.KPOSITION = MP.KPOSITION AND \
243 ML.MESHID = MP.MESHID AND \
244 M.OBJECTID = ? AND \
245 MP.MESHID = M.MESHID AND \
246 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
247 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) \
248 ORDER BY ML.UPPERZLOCATION DESC
249
250 verticalprofile_mesh_maxdepth = SELECT MP.KPOSITION KEY, \
251 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \
252 from MEDIAN.MESHLAYER ML, \
253 MEDIAN.MESHPOINT MP, \
254 MEDIAN.MESH M \
255 WHERE ML.KPOSITION = MP.KPOSITION AND \
256 ML.MESHID = MP.MESHID AND \
257 M.OBJECTID = ? AND \
258 MP.MESHID = M.MESHID AND \
259 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
260 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) AND \
261 MP.KPOSITION < ? \
262 ORDER BY ML.UPPERZLOCATION DESC
263
237 verticalprofile_mesh_parameter=SELECT distinct \ 264 verticalprofile_mesh_parameter=SELECT distinct \
238 p.PARAMETERID KEY , \ 265 p.PARAMETERID KEY , \
239 p.GERMANNAME VALUE \ 266 p.GERMANNAME VALUE \
240 from MEDIAN.PARAMETER p, \ 267 from MEDIAN.PARAMETER p, \
241 MEDIAN.MESHSCALARVALUE msc, \ 268 MEDIAN.MESHSCALARVALUE msc, \
279 from MEDIAN.MESHPOINT mp, \ 306 from MEDIAN.MESHPOINT mp, \
280 MEDIAN.MESH m \ 307 MEDIAN.MESH m \
281 where m.OBJECTID = ? AND \ 308 where m.OBJECTID = ? AND \
282 mp.MESHID = m.MESHID AND \ 309 mp.MESHID = m.MESHID AND \
283 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ 310 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
284 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ 311 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) AND \
312 mp.KPOSITION <= ? AND \
313 mp.KPOSITION >= ? \
285 order by msv.PARAMETERID, \ 314 order by msv.PARAMETERID, \
286 msv.TIMEVALUE, \ 315 msv.TIMEVALUE, \
287 ml.UPPERZLOCATION 316 ml.UPPERZLOCATION
288 317
289 ############################################# 318 #############################################
558 order by msv.TIMEVALUE, \ 587 order by msv.TIMEVALUE, \
559 msv.PARAMETERID, \ 588 msv.PARAMETERID, \
560 MEDIAN.MESHPOINT.JPOSITION , \ 589 MEDIAN.MESHPOINT.JPOSITION , \
561 MEDIAN.MESHPOINT.IPOSITION, \ 590 MEDIAN.MESHPOINT.IPOSITION, \
562 MEDIAN.MESHPOINT.KPOSITION 591 MEDIAN.MESHPOINT.KPOSITION
563
564
565 select mp.FEATUREID KEY, 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE from MEDIAN.MESHLAYER ml, MEDIAN.MESHPOINT mp, MEDIAN.MESH M where ml.KPOSITION = mp.KPOSITION and ml.MESHID = mp.MESHID and m.OBJECTID = 3 AND mp.MESHID = m.MESHID AND IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = 2003771) and JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = 2003771) order by ml.UPPERZLOCATION desc
http://dive4elements.wald.intevation.org