Change precision on geometry operations in SQL Server

249 views Asked by At

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 ?

0

There are 0 answers