[postgis-users] st_equals on line with tolerance

[Guillaume ARNAUD]

Hi,

I need to compare these 2 lines (srid : 2154) :

"LINESTRING(571927 6327619.2,571906.899999999 6327612.4,571826.700000003 
6327586.3,571770.600000001 6327567,571718.700000003 
6327549.9,571670.899999999 6327532.4,571589.5 6327505)"

"LINESTRING(571927 6327619.2,571906.899999999 6327612.4,571826.700000003 
6327586.3,571824.343590402 6327585.48932789,571770.600000001 
6327567,571718.700000003 6327549.9,571670.899999999 6327532.4,571589.5 
6327505)"

I want the result of sql say that it match ?

The difference is only this point : 571824.343590402 6327585.48932789 
(add by an app) and this point is very close from the first line : 
1.98930589140335e-09 m so, can i add a tolerance to compare ?

Thanks.

-- 
------------------------------------------------------------------------
	
Logo CD82 <http://www.ledepartement.fr> 	Guillaume ARNAUD
Technicien SIG
Cellule SIGD
Direction des systèmes informatiques et de télécommunication
Pôle coordination et ressources
Tél : 05 63 91 82 37
guillaume.arnaud at ledepartement82.fr
------------------------------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20191205/5c3612c6/attachment.html>