comparison gnv-artifacts/doc/conf/queries.properties @ 241:8500529d82af

Added ODV-Export to VerticalProfiles gnv-artifacts/trunk@309 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Mon, 09 Nov 2009 15:24:41 +0000
parents 76897b73db4e
children 5925739d25ac
comparison
equal deleted inserted replaced
240:76897b73db4e 241:8500529d82af
434 mp.KPOSITION <= ? AND \ 434 mp.KPOSITION <= ? AND \
435 mp.KPOSITION >= ? \ 435 mp.KPOSITION >= ? \
436 order by msv.PARAMETERID, \ 436 order by msv.PARAMETERID, \
437 msv.TIMEVALUE, \ 437 msv.TIMEVALUE, \
438 ml.UPPERZLOCATION 438 ml.UPPERZLOCATION
439
440 verticalprofile_mesh_odv_data=select SI.NAME CRUISE, \
441 m.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \
442 '*' TYPE, \
443 ST_ASTEXT(SHAPE), \
444 0 BOTDEPTH, \
445 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \
446 msv.DATAVALUE , \
447 msv.PARAMETERID PARAMETER, \
448 msv.TIMEVALUE , \
449 from MEDIAN.MESHLAYER ml, \
450 MEDIAN.MESHPOINT, \
451 MEDIAN.MESH m, \
452 MEDIAN.MESHSCALARVALUE msv, \
453 MEDIAN.SOURCEINFO SI, \
454 where m.SOURCEID = SI.SOURCEID AND \
455 msv.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \
456 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
457 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
458 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
459 m.PARTIDMIN <= msv.PARTID AND \
460 m.PARTIDMAX >= msv.PARTID AND \
461 msv.PARAMETERID in (?) AND \
462 msv.TIMEVALUE in (?) AND \
463 m.OBJECTID = ? AND \
464 MEDIAN.MESHPOINT.FEATUREID in \
465 ( select FEATUREID \
466 from MEDIAN.MESHPOINT mp, \
467 MEDIAN.MESH m \
468 where m.OBJECTID = ? AND \
469 mp.MESHID = m.MESHID AND \
470 IPOSITION = (select IPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?) and \
471 JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = ?)) AND \
472 MEDIAN.MESHPOINT.KPOSITION <= ? AND \
473 MEDIAN.MESHPOINT.KPOSITION >= ? \
474 order by msv.PARAMETERID, \
475 msv.TIMEVALUE, \
476 ml.UPPERZLOCATION
439 477
440 ############################################# 478 #############################################
441 ############################################# 479 #############################################
442 ##### Vertikalprofil InstantaneousPoint ##### 480 ##### Vertikalprofil InstantaneousPoint #####
443 ############################################# 481 #############################################

http://dive4elements.wald.intevation.org