[postgis-users] help with a query

[James Keener]

Depends on what you mean by direction. If you want to grab the start and end points (st_startpoint and st_endpoint) and check their x and y (st_x and st_y) for some condition (both less at the end?) Then update the record with the value of st_reverse.

I guess my other question is why it matters.

Jim

On September 13, 2016 8:31:07 AM EDT, Jonatan Malaver <jon.malaver at shrewsburyma.gov> wrote:
>Hello,
>
> I'm trying to come up with a query that would check the direction of a
>line. If the end point is not the start point of the next line to
>update
>the line by reversing that line. Can anyone give me pointers on how to
>do
>it?
>
>Thanks,
>Jon
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/postgis-users

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160913/dec3a30a/attachment.html>