<div dir="ltr"><div class="gmail_default" style="font-family:comic sans ms,sans-serif">Josep:<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">This is what is expected:<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><span style="font-family:monospace,monospace"><br> SELECT * FROM pgr_withPoints(<br> 'SELECT id, source, target, cost, reverse_cost FROM edge_table ORDER BY id',<br> 'SELECT pid, edge_id, fraction, side from pointsOfInterest',<br> -1, -3);<br> seq | path_seq | node | edge | cost | agg_cost <br>-----+----------+------+------+------+----------<br> 1 | 1 | -1 | 1 | 0.6 | 0<br> 2 | 2 | 2 | 4 | 1 | 0.6<br> 3 | 3 | 5 | 10 | 1 | 1.6<br> 4 | 4 | 10 | 12 | 0.6 | 2.6<br> 5 | 5 | -3 | -1 | 0 | 3.2<br>(5 rows)<br></span></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">Vicky<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">PD. I need the issue open so that I can commit the fix against the issue.<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">Another PD. we are in the final release details for 2.2<br>(message hasn't being sent but its being already tagged so the fix will be on a micro release)<br><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Apr 15, 2016 at 12:43 AM, Vicky Vergara <span dir="ltr"><<a href="mailto:vicky@georepublic.de" target="_blank">vicky@georepublic.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:comic sans ms,sans-serif"> Josep:<br>Your explanation is very clear, thanks for testing.<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">Please open an issue with this bug. (while I start working on it)<br><a href="https://github.com/pgRouting/pgrouting/issues" target="_blank">https://github.com/pgRouting/pgrouting/issues</a><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">Just for your information: one of the reasons that the new functionality is placed as proposed functions because of bugs that might still be there.<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">Thanks again for trying it out.<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif">Vicky<br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div><br><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div><div class="gmail_default" style="font-family:comic sans ms,sans-serif"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Thu, Apr 14, 2016 at 1:03 PM, Josep Lopez Xarbau <span dir="ltr"><<a href="mailto:jlopez@tecnocampus.cat" target="_blank">jlopez@tecnocampus.cat</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
<div link="#0563C1" vlink="#954F72" lang="ES">
<div>
<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 style="background:white;border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="padding:.75pt 6.0pt .75pt 3.75pt">
<p class="MsoNormal" style="line-height:16.2pt"><b><span style="font-family:"Arial","sans-serif";color:#333333" lang="EN-US">Example:</span></b></p>
</td>
<td style="padding:.75pt 6.0pt .75pt 3.75pt" valign="top">
<p class="MsoNormal" style="line-height:16.2pt"><span style="font-family:"Arial","sans-serif";color:#333333" lang="EN-US">>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 style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US">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 style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US"> '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 style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US"> '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 style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US"> -1, -3);</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt;line-height:16.2pt;background:#f0f0f0;border:none;padding:0cm">
<span style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US">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 style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US">-----+----------+------+------+------+----------</span></p>
<p class="MsoNormal" style="margin-bottom:9.0pt;line-height:16.2pt;background:#f0f0f0;border:none;padding:0cm">
<span style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US"> 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 style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US"> 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 style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US"> 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 style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US"> 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 style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US"> 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 style="font-size:10.0pt;font-family:"Courier New";color:#333333" lang="EN-US">(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><img src="cid:image002.png@01D19688.566D5720" alt="../../../_images/Fig1-originalData.png" height="847" width="878"></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 style="margin-left:211.5pt"><span lang="EN-US"><span>1<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US">1</span></p>
<p style="margin-left:211.5pt"><span lang="EN-US"><span>2<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US">5</span></p>
<p style="margin-left:211.5pt"><span lang="EN-US"><span>3<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US">4</span></p>
<p style="margin-left:211.5pt"><span lang="EN-US"><span>4<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US">2</span></p>
<p style="margin-left:211.5pt"><span lang="EN-US"><span>5<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-US">3</span></p>
<p style="margin-left:211.5pt"><span lang="EN-US"><span>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>
<div class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black" lang="CA">
<hr size="2" width="100%" align="left">
</span></div>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray" lang="CA">CONFIDENCIALITAT</span></b><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray" lang="CA"><br>
Aquesta</span><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:#1f497d" lang="CA">
</span><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray" lang="CA">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" target="_blank"><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 style="font-size:7.5pt;font-family:"Verdana","sans-serif"" lang="CA"></span></b></p>
<br>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray" lang="CA">CONFIDENCIALIDAD<br>
</span></b><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray" lang="CA">La
<span>presente</span> <span>información</span> es confidencial, personal e intransferible y
<span>sólo</span> va dirigida a la/s <span>dirección</span>/es
<span>indicadas</span>. <span>Cualquier</span> <span>
modificación</span>, <span>retransmisión</span>, <span>
difusión</span> u <span>otro</span> uso de esta <span>
información</span> por <span>personas</span> o <span>
entidades</span> <span>diferentes</span> a la persona a la que va dirigida
<span>está</span> prohibida. Si <span>usted</span> lo ha
<span>recibido</span> por error, <span>le</span> <span>
rogamos</span> que lo <span>reenvie</span> a </span><span><span style="font-family:"Verdana","sans-serif";color:gray"><a href="http://desconegut@tecnocampus.com" target="_blank"><span style="font-size:7.5pt;color:gray" lang="CA">desconegut@tecnocampus.com</span></a></span></span><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:gray" lang="CA">,
y <span>borre</span> el <span>mensaje</span> original
<span>junto</span> con <span>sus</span> <span>
ficheros</span> <span>anexos</span> sin <span>leerlo</span> ni
<span>grabarlo</span>. <span>Gracias</span>. <br>
Antes de imprimir, <span>asegúrese</span> que es <span>
realmente</span> <span>necesario</span> <span>hacerlo</span>.
<br>
<b>EL MEDIO AMBIENTE ES COSA DE TODOS.</b></span></p>
<p class="MsoNormal"> </p>
</div>
</div>
<br></div></div>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></blockquote></div><br><br clear="all"><br>-- <br><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><pre>Georepublic UG (haftungsbeschränkt)
Salzmannstraße 44,
81739 München, Germany
Vicky Vergara
Operations Research
eMail: vicky@<a href="http://georepublic.de" target="_blank">georepublic.de</a>
Web: <a href="https://georepublic.info" target="_blank">https://georepublic.info</a>
Tel: +49 (089) 4161 7698-1
Fax: +49 (089) 4161 7698-9
Commercial register: Amtsgericht München, HRB 181428
CEO: Daniel Kastl
<span></span></pre></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><pre>Georepublic UG (haftungsbeschränkt)
Salzmannstraße 44,
81739 München, Germany
Vicky Vergara
Operations Research
eMail: vicky@<a href="http://georepublic.de" target="_blank">georepublic.de</a>
Web: <a href="https://georepublic.info" target="_blank">https://georepublic.info</a>
Tel: +49 (089) 4161 7698-1
Fax: +49 (089) 4161 7698-9
Commercial register: Amtsgericht München, HRB 181428
CEO: Daniel Kastl
<span></span></pre></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div>