Hi All,<br><br>I need to generate some maps that show all of the road segments that are within a certain distance of specific points. I have been able to generate some answers using the driving_distance function, but am not sure what to do with them. Here's what I get:<br>
<br><span style="font-family: courier new,monospace;"># SELECT * FROM driving_distance('SELECT gid AS id, source, target, length::double precision AS cost FROM edges',49,2000,false,false);</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> vertex_id | edge_id | cost </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">-----------+---------+------------------</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> 15 | 9 | 1854.34547361565</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> 20 | 104 | 1549.85630678904</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> 22 | 68 | 858.367668935802</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> 23 | 125 | 1466.02479201359</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> 24 | 75 | 801.137871846872</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> 25 | 125 | 1169.02817170106</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> 26 | 106 | 1296.98197602289</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> 48 | 71 | 902.595810873304</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> 49 | 106 | 0</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> 51 | 74 | 1948.07551810288</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> 52 | 75 | 1620.93404864578</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">(11 rows)</span><br><br>These answers seem legit, but I'm not sure what to do with them. Ultimately, I need to show both the minimum enclosing polygon that "surrounds" all of the road segments, as well as the road segments themselves. Can someone please give me some pointers as to what I can do to accomplish this?<br>
<br>Thanks,<br><br>Roger<br>--<br>