<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-7">
<meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EL link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US>Dear list,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>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:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>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)?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Bonus questions:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>-What type EXACTLY is the result of this function? Is it a SELECT list? An array? <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>-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.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Thank you all in advance,<o:p></o:p></span></p><p class=MsoNormal><b><span lang=EN-US style='font-size:12.0pt;font-family:"Cambria","serif";color:#1F497D'>Petros Apotsos<o:p></o:p></span></b></p><p class=MsoNormal><span lang=EN-US style='font-family:"Cambria","serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Cambria","serif";color:#1F497D'>Rural & Surveying Engineer<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Cambria","serif";color:#1F497D'>Technical Chamber of Greece Registry Number 96798<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Cambria","serif";color:#1F497D'>Ô</span><span lang=EN-US style='font-family:"Cambria","serif";color:#1F497D'>: 2310 220345<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Cambria","serif";color:#1F497D'>F: 2310 220346<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Cambria","serif";color:#1F497D'>Ermou 18A, Postal Code 54624<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Cambria","serif";color:#1F497D'>Thessaloniki, GREECE<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div> <BR><BR>__________ Information from ESET Smart Security, version of virus signature database 9154 (20131210) __________<BR><BR>The message was checked by ESET Smart Security.<BR><BR><A HREF="http://www.eset.com">http://www.eset.com</A><BR> </body></html>