Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/src/test/ressources/queries.properties @ 188:693f7b676ade
Adding two further fis which are based on Mesh to the System.
Fis in Median.Mesh will be choosen using the sourceid issue49
gnv-artifacts/trunk@232 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 16 Oct 2009 14:51:43 +0000 |
| parents | 5d050f6de41d |
| children | d436c8b27ae3 |
comparison
equal
deleted
inserted
replaced
| 187:92a43d90a0b8 | 188:693f7b676ade |
|---|---|
| 91 ############################################# | 91 ############################################# |
| 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 WHERE SOURCEID IN (?) \ |
| 97 ORDER BY m.NAME | |
| 97 timeseries_meshpoint = SELECT FEATUREID, \ | 98 timeseries_meshpoint = SELECT FEATUREID, \ |
| 98 ST_ASTEXT(SHAPE) \ | 99 ST_ASTEXT(SHAPE) \ |
| 99 FROM MEDIAN.MESHPOINT \ | 100 FROM MEDIAN.MESHPOINT \ |
| 100 WHERE MESHID in \ | 101 WHERE MESHID in \ |
| 101 (SELECT DISTINCT MESHID \ | 102 (SELECT DISTINCT MESHID \ |
| 227 ############################################# | 228 ############################################# |
| 228 | 229 |
| 229 verticalprofile_mesh = SELECT OBJECTID KEY, \ | 230 verticalprofile_mesh = SELECT OBJECTID KEY, \ |
| 230 m.NAME VALUE \ | 231 m.NAME VALUE \ |
| 231 FROM MEDIAN.MESH m \ | 232 FROM MEDIAN.MESH m \ |
| 233 WHERE SOURCEID IN (?) \ | |
| 232 order by m.NAME | 234 order by m.NAME |
| 233 | 235 |
| 234 verticalprofile_mesh_point = SELECT FEATUREID, \ | 236 verticalprofile_mesh_point = SELECT FEATUREID, \ |
| 235 ST_ASTEXT(SHAPE) \ | 237 ST_ASTEXT(SHAPE) \ |
| 236 FROM MEDIAN.MESHPOINT \ | 238 FROM MEDIAN.MESHPOINT \ |