[postgis-users] Removing holes from polygons

strk strk at keybit.net
Tue Nov 3 12:15:07 PST 2009

On Tue, Nov 03, 2009 at 02:23:28PM -0500, Akhil Jaggarwal wrote:

> Any tips or hints on a query which removes all the inner holes from a
> polygon and returns and keeps the geometry of the largest one intact?

SELECT ST_ExteriorRing(geometry)  ...


 Free GIS & Flash consultant/developer      ()  ASCII Ribbon Campaign
 http://foo.keybit.net/~strk/services.html  /\  Keep it simple! 

More information about the postgis-users mailing list