Move points to the main façade

by Endi Soares   Last Updated October 09, 2019 18:22 PM

How can I move the points to the main façade using Postgis?

I have used the following query

SELECT ST_ClosestPoint(ln.geom, pt.geom)
FROM "testes"."line1" AS ln
   WHERE ((pt.geom <-> ln.geom) < 0.00019 )
ORDER BY pt.geom <-> ln.geom

But the points are moved to the nearest line.

How can I put the roads as a reference, so the dots move to the edge based on the orientation of the main road?

Move points to the main façade

Related Questions

Updated June 20, 2015 01:09 AM

Updated April 13, 2015 00:09 AM

Updated February 01, 2019 21:22 PM

Updated February 07, 2019 19:22 PM

Updated October 30, 2018 14:22 PM