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 column.
How can I get the linkids from the network, which don't touch any other links? Maybe the function is st_touches, but how can I ask this on the whole network from each link?