Get path as a geometry

[latot]

Hi all!

Problem
With pgrouting, we can get the costs and paths of practically every node, this is great, but there is no easy way to transform the path, to the traveled geometry, at least in the Cost Matrix.

Improvement
I think would be great, if the functions has a new param, where we set it to true they will return a new geometry column with the traveled path.

Actually, I think can be applied in some ways, like this:

In the MatrixCost, add a new column with the full traveled path in a geometry.
While in the one2one nodes, is possible add a new geom column where is has the traveled path of the seq. Due to this, we would have n-1 linestrings, and one empty (similar to what happens with agg_cost).

Thx!

[latot]

Oks, I tested a little this, can be... very good and very bad, specially because for many2many cases, the geoms can use a lot of space on disk, really.. eats all my free disk space.

[cvvergara]

This is kind of final application purposes:

• the whole path?
• the path broken into subpaths by name?
• Maybe my application needs also the azimuth?
• Maybe my application is for social networks which do not have lat lon data

@latot have a look at the pgRouting workshop it has an example