Is it possible to change/define precision on/for geometry operations like STEquals
, STUnion
, ...? More concrete... let say we have to geometries in Web Mercator coordinate system (3857) where I want to have precision, let's say, on 1 decimal number.
DECLARE @g1 geometry = geometry::STGeomFromText('LINESTRING (100 100, 20 180, 180 180)', 3857);
DECLARE @g2 geometry = geometry::STGeomFromText('LINESTRING (100 100, 20 180, 180 180.0001)', 3857);
Select @g1.STEquals(@g2)
-- returns 0/false
It there a way to manipulate those functions so STEquals
would return 1/true ?