Mercurial > dive4elements > gnv-client
diff 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 |
line wrap: on
line diff
--- a/gnv-artifacts/src/test/ressources/queries.properties Fri Oct 16 08:44:09 2009 +0000 +++ b/gnv-artifacts/src/test/ressources/queries.properties Fri Oct 16 09:31:25 2009 +0000 @@ -105,7 +105,7 @@ INTERSECTS(SHAPE,"?") timeseries_meshpoint_depth = select mp.FEATUREID KEY, \ - -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \ + mp.KPOSITION || ' ( '|| -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION || ' )' as VALUE \ from MEDIAN.MESHLAYER ml, \ MEDIAN.MESHPOINT mp \ where ml.KPOSITION = mp.KPOSITION and \ @@ -450,7 +450,7 @@ ############################################# horizontalprofile_meshpoint_depth = SELECT DISTINCT \ mp.KPOSITION KEY, \ - -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \ + mp.KPOSITION || ' ( '||-ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION || ' ) ' VALUE \ from MEDIAN.MESHLAYER ml, \ MEDIAN.MESHPOINT mp \ where ml.KPOSITION = mp.KPOSITION and \