<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=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
margin-bottom:12.0pt;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</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=EN-US link=blue vlink=purple>
<div class=Section1>
<p align=center style='text-align:center;line-height:13.5pt'><span
style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333'>While
applying the following tutorial: <a
href="http://anitagraser.com/2011/02/09/creating-catchment-areas-with-pgrouting-and-qgis/">http://anitagraser.com/2011/02/09/creating-catchment-areas-with-pgrouting-and-qgis/</a>
utilizing vector network which has been tested (and demonstrated functionality)
for shortest path application, it returned the following message:<o:p></o:p></span></p>
<p align=center style='text-align:center;line-height:13.5pt;background:#E9EDE7'><span
style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333'>Query
returned successfully: 1013 rows affected, 199 ms execution time<o:p></o:p></span></p>
<p align=center style='text-align:center;line-height:13.5pt'><span
style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333'>but
returned no table as output!<o:p></o:p></span></p>
<p align=center style='text-align:center;line-height:13.5pt'><span
style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333'>The
code I used is:<o:p></o:p></span></p>
<p align=center style='text-align:center;line-height:13.5pt'><span
style='font-size:10.0pt;font-family:Consolas;color:#222222;background:#EEEEEE'>create
table catchment_1 as select id, the_geom, (select sum(cost) from ( SELECT *
FROM pgr_dijkstra( 'SELECT id, source, target, st_length(geom) as cost FROM
schema.cvl', 1, 320, false, false )) as foo ) as cost from
schema.cvl_vertices_pgr </span><span style='font-size:10.5pt;font-family:"Helvetica","sans-serif";
color:#333333'><o:p></o:p></span></p>
<p align=center style='text-align:center;line-height:13.5pt'><span
style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333'>I
also tried passing "id" to the function instead of "320" as
per the tutorial but got the following msg:<o:p></o:p></span></p>
<p align=center style='text-align:center;line-height:13.5pt;background:#E9EDE7'><span
style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333'>ERROR:
function pgr_dijkstra(unknown, integer, bigint, boolean, boolean) does not
exist SQL state: 42883<o:p></o:p></span></p>
<p align=center style='text-align:center;line-height:13.5pt'><span
style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333'>Although,
pgr_dijkstra is working well with other codes.. so, it's one of the recognized
functions in my installed pgRouting layer<o:p></o:p></span></p>
<p align=center style='text-align:center;line-height:13.5pt'><span
style='font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333'>I'm
using QGIS 2.0.1 and pgRouting pg93-binaries-2.4.0<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>In order to gradually test the code, I started by the inner
SELECT then went up step by step.. I got result table for each step until I
reached the highest SELECT in the structure.. I got a table showing the cost
for each point_id. the special result is a point feature.. but what drew my attention
in the result table is that all costs are exactly the same '32430.028' whereas
the points are non-regularly distributed.. This means that I just needed to
remove 'create table catchment_1 as' to get a result table, but still the cost
values do not seem to make sense.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>LAST COMMENT.. If you know another code/method that helps in
multi-routing from one point to list of targets to result routes and costs from
single-origin (source) to multi-destinations (targets), please provide
guidance.. origins and destinations are in a single points feature (i.e.
cvl_vertices_pgr), whereas routes calculation shall take place in lines feature
(i.e. cvl).<o:p></o:p></p>
<div align=center>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<div align=center>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
</tr>
</table>
</div>
</td>
<td valign=top style='padding:0in 4.5pt 0in 5.25pt'></td>
</tr>
</table>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>