Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 736:b8c7105f2b94 | 737:3f8f71e88587 |
|---|---|
| 152 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ | 152 p.GERMANNAME || ' ['|| p.UNIT ||']' VALUE, \ |
| 153 p.GERMANNAME \ | 153 p.GERMANNAME \ |
| 154 from MEDIAN.PARAMETER p, \ | 154 from MEDIAN.PARAMETER p, \ |
| 155 MEDIAN.MESHSCALARVALUE msc, \ | 155 MEDIAN.MESHSCALARVALUE msc, \ |
| 156 MEDIAN.MESH m \ | 156 MEDIAN.MESH m \ |
| 157 where m.OBJECTID = ? AND \ | 157 where m.OBJECTID = ? AND \ |
| 158 msc.PARTID = m.PARTIDMIN AND \ | 158 msc.PARTID >= m.PARTIDMIN AND \ |
| 159 msc.PARTID <= m.PARTIDMAX AND \ | |
| 159 msc.PARAMETERID = p.PARAMETERID \ | 160 msc.PARAMETERID = p.PARAMETERID \ |
| 160 order by p.GERMANNAME | 161 order by p.GERMANNAME |
| 161 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \ | 162 timeseries_mesh_interval=select /*+ parallel(TIMEVALUE,5) */ \ |
| 162 min(TIMEVALUE) MIN, \ | 163 min(TIMEVALUE) MIN, \ |
| 163 max(TIMEVALUE) MAX \ | 164 max(TIMEVALUE) MAX \ |
| 361 (SELECT st_astext(SHAPE) \ | 362 (SELECT st_astext(SHAPE) \ |
| 362 FROM MEDIAN.FEATUREAREA \ | 363 FROM MEDIAN.FEATUREAREA \ |
| 363 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | 364 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ |
| 364 FEATURECODE = ? )\ | 365 FEATURECODE = ? )\ |
| 365 ) \ | 366 ) \ |
| 367 order by M.NAME | |
| 368 | |
| 369 verticalprofile_mesh_with_wkt = SELECT M.OBJECTID KEY, \ | |
| 370 M.NAME VALUE \ | |
| 371 FROM MEDIAN.MESHPOINT, \ | |
| 372 MEDIAN.MESH M \ | |
| 373 WHERE M.SOURCEID IN (?) AND \ | |
| 374 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 375 INTERSECTS(SHAPE, "?") \ | |
| 366 order by M.NAME | 376 order by M.NAME |
| 367 | 377 |
| 368 verticalprofile_mesh_point = SELECT FEATUREID, \ | 378 verticalprofile_mesh_point = SELECT FEATUREID, \ |
| 369 ST_ASTEXT(SHAPE) \ | 379 ST_ASTEXT(SHAPE) \ |
| 370 FROM MEDIAN.MESHPOINT \ | 380 FROM MEDIAN.MESHPOINT \ |