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

[Stephen Woodbridge]

On 1/28/2021 10:34 AM, Luca Bertoncello wrote:
> Am 28.01.2021 16:21, schrieb Tomas Straupis:
>
>>   Something like:
>>
>>   UPDATE city_boundaries SET way = ST_SimplifyPreserveTopology(way, 
>> 100);
>>
>>   before running running buffer +- update.
>
> I get the error:
>
> FEHLER:  Geometry type (Polygon) does not match column type 
> (MultiPolygon)
>
> Could you say me how to correct the query?

UPDATE city_boundaries SET way =ST_Multi( 
ST_SimplifyPreserveTopology(way, 100));

>
> Thanks
> Luca Bertoncello
> (lucabert at lucabert.de)
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users