<!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=952350113-24042008><FONT face=Arial
color=#0000ff size=2>Horst,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=952350113-24042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=952350113-24042008><FONT face=Arial
color=#0000ff size=2>Would be good if you also posted this to the PostGIS
wiki.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=952350113-24042008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=952350113-24042008><FONT face=Arial
color=#0000ff size=2>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=952350113-24042008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<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> Thursday, April 24, 2008 8:49 AM<BR><B>To:</B>
postgis-users<BR><B>Subject:</B> [postgis-users] PostGIS Geometry Clean
function<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">In the last few days I developed
a plpgsql function to clean not valid polygon and linestring geometries. This
function cleans all ring-self- and self-intersections in PostGIS layers.
</SPAN></DIV><BR>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">The input is a valid or non
valid geometry with one or more self-intersections. The result is a clean Multi
geometry where all intersections are correct noded and divided into multiparts.
I tested it with polygon layers with more than 800000 objects and it works fine
for me. You can use the function with PostGIS >= 1.3.2. If you want to use it
with PostGIS 1.1.6 you have to modify the source and remove all ST_ from the
specific funktion names. </SPAN></DIV><BR>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">I hope the function could be
helpful for you, for me it is.</SPAN></DIV><BR>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">Looking forward for your
comments.</SPAN></DIV><BR>
<DIV class=Normal><SPAN style="FONT-SIZE: 10pt">Best regards</SPAN></DIV><BR>
<DIV class=Normal><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>