<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
<font class="Apple-style-span" face="Tahoma" size="2">It is the lines. I'm finding that ST_Union cleans them up pretty well.</font><div style="font-family: Tahoma; font-size: 10pt; ">cleangeometry() functions address problem polygons in the db and</div><div style="font-family: Tahoma; font-size: 10pt; ">they are processing smoothly. </div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; ">also using:</div><div><font class="Apple-style-span" face="Tahoma" size="2">http://www.kappasys.ch/pgtools/cleangeometry/cleanGeometry.sql</font></div><div><font class="Apple-style-span" face="Tahoma" size="2">prior to any CreateTopoGeo run for polygons</font></div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; ">Still trying to think through finding the offending point. I read</div><div style="font-family: Tahoma; font-size: 10pt; ">some Geos source and JTS and see that it down't have access to rowid,</div><div style="font-family: Tahoma; font-size: 10pt; ">as you said, which since it appears that you re-wrote most of it, you'd</div><div style="font-family: Tahoma; font-size: 10pt; ">know very well.</div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; "><div style="font-size: 10pt; ">If I can figure out TopoElementArray_agg and CreateTopoGeom</div><div style="font-size: 10pt; ">I'll be on my way. I hope your other users are more adept than I.</div><div style="font-size: 10pt; "><br></div><div style="font-size: 10pt; ">I'll put my box to work on another town of polygons while sleeping.</div><div style="font-size: 10pt; "><br></div><div style="font-size: 10pt; ">Chris</div></div><div style="font-family: Tahoma; font-size: 10pt; "><br><br><div>> Date: Fri, 9 Dec 2011 11:53:06 +0100<br>> From: strk@keybit.net<br>> To: postgis-users@postgis.refractions.net<br>> Subject: Re: [postgis-users] Preparing for Topology - St_CreateTopoGeo<br>> <br>> On Thu, Dec 08, 2011 at 11:59:14PM -0500, Chris English wrote:<br>> > <br>> > On error, a problematic point is indicated, but it refers to the indexbeing developed by splitting and doesn't refer to the original, offending row oidof the source file being processed to help tracing. <br>> <br>> The function doesn't know about the input rowid as it gets the combined<br>> collection of all rows. Indicating the problematic point should be enough<br>> for you to select all components in the source table which overlap that<br>> point. An index doesn't help much. If that's all you get please file a<br>> a bug to request a more useful error.<br>> <br>> > Attached a file which may or may not be of interest, two smallishshape files that successfully became topologies independently,but failed when I attempted to combine them. One multi-ploygon,one linestring. <br>> <br>> Most likely the linestrings are close to but not exactly the same as the<br>> polygon boundary. Keep collecting both, but close to the offending point<br>> (if known, see above).<br>> <br>> --strk;<br>> <br>> ,------o-. <br>> | __/ | Thank you for PostGIS-2.0 Topology !<br>> | / 2.0 | http://www.pledgebank.com/postgistopology<br>> `-o------'<br>> <br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@postgis.refractions.net<br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br></div></div> </div></body>
</html>