[postgis-users] st_equals on line with tolerance

[Martin Davis]

You could test if the Hausdorff distance between the lines is less than a
tolerance value:

ST_HausdorffDistance(geom1, geom2) < tolerance

On Thu, Dec 5, 2019 at 5:59 AM Guillaume ARNAUD <
guillaume.arnaud at ledepartement82.fr> wrote:

> 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 ?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20191205/a8352f86/attachment.html>