Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 737:3f8f71e88587
Modified the Workflow of TimeSeries on Meshes that the Data that was sent by the Mapviewer-Interface
gnv-artifacts/trunk@776 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Mon, 15 Mar 2010 13:49:50 +0000 |
| parents | f6630d0203da |
| children | 40c9a48f51ea |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Mon Mar 15 13:40:14 2010 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Mon Mar 15 13:49:50 2010 +0000 @@ -154,8 +154,9 @@ from MEDIAN.PARAMETER p, \ MEDIAN.MESHSCALARVALUE msc, \ MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - msc.PARTID = m.PARTIDMIN AND \ + where m.OBJECTID = ? AND \ + msc.PARTID >= m.PARTIDMIN AND \ + msc.PARTID <= m.PARTIDMAX AND \ msc.PARAMETERID = p.PARAMETERID \ order by p.GERMANNAME timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \ @@ -364,6 +365,15 @@ FEATURECODE = ? )\ ) \ order by M.NAME + +verticalprofile_mesh_with_wkt = SELECT M.OBJECTID KEY, \ + M.NAME VALUE \ + FROM MEDIAN.MESHPOINT, \ + MEDIAN.MESH M \ + WHERE M.SOURCEID IN (?) AND \ + M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ + INTERSECTS(SHAPE, "?") \ + order by M.NAME verticalprofile_mesh_point = SELECT FEATUREID, \ ST_ASTEXT(SHAPE) \