I've been looking for some function that will consider geometries from a table.
The selection would look something like this:
SELECT geom FROM mytable WHERE geoid IN (1, 10, 15, 30, 2)
How can I tell if the geometries are "contiguous" (sharing at least one point or boundary with no gaps, i.e. geometries are strung together with no breaks).
For more clarity: Assume we use the "^" as a triangle and the SELECT statement above gives this result of three geometries touching and two touching geometries by themselves: ^^^ ^^ The goal is to determine that the above condition is not contiguous, but the following would be: ^^^^^