Implicit SQL link between River reaches and associated storage area
It should be possible to write a validation query to check if the lowest vertex of a River reach bank line does not lie below the ground level of the storage area it overflows to. With an implicit link between the river reach and the left and right storage areas it overflows to, the query would be easy:
Object type: river reach
SELECT WHERE min(leftbank.Z) < leftnode.groundlevel;
SELECT WHERE min(rightbank.Z) < rightnode.groundlevel;
1
vote
Anonymous
shared this idea