Mercurial > dive4elements > river
changeset 7190:851fc99be4bc
issue1435: meta-data.xml: Add sedimentload/yield- part to minfo part of dc.
author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
---|---|
date | Fri, 27 Sep 2013 14:42:03 +0200 |
parents | 4c8ce0c41dc2 |
children | 7bd19eff9bca |
files | artifacts/doc/conf/meta-data.xml |
diffstat | 1 files changed, 30 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/artifacts/doc/conf/meta-data.xml Fri Sep 27 14:40:39 2013 +0200 +++ b/artifacts/doc/conf/meta-data.xml Fri Sep 27 14:42:03 2013 +0200 @@ -1225,9 +1225,39 @@ <dc:call-macro name="basedata_7_waterlevels"/> <dc:call-macro name="minfo-heights"/> <dc:call-macro name="sounding-width"/> + <dc:call-macro name="yields"/> </minfo> </dc:macro> + <dc:macro name="yields"> + <dc:context> + <dc:statement> + SELECT DISTINCT + sy.id AS syid, + sy.description AS description, + ti.start_time AS year + FROM sediment_yield sy + JOIN rivers r ON sy.river_id = r.id + JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id + JOIN time_intervals ti ON sy.time_interval_id = ti.id + WHERE r.name = 'Elbe' + AND ti.stop_time IS NULL + AND syv.station BETWEEN ${fromkm} AND ${tokm} + </dc:statement> + <dc:if test="dc:has-result()"> + <dc:for-each> + <year description="{$description}" + factory="sedimentyield" + target_out="{$out}" + info="infome" + ids="{$syid}" /> +<!-- or epoch --> + </dc:for-each> + </dc:if> + </dc:context> + </dc:macro> + + <dc:macro name="basedata_5_flood-protections"> <dc:filter expr="$kind=5"> <dc:if test="dc:has-result()">