topic Select and delete features based on a condition of another polygon layer in ArcGIS Pro Questions

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

BrigitteColin — Mon, 23 Oct 2023 05:01:51 GMT

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!

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

JohannesBierer — Mon, 23 Oct 2023 07:45:40 GMT

What about select by location tool?

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

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

BrigitteColin — Mon, 23 Oct 2023 21:16:59 GMT

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?

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

BrigitteColin — Mon, 23 Oct 2023 21:56:14 GMT

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.