Questions tagged [st-touches]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer

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 ...
four-eyes's user avatar
  • 3,370
6 votes
2 answers

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 ...
Tim Robertson's user avatar
3 votes
1 answer

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 ...
Tibor's user avatar
  • 375
3 votes
1 answer

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)?
spatialhast's user avatar
  • 3,611
2 votes
1 answer

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 ...
pkExec's user avatar
  • 312
2 votes
1 answer

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 ...
Zuenie's user avatar
  • 585