Questions tagged [st-touches]
The st-touches tag has no usage guidance.
6
questions
1
vote
1
answer
43
views
Select lines that are no 'islands'
I have one table with several linestrings. I want to select all these linestrings, that do not touch any other linestrings, thus are "islands", are not connected to any other linestring. How ...
- 3,370
6
votes
2
answers
878
views
Efficient combination of st_intersects and not st_touches
I'm attempting to an efficient way to find "overlapping" polygons. Specifically we have a bunch of postal code/city/neighborhood data where I specifically don't want the default behavior of ...
3
votes
1
answer
88
views
Finding isolated links in a network of links with PostgreSQL
I have a street network from many of links in a PostgreSQL table. Some links have no connection to the network. I want to isolate these links from the network. Each link has a geometry (geom) and id ...
- 375
3
votes
1
answer
126
views
Join touched lines with point layer in PostGIS
I have a road layer and point layer. How can I merge touching lines into one line where the lines intersects the points (delete pseudo nodes)?
- 3,611
2
votes
1
answer
304
views
Checking if result of st_difference is empty
I am trying to select lines that completely touch a polygon (not at just a single point).
I would assume it would be a simple case of st_isempty(st_difference(geom_a,geom_b)).
However, this is not the ...
- 312
2
votes
1
answer
175
views
Performance optimization of ST_Touches
The query I am running is taking a considerable amount of time. I was wondering whether I am missing an opportunity to drastically improve performance.
My goal is to find out how many neighboring ...
- 585