<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Ok so it get's interesting trying to
use embed one function within another, for example calculating
driving distance and wrapping with alpha shape.<br>
<br>
This is as far as I've gotten:<br>
<br>
<br>
<br>
<br>
On 06/21/2013 04:07 PM, Stephen Mather wrote:<br>
</div>
<blockquote cite="mid:51C4B291.3000705@smathermather.com"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
Hi All,<br>
<br>
Having a great time with 2.0-develop. Question on
pgr_drivingDistance. I added geometry to the test dataset and
wrote the following query to return all points within driving
distance:<br>
<br>
<div class="moz-text-html" lang="x-western">
<div dir="ltr">WITH DD AS (<br>
SELECT seq, id1 AS node, cost<br>
FROM pgr_drivingDistance(<br>
'SELECT id, source, target, cost FROM
edge_table',<br>
7, 1.5, false, false<br>
)<br>
)<br>
<br>
SELECT ST_AsText(the_geom)<br>
FROM vertex_table w, DD d<br>
WHERE <a moz-do-not-send="true" href="http://w.id">w.id</a>
= d.node<br>
;<br>
<br>
</div>
</div>
A) Am I correct in my usage of this?<br>
B) Am I correct in assuming there is no way (at this time) to
return subsets of lines, similar to TSP?<br>
<br>
Best,<br>
Steve<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pgrouting-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgrouting-dev@lists.osgeo.org">pgrouting-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev">http://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>