Mercurial > gemma
diff pkg/imports/sec.go @ 3560:ec1aec03676d
Use waterway area as basis for section area
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 31 May 2019 16:54:09 +0200 |
parents | 40bc7e3bc561 |
children | 4c585b5d4fe8 |
line wrap: on
line diff
--- a/pkg/imports/sec.go Fri May 31 16:42:43 2019 +0200 +++ b/pkg/imports/sec.go Fri May 31 16:54:09 2019 +0200 @@ -110,10 +110,10 @@ ) VALUES ( $11, (SELECT r FROM r), - ST_Transform(ISRSrange_area( - (SELECT axs FROM axs), - (SELECT ST_Buffer(axs, 1500) FROM axs)), - 4326), + ISRSrange_area( + (SELECT axs FROM axs), + (SELECT ST_Collect(CAST(area AS geometry)) + FROM waterway.waterway_area)), $12, $13, $14,