Move points to the main façade

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

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?

Move points to the main façade



Related Questions




Getting Latitude and Longitude from a Linestring

Updated February 01, 2019 21:22 PM