Greetings:
Once a month, I update my Geodatabase with updated property information from our county's assessor data. Other parts of my company need to know is different attributes change on any parcel(s) over a given time. In the past, I would export the data to Excel and use Microsoft Access to compare the different fields and product different excel reports.
I want to change my workflow and build an ArcGIS Model through model builder and/or a python script to take Feature Class 1 (Parcels_072014) and compare specific fields with Feature Class 2 (Parcels_092014). Since the Parcel Numbers (PID) doesn't change, but the associated information does (Owner Name, Site Address, ETC) and I want to be able to isolate those changes.
What is the best way to do this?
Thank You