Skip To Content

Validate address data using batch jobs

Available with Data Reviewer license.

Tutorial summary

Features that do not meet quality requirements are centrally managed from your geodatabase as Reviewer results. Results contain information about the source of the error, how and when the error was detected, and the reason for the error.

In this tutorial, you will use data in the Data Reviewer for ArcGIS Pro tutorial package to validate address features such as road centerlines, facilities, and site addresses. Features that fail validation are written to a geodatabase to facilitate review and corrective workflows.

Estimated time

20 minutes

Software requirements

ArcGIS Pro 2.1

Data requirements

The data for this tutorial is available from the Data Reviewer for ArcGIS Pro Tutorial page. This package contains an ArcGIS Pro project package and a subset of the Local Government sample data. To download the data, follow these steps:

  1. Go to the Data Reviewer for ArcGIS Pro Tutorial page.
  2. Choose Download.
  3. Extract the files to a convenient location on your computer, such as C:\Data_Reviewer_for_ArcGIS_Pro_Tutorial.

Open the project

In this exercise, you will add two batch jobs that are part of the Data Reviewer for ArcGIS Pro tutorial package to the current project. The Addresses_AttributeValidation batch job has several Execute SQL checks that verify attribute values on Address Points, Road Centerline, and Facility Site features; the Addresses_SpatialRelationships batch job contains several checks that ensure there are no overlapping features for address ranges and that there are no duplicate features.

  1. Start ArcGIS Pro and sign in if necessary.
    Caution:

    If you have not already downloaded the Data Reviewer for ArcGIS Pro tutorial data, see the data requirements listed above.

  2. On the start page, under your recent projects, click Open another project.
    Note:

    If you already have a project open, click Open Open Project on the Quick Access Toolbar and go to step 4.

  3. On the Open page, under Open, click Computer and click Browse Browse.
  4. Browse to the Data_Reviewer\Exercise_4 folder on the Open Project dialog box.
    Note:

    The Data_Reviewer\Exercise_4 folder is located in the directory where the Data Reviewer for ArcGIS Pro tutorial package was extracted.

  5. Select DataReviewerArcGISProTutorial_Exercise4.ppkx.
  6. Click OK.
  7. The project opens with a topographic basemap with city data zoomed to Naperville, Illinois.

Add batch jobs to the project

A batch job is a container for configured validation checks that enable you to validate your data to identify features that do not meet quality requirements. For example, you can have a batch job that validates attribute values and another that validates data based on spatial conditions. Batch jobs are created using ArcMap and are referenced in your project.

In this section, you will add batch jobs to your project and use them for validating features.

  1. Click the Insert tab.
  2. In the Project group, click the Connections drop-down arrow Add Connection and click Add Reviewer Batch Jobs Add Reviewer Batch Jobs.

    The Select Reviewer Batch Jobs dialog box appears.

    Select Reviewer Workspace dialog box
  3. Browse to the Data_Reviewer\Exercise_4 folder.
    Note:

    The Data_Reviewer\Exercise_4 folder is located in the directory where the Data Reviewer for ArcGIS Pro tutorial package was extracted.

  4. Select Address_AttributeValidation.rbj and Addresses_SpatialRelationships.rbj, and click OK.

    You can select multiple files by pressing the Shift key.

    The Addresses_AttributeValidation.rbj and Addresses_SpatialRelationships.rbj files appear under the Reviewer Batch Jobs group in the Catalog pane.

  5. Click OK.

    You have now added two Reviewer batch jobs to the project and can proceed to the next section to run them on your data.

  6. You can view information about the contents of a batch job by right-clicking the Batch Job item and clicking View Metadata View Metadata. The item description information is useful in determining the number and type of checks configured in the batch job.

Validate features using batch jobs

Now that batch jobs have been added to the project, you can use them to validate features in your project to establish a baseline understanding of their quality. These batch jobs include several checks that validate conditions such as road centerline values that are not zero, duplicate geometry for address points and centerlines, and that domain values are valid.

Validate features in the active map extent

In this section, you will use a batch job to validate features in the active map extent.

  1. Click the Map tab.
  2. In the Navigate group, click Bookmark Bookmarks and click Spatial Relationships.

    The map zooms to the extent of the Spatial Relationships bookmark. This is the map extent that the Addresses_SpatialRelationships batch job will run on.

  3. In the Catalog pane, expand Reviewer Batch Jobs.
  4. Right-click Addresses_SpatialRelationships.rbj.
  5. Click Execute > Active Map Extent Active Map Extent.

    The Execute Reviewer Batch Job geoprocessing tool appears in the Geoprocessing pane. The Reviewer Workspace parameter is populated with the project's Reviewer workspace. The Session parameter is populated with the project's default Reviewer session. The Batch Job File parameter is populated with the name of the selected batch job. The Production Workspace parameter is populated with the path to the map's workspace source.

    Note:

    Once a default Reviewer session has been configured, the Session parameter for the Execute Reviewer Batch Job geoprocessing tool will automatically be populated with the default session. If you already have a session open in the Reviewer Results pane, that session will take precedence over the default session.

  6. Click Run.

    Features within the current map extent that do not comply with the rules stored in the batch job are automatically written as results to the default or active Reviewer session.

Validate features in the database

In this section, you will use a batch job to validate features in the database.

  1. In the Catalog pane, expand Reviewer Batch Jobs.
  2. Right-click Addresses_AttributeValidation.rbj.
  3. Click Execute > Full Database Full Database.

    The Execute Reviewer Batch Job geoprocessing tool appears in the Geoprocessing pane. The Reviewer Workspace parameter is populated with the project's Reviewer workspace. The Session parameter is populated with the project's default Reviewer session. The Batch Job File parameter is populated with the name of the selected batch job. The Production Workspace parameter is populated with the path to the map's workspace source.

    Note:

    Once a default Reviewer session has been configured, the Session parameter for the Execute Reviewer Batch Job geoprocessing tool will automatically be populated with the default session. If you already have a session open in the Reviewer Results pane, that session will take precedence over the default session.

  4. Click Run.

    Features within the current database that do not comply with the rules stored in the batch job are automatically written as results to the default or active Reviewer session.

In this exercise, you added Reviewer batch jobs authored in ArcMap to your ArcGIS Pro project, and used the Execute Reviewer Batch Job geoprocessing tool to identify features that do not meet data quality requirements. Validation was run on both the current map extent and all features stored in a geodatabase.

After running Reviewer batch jobs to validate data created, edited, or referenced in your project, features that fail validation are written to a geodatabase to facilitate review and corrective workflows. Move on to the next exercise to work with the Reviewer Results pane to identify and correct features in error and update the life cycle phase of a result to document your progress.

Related topics