[postgis-users] Postgis overlapping two linestrings

[James David Smith]

Hi Ani,

Have you looked into st_intersects() ? and st_intersection() ?

http://postgis.refractions.net/docs/ST_Intersects.html

James

On 22 November 2013 16:17, Ani Alamo <alamo.ani at gmail.com> wrote:
> Hi!
> I need a specific function to get if two linestring overlaps. e.g.
> Linestring 1 is Point (0, 0) : Point (10, 0) Linestring 2 is Point (0, 0) :
> Point (3, 0)
>
> In this case I need "true" result because LineString 1 overlaps in different
> points like 0,0 1,0 2,0 & 3,0. I dont need the common points, I only need if
> two linestring overlaps or not. I tried with this function in postgis...
>
> overlaps(buffer(LINESTRING1, 0.001), buffer(LINESTRING2, 0.001))
> I create a buffer on both linestrings... but muy problem is some times works
> better, some times not.
>
> Can you help me please?
>
> Thanks!
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users