I have a very repetitive workflow that I would like to try to automate but am a beginner coder. I have looked into this before via ModelBuilder but I struggle with it because the field that I'm using to calculate an existing field is joined from the join layer, so the "naming" of that field tends to be unique and not exist before the join happens.
My workflow is as follows:
In a dozen layers, I have the same schema and fields that are calculated based off of various boundary layers. For example, fields would be: Boundary 1, Boundary 2, Boundary 3, Boundary 4, and so forth. Each of those boundary fields are pulled from polygon layers, and one line layer where join is based on 50 ft distance. Once I spatially join the boundary layer(s) to the target layer, I calculate those Boundary 1-4 fields based on the matching field in the joined layer. Because there are multiple boundary layers, I have to do this one by one for every single layer.
This seems like a VERY common workflow so I am wondering if anyone has any starting scripts or advice on the best ways to script this. For example, arcpy, ArcGIS API for Python, geopandas, maybe? Thank you!