I have a parcel layer that in some cases has multiple stacked coincident parcels on top of each other. I'm trying to identify the parcels that are duplicated like that using Postgre 9.5.1/PostGIS 2.2.
What PostGIS functions would one use to determine this?
My first thought is to create a CTE and compare the two using ST_Equals, but that is returning a very large result.
There are about 2.6 million parcels in the DB.
Here's kind of what I was thinking:
with first as (select gid, geom from testing.parcel_selection) select st_equals(a.geom,b.geom) from first a, testing.parcel_selection b;