[pgrouting-users] pgr_costresult to geometry

Petros Apotsos petrosapotsos at gmail.com
Tue Dec 10 07:18:47 PST 2013

Dear list,

I am sure this has been answered already, but I am new to this list (and
pgRouting altogether) and haven't been able to find a suitable answer. The
question is:

I am using the 2nd version of the function pgr_trsp to do sequential routing
between GPS signals on a road network. How can I convert the pgr_costresult
to a useful geometry type (LINESTRING would be great)?

Bonus questions:

-What type EXACTLY is the result of this function? Is it a SELECT list? An

-Why the heck doesn't pgRouting produce (or include respective functions to
do so) geometry results, but rather this kind of results. In most cases (if
not all) it comes down to actually needing such an output.


Thank you all in advance,

Petros Apotsos


Rural & Surveying Engineer

Technical Chamber of Greece Registry Number 96798

Τ: 2310 220345

F: 2310 220346

Ermou 18A, Postal Code 54624

Thessaloniki, GREECE


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20131210/e7ad7ef9/attachment.html>

More information about the Pgrouting-users mailing list