<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML lang=en><HEAD><TITLE>Scalix message content</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<STYLE type=text/css>.Normal {
MARGIN-TOP: 0pt; FONT-SIZE: 12pt; MARGIN-BOTTOM: 0pt; TEXT-INDENT: 0pt; FONT-FAMILY: Arial; TEXT-ALIGN: left
}
.Default_Paragraph_Font {
FONT-WEIGHT: normal; FONT-SIZE: 12pt; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: Arial; BACKGROUND-COLOR: white; FONT-VARIANT: normal; TEXT-DECORATION: none
}
DIV.ltTOCtitle {
FONT-WEIGHT: bold; FONT-SIZE: 8pt; FONT-FAMILY: Verdana; TEXT-ALIGN: center
}
DIV.ltTOCl1 {
FONT-WEIGHT: bold; FONT-SIZE: 8pt; MARGIN-LEFT: 32pt; TEXT-INDENT: -32pt; FONT-FAMILY: Verdana
}
DIV.ltTOCl2 {
FONT-WEIGHT: bold; FONT-SIZE: 8pt; MARGIN-LEFT: 40pt; TEXT-INDENT: -32pt; FONT-FAMILY: Verdana
}
DIV.ltTOCl3 {
FONT-WEIGHT: bold; FONT-SIZE: 8pt; MARGIN-LEFT: 48pt; TEXT-INDENT: -32pt; FONT-FAMILY: Verdana
}
DIV.ltTOCl4 {
FONT-WEIGHT: bold; FONT-SIZE: 8pt; MARGIN-LEFT: 56pt; TEXT-INDENT: -32pt; FONT-FAMILY: Verdana
}
DIV.ltTOCl5 {
FONT-WEIGHT: bold; FONT-SIZE: 8pt; MARGIN-LEFT: 64pt; TEXT-INDENT: -32pt; FONT-FAMILY: Verdana
}
DIV.ltTOCl6 {
FONT-WEIGHT: bold; FONT-SIZE: 8pt; MARGIN-LEFT: 72pt; TEXT-INDENT: -32pt; FONT-FAMILY: Verdana
}
</STYLE>
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=085351212-23042008><FONT face=Arial
color=#0000ff size=2>This sometimes does the trick for me if they actually can
be unioned</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=085351212-23042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=085351212-23042008><FONT face=Arial
color=#0000ff size=2> ST_Union(GEOMCOLL,
ST_GeomFromText('GEOMETRYCOLLECTION(EMPTY)', yoursridhere) )</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=085351212-23042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=085351212-23042008><FONT face=Arial
color=#0000ff size=2>(your number 2 doesn't work because that is the aggregate
form, not because ST_Union can't handle geometry collections I
think)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=085351212-23042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=085351212-23042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=085351212-23042008></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>Hope that helps,</FONT></FONT></FONT></DIV>
<DIV><FONT><FONT color=#0000ff><FONT size=2><SPAN
class=085351212-23042008></SPAN></FONT></FONT></FONT><SPAN
class=085351212-23042008></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2>R<SPAN
class=085351212-23042008>egina</SPAN></FONT></FONT></FONT><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Düster Horst<BR><B>Sent:</B> Wednesday, April 23, 2008 2:25 AM<BR><B>To:</B>
postgis-users<BR><B>Subject:</B> [postgis-users] Geometrycollection to
Multipolygon<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">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.</SPAN></DIV><BR>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">Until now I tried the following
steps without result:</SPAN></DIV><BR>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">1. ST_BUFFER(GEOMCOLL,0.0) =>
It works but all inner rings of my input geometry are lost.</SPAN><BR><SPAN
style="FONT-SIZE: 10pt">2. ST_UNION(GEOMCOLL) => doesn't work with
Geometrycollections</SPAN></DIV><BR>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">Does anyone has a solution to
solve my problem?</SPAN></DIV><BR>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">Best regards</SPAN><BR><SPAN
style="FONT-SIZE: 10pt">Horst</SPAN></DIV><BR>
<DIV class=Normal><SPAN
style="FONT-SIZE: 10pt">------------------------------------------------</SPAN></DIV><BR>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">Dr. Horst Düster</SPAN><BR><SPAN
style="FONT-SIZE: 10pt">GIS-Koordinator, Stv. Amtschef</SPAN></DIV><BR>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">Kanton Solothurn</SPAN><BR><SPAN
style="FONT-SIZE: 10pt">Bau- und Justizdepartement</SPAN><BR><SPAN
style="FONT-SIZE: 10pt">Amt für Geoinformation</SPAN><BR><SPAN
style="FONT-SIZE: 10pt">SO!GIS Koordination</SPAN><BR><SPAN
style="FONT-SIZE: 10pt">Rötistrasse 4</SPAN><BR><SPAN
style="FONT-SIZE: 10pt">CH-4501 Solothurn</SPAN></DIV><BR>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">Telefon ++41(0)32 627 25
32</SPAN><BR><SPAN style="FONT-SIZE: 10pt">Telefax ++41(0)32 627 22
14</SPAN></DIV><BR>
<DIV class=Normal><SPAN
style="FONT-SIZE: 10pt">mailto:horst.duester@bd.so.ch</SPAN><BR><SPAN
style="FONT-SIZE: 10pt">http://www.agi.so.ch</SPAN></DIV><BR></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>