Reputation
Top tag
Next privilege 20 Rep.
Talk in chat
Badges
1
Newest
 Student
Impact
~925 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
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?