Mercurial > gemma
changeset 1631:6ee06eb37fa9
Use new function to calculate bn area.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 19 Dec 2018 18:37:40 +0100 |
parents | f6218f11062a |
children | 0123a120e999 |
files | pkg/imports/bn.go |
diffstat | 1 files changed, 5 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/pkg/imports/bn.go Wed Dec 19 18:12:03 2018 +0100 +++ b/pkg/imports/bn.go Wed Dec 19 18:37:40 2018 +0100 @@ -57,7 +57,11 @@ $3, $4, isrsrange(isrs_fromText($5), isrs_fromText($6)), - ST_MakePolygon(ST_ExteriorRing(ST_Buffer(ST_SetSRID(ST_Makepoint(13.05501, 47.80949), 4326), 0.01)))::Geography, + ISRSrange_area( + isrsrange(isrs_fromText($5), isrs_fromText($6)), + (SELECT ST_Union(CAST(area AS geometry)) + FROM waterway.fairway_dimensions + WHERE level_of_service = 3)), $7, $8, $9,