[postgis-users] Removing Interior Rings

Michael Fuhr mike at fuhr.org
Wed Nov 29 23:49:26 PST 2006

On Thu, Nov 30, 2006 at 02:26:27PM +1100, Craig Feuerherdt wrote:
> I am attempting to simplify a series of polygons by buffering them and then
> unioning the buffers together (sql below).
> This works fine however, in some instances, there are interior rings (holes)
> which I would like to remove.
> I have tried Segmentize, but it failed to remove the interior rings.

Have you tried exteriorring() to get the exterior ring as a LINESTRING
and makepolygon() to turn it back into a POLYGON?

Michael Fuhr

More information about the postgis-users mailing list