Populate field in SP layer based on nearest Pole
Good afternoon ESRI Community,
I have created a model that references two layers in a versioned enterprise SDE, named SP and FSA, and one layer from a non-versioned, read-only SDE named Pole.
The idea is for this to be run as a geoprocessing tool where an end user selects an FSA on the map, and the tool populates all SP's with a subtype of 30 within the FSA with the nearest Pole number in the "SID" field.
I tried doing so using the generate near table tool, as seen above, and got error 00049: table is not editable during the Calculate Field. I also tried creating a model using the near tool, and got the same error when the near ran. Finally, I attempted to use Add Spatial Join, but am having issues with the intermediate layer remaining the scratch GDB despite telling the model to delete it after running.
Does anyone have any ideas as to what I may be doing wrong, or perhaps if there is another method that would be better to complete this workflow? I am in my version and an edit session when attempting to run these tools. Any assistance is appreciated. Thank you!
