← Back to team overview

dhis2-devs team mailing list archive

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



Follow ups