Select and delete features based on a condition of another polygon layer

[BrigitteColin]

Hi all,

I have the following challenge. 

- 1 building footprints  (800.00 records)

- 1 state-wide layer (50 records showing 50 subareas)

I want to select/delete all building footprints that fall within one subareas polygon in the state-wide layer.  It sounds so easy but I can not find the right tool. 

The SQL code would look like this.

Select all polygons that are within the subarea xyz of layer state-wide (the second polygon layer)

Any ideas please? 

Thank you! 

[JohannesBierer]

What about select by location tool?

https://pro.arcgis.com/en/pro-app/latest/help/mapping/navigation/select-features-by-location.htm

[BrigitteColin]

Hi Johannes,

The select tool is a good start, but I can not set the condition of using only one record. I can set the relationship between the two layers, meaning intersect, or within or contains etc. This mean the whole dataset is considered and not just one record.

What I am after is that only one record will be used (of 50 in total).  For example,  select all building footprints of layer 1 and then delete all those building footprints based on an bigger polygon overlay of a single record of  layer 2.  -> Delete all building footprint in a selected polygon that contains all the single building footprints of layer 2. 

The Select tool allows me to set a distance only. Should I use this? 

Any ideas please? 

[BrigitteColin · Accepted solution]

To all - I found the solution myself !  🙂 

I did a def query to filter on this one specific record in the def query and then I used the select tool. This combination works.