Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 325:3eff9241ea1e
Refactoring of the Transitionmodel.
Now each Transition is responsible to allocate the Data which is required to describe or feed it.
gnv-artifacts/trunk@390 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 01 Dec 2009 15:58:02 +0000 |
| parents | 251f16a083f8 |
| children | 1b9ca0f2d498 |
comparison
equal
deleted
inserted
replaced
| 324:e6e172a4915e | 325:3eff9241ea1e |
|---|---|
| 489 MEDIAN.MEASUREMENT M \ | 489 MEDIAN.MEASUREMENT M \ |
| 490 WHERE S.SERIESID = I.SERIESID AND \ | 490 WHERE S.SERIESID = I.SERIESID AND \ |
| 491 I.POINTSPEC = 4 AND \ | 491 I.POINTSPEC = 4 AND \ |
| 492 I.FEATUREID = M.FEATUREID AND \ | 492 I.FEATUREID = M.FEATUREID AND \ |
| 493 M.SOURCEID= ? \ | 493 M.SOURCEID= ? \ |
| 494 ORDER BY S.DESCRIPTION | |
| 495 | |
| 496 verticalprofile_instantaneouspoint_series_with_area = SELECT \ | |
| 497 S.SERIESID KEY, \ | |
| 498 S.DESCRIPTION VALUE \ | |
| 499 FROM MEDIAN.INSTANTANEOUSPOINT, \ | |
| 500 MEDIAN.SERIES S, \ | |
| 501 MEDIAN.MEASUREMENT M \ | |
| 502 WHERE S.SERIESID = MEDIAN.INSTANTANEOUSPOINT.SERIESID AND \ | |
| 503 MEDIAN.INSTANTANEOUSPOINT.POINTSPEC = 4 AND \ | |
| 504 MEDIAN.INSTANTANEOUSPOINT.FEATUREID = M.FEATUREID AND \ | |
| 505 M.SOURCEID= ? AND \ | |
| 506 INTERSECTS(SHAPE, \ | |
| 507 (SELECT st_astext(SHAPE) \ | |
| 508 FROM MEDIAN.FEATUREAREA \ | |
| 509 WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ | |
| 510 FEATURECODE = ? )\ | |
| 511 ) \ | |
| 494 ORDER BY S.DESCRIPTION | 512 ORDER BY S.DESCRIPTION |
| 495 | 513 |
| 496 verticalprofile_instantaneouspoint_point = SELECT \ | 514 verticalprofile_instantaneouspoint_point = SELECT \ |
| 497 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ | 515 MEDIAN.INSTANTANEOUSPOINT.FEATUREID, \ |
| 498 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \ | 516 to_char(MEDIAN.INSTANTANEOUSPOINT.TIMEVALUE,'DD.MM.YYYY HH24:MI') VALUE, \ |