AW: [postgis-users] Comparison of geometries

[Düster Horst]

--strk

I checked my geometries with isValid() and the function reports some Ring
Self-intersections and Self-intersections. This table throws the GEOS equals
error. I clean the geometry with ArcView and the Method [shape].clean. After
this clean isValid() reports Ring Self-intersections but no more
Self-intersections. Now GEOS don't throw any equals errors. The mentioned
comparison works fine.

Does there exist any way or workaround to clean a geometry table with
PostGIS or is it planned to create a function like geomClean(geometry)?

With best regards
 
Dr. Horst Düster 
GIS-Koordinator, Stv. Amtsvorsteher

Kanton Solothurn 
Amt für Geoinformation
Abteilung SO!GIS Koordination
Rötistrasse 4
CH-4501 Solothurn 

Tel.: ++41 (0)32 627 25 32 
Fax: ++41 (0)32 627 22 14

horst.duester at bd.so.ch 
www.sogis.so.ch



> -----Ursprüngliche Nachricht-----
> Von: strk at refractions.net [mailto:strk at refractions.net]
> Gesendet am: Mittwoch, 1. Februar 2006 18:59
> An: 'PostGIS Users Discussion'
> Betreff: Re: [postgis-users] Comparison of geometries
> 
> On Wed, Feb 01, 2006 at 05:38:29PM +0100, Düster Horst wrote:
> > Now I'm running into the next problem. 
> > 
> > TopologyException: side location conflict (625462,238372)
> > ERROR:  GEOS equals() threw an error!
> > 
> > select count(wkb_geometry) from table where not 
> issimple(wkb_geometry)
> > 
> > results no records. At the mentioned location 625462,238372 (Swiss
> > coordinates) I can't discover any geometrical problem.
> 
> You should use isValid() to check validity, not isSimple().
> --strk;
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>