[postgis-users] Method to remove overlaps in a layer

Pierre Racine Pierre.Racine at sbf.ulaval.ca
Mon Mar 19 11:16:30 PDT 2012

> You should really be constructing a topology out of that dataset, you know ?
> Will be probably slow but I'm sure you can survive :)

So what would be the normal/easiest steps to convert a messy polygon coverage into a clean topology? Is it documented somewhere?

My guess:

1- SET search_path TO topology,public;

2- SELECT CreateTopoGeom('test')

3- SELECT toTopoGeom(geom, 'test', 1)
FROM mymessyone;


SELECT ST_CreateTopoGeo('test', geom)
FROM mymessyone;

What happens when a polygon to be added to the topology overlaps a polygon already in the topology?



More information about the postgis-users mailing list