Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 1046:026f89df4091
Added queries for meshes using vectorvalues for horizontalprofiles.
gnv-artifacts/trunk@1118 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 21 May 2010 10:54:29 +0000 |
| parents | 3fe08ea3f2b6 |
| children | 05ab74539ed3 |
comparison
equal
deleted
inserted
replaced
| 1045:3fe08ea3f2b6 | 1046:026f89df4091 |
|---|---|
| 1374 order by msv.TIMEVALUE, \ | 1374 order by msv.TIMEVALUE, \ |
| 1375 MEDIAN.MESHPOINT.KPOSITION, \ | 1375 MEDIAN.MESHPOINT.KPOSITION, \ |
| 1376 MEDIAN.MESHPOINT.JPOSITION, \ | 1376 MEDIAN.MESHPOINT.JPOSITION, \ |
| 1377 MEDIAN.MESHPOINT.IPOSITION, \ | 1377 MEDIAN.MESHPOINT.IPOSITION, \ |
| 1378 msv.PARAMETERID | 1378 msv.PARAMETERID |
| 1379 | 1379 |
| 1380 ############################################# | |
| 1381 ############################################# | |
| 1382 ########### Horizontalprofil MESH ########### | |
| 1383 ########### Vektordaten ########### | |
| 1384 ############################################# | |
| 1385 ############################################# | |
| 1386 | |
| 1387 horizontalprofile_mesh_chart_data_vector= SELECT ST_ASTEXT(SHAPE), \ | |
| 1388 MVV.XCOMPONENT, \ | |
| 1389 MVV.YCOMPONENT, \ | |
| 1390 MVV.ZCOMPONENT, \ | |
| 1391 MVV.SPEED, \ | |
| 1392 MVV.DIRECTION, \ | |
| 1393 MVV.PARAMETERID GROUP1, \ | |
| 1394 MEDIAN.MESHPOINT.KPOSITION GROUP2, \ | |
| 1395 MVV.TIMEVALUE GROUP3, \ | |
| 1396 MEDIAN.MESHPOINT.JPOSITION, \ | |
| 1397 MEDIAN.MESHPOINT.IPOSITION, \ | |
| 1398 2 DATAID, \ | |
| 1399 MEDIAN.MESHPOINT.MESHID \ | |
| 1400 FROM MEDIAN.MESHLAYER ML, \ | |
| 1401 MEDIAN.MESHPOINT, \ | |
| 1402 MEDIAN.MESH M, \ | |
| 1403 MEDIAN.MESHCURRENTVALUE MVV \ | |
| 1404 WHERE MVV.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ | |
| 1405 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \ | |
| 1406 ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 1407 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 1408 M.PARTIDMIN <= MVV.PARTID AND \ | |
| 1409 M.PARTIDMAX >= MVV.PARTID AND \ | |
| 1410 MVV.PARAMETERID = ? AND \ | |
| 1411 MVV.TIMEVALUE = ? AND \ | |
| 1412 M.OBJECTID = ? AND \ | |
| 1413 MEDIAN.MESHPOINT.FEATUREID IN \ | |
| 1414 ( SELECT FEATUREID \ | |
| 1415 from MEDIAN.MESHPOINT MP, \ | |
| 1416 MEDIAN.MESH M \ | |
| 1417 where M.OBJECTID = ? AND \ | |
| 1418 MP.MESHID = M.MESHID AND \ | |
| 1419 KPOSITION IN ( ? ) AND \ | |
| 1420 ? = (SELECT ? FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?)) \ | |
| 1421 ORDER BY MVV.TIMEVALUE, \ | |
| 1422 MEDIAN.MESHPOINT.KPOSITION, \ | |
| 1423 MVV.PARAMETERID, \ | |
| 1424 MEDIAN.MESHPOINT.JPOSITION, \ | |
| 1425 MEDIAN.MESHPOINT.IPOSITION | |
| 1426 | |
| 1427 horizontalprofile_mesh_odv_data_vector= SELECT SI.NAME CRUISE, \ | |
| 1428 M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ | |
| 1429 '*' TYPE, \ | |
| 1430 ST_ASTEXT(SHAPE), \ | |
| 1431 0 BOTDEPTH, \ | |
| 1432 (((ML.UPPERZLOCATION + ML.LOWERZLOCATION) / 2)*-1) DEPTH, \ | |
| 1433 MVV.XCOMPONENT, \ | |
| 1434 MVV.YCOMPONENT, \ | |
| 1435 MVV.ZCOMPONENT, \ | |
| 1436 MVV.SPEED, \ | |
| 1437 MVV.DIRECTION, \ | |
| 1438 MVV.PARAMETERID PARAMETER, \ | |
| 1439 MVV.TIMEVALUE, \ | |
| 1440 MEDIAN.MESHPOINT.JPOSITION, \ | |
| 1441 MEDIAN.MESHPOINT.IPOSITION , \ | |
| 1442 '1' QF \ | |
| 1443 from MEDIAN.MESHLAYER ML, \ | |
| 1444 MEDIAN.MESHPOINT, \ | |
| 1445 MEDIAN.MESH M, \ | |
| 1446 MEDIAN.MESHCURRENTVALUE MVV, \ | |
| 1447 MEDIAN.SOURCEINFO SI \ | |
| 1448 where MVV.FEATUREID = MEDIAN.MESHPOINT. FEATUREID AND \ | |
| 1449 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ | |
| 1450 ML.MESHID = MEDIAN.MESHPOINT.MESHID and \ | |
| 1451 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 1452 M.SOURCEID = SI.SOURCEID AND \ | |
| 1453 M.PARTIDMIN <= MVV.PARTID AND \ | |
| 1454 M.PARTIDMAX >= MVV.PARTID AND \ | |
| 1455 MVV.PARAMETERID = ? AND \ | |
| 1456 MVV.TIMEVALUE = ? AND \ | |
| 1457 M.OBJECTID = ? AND \ | |
| 1458 MEDIAN.MESHPOINT.FEATUREID IN \ | |
| 1459 ( SELECT FEATUREID \ | |
| 1460 FROM MEDIAN.MESHPOINT MP, \ | |
| 1461 MEDIAN.MESH M \ | |
| 1462 WHERE M.OBJECTID = ? AND \ | |
| 1463 MP.MESHID = M.MESHID AND \ | |
| 1464 KPOSITION IN ( ? ) AND \ | |
| 1465 ? = (SELECT ? FROM MEDIAN.MESHPOINT WHERE FEATUREID = ?)) \ | |
| 1466 ORDER BY MVV.TIMEVALUE, \ | |
| 1467 MEDIAN.MESHPOINT.KPOSITION, \ | |
| 1468 MEDIAN.MESHPOINT.JPOSITION, \ | |
| 1469 MEDIAN.MESHPOINT.IPOSITION, \ | |
| 1470 MVV.PARAMETERID | |
| 1471 | |
| 1380 ############################################# | 1472 ############################################# |
| 1381 ############################################# | 1473 ############################################# |
| 1382 ########### Horizontalprofil MESH ########### | 1474 ########### Horizontalprofil MESH ########### |
| 1383 ########### Schnittprofil ########### | 1475 ########### Schnittprofil ########### |
| 1384 ############################################# | 1476 ############################################# |