# HG changeset patch # User Andre Heinecke # Date 1366281475 -7200 # Node ID dc5f8188591846a16b0c577d806c8066b04c02f7 # Parent 9f9dfe1b991320456845debd750ac46bd1f267af Add hydroboundaries where sectie and sobek is null diff -r 9f9dfe1b9913 -r dc5f81885918 flys-artifacts/doc/conf/meta-data.xml --- 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 @@ + + + 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 + + + + +