Using PostGIS, what is an efficient way to check whether a table with a geometry column has geometries that overlap each other?
This is my table:
Column | Type | Modifiers
---------+-----------------------------+-----------
sts | character(1) |
geom | geometry(MultiPolygon,5070) |
I guess I could see whether:
SUM(ST_Area(geom))
is the same as:
SUM(ST_Area(ST_Union(geom)))
But that doesn't feel like it's likely to be the most efficient way to do it, especially since my table has about 40k features.
Any ideas?
One comment on a related question suggests one could "search for overlaps by their bounding boxes" - is that a possibility?