Database Reference
In-Depth Information
While this is marginally better, the result is quite "lumpy." We will use the
ST_Simplify_PreserveTopology
function to simplify the polygons and then
grab just the external ring to remove the internal holes.
CREATE TABLE chp04.lidar_buildings_buffer AS
WITH lidar_query AS
(SELECT
ST_ExteriorRing(ST_SimplifyPreserveTopology((ST_Dump(ST_Union(ST_Buffer(the_geom,
5)))).geom, 10)) AS the_geom FROM
chp04.lidar_buildings)
SELECT chp04.polygonize_to_multi(the_geom) AS
the_geom from lidar_query;
Now, we have simplifiedversions of our buffered geometries:
