[postgis-users] GeomUnion() strange results

Düster Horst Horst.Duester at bd.so.ch
Fri Mar 2 05:28:10 PST 2007


I try to create the exterior boundary of all polygons of the attached
postgis polygon table with:

select geomunion(wkb_geometry) from test;

As the result I don't get the expected result. Only parts of the input
polygons are dissolved. The culprit seems to be the polygon with gid=1.
This polygon is very complex with many vertex points. All geometries are
valid, checked by isValid(wkb_geometry). Please use the attached
geometry table to reproduce this behaviour.

My System:

PostgreSQL 8.1.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.4
20050721 (Red Hat 3.4.4-2)
POSTGIS="1.1.5" GEOS="3.0.0rc1-CAPI-1.2.0" PROJ="Rel. 4.4.8, 3 May 2004"
USE_STATS


I would appreciate any hint.

Best regards
Horst


------------------------------------------------

Dr. Horst Düster
GIS-Koordinator, Stv. Amtschef

Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
SO!GIS Koordination
Rötistrasse 4
CH-4501 Solothurn

Telefon ++41(0)32 627 25 32
Telefax ++41(0)32 627 22 14

mailto:horst.duester at bd.so.ch
http://www.agi.so.ch 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070302/ea39b134/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.zip
Type: application/zip
Size: 348590 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070302/ea39b134/attachment.zip>


More information about the postgis-users mailing list