<div dir="ltr">Hello,<div><br></div><div>Use st_collect(pt.geom)</div><div><br></div><div>Nicolas</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 28 September 2015 at 22:05, Bistrais, Bob <span dir="ltr"><<a href="mailto:Bob.Bistrais@maine.gov" target="_blank">Bob.Bistrais@maine.gov</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">





<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">I am trying to create one multilinestring from several multilinestrings.  These are the geom results from a pgRouting query:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">SELECT pt.geom<u></u><u></u></p>
<p class="MsoNormal">                FROM pgr_dijkstra(<u></u><u></u></p>
<p class="MsoNormal">                                'SELECT gid AS id,<u></u><u></u></p>
<p class="MsoNormal">                                                sourceroute::integer as source,<u></u><u></u></p>
<p class="MsoNormal">                                                targetroute::integer as target,<u></u><u></u></p>
<p class="MsoNormal">                                                (feet / 5280)::double precision AS cost,<u></u><u></u></p>
<p class="MsoNormal">                                                feet::double precision as reverse_cost<u></u><u></u></p>
<p class="MsoNormal">                                                FROM ngrdsaroo2',2465,1713,false,true)
<u></u><u></u></p>
<p class="MsoNormal">                                                as di<u></u><u></u></p>
<p class="MsoNormal">                                                JOIN ngrdsaroo2 pt on di.id2 = pt.gid<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">-This returns many rows of multilinesting geometry.  I want to combine these into one geometry, so that I can save it as a route for display.  I’ve tried ST_Union, ST_LineMerge, and others, but can’t seem to get anything to work, I keep
 getting errors.<u></u><u></u></p>
</div>
</div>

<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>