Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/doc/conf/queries.properties @ 205:6e7952fd1744

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added the support to Display the Time and the position of an Measurement in an VerticalProfile of Type Instantaneous Point gnv-artifacts/trunk@261 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Thu, 22 Oct 2009 14:02:30 +0000
parents b66e8a6f3907
children 01ac348ac4a4
comparison
equal deleted inserted replaced
204:734ac082c8d1 205:6e7952fd1744
311 I.POINTSPEC = 4 AND \ 311 I.POINTSPEC = 4 AND \
312 I.FEATUREID = M.FEATUREID AND \ 312 I.FEATUREID = M.FEATUREID AND \
313 M.SOURCEID= ? \ 313 M.SOURCEID= ? \
314 ORDER BY S.DESCRIPTION 314 ORDER BY S.DESCRIPTION
315 315
316 verticalprofile_instantaneouspoint_point = SELECT DISTINCT \ 316 verticalprofile_instantaneouspoint_point = SELECT \
317 I.FEATUREID KEY, \ 317 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
318 to_char(I.TIMEVALUE,'DD.MM.YYYY HH24:MI') || ' - '|| I.SHAPE VALUE, \ 318 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \
319 I.TIMEVALUE \ 319 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE, \
320 FROM MEDIAN.INSTANTANEOUSPOINT I, \ 320 ST_ASTEXT(SHAPE) \
321 FROM MEDIAN.INSTANTANEOUSPOINT, \
321 MEDIAN.MEASUREMENT M \ 322 MEDIAN.MEASUREMENT M \
322 WHERE I.SERIESID = ? AND \ 323 WHERE MEDIAN.INSTANTANEOUSPOINT.SERIESID = ? AND \
323 I.POINTSPEC = 4 AND \ 324 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \
324 I.FEATUREID = M.FEATUREID AND \ 325 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
325 M.SOURCEID = ? \ 326 M.SOURCEID = ? \
326 ORDER BY I.TIMEVALUE 327 ORDER BY MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \
328 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
327 329
328 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ 330 verticalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
329 P.PARAMETERID KEY , \ 331 P.PARAMETERID KEY , \
330 P.GERMANNAME VALUE \ 332 P.GERMANNAME VALUE \
331 FROM MEDIAN.PARAMETER P, \ 333 FROM MEDIAN.PARAMETER P, \
386 WHERE C.CRUISEID = T.CRUISEID AND \ 388 WHERE C.CRUISEID = T.CRUISEID AND \
387 T.TRACKID = S.TRACKID AND \ 389 T.TRACKID = S.TRACKID AND \
388 S.SURVEYID = I.SURVEYID AND \ 390 S.SURVEYID = I.SURVEYID AND \
389 I.FEATUREID = M.FEATUREID AND \ 391 I.FEATUREID = M.FEATUREID AND \
390 C.VEHICLEID = ? AND \ 392 C.VEHICLEID = ? AND \
391 M.SOURCEID = ? AND \ 393 M.SOURCEID = ? \
392 C.NAME IS NOT NULL \
393 ORDER BY C.NAME 394 ORDER BY C.NAME
394 horizontalprofile_instantaneouspoint_track= SELECT \ 395 horizontalprofile_instantaneouspoint_track= SELECT \
395 T.TRACKID KEY , \ 396 T.TRACKID KEY , \
396 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \ 397 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \
397 FROM MEDIAN.TRACK T \ 398 FROM MEDIAN.TRACK T \
542 from MEDIAN.MESHPOINT mp, \ 543 from MEDIAN.MESHPOINT mp, \
543 MEDIAN.MESH m \ 544 MEDIAN.MESH m \
544 where m.OBJECTID = ? AND \ 545 where m.OBJECTID = ? AND \
545 mp.MESHID = m.MESHID AND \ 546 mp.MESHID = m.MESHID AND \
546 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ 547 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
547 order by msv.TIMEVALUE, \ 548 order by msv.TIMEVALUE, \
548 msv.PARAMETERID, \ 549 msv.PARAMETERID, \
549 MEDIAN.MESHPOINT.JPOSITION , \ 550 MEDIAN.MESHPOINT.JPOSITION , \
550 MEDIAN.MESHPOINT.IPOSITION, \ 551 MEDIAN.MESHPOINT.IPOSITION, \
551 MEDIAN.MESHPOINT.KPOSITION 552 MEDIAN.MESHPOINT.KPOSITION
552
http://dive4elements.wald.intevation.org