I have a python script that runs periodically that updates a "status" attribute based on location relative to another feature class.
I have a SQL table that has a list of individual exceptions, where the status is not determined solely by location.
Both the feature class that I'm trying to update and the SQL table have a unique identifier. How can I change the attribute based on the unique identifier's presence in the other table?
For example, the house with the unique ID# 12345 is updated to "available" because it within the determined distance of a property I just bought. However, I am uninterested in red houses. The table of red houses lists #12345. I need to change #12345 back to "unavailable" because it's in the list.