Mercurial > dive4elements > gnv-client
diff gnv-artifacts/src/test/ressources/queries.properties @ 174:dbf68950b4d9
Added real Coordinate-Query to HorizontalProfile- and VerticalProfile-Mesh
gnv-artifacts/trunk@213 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 13 Oct 2009 10:17:46 +0000 |
| parents | 1b2fc94766c9 |
| children | 14263534255b |
line wrap: on
line diff
--- a/gnv-artifacts/src/test/ressources/queries.properties Tue Oct 13 09:11:23 2009 +0000 +++ b/gnv-artifacts/src/test/ressources/queries.properties Tue Oct 13 10:17:46 2009 +0000 @@ -230,14 +230,15 @@ FROM MEDIAN.MESH m \ order by m.NAME -verticalprofile_mesh_point = SELECT FEATUREID KEY, \ - SHAPE VALUE \ - FROM MEDIAN.MESHPOINT mp , \ - MEDIAN.MESH m \ - WHERE m.OBJECTID = ? AND \ - m.MESHID = mp.MESHID AND \ - mp.KPOSITION = 1 AND \ - rownum < 10 +verticalprofile_mesh_point = SELECT FEATUREID, \ + ST_ASTEXT(SHAPE) \ + FROM MEDIAN.MESHPOINT \ + WHERE MESHID in \ + (SELECT DISTINCT MESHID \ + FROM MEDIAN.MESH \ + WHERE OBJECTID = ?) AND \ + KPOSITION = 1 AND \ + INTERSECTS(SHAPE,"?") verticalprofile_mesh_parameter=SELECT distinct \ p.PARAMETERID KEY , \