What is the position of a new point on a line

[المشرف العام]

I have three tables: ways_vertices_pgr (from OSM Routing, contains road vertexes I use for creating routes and among other things their geometry), routes (geometry) and a table which holds the order information (vertex ids and order numbers, from this data and ways_vertices data I create routes). My issue is that when I select a point from ways_vertices_pgr, I have no "good" information on where on my roads this position is. Currently I do TSP algorithm and basically it works, but in case non-optimal procedures were used at first, it changes other orders as well which I don't want.What would be best solution for this case?Hopefully it's understandable, otherwise I might add some sketches.

Thanks!



أكثر...