[postgis-users] Geometrycollection to Multipolygon

[Düster Horst]

I do have a Geometrycollection which consists of a collection of
Multipolygons and Polygons. My aim is to create one single Multipolygon
from the mentioned Geometry collection.

Until now I tried the following steps without result:

1. ST_BUFFER(GEOMCOLL,0.0) => It works but all inner rings of my input
geometry are lost.
2. ST_UNION(GEOMCOLL) => doesn't work with Geometrycollections

Does anyone has a solution to solve my problem?

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/20080423/4faa1fef/attachment.html>