Fixing broken shapefile geometries

Hello,

For those working on GIS, I thought I'd share a very useful tool for
repairing invalid topologies, such as self-intersecting polygons:

For this, you can use the cleanGeometry function in PostGIS:
http://www.sogis1.so.ch/sogis/dl/postgis/cleanGeometry.sql

Example:

update "UGA_adm1" set the_geom=cleanGeometry(the_geom)

Knut

I should mention that this function is developed by Kappasys, which is
developing GIS infrastructure tools for the Solothurn Canton of
Switzerland. Just another testament to the power of PostGIS, which we
should integrate (in conjunction with Geoserver) in the future.

Knut

ยทยทยท

On Wed, Aug 25, 2010 at 9:36 AM, Knut Staring <knutst@gmail.com> wrote:

Hello,

For those working on GIS, I thought I'd share a very useful tool for
repairing invalid topologies, such as self-intersecting polygons:

For this, you can use the cleanGeometry function in PostGIS:
http://www.sogis1.so.ch/sogis/dl/postgis/cleanGeometry.sql

Example:

update "UGA_adm1" set the_geom=cleanGeometry(the_geom)

Knut

--
Cheers,
Knut Staring