Mercurial > gemma
changeset 1899:272133cd65da
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