Mercurial > gemma
changeset 2911:a75c546ef498
Use buffer around axis for stretch area
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 02 Apr 2019 19:24:08 +0200 |
parents | c8c7122047a2 |
children | 93fa55bce126 |
files | pkg/imports/st.go |
diffstat | 1 files changed, 7 insertions(+), 6 deletions(-) [+] |
line wrap: on
line diff
--- a/pkg/imports/st.go Tue Apr 02 18:59:26 2019 +0200 +++ b/pkg/imports/st.go Tue Apr 02 19:24:08 2019 +0200 @@ -97,8 +97,9 @@ $8::char(5), $9::char(5), $10::int)::isrs) - ) AS r -) + ) AS r), +axs AS ( + SELECT ISRSrange_axis((SELECT r FROM r), $16::double precision) AS axs) INSERT INTO waterway.stretches ( name, stretch, @@ -110,10 +111,10 @@ ) VALUES ( $11, (SELECT r FROM r), - ISRSrange_area( - ISRSrange_axis((SELECT r FROM r), $16::double precision), - (SELECT ST_Collect(CAST(area AS geometry)) - FROM waterway.waterway_area)), + ST_Transform(ISRSrange_area( + (SELECT axs FROM axs), + (SELECT ST_Buffer(axs, 10000) FROM axs)), + 4326), $12, $13, $14,