I have a Spatial Join that has a JOIN merge rule on the text field name ZONING. I find I keep having to widen the ZONING field whenever it fails on a value too long to store in it. The latest iteration failed on a value 10,704 characters long. When I attempted to make the field 11,000 wide, it told me 8000 is the max. So what can I do?
Later in the script I eliminate duplicates and put the ZONING field content in alphabetical order, but because this extreme length of value occurs in the middle of the executing Spatial Join, I don't know how to intercede there. I am eager for any suggested workarounds, please.