check spatial intersection consistency by making sure no duplicate rows are returned

check.interesect.consistency.sql

-- listing only records that appear more than twice
-- in result which finds points within areas 
-- 
-- the partitioning allows us to figure the results
-- alongside corresponding dulplicate areas
-- 
-- the n.type may be skipped, is included as aexample

select * from (
  select 
    p.pid, n.id, n.type,
    count(p.pid) over (partition by p.pid) as pcnt
  from 
    parcels p 
  inner join   
    neighborhoods n
     on st_within(p.geometry, n.geometry))
where pcnt > 1
order by pcnt desc