Find out of range site addresses

Use ArcGIS Data Reviewer to create quality control checks to find site addresses that fall outside address ranges on your road centerline data. This check helps to ensure site address and road centerline data are integrated in to a comprehensive address inventory for your community.

To create a check to validate your site addresses, complete the following steps:

In the AddressDataManagement.mxd, open the Addresses - Site Address Points attribute table.
Add a new long integer field and name the field ADDRNUMBER.

Note:

You must create the long integer field because the geometry on geometry check can only compare values that have the same field type. In the current Local Government Information Model, the ADDRNUM is a string field, while the TOLEFT and TORIGHT are integer fields.
Calculate the ADDRNUMBER field using the following calculation:
- ADDRNUMBER = [ADDRNUM]
Click Yes to close the Field Calculator dialog box. This warning appears because not all of the ADDRNUM field is calculated since some of them have letters.
Click OK to close the Field Calculator dialog box.
Stop your edit session and save your edits.
Start a Reviewer session using MapsandGeodatabase\DataReviewer.gdb as your reviewer workspace and name your session Address Number Validation. Set the spatial reference to NAD_1983_HARN_StatePlane_Illinois_East_FIPS_1201_Feet (US Feet).

Note:

If you are using ArcGIS 10.4 Data Reviewer or ArcGIS 10.5 Data Reviewer, follow the steps in this Start a Reviewer session topic.
Create a geometry on geometry check using the following configurations:
- Feature Class/Subtype in the Feature Class 1 area: SiteAddressPoint - LocalGovernment.gdb.
- Feature Class/Subtype in the Feature Class 2 area: RoadCenterline - LocalGovernment.gdb.
- Type: Intersects.
- Check the Not - find features not in this relationship check box.
- Type 135 in the Tolerance text box and choose Feet from the Tolerance drop-down list.
  
  Note:
  
  When configuring the check using your data, identify the approximate distance from your address point to the road centerline, and use that distance as the tolerance parameter.
- Click the Compare Attribute > Select Attributes and create the following error conditions:
  - FULLNAME = FULLNAME
  - ADDRNUMBER <= TOLEFT
  - ADDRNUMBER >= FROMRIGHT
  Tip:
  
  Choose the lowest and highest fields in the road centerline feature class to compare against the address number field in the address point feature class.
Click the Bookmarks menu and choose the Sample Area bookmark.
Hide the Table of Contents.
Run the data check on the Current Extent, which runs the check on the current map extent.
Choose the Write to Reviewer Table option and click OK. The Write to Reviewer table automatically writes all records to the Reviewer table.
Open the Reviewer table and double-click on the error with ID 11411 to zoom into the error record.
Compare the site address point ADDRNUMBER value with the road centerline TOLEFT and FROMRIGHT values.

Note:

The address number is 127, while the 14th St FROMRIGHT value is 109 and the TOLEFT value is 110.

You'll find some errors that are not true errors, especially site address points close to intersections, because when the check runs, it draws a buffer around the point and finds road segments with the same FULLNAME. In some cases, the site address point close to an intersection compares its values against the wrong road segment.