I have a postgis database with two tables. In the first table I have linestrings of a street network. The second table has points that are located on the street network.
What I want is to find the connection between these nodes using a shortest path method. The result would be an array of all the linestrings which are among these two nodes.
I want to run this code in an iterative way based on different node-pairs that I have stored in a csv file.
Which tool would you recommend me for something like this? Can pgRouting do something like this?