Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/src/test/ressources/queries.properties @ 184:5d050f6de41d
The Levelnumber of Meshes will also be visualized in the choose of depth GT_0020.0020
gnv-artifacts/trunk@228 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 16 Oct 2009 09:31:25 +0000 |
| parents | f2c76f35da5a |
| children | 693f7b676ade |
comparison
equal
deleted
inserted
replaced
| 183:3e4256a6b48b | 184:5d050f6de41d |
|---|---|
| 103 WHERE OBJECTID = ?) AND \ | 103 WHERE OBJECTID = ?) AND \ |
| 104 KPOSITION = 1 AND \ | 104 KPOSITION = 1 AND \ |
| 105 INTERSECTS(SHAPE,"?") | 105 INTERSECTS(SHAPE,"?") |
| 106 | 106 |
| 107 timeseries_meshpoint_depth = select mp.FEATUREID KEY, \ | 107 timeseries_meshpoint_depth = select mp.FEATUREID KEY, \ |
| 108 -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \ | 108 mp.KPOSITION || ' ( '|| -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION || ' )' as VALUE \ |
| 109 from MEDIAN.MESHLAYER ml, \ | 109 from MEDIAN.MESHLAYER ml, \ |
| 110 MEDIAN.MESHPOINT mp \ | 110 MEDIAN.MESHPOINT mp \ |
| 111 where ml.KPOSITION = mp.KPOSITION and \ | 111 where ml.KPOSITION = mp.KPOSITION and \ |
| 112 ml.MESHID = mp.MESHID and \ | 112 ml.MESHID = mp.MESHID and \ |
| 113 mp.FEATUREID in \ | 113 mp.FEATUREID in \ |
| 448 ########### Horizontalprofil MESH ########### | 448 ########### Horizontalprofil MESH ########### |
| 449 ############################################# | 449 ############################################# |
| 450 ############################################# | 450 ############################################# |
| 451 horizontalprofile_meshpoint_depth = SELECT DISTINCT \ | 451 horizontalprofile_meshpoint_depth = SELECT DISTINCT \ |
| 452 mp.KPOSITION KEY, \ | 452 mp.KPOSITION KEY, \ |
| 453 -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \ | 453 mp.KPOSITION || ' ( '||-ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION || ' ) ' VALUE \ |
| 454 from MEDIAN.MESHLAYER ml, \ | 454 from MEDIAN.MESHLAYER ml, \ |
| 455 MEDIAN.MESHPOINT mp \ | 455 MEDIAN.MESHPOINT mp \ |
| 456 where ml.KPOSITION = mp.KPOSITION and \ | 456 where ml.KPOSITION = mp.KPOSITION and \ |
| 457 ml.MESHID = mp.MESHID and \ | 457 ml.MESHID = mp.MESHID and \ |
| 458 mp.FEATUREID in \ | 458 mp.FEATUREID in \ |