is there anyway to set tolerance in Postgis, in Arcgis tolerance is the minimum distance which could separate two points, if the distance between them is smaller than the tolerance so the points are considered overlapped. i need to set this parameter because i get some weird results using functions like ST_Intersects, ST_equals, ST_difference
. in this conditions i check intersecting points by ST_Distance(p1 , p2) < tolerance
but i would like to get a more robust and general solution.
in my use case i need only 1cm to 1mm precision, but for example sometimes ST_Intersects do not give expected results because of some microns (0.000001).
SELECT ST_Intersects('POINT(0.00000000000000001 0)'::geometry, 'LINESTRING ( 0 0, 0 2 )'::geometry);
No comments:
Post a Comment