[postgis-users] Preparing for Topology - St_CreateTopoGeo

[Chris English]

It is the lines.  I'm finding that ST_Union cleans them up pretty well.cleangeometry() functions address problem polygons  in the db andthey are processing smoothly. 
also using:http://www.kappasys.ch/pgtools/cleangeometry/cleanGeometry.sqlprior to any CreateTopoGeo run for polygons
Still trying to think through finding the offending point.  I readsome Geos source and JTS and see that it down't have access to rowid,as you said, which since it appears that you re-wrote most of it, you'dknow very well.
If I can figure out TopoElementArray_agg and CreateTopoGeomI'll be on my way.  I hope your other users are more adept than I.
I'll put my box to work on another town of polygons while sleeping.
Chris

> Date: Fri, 9 Dec 2011 11:53:06 +0100
> From: strk at keybit.net
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] Preparing for Topology - St_CreateTopoGeo
> 
> On Thu, Dec 08, 2011 at 11:59:14PM -0500, Chris English wrote:
> > 
> > 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.  
> 
> The function doesn't know about the input rowid as it gets the combined
> collection of all rows. Indicating the problematic point should be enough
> for you to select all components in the source table which overlap that
> point. An index doesn't help much. If that's all you get please file a
> a bug to request a more useful error.
> 
> > 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.  
> 
> Most likely the linestrings are close to but not exactly the same as the
> polygon boundary. Keep collecting both, but close to the offending point
> (if known, see above).
> 
> --strk;
> 
>   ,------o-. 
>   |   __/  |    Thank you for PostGIS-2.0 Topology !
>   |  / 2.0 |    http://www.pledgebank.com/postgistopology
>   `-o------'
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111214/973c3ba3/attachment.html>