[postgis-users] Need to combine several multilinestrings into one
nicolas.ribot at gmail.com
Tue Sep 29 02:00:45 PDT 2015
On 28 September 2015 at 22:05, Bistrais, Bob <Bob.Bistrais at maine.gov> wrote:
> I am trying to create one multilinestring from several multilinestrings.
> These are the geom results from a pgRouting query:
> SELECT pt.geom
> FROM pgr_dijkstra(
> 'SELECT gid AS id,
> sourceroute::integer as
> targetroute::integer as
> (feet / 5280)::double
> precision AS cost,
> feet::double precision as
> as di
> JOIN ngrdsaroo2 pt on
> di.id2 = pt.gid
> -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.
> postgis-users mailing list
> postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users