[postgis-users] Problems with GeomUnion

[Markus Schaber]

Hi, Bill,

Bill Binko schrieb:

> Now I need a way to fix self-intersecting shapes.  I wonder why I didn't 
> get errors when loading the shapefiles into the database!

Geometry validity check is a rather expensive operation, especially on
polygons with lots of vertices, it costs lots of CPU.

Imagine you have one machine where you prepare your GIS database, and
then dump it and restore your dump on your production servers. Checking
the validity simply would slow down this process unecessarily.

The current CVS version of the postgis manual has a section telling you
how you can manually force this check on geometry loading.

Markus
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 256 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050408/449eeec6/attachment.pgp>