changeset 5760:dc5f81885918

Add hydroboundaries where sectie and sobek is null
author Andre Heinecke <aheinecke@intevation.de>
date Thu, 18 Apr 2013 12:37:55 +0200
parents 9f9dfe1b9913
children 4416dd518103
files flys-artifacts/doc/conf/meta-data.xml
diffstat 1 files changed, 16 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/flys-artifacts/doc/conf/meta-data.xml	Thu Apr 18 12:37:24 2013 +0200
+++ b/flys-artifacts/doc/conf/meta-data.xml	Thu Apr 18 12:37:55 2013 +0200
@@ -1230,6 +1230,22 @@
                 </sobek_flooded>
               </dc:if>
             </dc:context>
+            <dc:context>
+              <dc:statement>
+                SELECT DISTINCT
+                b.name AS name
+                FROM hydr_boundaries_poly b
+                WHERE b.river_id = ${river_id}
+                AND b.kind = 1
+                AND b.sobek IS NULL
+                AND b.sectie is NULL
+              </dc:statement>
+              <dc:for-each>
+                <boundary name="{$name}"
+                          factory="wmshydrboundariespolyfactory"
+                          ids="{$river_id};{$name}"/>
+              </dc:for-each>
+            </dc:context>
           </dc:macro>
 
           <dc:macro name="flood-map-hydr-boundaries">

http://dive4elements.wald.intevation.org