Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 482:64e65daa65e9
Fixed some bugs with calculating "Horizontalschnitte".
gnv-artifacts/trunk@557 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Sun, 17 Jan 2010 21:26:21 +0000 |
| parents | 62fc63d0f71d |
| children | c6249cb631df |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Sun Jan 17 16:34:11 2010 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Sun Jan 17 21:26:21 2010 +0000 @@ -1085,26 +1085,28 @@ horizontalcrosssection_mesh_data = SELECT ST_ASTEXT(SHAPE), \ MSV.DATAVALUE YORDINATE, \ - MEDIAN.MESHFACE.JPOSITION, \ - MEDIAN.MESHFACE.IPOSITION, \ - MEDIAN.MESHFACE.KPOSITION, \ + MEDIAN.MESHPOINT.JPOSITION, \ + MEDIAN.MESHPOINT.IPOSITION, \ + MEDIAN.MESHPOINT.KPOSITION, \ + MSV.PARAMETERID, \ + MSV.TIMEVALUE, \ 2 DATAID \ from MEDIAN.MESHLAYER ML, \ - MEDIAN.MESHFACE, \ + MEDIAN.MESHPOINT, \ MEDIAN.MESH M, \ MEDIAN.MESHSCALARVALUE MSV \ - where MSV.FEATUREID = MEDIAN.MESHFACE.FEATUREID AND \ - ML.KPOSITION = MEDIAN.MESHFACE.KPOSITION and \ - ML.MESHID = MEDIAN.MESHFACE.MESHID and \ - M.MESHID = MEDIAN.MESHFACE.MESHID AND \ + where MSV.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ + ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ + ML.MESHID = MEDIAN.MESHPOINT.MESHID and \ + M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ M.PARTIDMIN <= MSV.PARTID AND \ M.PARTIDMAX >= MSV.PARTID AND \ MSV.PARAMETERID = ? AND \ MSV.TIMEVALUE = ? AND \ M.OBJECTID = ? AND \ - MEDIAN.MESHFACE.KPOSITION = ? \ - order by MEDIAN.MESHFACE.JPOSITION, \ - MEDIAN.MESHFACE.IPOSITION + MEDIAN.MESHPOINT.KPOSITION = ? \ + order by MEDIAN.MESHPOINT.JPOSITION, \ + MEDIAN.MESHPOINT.IPOSITION horizontalcrosssection_mesh_odv_data = SELECT SI.NAME CRUISE, \ M.MESHID || '-' || MEDIAN.MESHPOINT.IPOSITION || '-' || MEDIAN.MESHPOINT.JPOSITION STATION, \ '*' TYPE, \