Finding Polygons which do not touch any other polygon in a single oracle database tab

المشرف العام

Administrator
طاقم الإدارة
I currently have an oracle table of approximately 100,000 records - all of which are polygons.I want to find all the polygons which do not touch any other polygon within the same table.

There are a few previous posts which use the ST_TOUCHES query but this relies on you having two geometries to compare against from different tables. Unless my understanding is incorrect?Where as what I want is a query which looks at the one table and one Geometry column and looks to see if a polygon touches another.



أكثر...
 
أعلى