Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/src/test/ressources/queries.properties @ 116:820238357bab

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added Horizontal-Profile-Support for Meshes. Modify the Workflow for Horizontal-Profile-InstantaneousPoint gnv-artifacts/trunk@169 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Fri, 02 Oct 2009 08:07:00 +0000
parents d8d38a4dd965
children 4841808819d9
comparison
equal deleted inserted replaced
115:158e89c2263b 116:820238357bab
337 ############################################# 337 #############################################
338 ############################################# 338 #############################################
339 #### Horizontalprofil InstantaneousPoint #### 339 #### Horizontalprofil InstantaneousPoint ####
340 ############################################# 340 #############################################
341 ############################################# 341 #############################################
342 342 horizontalprofile_instantaneouspoint_vehicle = SELECT DISTINCT \
343 horizontalprofile_instantaneouspoint_cruise = SELECT \ 343 V.VEHICLEID KEY, \
344 CRUISEID KEY , \ 344 V.NAME VALUE \
345 NAME VALUE \ 345 FROM MEDIAN.VEHICLE V, \
346 FROM MEDIAN.CRUISE \ 346 MEDIAN.CRUISE C, \
347 WHERE NAME IS NOT NULL \ 347 MEDIAN.TRACK T, \
348 ORDER BY NAME 348 MEDIAN.SURVEYINFO S, \
349 MEDIAN.INSTANTANEOUSPOINT I, \
350 MEDIAN.MEASUREMENT M \
351 WHERE V.VEHICLEID = C.VEHICLEID AND \
352 C.CRUISEID = T.CRUISEID AND \
353 T.TRACKID = S.TRACKID AND \
354 S.SURVEYID = I.SURVEYID AND \
355 I.FEATUREID = M.FEATUREID AND \
356 M.SOURCEID = ? \
357 ORDER BY V.NAME
358 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \
359 C.CRUISEID KEY , \
360 C.NAME VALUE \
361 FROM MEDIAN.CRUISE C, \
362 MEDIAN.TRACK T, \
363 MEDIAN.SURVEYINFO S, \
364 MEDIAN.INSTANTANEOUSPOINT I, \
365 MEDIAN.MEASUREMENT M \
366 WHERE C.CRUISEID = T.CRUISEID AND \
367 T.TRACKID = S.TRACKID AND \
368 S.SURVEYID = I.SURVEYID AND \
369 I.FEATUREID = M.FEATUREID AND \
370 C.VEHICLEID = ? AND \
371 M.SOURCEID = ? AND \
372 C.NAME IS NOT NULL \
373 ORDER BY C.NAME
349 horizontalprofile_instantaneouspoint_track= SELECT \ 374 horizontalprofile_instantaneouspoint_track= SELECT \
350 TRACKID KEY , \ 375 T.TRACKID KEY , \
351 NAME VALUE \ 376 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \
352 FROM MEDIAN.TRACK \ 377 FROM MEDIAN.TRACK T \
353 WHERE CRUISEID = ? \ 378 WHERE T.CRUISEID = ? \
354 ORDER BY NAME 379 ORDER BY T.STARTDATE, \
380 T.ENDDATE, \
381 T.NAME
355 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \ 382 horizontalprofile_instantaneouspoint_surveyinfo = SELECT \
356 SURVEYID KEY , \ 383 SURVEYID KEY , \
357 DESCRIPTION VALUE \ 384 to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| DESCRIPTION VALUE \
358 FROM MEDIAN.SURVEYINFO \ 385 FROM MEDIAN.SURVEYINFO \
359 WHERE TRACKID = ? \ 386 WHERE TRACKID = ? \
360 ORDER BY DESCRIPTION 387 ORDER BY STARTDATE, \
388 ENDDATE, \
389 DESCRIPTION
361 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \ 390 horizontalprofile_instantaneouspoint_parameter = SELECT DISTINCT \
362 P.PARAMETERID KEY , \ 391 P.PARAMETERID KEY , \
363 P.GERMANNAME VALUE \ 392 P.GERMANNAME VALUE \
364 FROM MEDIAN.PARAMETER P , \ 393 FROM MEDIAN.PARAMETER P , \
365 MEDIAN.MEASUREMENT M , \ 394 MEDIAN.MEASUREMENT M , \
393 M.ZLOCATION IN (?) AND \ 422 M.ZLOCATION IN (?) AND \
394 MSV.PARAMETERID in (?) \ 423 MSV.PARAMETERID in (?) \
395 ORDER BY IP.TIMEVALUE, \ 424 ORDER BY IP.TIMEVALUE, \
396 MSV.PARAMETERID, \ 425 MSV.PARAMETERID, \
397 M.ZLOCATION 426 M.ZLOCATION
427
428 #############################################
429 #############################################
430 ########### Horizontalprofil MESH ###########
431 #############################################
432 #############################################
433 horizontalprofile_meshpoint_depth = SELECT DISTINCT \
434 mp.KPOSITION KEY, \
435 -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \
436 from MEDIAN.MESHLAYER ml, \
437 MEDIAN.MESHPOINT mp \
438 where ml.KPOSITION = mp.KPOSITION and \
439 ml.MESHID = mp.MESHID and \
440 mp.FEATUREID in \
441 ( select FEATUREID \
442 from MEDIAN.MESHPOINT mp, \
443 MEDIAN.MESH m \
444 where m.OBJECTID = ? AND \
445 mp.MESHID = m.MESHID AND \
446 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
447 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) \
448 order by mp.KPOSITION
449
450 horizontalprofile_mesh_chart_data = select mp.IPOSITION XORDINATE_XCOORD, mp.JPOSITION XORDINATE_YCOORD, \
451 msv.DATAVALUE YORDINATE, \
452 msv.PARAMETERID GROUP1, \
453 msv.TIMEVALUE GROUP2, \
454 mp.KPOSITION GROUP3 \
455 from MEDIAN.MESHLAYER ml, \
456 MEDIAN.MESHPOINT mp, \
457 MEDIAN.MESH m, \
458 MEDIAN.MESHSCALARVALUE msv \
459 where msv.FEATUREID = mp. FEATUREID AND \
460 ml.KPOSITION = mp.KPOSITION and \
461 ml.MESHID = mp.MESHID and \
462 m.MESHID = mp.MESHID AND \
463 m.PARTIDMIN <= msv.PARTID AND \
464 m.PARTIDMAX >= msv.PARTID AND \
465 msv.PARAMETERID in (?) AND \
466 msv.TIMEVALUE in (?) AND \
467 m.OBJECTID = ? AND \
468 mp.FEATUREID in \
469 ( select FEATUREID \
470 from MEDIAN.MESHPOINT mp, \
471 MEDIAN.MESH m \
472 where m.OBJECTID = ? AND \
473 mp.MESHID = m.MESHID AND \
474 KPOSITION in ( ? ) and \
475 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \
476 order by mp.KPOSITION, \
477 msv.TIMEVALUE, \
478 msv.PARAMETERID, \
479 mp.JPOSITION , \
480 mp.IPOSITION
481
http://dive4elements.wald.intevation.org