Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 1047:05ab74539ed3
Added queries for meshes using vectorvalues for 'Horizontales Schnittprofil'
gnv-artifacts/trunk@1119 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 21 May 2010 11:36:48 +0000 |
| parents | 026f89df4091 |
| children | 04967dc9c83f |
comparison
equal
deleted
inserted
replaced
| 1046:026f89df4091 | 1047:05ab74539ed3 |
|---|---|
| 1529 order by msv.TIMEVALUE, \ | 1529 order by msv.TIMEVALUE, \ |
| 1530 MEDIAN.MESHPOINT.KPOSITION, \ | 1530 MEDIAN.MESHPOINT.KPOSITION, \ |
| 1531 msv.PARAMETERID, \ | 1531 msv.PARAMETERID, \ |
| 1532 MEDIAN.MESHPOINT.JPOSITION, \ | 1532 MEDIAN.MESHPOINT.JPOSITION, \ |
| 1533 MEDIAN.MESHPOINT.IPOSITION | 1533 MEDIAN.MESHPOINT.IPOSITION |
| 1534 | |
| 1535 ############################################# | |
| 1536 ############################################# | |
| 1537 ########### Horizontalprofil MESH ########### | |
| 1538 ########### Schnittprofil ########### | |
| 1539 ########### Vektordaten ########### | |
| 1540 ############################################# | |
| 1541 ############################################# | |
| 1542 | |
| 1543 horizontalprofile_mesh_cross_chart_data_vector = SELECT ST_ASTEXT(SHAPE), \ | |
| 1544 MVV.XCOMPONENT, \ | |
| 1545 MVV.YCOMPONENT, \ | |
| 1546 MVV.ZCOMPONENT, \ | |
| 1547 MVV.SPEED, \ | |
| 1548 MVV.DIRECTION, \ | |
| 1549 MVV.PARAMETERID GROUP1, \ | |
| 1550 MEDIAN.MESHPOINT.KPOSITION GROUP2, \ | |
| 1551 MVV.TIMEVALUE GROUP3, \ | |
| 1552 MEDIAN.MESHPOINT.JPOSITION, \ | |
| 1553 MEDIAN.MESHPOINT.IPOSITION, \ | |
| 1554 2 DATAID \ | |
| 1555 FROM MEDIAN.MESHLAYER ML, \ | |
| 1556 MEDIAN.MESHPOINT, \ | |
| 1557 MEDIAN.MESH M, \ | |
| 1558 MEDIAN.MESHCURRENTVALUE MVV \ | |
| 1559 WHERE MVV.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ | |
| 1560 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \ | |
| 1561 ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 1562 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 1563 M.PARTIDMIN <= MVV.PARTID AND \ | |
| 1564 M.PARTIDMAX >= MVV.PARTID AND \ | |
| 1565 MVV.PARAMETERID = ? AND \ | |
| 1566 MVV.TIMEVALUE = ? AND \ | |
| 1567 M.OBJECTID = ? AND \ | |
| 1568 ML.KPOSITION in (?) AND \ | |
| 1569 MEDIAN.MESHPOINT.FEATUREID in \ | |
| 1570 ( \ | |
| 1571 SELECT DISTINCT FEATUREID \ | |
| 1572 FROM MEDIAN.MESHPOINT \ | |
| 1573 WHERE ? \ | |
| 1574 ) \ | |
| 1575 ORDER BY MVV.TIMEVALUE, \ | |
| 1576 MEDIAN.MESHPOINT.KPOSITION, \ | |
| 1577 MVV.PARAMETERID, \ | |
| 1578 MEDIAN.MESHPOINT.JPOSITION, \ | |
| 1579 MEDIAN.MESHPOINT.IPOSITION | |
| 1580 | |
| 1534 ############################################# | 1581 ############################################# |
| 1535 ############################################# | 1582 ############################################# |
| 1536 ############# Profilschnitt MESH ############ | 1583 ############# Profilschnitt MESH ############ |
| 1537 ############################################# | 1584 ############################################# |
| 1538 ############################################# | 1585 ############################################# |