Mercurial > dive4elements > gnv-client
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 ############################################# |