And also ST_IsSimple (that precisely check for self intersection). Cheers, Rémi-C
2015-02-26 8:32 GMT+01:00 BladeOfLight16 <[email protected]>: > On Wed, Feb 25, 2015 at 12:14 PM, Joseph Spenner <[email protected]> > wrote: > >> DBD::Pg::st execute failed: ERROR: Error performing intersection: >> TopologyException: Input geom 1 is invalid: Self-intersection at or near >> point -381688.06935935974 -1206669.4272876547 at -381688.06935935974 >> -1206669.4272876547 at ./test.pl line 151. >> > > Did you try ST_IsValid to verify the geometry is valid according to the > OGC standard? (See > http://postgis.net/docs/using_postgis_dbmanagement.html#OGC_Validity. > ST_IsValidDetail and ST_IsValidReason are also helpful in this regard.) > What happens if you run it through ST_MakeValid? Be aware that ST_MakeValid > can sometimes result in GeometryCollections if the input shape is malformed > (usually "rings" without enough points are that have different start and > end points). > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
