Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/src/test/ressources/queries.properties @ 120:5134266f00e7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Resolved gnv/issue21 No NPE will be thrown. Add Dummydata for Calculating the distance between two MeasurmentPoints. gnv-artifacts/trunk@190 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 06 Oct 2009 10:58:47 +0000
parents 4841808819d9
children 7be22e76c270
comparison
equal deleted inserted replaced
119:4841808819d9 120:5134266f00e7
419 FROM MEDIAN.MEASUREMENT M , \ 419 FROM MEDIAN.MEASUREMENT M , \
420 MEDIAN.INSTANTANEOUSPOINT IP \ 420 MEDIAN.INSTANTANEOUSPOINT IP \
421 WHERE M.FEATUREID = IP.FEATUREID AND \ 421 WHERE M.FEATUREID = IP.FEATUREID AND \
422 IP.SURVEYID = ? \ 422 IP.SURVEYID = ? \
423 ORDER BY M.ZLOCATION 423 ORDER BY M.ZLOCATION
424 horizontalprofile_instantaneouspoint_chart_data = SELECT M.XLOCATION XORDINATE_XCOORD , \ 424 horizontalprofile_instantaneouspoint_chart_data = SELECT MSV.OBJECTID XORDINATE_XCOORD , \
425 M.YLOCATION XORDINATE_YCOORD , \ 425 MSV.OBJECTID XORDINATE_YCOORD , \
426 MSV.DATAVALUE YORDINATE , \ 426 MSV.DATAVALUE YORDINATE , \
427 MSV.PARAMETERID GROUP1 , \ 427 MSV.PARAMETERID GROUP1 , \
428 IP.TIMEVALUE GROUP2 , \ 428 ZLOCATION GROUP2 , \
429 ZLOCATION GROUP3 \ 429 1 GROUP3 \
430 FROM MEDIAN.INSTANTANEOUSPOINT IP, \ 430 FROM MEDIAN.INSTANTANEOUSPOINT IP, \
431 MEDIAN.MEASUREMENT M, \ 431 MEDIAN.MEASUREMENT M, \
432 MEDIAN.MEASUREDSCALARVALUE MSV \ 432 MEDIAN.MEASUREDSCALARVALUE MSV \
433 WHERE IP.FEATUREID = M.FEATUREID AND \ 433 WHERE IP.FEATUREID = M.FEATUREID AND \
434 M.MEASUREMENTID = MSV.MEASUREMENTID AND \ 434 M.MEASUREMENTID = MSV.MEASUREMENTID AND \
435 IP.SURVEYID = ? AND \ 435 IP.SURVEYID = ? AND \
436 M.ZLOCATION IN (?) AND \ 436 M.ZLOCATION IN (?) AND \
437 MSV.PARAMETERID in (?) \ 437 MSV.PARAMETERID in (?) \
438 ORDER BY M.ZLOCATION, \ 438 ORDER BY MSV.PARAMETERID, \
439 MSV.PARAMETERID, \ 439 M.ZLOCATION
440 IP.TIMEVALUE 440
441
442 ############################################# 441 #############################################
443 ############################################# 442 #############################################
444 ########### Horizontalprofil MESH ########### 443 ########### Horizontalprofil MESH ###########
445 ############################################# 444 #############################################
446 ############################################# 445 #############################################
490 order by mp.KPOSITION, \ 489 order by mp.KPOSITION, \
491 msv.TIMEVALUE, \ 490 msv.TIMEVALUE, \
492 msv.PARAMETERID, \ 491 msv.PARAMETERID, \
493 mp.JPOSITION , \ 492 mp.JPOSITION , \
494 mp.IPOSITION 493 mp.IPOSITION
495
496 494
http://dive4elements.wald.intevation.org