AnsweredAssumed Answered

How to check that a Relationship has been completed for every record

Question asked by cdspatial Champion on Nov 19, 2015
Latest reply on Nov 19, 2015 by cdspatial

Is there a way to run an automated check to see if all features in one layer have have had the relationship established through the Relationship Class to their matching feature in another layer?

 

Here's the specific example:

RelationshipClassQCquestion.jpg

 

In this case we are entering a new subdivision into the City's landbase layers.  One of the tasks is creating the relationship between each Parcel Polygon and its Address Point (and its linked Address Annotation).  In the example here, as seen in the Attribute Window, the relationship has been established for this parcel and its address point. 

 

What I was wondering is if there was a way to automatically check all the parcels in this subdivision after the relationships have all been updated to ensure that each parcel does have at least one address point related to it, in order to catch omissions, as our business rule is that each parcel must have an address point.  I'm hoping there is an alternative way to check the work besides clicking on each parcel and drilling down the Attributes tree to see if the data has been related to that address point.  To clarify, checking to see that an address point is spatially located on each parcel is not the issue in this case; instead we're looking for a way to check to see if they all have been related through the Relationship Class.

 

I've not done much with Relationship Classes before, so I suspect I am missing something obvious.  We are using ArcGIS 10.2.1. and the data resides in SDE 10.2.1/SQL Server 2008 R2.

 

Thanks in advance,

 

 

Chris Donohue, GISP

Outcomes