And also ST_IsSimple (that precisely check for self intersection). Cheers, Rémi-C
2015-02-26 8:32 GMT+01:00 BladeOfLight16 <bladeofligh...@gmail.com>: > On Wed, Feb 25, 2015 at 12:14 PM, Joseph Spenner <joseph85...@yahoo.com> > 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 > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users