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?

- Serverfault Help
- Superuser Help
- Ubuntu Help
- Webapps Help
- Webmasters Help
- Programmers Help
- Dba Help
- Drupal Help
- Wordpress Help
- Magento Help
- Joomla Help
- Android Help
- Apple Help
- Game Help
- Gaming Help
- Blender Help
- Ux Help
- Cooking Help
- Photo Help
- Stats Help
- Math Help
- Diy Help
- Gis Help
- Tex Help
- Meta Help
- Electronics Help
- Stackoverflow Help
- Bitcoin Help
- Ethereum Help