I need get custom segment of any Linestring. For better understanding I've added image. enter image description here

Blue line is my Linestring which contains 3 points, and on the base of red point I need cut or fill line in same level as red point. How can I do that?

I use dijsktra function like that:

SELECT e.seq, e.path_seq, e.node, e.cost, e.agg_cost, w.name, w.the_geom, w.x1, w.y1, w.x2, w.y2, st_astext(w.the_geom)
FROM pgr_dijkstra('
    SELECT gid AS id,
         cost_s AS cost,
         reverse_cost_s AS reverse_cost
        FROM pgr.ways',
    directed := true)e
    left join pgr.ways w on w.gid = e.edge
    order by e.seq

and on image are my first and last edges of result which are not corresponding with ending vertexes (red points), so I need edit this edges.

  • Similar problem here Commented Mar 11, 2017 at 2:26
  • GIS SE is less a place where you state what you need and more a place where you show what you've done. Coding problems are expected to show a good-faith effort to solve the problem. Please edit the question to show your SQL. I would also note that "substring" is not a conventional term to refer to a clipped line.
    – Vince
    Commented Mar 11, 2017 at 12:37
  • @Vince Ok, I edit question and added sql of dijsktra algorithm and describe how my question is related with. I hope it is better for understanding. Commented Mar 11, 2017 at 12:54


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.