I have a list of addresses that I need to contact. Some are listed in the attribute table, and some aren't. I'm trying to find the ones that aren't.
contacted = ['123 STOWE ST', '123 ROSE DR', '124 ROSE DR', '125 ROSE DR', etc.]
The attribute table has a
Property_Street field that lists addresses. I want to figure out which addresses are in the contacted list and are not in the
The only thing I've figured out so far is to isolate the records that have been confirmed as contacted based on the '
Contacted' field in the attribute table. But it returns a layer, not a field, and I don't know how to isolate the
Property_Street field from that layer.
query = "\"CONTACTED\" = 1" contacted_in_tbl = arcpy.SelectLayerByAttribute_management("hot_zone", "NEW_SELECTION", query)