Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 216:9db263ee2678
Added Workflow for determining the Query-Parameters for Horizontal cross-sections.
gnv-artifacts/trunk@274 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Wed, 28 Oct 2009 16:26:03 +0000 |
| parents | c0a798299efc |
| children | 3dcd2b0b456e |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Wed Oct 28 09:53:57 2009 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Wed Oct 28 16:26:03 2009 +0000 @@ -544,7 +544,7 @@ ############################################# ############################################# -########### Profilschnitt MESH ########### +############# Profilschnitt MESH ############ ############################################# ############################################# verticalcrosssection_mesh_date = select distinct \ @@ -588,4 +588,33 @@ msv.PARAMETERID, \ MEDIAN.MESHPOINT.JPOSITION , \ MEDIAN.MESHPOINT.IPOSITION, \ - MEDIAN.MESHPOINT.KPOSITION \ No newline at end of file + MEDIAN.MESHPOINT.KPOSITION + +############################################# +############################################# +########## Horizontalschnitt MESH ########### +############################################# +############################################# +horizontalcrosssection_meshpoint_depth = SELECT DISTINCT MP.KPOSITION KEY, \ + 'Layer ' || ML.KPOSITION || ': ' || -ML.UPPERZLOCATION || ' - '|| -ML.LOWERZLOCATION VALUE \ + from MEDIAN.MESHLAYER ML, \ + MEDIAN.MESHPOINT MP, \ + MEDIAN.MESH M \ + WHERE ML.KPOSITION = MP.KPOSITION AND \ + ML.MESHID = MP.MESHID AND \ + M.OBJECTID = ? AND \ + MP.MESHID = M.MESHID \ + ORDER BY MP.KPOSITION + +horizontalcrosssection_mesh_date = select distinct \ + msv.TIMEVALUE KEY, \ + msv.TIMEVALUE VALUE \ + from MEDIAN.MESHSCALARVALUE msv , \ + MEDIAN.MESH m \ + where m.OBJECTID = ? AND \ + msv.PARTID >= m.PARTIDMIN AND \ + msv.PARTID <= m.PARTIDMAX AND \ + msv.PARAMETERID = ? \ + order by msv.TIMEVALUE + +horizontalcrosssection_mesh_data = Select 1 from dual; \ No newline at end of file