Mercurial > gemma
changeset 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 | c220ad7e61ed |
children | 453f15ba8030 |
files | pkg/imports/sec.go |
diffstat | 1 files changed, 4 insertions(+), 4 deletions(-) [+] |
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,