FULL DISCLOSURE: New to Python, so using the built in Python code blocks within field calculator would work best for me. 🙂
I'm using a Census tract shapefile with their corresponding attributes of interest within ArcMap 10.7.1. My project goal is to identify the subset of tracts that share a line segment while:
- maximizing the sum of unemployed people for all tracts (attribute #1) and
- keeping the unemployment rate for all tracts under 6.5 percent (attribute #2, unemployment rate will need to be calculated as the sum of one field divided by the sum of another field for the selected tracts).
In the past, I've used tools to identify polygons that share a border, and I used the 'Select by Attributes' tool in another project to query.
However, I'm stuck because this particular project has an interdependent set of criteria based on both spatial relationship and corresponding attributes.
How to efficiently model multiple iterations to find optimal solution?