I have a multilinestring made up of several pieces, some of which are facing the wrong direction. (Accessible here: http://pastebin.com/89Zcixv5 )
I think what I'm looking for is some utilization of ST_MakeLine, but when I try to use it, the pieces of the trail get put together wrong. (See: http://i5.minus.com/iJ5QVbaA9rm2g.png )
I have a ton of trails in this format that I need to convert from MultiLineStrings to LineStrings containing the whole trail.
If anybody has any ideas, I'd greatly appreciate all the help I can get!