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

[Pierre Racine]

> 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;

or

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?

Thanks,

Pierre