<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:#0563C1;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New"}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
span.EstiloCorreo17
{font-family:"Calibri","sans-serif";
color:windowtext}
span.HTMLconformatoprevioCar
{font-family:"Courier New"}
.MsoChpDefault
{}
@page WordSection1
{margin:70.85pt 3.0cm 70.85pt 3.0cm}
div.WordSection1
{}
ol
{margin-bottom:0cm}
ul
{margin-bottom:0cm}
-->
</style>
</head>
<body lang="ES" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hi, I’ve tried this function and it seems not to work correctly. When it calculates the route between vertex it does well, but when using the pointsofinterest, it confuses the ids of the points and the result is incorrect.</span></p>
<p class="MsoNormal"><span lang="EN-US">If we take a look at the example:</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="background:white; border-collapse:collapse">
<tbody>
<tr>
<td style="padding:.75pt 6.0pt .75pt 3.75pt">
<p class="MsoNormal" style="line-height:16.2pt"><b><span lang="EN-US" style="font-family:"Arial","sans-serif"; color:#333333">Example:</span></b></p>
</td>
<td valign="top" style="padding:.75pt 6.0pt .75pt 3.75pt">
<p class="MsoNormal" style="line-height:16.2pt"><span lang="EN-US" style="font-family:"Arial","sans-serif"; color:#333333">From point 1 to point 3</span></p>
</td>
</tr>
</tbody>
</table>
<div style="border:dotted #0C3762 1.0pt; padding:10.0pt 10.0pt 10.0pt 10.0pt; background:#F0F0F0">
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333">SELECT * FROM pgr_withPoints(</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333"> 'SELECT id, source, target, cost, reverse_cost FROM edge_table ORDER BY id',</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333"> 'SELECT pid, edge_id, fraction, side from pointsOfInterest',</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333"> -1, -3);</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333">seq | path_seq | node | edge | cost | agg_cost
</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333">-----+----------+------+------+------+----------</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333"> 1 | 1 | -1 | 1 | 0.6 | 0</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333"> 2 | 2 | 2 | 4 | 1 | 0.6</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333"> 3 | 3 | 5 | 7 | 1 | 1.6</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333"> 4 | 4 | 8 | 6 | 0.7 | 2.6</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333"> 5 | 5 | -3 | -1 | 0 | 3.3</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt; line-height:16.2pt; background:#F0F0F0; border:none; padding:0cm">
<span lang="EN-US" style="font-size:10.0pt; font-family:"Courier New"; color:#333333">(5 rows)</span></p>
</div>
<p class="MsoNormal"><span lang="EN-US">If we follow the edges, we’ll see that it begins from the point 1 but ends at point 4. Edges sequence(1,4,7,6)</span></p>
<p class="MsoNormal"><span style=""><img width="878" height="847" id="Imagen_x0020_2" src="cid:image002.png@01D19688.566D5720" alt="../../../_images/Fig1-originalData.png"></span><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">These are the correspondences of the points</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Point of ‘Pointsofinterest’ Point used by pgr_withpoints</span></p>
<p class="MsoListParagraph" style="margin-left:211.5pt; text-indent:-176.25pt"><span lang="EN-US"><span style="">1<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US">1</span></p>
<p class="MsoListParagraph" style="margin-left:211.5pt; text-indent:-176.25pt"><span lang="EN-US"><span style="">2<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US">5</span></p>
<p class="MsoListParagraph" style="margin-left:211.5pt; text-indent:-176.25pt"><span lang="EN-US"><span style="">3<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US">4</span></p>
<p class="MsoListParagraph" style="margin-left:211.5pt; text-indent:-176.25pt"><span lang="EN-US"><span style="">4<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US">2</span></p>
<p class="MsoListParagraph" style="margin-left:211.5pt; text-indent:-176.25pt"><span lang="EN-US"><span style="">5<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US">3</span></p>
<p class="MsoListParagraph" style="margin-left:211.5pt; text-indent:-176.25pt"><span lang="EN-US"><span style="">6<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US">6</span></p>
<p class="MsoNormal"><span lang="EN-US">Hope I explained myself clearly, and sorry for my English (;P).</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Josep.</span></p>
</div>
<div class="WordSection1">
<div class="MsoNormal"><span lang="CA" style="font-size:10.0pt; font-family:"Tahoma","sans-serif"; color:black">
<hr size="2" width="100%" align="left">
</span></div>
<p class="MsoNormal"><b><span lang="CA" style="font-size:7.5pt; font-family:"Verdana","sans-serif"; color:gray">CONFIDENCIALITAT</span></b><span lang="CA" style="font-size:7.5pt; font-family:"Verdana","sans-serif"; color:gray"><br>
Aquesta</span><span lang="CA" style="font-size:7.5pt; font-family:"Verdana","sans-serif"; color:#1F497D">
</span><span lang="CA" style="font-size:7.5pt; font-family:"Verdana","sans-serif"; color:gray">informació és confidencial, personal i intransferible i només va dirigida a la/les adreça/ces indicades. Qualsevol modificació, retransmissió, difusió o altre ús
d'aquesta informació per persones o entitats diferents a la persona a qui va dirigida està prohibida. Si vostè l'ha rebut per error, li preguem que ho reenviï a
<u><a href="mailto:desconegut@tecnocampus.com"><span style="color:gray">desconegut@tecnocampus.cat</span></a></u>, i esborri el missatge original juntament amb els seus fitxers annexos sense llegir-lo ni gravar-lo. Gràcies.
<br>
Abans d'imprimir-lo, assegura't de que és realment necessari. <br>
<b>EL MEDI AMBIENT ÉS COSA DE TOTS.</b></span><b><span lang="CA" style="font-size:7.5pt; font-family:"Verdana","sans-serif""></span></b></p>
<br>
<p class="MsoNormal"><b><span lang="CA" style="font-size:7.5pt; font-family:"Verdana","sans-serif"; color:gray">CONFIDENCIALIDAD<br>
</span></b><span lang="CA" style="font-size:7.5pt; font-family:"Verdana","sans-serif"; color:gray">La
<span class="SpellE">presente</span> <span class="SpellE">información</span> es confidencial, personal e intransferible y
<span class="SpellE">sólo</span> va dirigida a la/s <span class="SpellE">dirección</span>/es
<span class="SpellE">indicadas</span>. <span class="SpellE">Cualquier</span> <span class="SpellE">
modificación</span>, <span class="SpellE">retransmisión</span>, <span class="SpellE">
difusión</span> u <span class="SpellE">otro</span> uso de esta <span class="SpellE">
información</span> por <span class="SpellE">personas</span> o <span class="SpellE">
entidades</span> <span class="SpellE">diferentes</span> a la persona a la que va dirigida
<span class="SpellE">está</span> prohibida. Si <span class="SpellE">usted</span> lo ha
<span class="SpellE">recibido</span> por error, <span class="SpellE">le</span> <span class="SpellE">
rogamos</span> que lo <span class="SpellE">reenvie</span> a </span><span class="MsoHyperlink"><span style="font-family:"Verdana","sans-serif"; color:gray"><a href="desconegut@tecnocampus.com"><span lang="CA" style="font-size:7.5pt; color:gray">desconegut@tecnocampus.com</span></a></span></span><span lang="CA" style="font-size:7.5pt; font-family:"Verdana","sans-serif"; color:gray">,
y <span class="SpellE">borre</span> el <span class="SpellE">mensaje</span> original
<span class="SpellE">junto</span> con <span class="SpellE">sus</span> <span class="SpellE">
ficheros</span> <span class="SpellE">anexos</span> sin <span class="SpellE">leerlo</span> ni
<span class="SpellE">grabarlo</span>. <span class="SpellE">Gracias</span>. <br>
Antes de imprimir, <span class="SpellE">asegúrese</span> que es <span class="SpellE">
realmente</span> <span class="SpellE">necesario</span> <span class="SpellE">hacerlo</span>.
<br>
<b>EL MEDIO AMBIENTE ES COSA DE TODOS.</b></span></p>
<p class="MsoNormal"> </p>
</div>
</body>
</html>