Re: [postgis-users] Postgis overlapping two linestrings

2013-11-24 Thread Mike Toews
On 23 November 2013 05:50, Ani Alamo wrote: > Uhm... exactly I have this linestrings: > LINESTRING(2.118932325 41.398745991,2.168720219 41.385631938) > LINESTRING(2.142346041 41.398526436,2.81541 41.409216161) > > intersections gives me: > GeometryCollection: GEOMETRYCOLLECTION EMPTY > > inter

Re: [postgis-users] Postgis overlapping two linestrings

2013-11-23 Thread Martin Feuchtwanger
ST_Relate() is an interesting and versatile function: http://postgis.org/docs/ST_Relate.html (also illustrated at http://workshops.boundlessgeo.com/postgis-intro/de9im.html ) But maybe your problem is one of tolerance/roundoff-error On 22/11/2013 8:17 AM, Ani Al

Re: [postgis-users] Postgis overlapping two linestrings

2013-11-22 Thread Rémi Cura
I hope you are not runnning into a very annoying precision issue. If it were the case, you may want to try the patch I just submitted to GEOS, (https://github.com/Remi-C/libgeos). and then you would check like this : decompose line A into points (ST_DumPPoints) if any point is on line B : true el

Re: [postgis-users] Postgis overlapping two linestrings

2013-11-22 Thread Rémi Cura
You may try http://postgis.net/docs/ST_SharedPaths.html Cheers, Rémi-C 2013/11/22 Ani Alamo > I tried this function: > intersects(buffer(LINESTRING1, 0.001), buffer(LINESTRING2, 0.001)) > Always gives me "false" result. > > I don't know what to do! > > > 2013/11/22 Ani Alamo > >> Uhm... exac

Re: [postgis-users] Postgis overlapping two linestrings

2013-11-22 Thread Ani Alamo
I tried this function: intersects(buffer(LINESTRING1, 0.001), buffer(LINESTRING2, 0.001)) Always gives me "false" result. I don't know what to do! 2013/11/22 Ani Alamo > Uhm... exactly I have this linestrings: > LINESTRING(2.118932325 41.398745991,2.168720219 41.385631938) > LINESTRING(2.14234

Re: [postgis-users] Postgis overlapping two linestrings

2013-11-22 Thread Ani Alamo
Uhm... exactly I have this linestrings: LINESTRING(2.118932325 41.398745991,2.168720219 41.385631938) LINESTRING(2.142346041 41.398526436,2.81541 41.409216161) intersections gives me: GeometryCollection: GEOMETRYCOLLECTION EMPTY intersects gives me: false but when I see the line drawn on map

Re: [postgis-users] Postgis overlapping two linestrings

2013-11-22 Thread 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 wrote: > Hi! > I need a specific function to get if two linestring overlaps. e.g. > Linestring 1 is Point (0, 0) : Point (10,

[postgis-users] Postgis overlapping two linestrings

2013-11-22 Thread Ani Alamo
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,