Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 173:1b2fc94766c9 | 174:dbf68950b4d9 |
|---|---|
| 228 verticalprofile_mesh = SELECT OBJECTID KEY, \ | 228 verticalprofile_mesh = SELECT OBJECTID KEY, \ |
| 229 m.NAME VALUE \ | 229 m.NAME VALUE \ |
| 230 FROM MEDIAN.MESH m \ | 230 FROM MEDIAN.MESH m \ |
| 231 order by m.NAME | 231 order by m.NAME |
| 232 | 232 |
| 233 verticalprofile_mesh_point = SELECT FEATUREID KEY, \ | 233 verticalprofile_mesh_point = SELECT FEATUREID, \ |
| 234 SHAPE VALUE \ | 234 ST_ASTEXT(SHAPE) \ |
| 235 FROM MEDIAN.MESHPOINT mp , \ | 235 FROM MEDIAN.MESHPOINT \ |
| 236 MEDIAN.MESH m \ | 236 WHERE MESHID in \ |
| 237 WHERE m.OBJECTID = ? AND \ | 237 (SELECT DISTINCT MESHID \ |
| 238 m.MESHID = mp.MESHID AND \ | 238 FROM MEDIAN.MESH \ |
| 239 mp.KPOSITION = 1 AND \ | 239 WHERE OBJECTID = ?) AND \ |
| 240 rownum < 10 | 240 KPOSITION = 1 AND \ |
| 241 INTERSECTS(SHAPE,"?") | |
| 241 | 242 |
| 242 verticalprofile_mesh_parameter=SELECT distinct \ | 243 verticalprofile_mesh_parameter=SELECT distinct \ |
| 243 p.PARAMETERID KEY , \ | 244 p.PARAMETERID KEY , \ |
| 244 p.GERMANNAME VALUE \ | 245 p.GERMANNAME VALUE \ |
| 245 from MEDIAN.PARAMETER p, \ | 246 from MEDIAN.PARAMETER p, \ |