Mercurial > dive4elements > gnv-client
diff gnv-artifacts/src/test/ressources/queries.properties @ 173:1b2fc94766c9
Added real Coordinate-Query to TimeSeries-Mesh
gnv-artifacts/trunk@212 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 13 Oct 2009 09:11:23 +0000 |
| parents | 7be22e76c270 |
| children | dbf68950b4d9 |
line wrap: on
line diff
--- a/gnv-artifacts/src/test/ressources/queries.properties Mon Oct 12 09:19:16 2009 +0000 +++ b/gnv-artifacts/src/test/ressources/queries.properties Tue Oct 13 09:11:23 2009 +0000 @@ -94,14 +94,15 @@ m.NAME VALUE \ FROM MEDIAN.MESH m \ order by m.NAME -timeseries_meshpoint = SELECT FEATUREID KEY, \ - SHAPE VALUE \ - FROM MEDIAN.MESHPOINT mp , \ - MEDIAN.MESH m \ - WHERE m.OBJECTID = ? AND \ - mp.MESHID = m.MESHID AND \ - KPOSITION = 1 AND \ - rownum < 10 +timeseries_meshpoint = 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,"?") timeseries_meshpoint_depth = select mp.FEATUREID KEY, \ -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \