<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML lang=en xml:lang="en"
xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE></TITLE>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<STYLE type=text/css>HTML {
OVERFLOW-X: visible
}
BODY {
OVERFLOW-X: visible
}
HTML {
PADDING-BOTTOM: 0px; OVERFLOW-X: auto; OVERFLOW-Y: auto; MARGIN: 0px; PADDING-LEFT: 0px; WIDTH: 100%; PADDING-RIGHT: 0px; HEIGHT: 100%; PADDING-TOP: 0px
}
BODY {
BACKGROUND-IMAGE: none; PADDING-BOTTOM: 5px; BACKGROUND-COLOR: transparent; MARGIN: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 5px; FONT-FAMILY: Verdana, Geneva, Arial, Helvetica, sans-serif; FONT-SIZE: 100.01%; PADDING-TOP: 5px
}
P {
PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px
}
BODY {
FONT-FAMILY: Verdana, Geneva, Arial, Helvetica, sans-serif; FONT-SIZE: 12px
}
P {
PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px
}
BLOCKQUOTE {
MARGIN-TOP: 0px; PADDING-LEFT: 5px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 5px
}
BLOCKQUOTE.quote {
BORDER-LEFT: #ccc 1px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px
}
.misspelled {
BACKGROUND: url(//webmailerng.1und1.de/static_resource/mailclient/widgets/basic/parts/maileditor/spellchecking_underline.gif) repeat-x center bottom
}
.correct {
}
.unknown {
}
.ignored {
}
</STYLE>
<META name=GENERATOR content="MSHTML 8.00.6001.18812"></HEAD>
<BODY id=bodyElement>
<DIV dir=ltr align=left><SPAN class=539231117-07102009>Kontakt,</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009>The below works fine for
me on my PostGIS 1.4 with GEOS 3.2 SVN. Which version of GEOS are you
running?</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009>Though geos 3.2 hasnt'
come out yet -- it handles these topological issues much better than GEOS 3.1
and older and others who have had these issues have been able to resolve by just
upgrading to GEOS 3.2.</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009>If you happen to be on a
windows box, we have GEOS 3.2 packaged in the windows experimental 1.5 build
(you can just copy over the geos*.dll from bin to your current 1.4 install bin
folder).</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009><A
href="http://www.postgis.org/download/windows/experimental.php">http://www.postgis.org/download/windows/experimental.php</A></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009>If you are running on
some Linux or Mac, you'll have to compile yourself.</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009>Hope that
helps,</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=539231117-07102009>Regina</SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>kontakt@westwindwetter.de<BR><B>Sent:</B> Wednesday, October 07, 2009 10:30
AM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] Problem with TopologyException<BR></FONT><BR></DIV>
<DIV></DIV>When using the new st_union with it's incredible performance,
sometimes a TopologyException occurs. The difference to older postgis or
geos-versions is, that the exception appears only as notice. I'm no longer able
to handle such exceptions in plpgsql. Is this a bug or a feature? Is there a
parameter to influence the behavior of TopologyExceptions?<BR><BR>Here's an
example:<BR><BR>All of the source geometries are valid. When combined as
multipolygon, it is invalid because of overlaps between the
source-geometries.<BR><BR>select st_union(geom) from <BR><BR>(<BR>select
st_geomfromtext('POLYGON((3551852.838 5499377.446,3551852.753
5499377.266,3551755.56 5499402.252,3551757.37 5499402.35,3551757.71
5499405.31,3551759.775 5499407.683,3551787.01 5499438.98,3551814.73
5499432.27,3551868.24 5499419.32,3551870.41 5499414.73,3551856.27
5499384.73,3551852.838 5499377.446))', 31467) as geom<BR><BR>union<BR><BR>select
st_geomfromtext('POLYGON((3551640.75 5499400.05,3551687.73
5499398.58,3551693.047 5499398.868,3551678.212 5499396.012,3551666.636
5499394.689,3551648.446 5499394.689,3551636.54 5499391.382,3551641.831
5499388.736,3551653.076 5499389.067,3551686.149 5499391.382,3551700.37
5499390.39,3551697.394 5499375.838,3551692.433 5499362.939,3551697.063
5499311.676,3551615.473 5499305.505,3551613.59 5499330.08,3551608.73
5499393.62,3551612.4 5499397.91,3551640.75 5499400.05))', 31467) as
geom<BR><BR>union<BR><BR>select st_geomfromtext('POLYGON((3551755.56
5499402.252,3551772.758 5499397.831,3551744.688 5499398.989,3551712.277
5499397.004,3551700.37 5499390.39,3551686.149 5499391.382,3551653.076
5499389.067,3551641.831 5499388.736,3551636.54 5499391.382,3551648.446
5499394.689,3551666.636 5499394.689,3551678.212 5499396.012,3551693.047
5499398.868,3551729.82 5499400.86,3551755.56 5499402.252))', 31467) as
geom<BR><BR>union<BR><BR>select st_geomfromtext('POLYGON((3551823.41
5499315.02,3551818.22 5499291.35,3551814.63 5499288.8,3551785.82
5499292.44,3551736.95 5499289.86,3551724.72 5499289.23,3551678.25
5499286.84,3551621.15 5499283.89,3551616.84 5499287.67,3551615.473
5499305.505,3551697.063 5499311.676,3551692.433 5499362.939,3551697.394
5499375.838,3551700.37 5499390.39,3551712.277 5499397.004,3551744.688
5499398.989,3551772.758 5499397.831,3551852.753 5499377.266,3551839.14
5499348.38,3551823.41 5499315.02))', 31467) as geom<BR>
<P>) sub<SPAN></SPAN></P>
<P id=__paragraph__1254925802000><BR><SPAN></SPAN></P>
<P id=__paragraph__1254925802000><SPAN>Thanks,</SPAN><SPAN></SPAN></P>
<P id=__paragraph__1254925805000><SPAN>Andreas<BR></SPAN></P><BASEFONT size=2
face=Verdana></BASEFONT></BODY></HTML>