How do I compare the attributes of two datasets with identical geometries?
Two data sets contain some 100,000 parcels. The geometries are identical in all respects but some of the attributes are different. A workflow or query is needed to find the parcels where the attributes are different.
The desired query woud be like:
parcel1.attribute NOT EQUAL to parcel2.attribute
The results should be the parcels which have different attributes.
Assuming the data is in an Oracle or SQL Server Warehouse, the procedure can be performed in a View as so:
create view diff as select parcel1.*, parcel2.* from parcel1, parcel2 where parcel1.id = parcel2.id and (parcel1.atttribute1 != parcel2.attribute1 or parcel1.atttribute2 != parcel2.attribute2)
The statement first matches all the parcels on ID, then filters in the ones with different values for attribute1 or attirubte2. If the data is in an Access warehouse, perform the process above as a Create Table Query.