I haven't been able to find a clear cut answer so I am hoping someone may be able to enlighten me.
I am working in ArcMap 10.5 and have 4 feature layers ( Primary Overhead, Primary Underground, Secondary Overhead and Secondary Underground power lines) and each of these layers has a field called 'Circuit Index.' I have a total of 14 circuits and want to do a Select by Attribute to show the Primary and Secondary power lines that are on each individual circuit. From this selection I plan to create a new shapefile that will show the service area for each circuit.
Short of going to each of my 4 layers, doing a Select by Attribute, creating a new layer from selection and then merging all selections for the particular circuit together, I'm not sure what to do.
Is there a tool that I could input all of my features into so that one selection would be created showing all features on a particular circuit or is this something that I would need to create some sort of model for?
I'm sure I could use model builder do a select by attribute then take those selections and merge them but I would have a bunch of unwanted shapefiles that I would need to go back and delete. I do not have a lot of experience using the model builder so if a model would be best route any advice on which tools to include in model builder would be appreciated; to avoid too many unwanted shapefiles.
Any and all constructive advice is much appreciated!
Best
Lukas
Now is a good opportunity to learn a little Python.
Here is the pseudo code:
If this is a task you do regularly you can use the Windows Task Scheduler to run this nightly, all hands-off.
Does this help?