Showing results for 
Search instead for 
Do you mean 

How do I Compare The Attributes of Two Datasets With Identical Geometries?

by Anonymous on ‎02-12-2016 12:21 PM - edited on ‎04-06-2016 11:29 AM by Moderator (325 Views)

Question

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. 

 

Answer

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. 

 

Contributors