Mercurial > gemma
comparison pkg/imports/bn.go @ 2248:cce158db02b0
Input area as multipolygons to generate area from stretch
Doing so is more resilient against invalid geometries and gives
more plausible results if tributaries are involved (i.e. does not
include the adjacent area of the tributary in the result).
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 13 Feb 2019 16:48:52 +0100 |
| parents | 3437ceee1529 |
| children | cfc523c70e90 |
comparison
equal
deleted
inserted
replaced
| 2247:e6fba449aa3c | 2248:cce158db02b0 |
|---|---|
| 62 $3, | 62 $3, |
| 63 $4, | 63 $4, |
| 64 isrsrange(isrs_fromText($5), isrs_fromText($6)), | 64 isrsrange(isrs_fromText($5), isrs_fromText($6)), |
| 65 ISRSrange_area( | 65 ISRSrange_area( |
| 66 isrsrange(isrs_fromText($5), isrs_fromText($6)), | 66 isrsrange(isrs_fromText($5), isrs_fromText($6)), |
| 67 (SELECT ST_Union(CAST(area AS geometry)) | 67 (SELECT ST_Collect(CAST(area AS geometry)) |
| 68 FROM waterway.waterway_area)), | 68 FROM waterway.waterway_area)), |
| 69 $7, | 69 $7, |
| 70 $8, | 70 $8, |
| 71 $9, | 71 $9, |
| 72 $10, | 72 $10, |