16 reputation
1
bio website
location
age
visits member for 2 years, 2 months
seen Feb 3 '12 at 22:43

Feb
3
comment How to detect overlapping linestrings in PostGIS?
Thanks. I'll be sure to update if I come up with a faster solution.
Feb
3
awarded  Student
Feb
3
comment How to detect overlapping linestrings in PostGIS?
Perhaps this will help clarify. Let's assume I run 1 mile down the street and that is stored in r1. I have another table of previous runs in s1. I want to return all runs in s1 that overlap r1. I exclude s1 data not in r1 bounding box. Then, I use Contains on a buffered version of my run to detect s1 runs that are inside that buffer. Does that help?
Feb
3
asked How to detect overlapping linestrings in PostGIS?