Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/src/test/ressources/queries.properties @ 176:bff7bbb7c6f0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add Spatial-Query-Syntax to HorizontalProfile-Queries and use Geometry to Calculate the X-Ordinate of the Chart. gnv-artifacts/trunk@219 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Wed, 14 Oct 2009 10:49:35 +0000
parents 14263534255b
children f2c76f35da5a
comparison
equal deleted inserted replaced
175:14263534255b 176:bff7bbb7c6f0
423 FROM MEDIAN.MEASUREMENT M , \ 423 FROM MEDIAN.MEASUREMENT M , \
424 MEDIAN.INSTANTANEOUSPOINT IP \ 424 MEDIAN.INSTANTANEOUSPOINT IP \
425 WHERE M.FEATUREID = IP.FEATUREID AND \ 425 WHERE M.FEATUREID = IP.FEATUREID AND \
426 IP.SURVEYID = ? \ 426 IP.SURVEYID = ? \
427 ORDER BY M.ZLOCATION 427 ORDER BY M.ZLOCATION
428 horizontalprofile_instantaneouspoint_chart_data = SELECT MSV.OBJECTID XORDINATE_XCOORD , \ 428 horizontalprofile_instantaneouspoint_chart_data = SELECT ST_ASTEXT(SHAPE) , \
429 MSV.OBJECTID XORDINATE_YCOORD , \ 429 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE TIME , \
430 MSV.DATAVALUE YORDINATE , \ 430 MSV.DATAVALUE YORDINATE , \
431 MSV.PARAMETERID GROUP1 , \ 431 MSV.PARAMETERID GROUP1 , \
432 ZLOCATION GROUP2 , \ 432 ZLOCATION GROUP2 , \
433 1 GROUP3 \ 433 1 GROUP3 \
434 FROM MEDIAN.INSTANTANEOUSPOINT IP, \ 434 FROM MEDIAN.INSTANTANEOUSPOINT, \
435 MEDIAN.MEASUREMENT M, \ 435 MEDIAN.MEASUREMENT M, \
436 MEDIAN.MEASUREDSCALARVALUE MSV \ 436 MEDIAN.MEASUREDSCALARVALUE MSV \
437 WHERE IP.FEATUREID = M.FEATUREID AND \ 437 WHERE MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \
438 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ 438 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
439 IP.SURVEYID = ? AND \ 439 MEDIAN.INSTANTANEOUSPOINT.SURVEYID = ? AND \
440 M.ZLOCATION IN (?) AND \ 440 M.ZLOCATION IN (?) AND \
441 MSV.PARAMETERID in (?) \ 441 MSV.PARAMETERID in (?) \
442 ORDER BY MSV.PARAMETERID, \ 442 ORDER BY MSV.PARAMETERID, \
443 M.ZLOCATION 443 M.ZLOCATION, \
444 MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE
444 445
445 ############################################# 446 #############################################
446 ############################################# 447 #############################################
447 ########### Horizontalprofil MESH ########### 448 ########### Horizontalprofil MESH ###########
448 ############################################# 449 #############################################
462 mp.MESHID = m.MESHID AND \ 463 mp.MESHID = m.MESHID AND \
463 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \ 464 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
464 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \ 465 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
465 order by mp.KPOSITION 466 order by mp.KPOSITION
466 467
467 horizontalprofile_mesh_chart_data = select mp.IPOSITION XORDINATE_XCOORD, mp.JPOSITION XORDINATE_YCOORD, \ 468 horizontalprofile_mesh_chart_data = SELECT ST_ASTEXT(SHAPE), \
468 msv.DATAVALUE YORDINATE, \ 469 msv.DATAVALUE YORDINATE, \
469 msv.PARAMETERID GROUP1, \ 470 msv.PARAMETERID GROUP1, \
470 msv.TIMEVALUE GROUP2, \ 471 msv.TIMEVALUE GROUP2, \
471 mp.KPOSITION GROUP3 \ 472 MEDIAN.MESHPOINT.KPOSITION GROUP3, \
473 MEDIAN.MESHPOINT.JPOSITION , \
474 MEDIAN.MESHPOINT.IPOSITION \
472 from MEDIAN.MESHLAYER ml, \ 475 from MEDIAN.MESHLAYER ml, \
473 MEDIAN.MESHPOINT mp, \ 476 MEDIAN.MESHPOINT , \
474 MEDIAN.MESH m, \ 477 MEDIAN.MESH m, \
475 MEDIAN.MESHSCALARVALUE msv \ 478 MEDIAN.MESHSCALARVALUE msv \
476 where msv.FEATUREID = mp. FEATUREID AND \ 479 where msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
477 ml.KPOSITION = mp.KPOSITION and \ 480 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
478 ml.MESHID = mp.MESHID and \ 481 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
479 m.MESHID = mp.MESHID AND \ 482 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
480 m.PARTIDMIN <= msv.PARTID AND \ 483 m.PARTIDMIN <= msv.PARTID AND \
481 m.PARTIDMAX >= msv.PARTID AND \ 484 m.PARTIDMAX >= msv.PARTID AND \
482 msv.PARAMETERID in (?) AND \ 485 msv.PARAMETERID in (?) AND \
483 msv.TIMEVALUE in (?) AND \ 486 msv.TIMEVALUE in (?) AND \
484 m.OBJECTID = ? AND \ 487 m.OBJECTID = ? AND \
485 mp.FEATUREID in \ 488 MEDIAN.MESHPOINT.FEATUREID in \
486 ( select FEATUREID \ 489 ( select FEATUREID \
487 from MEDIAN.MESHPOINT mp, \ 490 from MEDIAN.MESHPOINT mp, \
488 MEDIAN.MESH m \ 491 MEDIAN.MESH m \
489 where m.OBJECTID = ? AND \ 492 where m.OBJECTID = ? AND \
490 mp.MESHID = m.MESHID AND \ 493 mp.MESHID = m.MESHID AND \
491 KPOSITION in ( ? ) and \ 494 KPOSITION in ( ? ) and \
492 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ 495 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
493 order by mp.KPOSITION, \ 496 order by MEDIAN.MESHPOINT.KPOSITION, \
494 msv.TIMEVALUE, \ 497 msv.TIMEVALUE, \
495 msv.PARAMETERID, \ 498 msv.PARAMETERID, \
496 mp.JPOSITION , \ 499 MEDIAN.MESHPOINT.JPOSITION , \
497 mp.IPOSITION 500 MEDIAN.MESHPOINT.IPOSITION
498 501
http://dive4elements.wald.intevation.org