Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/src/test/ressources/queries.properties @ 191:d436c8b27ae3
Changed the Value of Layer and Depth range visualization of Meshes
according to issue50
gnv-artifacts/trunk@239 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Mon, 19 Oct 2009 09:40:31 +0000 |
| parents | 693f7b676ade |
| children | 60c61f323f16 |
comparison
equal
deleted
inserted
replaced
| 190:baaa1618fa27 | 191:d436c8b27ae3 |
|---|---|
| 104 WHERE OBJECTID = ?) AND \ | 104 WHERE OBJECTID = ?) AND \ |
| 105 KPOSITION = 1 AND \ | 105 KPOSITION = 1 AND \ |
| 106 INTERSECTS(SHAPE,"?") | 106 INTERSECTS(SHAPE,"?") |
| 107 | 107 |
| 108 timeseries_meshpoint_depth = select mp.FEATUREID KEY, \ | 108 timeseries_meshpoint_depth = select mp.FEATUREID KEY, \ |
| 109 mp.KPOSITION || ' ( '|| -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION || ' )' as VALUE \ | 109 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION as VALUE \ |
| 110 from MEDIAN.MESHLAYER ml, \ | 110 from MEDIAN.MESHLAYER ml, \ |
| 111 MEDIAN.MESHPOINT mp \ | 111 MEDIAN.MESHPOINT mp \ |
| 112 where ml.KPOSITION = mp.KPOSITION and \ | 112 where ml.KPOSITION = mp.KPOSITION and \ |
| 113 ml.MESHID = mp.MESHID and \ | 113 ml.MESHID = mp.MESHID and \ |
| 114 mp.FEATUREID in \ | 114 mp.FEATUREID in \ |
| 450 ########### Horizontalprofil MESH ########### | 450 ########### Horizontalprofil MESH ########### |
| 451 ############################################# | 451 ############################################# |
| 452 ############################################# | 452 ############################################# |
| 453 horizontalprofile_meshpoint_depth = SELECT DISTINCT \ | 453 horizontalprofile_meshpoint_depth = SELECT DISTINCT \ |
| 454 mp.KPOSITION KEY, \ | 454 mp.KPOSITION KEY, \ |
| 455 mp.KPOSITION || ' ( '||-ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION || ' ) ' VALUE \ | 455 'Layer ' || ml.KPOSITION || ': ' || -ml.UPPERZLOCATION || ' - '|| -ml.LOWERZLOCATION VALUE \ |
| 456 from MEDIAN.MESHLAYER ml, \ | 456 from MEDIAN.MESHLAYER ml, \ |
| 457 MEDIAN.MESHPOINT mp \ | 457 MEDIAN.MESHPOINT mp \ |
| 458 where ml.KPOSITION = mp.KPOSITION and \ | 458 where ml.KPOSITION = mp.KPOSITION and \ |
| 459 ml.MESHID = mp.MESHID and \ | 459 ml.MESHID = mp.MESHID and \ |
| 460 mp.FEATUREID in \ | 460 mp.FEATUREID in \ |