Mercurial > gemma

changeset 1899:272133cd65da

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Workarround for failing waterway_area imports. * Create a buffer for responsibility area * Fix selfintersections using ST_MakeValid * Ensure all geometries are polygon using ST_CollectionExtract
author Raimund Renkert <raimund.renkert@intevation.de>
date Fri, 18 Jan 2019 14:58:34 +0100
parents 8a56a64e4410
children 6a67cd819e93
files pkg/imports/wa.go
diffstat 1 files changed, 3 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/wa.go	Fri Jan 18 13:58:05 2019 +0100
+++ b/pkg/imports/wa.go	Fri Jan 18 14:58:34 2019 +0100
@@ -104,11 +104,11 @@
 SELECT ST_Transform(clipped.geom, 4326)::geography, $3, $4 FROM (
     SELECT (ST_Dump(
        ST_Intersection(
-         (SELECT a FROM resp),
-         ST_Transform(
+         (SELECT ST_Buffer(a, 0.0001) FROM resp),
+         ST_CollectionExtract(ST_MakeValid(ST_Transform(
            ST_GeomFromWKB($1, $2::integer),
            (SELECT t FROM resp)
-         )
+         )),3)
        )
      )).geom AS geom
   ) AS clipped