Tag Info

Hot answers tagged

3

I would use Python's itertools and a SearchCursor for a very efficient way to find the spatial relationships you are after. You can incorporate the geometry methods overlaps, contains, and equal to get at the geometry properties. Start off by creating a function to better organize the workflow and for repeatability def findOverlaps(x): Open a search ...


2

I have an idea what may work for you. It is going to be based off some assumptions, but it would help narrow down your list of possible identical features. This would not be an automated process, but it would require manually looking at the duplicates. Based off the comments, it seems like the automated tools don't compare attributes so this would help ...


1

You can do this in SQL using a spatial self join. You don't state which SQL dialect you are using, so this example uses Postgres/Postgis, but it could be easily adapted to Oracle or SQL Server. Assuming a table called buildings, with geometry stored in a column called geom: SELECT a.id, b.id from buildings a, buildings b WHERE ST_INTERSECTS(a.geom, ...



Only top voted, non community-wiki answers of a minimum length are eligible