[postgis-users] linestring vertex order after st_union

Rorie Overby ogrears at hotmail.com
Wed Mar 11 19:07:38 PDT 2009

I'm wondering if the order of a linestring's vertices can be adjusted when unioning geometries. It seems like they aren't, but should be when unioning multiple smaller components into one long multilinestring. 

For example, when unioning these linestrings

 (0 0,0 1,0 2),(0 4,0 3,0 2),(0 4,0 5,0 6)

I'd want to get this multilinestring returned

((0 0,0 1,0 2),(0 2,0 3,0 4),(0 4,0 5,0 6))

Is there a method of returning the order (right/left) of a linestring's vertices, or better yet, is there any way to force unioned geometries to use the same vertex order?

Express your personality in color! Preview and select themes for Hotmail®. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090311/f8af0788/attachment.html>

More information about the postgis-users mailing list