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 LIMIT 1);
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?