Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 172:b5e55f460f0b | 173:1b2fc94766c9 |
|---|---|
| 92 | 92 |
| 93 timeseries_mesh = SELECT OBJECTID KEY, \ | 93 timeseries_mesh = SELECT OBJECTID KEY, \ |
| 94 m.NAME VALUE \ | 94 m.NAME VALUE \ |
| 95 FROM MEDIAN.MESH m \ | 95 FROM MEDIAN.MESH m \ |
| 96 order by m.NAME | 96 order by m.NAME |
| 97 timeseries_meshpoint = SELECT FEATUREID KEY, \ | 97 timeseries_meshpoint = SELECT FEATUREID, \ |
| 98 SHAPE VALUE \ | 98 ST_ASTEXT(SHAPE) \ |
| 99 FROM MEDIAN.MESHPOINT mp , \ | 99 FROM MEDIAN.MESHPOINT \ |
| 100 MEDIAN.MESH m \ | 100 WHERE MESHID in \ |
| 101 WHERE m.OBJECTID = ? AND \ | 101 (SELECT DISTINCT MESHID \ |
| 102 mp.MESHID = m.MESHID AND \ | 102 FROM MEDIAN.MESH \ |
| 103 KPOSITION = 1 AND \ | 103 WHERE OBJECTID = ?) AND \ |
| 104 rownum < 10 | 104 KPOSITION = 1 AND \ |
| 105 INTERSECTS(SHAPE,"?") | |
| 105 | 106 |
| 106 timeseries_meshpoint_depth = select mp.FEATUREID KEY, \ | 107 timeseries_meshpoint_depth = select mp.FEATUREID KEY, \ |
| 107 -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \ | 108 -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \ |
| 108 from MEDIAN.MESHLAYER ml, \ | 109 from MEDIAN.MESHLAYER ml, \ |
| 109 MEDIAN.MESHPOINT mp \ | 110 MEDIAN.MESHPOINT mp \ |