[postgis-users] Overlapping of polygons with SimplifyPreserveTopology

Paolo Cavallini cavallini at faunalia.it
Mon Dec 9 22:00:13 PST 2013


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il 10/12/2013 04:49, Luca Morandini ha scritto:

> we noticed that, despite the use of ST_SimplifyPreserveTopology, 
> non-adjacent polygons may overlap; this happens when there is a
> long and narrow water body of between them (think of a fiord), but
> this body is not itself a polygon.
> 
> To solve this issue we came up with the idea of adding an
> "universe polygon"; that is, a polygon that enclose the entire
> extent of a table, so that every polygon has a left and right
> polygon: would this do the trick ?

Hi Luca,
you really need to use full topology for this.
ST_SimplifyPreserveTopology simply prevents topological errors, it
does not guarantee sharing of nodes etc.
Good luck.

- -- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.15 (GNU/Linux)
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iEYEARECAAYFAlKmreQACgkQ/NedwLUzIr538QCePEiOoGaI2eSq9u8JsCviY77X
0bgAn0BrwdhOY0Ua4hnLmIWE/YdkLon3
=UWZJ
-----END PGP SIGNATURE-----


More information about the postgis-users mailing list