Mercurial > gemma
diff pkg/imports/wa.go @ 2912:93fa55bce126
Add utility function to get users area of responsibility
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 02 Apr 2019 19:25:17 +0200 |
parents | 8a8a929182f9 |
children | ecb1e34157a3 |
line wrap: on
line diff
--- a/pkg/imports/wa.go Tue Apr 02 19:24:08 2019 +0200 +++ b/pkg/imports/wa.go Tue Apr 02 19:25:17 2019 +0200 @@ -81,22 +81,16 @@ const ( deleteWaterwayAreaSQL = ` WITH resp AS ( - SELECT best_utm(area) AS t, - ST_Transform(area::geometry, best_utm(area)) AS a - FROM users.responsibility_areas - WHERE country = users.current_user_country() + SELECT users.current_user_area_utm() AS a ) DELETE FROM waterway.waterway_area WHERE pg_has_role('sys_admin', 'MEMBER') OR ST_Covers((SELECT a FROM resp), - ST_Transform(area::geometry, (SELECT t FROM resp))) + ST_Transform(area::geometry, (SELECT ST_SRID(a) FROM resp))) ` insertWaterwayAreaSQL = ` WITH resp AS ( - SELECT best_utm(area) AS t, - ST_Transform(area::geometry, best_utm(area)) AS a - FROM users.responsibility_areas - WHERE country = users.current_user_country() + SELECT users.current_user_area_utm() AS a ) INSERT INTO waterway.waterway_area (area, catccl, dirimp) SELECT dmp.geom, $3, $4 @@ -106,7 +100,7 @@ THEN ST_MakeValid(ST_Transform(new_area, best_utm(ST_Transform(new_area, 4326)))) ELSE ST_Intersection((SELECT a FROM resp), - ST_MakeValid(ST_Transform(new_area, (SELECT t FROM resp)))) + ST_MakeValid(ST_Transform(new_area, (SELECT ST_SRID(a) FROM resp)))) END, 3), 4326)) AS dmp `