I'm trying to create a validation routine that tells me what points are not in their expected polygon.
I have two tables with an areaid common to both- one has point geometry (building b) and the other has polygons (area a). something along the lines of the following badly phrased pseudocode!
select * from building where building point does not exist in area and a.areaid = b.areaid
All help appreciated! Thanks in advance