I have two Enterprise geodatabase feature classes that I am working with for an entire county. Both have account numbers for every different parcel of land, and in one of the feature classes (called Parcels), there is an attribute field that is marked 01 if the parcel is a preserved piece of land. The other feature class (Easements) stores just the parcels that are preserved, and does not have the same attribute field in its table. There are discrepancies (errors) that I need to fix, and I am trying to figure out the easiest way possible to do so, as Parcels has about 190,000 polygons for every parcel in the county. Here is what I need to do:
Find the parcels in the Parcel layer that are NOT marked as 01 (preserved), and need to be fixed.
Find the parcels in the Parcel layer that ARE marked as 01 that are not preserved and need to be fixed.
I have tried the Select by Location tool as well as the Select by Attribute tool, and I have used every different relationship possible under the Select by Location tool, but I still do not know of the quickest way to come up with a list of parcels that need to be marked as 01 as well as a list of parcels that need to have their 01 mark removed. I even tried to do a table compare with that tool, but since the attribute field does not exist in the Easements layer, it does not work. I hope this is worded directly enough, I have been struggling with this for a while and am at a loss, so I figured I'd take it here and see if anyone can help.
