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 < [email protected]> 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 ? >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
