[postgis-users] Creating a boundary of an aggregate of buildings

[Luca Bertoncello]

Am 28.01.2021 16:21, schrieb Tomas Straupis:

Hi Tomas,

>   If 300m buffer +- is good for your scale, then you can reduce the

Yes, 300m is good for what I need, I tested it on a small region.

> number of vertexes thus speeding up buffer operations considerably.
> For example you could dp simplify geometries beforehand.
> 
>   Something like:
> 
>   UPDATE city_boundaries SET way = ST_SimplifyPreserveTopology(way, 
> 100);
> 
>   before running running buffer +- update.

OK, I'll try in the test environment how it looks like, then try on the 
production server.

Thanks
Luca Bertoncello
(lucabert at lucabert.de)