A little secret to rock your YouTube subscribers
BUFFER in Postgis ST_Buffer()
ALTER TABLE fiumi
ADD COLUMN buffer
GEOMETRY(MultiPolygon,3003,2);
UPDATE fiumi
SET buffer=ST_Multi(ST_Buffer(geom,100));
CREATE TABLE buffer_union AS SELECT
ST_Union(buffer)::GEOMETRY(MultiPolygon,3003),
ROUND((ST_Area(ST_Union(buffer))/1000)::numeric,2)
FROM fiumi;
ALTER TABLE fiumi
DROP COLUMN buffer;
Recommended
