[postgis-users] flip lines

[Stephen Woodbridge]

On 11/6/2012 12:11 PM, Pedro Costa wrote:
> Thanks Sandro...
>
> It is possible determine the current directions before use st_reverse?

How do you define direction?
by compass? you can use st_azimith
do you lines have multiple points beyond the 2 ends? do you care about 
these when determining directions? or only the end points?

Not a trivial question without additional information.

-Steve W

> I want all lines with same direction
>
>
> Em 06-11-2012 16:37, Sandro Santilli escreveu:
>> On Tue, Nov 06, 2012 at 03:52:44PM +0000, Pedro Costa wrote:
>>> Hi,
>>>
>>> Anybody know hot to flip the direction of lines?
>>> I'm trying to do this with swap (from qgis) but don't work....
>>> How I do that with SQL?
>> ST_Reverse(line)
>>
>> --strk;
>>
>>   http://www.cartodb.com - Map, analyze and build applications with
>> your data
>>
>>                                         ~~ http://strk.keybit.net
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users