# HG changeset patch # User Tom Gottfried # Date 1584635780 -3600 # Node ID afc2425886422065fd82bec3f23e80e073bdc56b # Parent 8c590ef35280ebc35472af359233000028a58406 Avoid needless geometry processing Mangling every geometry in the intersection machinery when importing as waterway admin leads to slightly different geometries compared to the same geometries imported by a sys_admin. This would create artificial history of entries when importing alternately as waterway admin and sys admin, once history of fairway dimensions is preserved. diff -r 8c590ef35280 -r afc242588642 pkg/imports/fd.go --- a/pkg/imports/fd.go Wed Mar 18 19:19:09 2020 +0100 +++ b/pkg/imports/fd.go Thu Mar 19 17:36:20 2020 +0100 @@ -161,6 +161,8 @@ SELECT ST_Multi(ST_CollectionExtract(ST_MakeValid(ST_Transform( CASE WHEN pg_has_role('sys_admin', 'MEMBER') + OR ST_Covers((SELECT a FROM resp), + ST_Transform(new_fd, (SELECT ST_SRID(a) FROM resp))) THEN new_fd ELSE ST_Intersection( (SELECT ST_Buffer(a, -0.0001) FROM resp),