Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 1043:d955571cdf2a
Added queries for Meshes using Vectorvalues for TimeSeries.
gnv-artifacts/trunk@1115 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 21 May 2010 08:28:49 +0000 |
| parents | 07b829c06981 |
| children | 3fe08ea3f2b6 |
comparison
equal
deleted
inserted
replaced
| 1042:07b829c06981 | 1043:d955571cdf2a |
|---|---|
| 335 order by MEDIAN.MESHPOINT.FEATUREID, \ | 335 order by MEDIAN.MESHPOINT.FEATUREID, \ |
| 336 msv.FEATUREID, \ | 336 msv.FEATUREID, \ |
| 337 msv.TIMEVALUE, \ | 337 msv.TIMEVALUE, \ |
| 338 msv.PARAMETERID | 338 msv.PARAMETERID |
| 339 | 339 |
| 340 ############################################# | |
| 341 ############################################# | |
| 342 ########## Zeitserie Mesh ############## | |
| 343 ########## Vektordaten ############## | |
| 344 ############################################# | |
| 345 ############################################# | |
| 346 | |
| 347 timeseries_mesh_parameter_vector=SELECT DISTINCT \ | |
| 348 P.PARAMETERID KEY, \ | |
| 349 P.GERMANNAME || ' ['|| P.UNIT ||']' VALUE, \ | |
| 350 P.GERMANNAME \ | |
| 351 FROM MEDIAN.PARAMETER P, \ | |
| 352 MEDIAN.MESHVECTORVALUE MVV, \ | |
| 353 MEDIAN.MESH M \ | |
| 354 WHERE M.OBJECTID = ? AND \ | |
| 355 MVV.PARTID >= M.PARTIDMIN AND \ | |
| 356 MVV.PARTID <= M.PARTIDMAX AND \ | |
| 357 MVV.PARAMETERID = P.PARAMETERID \ | |
| 358 ORDER BY P.GERMANNAME | |
| 359 | |
| 360 timeseries_mesh_interval_vector=SELECT /*+ parallel(TIMEVALUE,5) */ \ | |
| 361 MIN(TIMEVALUE) MIN, \ | |
| 362 MAX(TIMEVALUE) MAX \ | |
| 363 FROM MEDIAN.MESHVECTORVALUE MVV, \ | |
| 364 MEDIAN.MESH M \ | |
| 365 WHERE M.OBJECTID = ? AND \ | |
| 366 MVV.PARTID >= M.PARTIDMIN AND \ | |
| 367 MVV.PARTID <= M.PARTIDMAX AND \ | |
| 368 MVV.PARAMETERID IN (?) | |
| 369 | |
| 370 timeseries_mesh_chart_data_vector =SELECT /*+ parallel(TIMEVALUE,10) */ \ | |
| 371 MVV.TIMEVALUE XORDINATE, \ | |
| 372 MVV.XCOMPONENT, \ | |
| 373 MVV.YCOMPONENT, \ | |
| 374 MVV.ZCOMPONENT, \ | |
| 375 MVV.SPEED, \ | |
| 376 MVV.DIRECTION, \ | |
| 377 MVV.PARAMETERID GROUP1, \ | |
| 378 MVV.FEATUREID GROUP2, \ | |
| 379 MP.FEATUREID GROUP3, \ | |
| 380 -1 GAPID \ | |
| 381 FROM MEDIAN.MESHCURRENTVALUE MVV, \ | |
| 382 MEDIAN.MESHPOINT MP, \ | |
| 383 MEDIAN.MESH M \ | |
| 384 WHERE (M.OBJECTID = ? AND \ | |
| 385 MVV.PARTID >= M.PARTIDMIN AND \ | |
| 386 MVV.PARTID <= M.PARTIDMAX ) AND \ | |
| 387 MVV.FEATUREID = MP.FEATUREID AND \ | |
| 388 MVV.PARAMETERID in ( ? ) AND \ | |
| 389 MP.FEATUREID in ( ? ) AND \ | |
| 390 MVV.TIMEVALUE >= ? AND \ | |
| 391 MVV.TIMEVALUE <= ? \ | |
| 392 ORDER BY MP.FEATUREID, \ | |
| 393 MVV.FEATUREID, \ | |
| 394 MVV.PARAMETERID, \ | |
| 395 MVV.TIMEVALUE | |
| 396 | |
| 397 timeseries_mesh_odv_data_vector = SELECT /*+ parallel(timevalue,10) */ \ | |
| 398 SI.NAME CRUISE, \ | |
| 399 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ | |
| 400 '*' TYPE, \ | |
| 401 ST_ASTEXT(SHAPE), \ | |
| 402 0 BOTDEPTH, \ | |
| 403 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ | |
| 404 MVV.TIMEVALUE, \ | |
| 405 MVV.XCOMPONENT, \ | |
| 406 MVV.YCOMPONENT, \ | |
| 407 MVV.ZCOMPONENT, \ | |
| 408 MVV.SPEED, \ | |
| 409 MVV.DIRECTION, \ | |
| 410 MVV.PARAMETERID PARAMETER, \ | |
| 411 '1' QF \ | |
| 412 FROM MEDIAN.MESHCURRENTVALUE MVV, \ | |
| 413 MEDIAN.MESHPOINT, \ | |
| 414 MEDIAN.MESH M, \ | |
| 415 MEDIAN.SOURCEINFO SI, \ | |
| 416 MEDIAN.MESHLAYER ML \ | |
| 417 WHERE (M.OBJECTID = ? AND \ | |
| 418 MVV.PARTID >= M.PARTIDMIN AND \ | |
| 419 MVV.PARTID <= M.PARTIDMAX ) AND \ | |
| 420 M.SOURCEID = SI.SOURCEID AND \ | |
| 421 ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 422 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \ | |
| 423 MVV.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ | |
| 424 MVV.PARAMETERID in (? ) AND \ | |
| 425 MEDIAN.MESHPOINT.FEATUREID in ( ? ) AND \ | |
| 426 MVV.TIMEVALUE >= ? AND \ | |
| 427 MVV.TIMEVALUE <= ? \ | |
| 428 ORDER BY MEDIAN.MESHPOINT.FEATUREID, \ | |
| 429 MVV.FEATUREID, \ | |
| 430 MVV.TIMEVALUE, \ | |
| 431 MVV.PARAMETERID | |
| 340 | 432 |
| 341 ############################################# | 433 ############################################# |
| 342 ############################################# | 434 ############################################# |
| 343 ########## Vertikalprofil ############## | 435 ########## Vertikalprofil ############## |
| 344 ############################################# | 436 ############################################# |
| 454 M.ZLOCATION <= ? \ | 546 M.ZLOCATION <= ? \ |
| 455 ORDER BY TSV.MEASUREMENTID, \ | 547 ORDER BY TSV.MEASUREMENTID, \ |
| 456 TSV.TIMESERIESID, \ | 548 TSV.TIMESERIESID, \ |
| 457 TSV.TIMEVALUE, \ | 549 TSV.TIMEVALUE, \ |
| 458 TS.PARAMETERID | 550 TS.PARAMETERID |
| 459 | 551 |
| 460 | |
| 461 ############################################# | 552 ############################################# |
| 462 ############################################# | 553 ############################################# |
| 463 ########## Vertikalprofil Mesh ############## | 554 ########## Vertikalprofil Mesh ############## |
| 464 ############################################# | 555 ############################################# |
| 465 ############################################# | 556 ############################################# |