Reports that can be created from Reviewer table records

With ArcGIS Data Reviewer, you can create different reports based on the records in the Reviewer table. These reports can be run for one or more Reviewer sessions. They allow you to view the check results based on different groupings or the total number of records in the table. You can also generate a report just for sampling results.

The reports are automatically generated as Microsoft Excel spreadsheets. This allows you to customize the formatting for the spreadsheet as needed.

The reports you can generate are as follows:

In addition to the preconfigured reports that are included with Data Reviewer, you can also choose to generate statistics based on the current view of the Reviewer table or export records from the table to an Excel spreadsheet.

Learn more about other types of reports that can be created with the Reviewer table records

Basic information, such as the date and time when the report was generated and by whom, the Reviewer workspace location, and the sessions on which the report has been run are all included at the top of the report.

Automated Check Report By Group

The Automated Check Report By Group report can be used to view a snapshot of the data at a specific point in time to understand how valid it is. The results in this report are grouped based on the batch job name, the date and time when the batch job was run, and batch job group. This report is based on records in the CHECKRUNTABLE and REVTABLEMAIN tables.

NotaNota:

This report does not include results from the Sampling and Metadata checks.

Example of an automated check report by group

The following columns are included in this report:

Column name

Description

Notes

Batch Job Name

The name of the batch job or single check that has been run in the Reviewer session

Date/Time

The date and time when the batch job or single check has been run

Batch Job Group

The name of the group in which the check is contained, as indicated in the batch job

Check Type

The type of check that has been run on the data

Check Title

The title of the check, if one has been specified in the Check Title text box on the check's properties dialog box

If a title has not been specified, the value is Check Name (Feature Class 1, Subtype).

Records Validated

The total number of features that have been validated by the check or batch job

Total Results

The total number of results returned by the checks in the batch job

Total Percent Accuracy

The accuracy of the data, based on the number of results from the total number of features validated

This is calculated as

(1 - (Total Results / Records Validated)) * 100

Distinct Results

The number of unique results from the total number of records validated

In instances where a feature is a result for multiple checks, it would only be counted as a distinct result once.

Distinct Percent Accuracy

The accuracy of the distinct results

This is calculated as

( 1 - (Distinct Results /  Records Validated)) * 100

Columns in the Automated Check Report By Group report

Automated Check Report By Origin Table

The Automated Check Report By Origin Table report can be used to view a snapshot of the data at a specific point in time to understand how valid it is. The results in this report are grouped based on the batch job name, the date and time when the batch job was run, and the feature class or table validated. This report is based on records in the CHECKRUNTABLE and REVTABLEMAIN tables.

NotaNota:

This report does not include results from the Sampling and Metadata checks.

Example of the automated check report by origin table

The following columns are included in this report:

Column name

Description

Notes

Batch Job Name

The name of the batch job or single check that has been run in the Reviewer session

Date/Time

The date and time when the batch job or single check has been run

Origin Table

The name of the feature class or table that has been validated using the check

Check Type

The type of check that has been run on the data

Check Title

The title of the check, if one has been specified in the Check Title text box on the check's properties dialog box

If a title has not been specified, the value is Check Name (Feature Class 1, Subtype).

Records Validated

The total number of features that have been validated by the check or batch job

Total Results

The total number of results returned by the checks in the batch job

Total Percent Accuracy

The accuracy of the data, based on the number of results from the total number of features validated

This is calculated as

(1 - (Total Results / Records Validated)) * 100

Distinct Results

The number of unique results from the total number of records validated

In instances where a feature is a result for multiple checks, it would only be counted as a distinct result once.

Distinct Percent Accuracy

The accuracy of the distinct results

This is calculated as

( 1 - (Distinct Results /  Records Validated)) * 100

Columns in the Automated Check Report By Origin Table report

Automated Check Report By Subtype

The Automated Check Report By Subtype report can be used to view a snapshot of the data at a specific point in time to understand how valid it is. The results in this report are grouped based on the batch job name, the date and time when the batch job was run, the feature class or table validated, and the subtype. This report is based on records in the CHECKRUNTABLE and REVTABLEMAIN tables.

NotaNota:

This report does not include results from the Sampling and Metadata checks.

Example of the automated check report by subtype

The following columns are included in this report:

Column name

Description

Notes

Batch Job Name

The name of the batch job or single check that has been run in the Reviewer session

Date/Time

The date and time when the batch job or single check has been run

Origin Table

The name of the feature class or table that has been validated using the check

Subtype

The name of the feature class subtype that has been validated using the check

Check Type

The type of check that has been run on the data

Check Title

The title of the check, if one has been specified in the Check Title text box on the check's properties dialog box

If a title has not been specified, the value is Check Name (Feature Class 1, Subtype).

Records Validated

The total number of features that have been validated

Total Results

The total number of results returned by the checks in the batch job

Total Percent Accuracy

The accuracy of the data, based on the number of results from the total number of features validated

This is calculated as

(1 - (Total Results / Records Validated)) * 100

Distinct Results

The number of unique results from the total number of records validated

In instances where a feature is a result for multiple checks, it would only be counted as a distinct result once.

Distinct Percent Accuracy

The accuracy of the distinct results

This is calculated as

( 1 - (Distinct Results /  Records Validated)) * 100

Columns in the Automated Check Report By Subtype report

Report By Total Record Count

The Report By Total Record Count report contains a summary of all the records in the Reviewer table. This report can be used to see how many results have been reported by the checks out of all the features in a feature class. The results are grouped by origin table (feature class or table name), then by the type of check that has been used to validate the data.

NotaNota:

This report does not include results from the Sampling and Metadata checks.

Example of the total record count report

The following columns are included in this report:

Column name

Description

Notes

Origin Table

The name of the feature class or table that has been validated using the check

Check Type

The type of check that has been run on the data

Check Title

The title of the check, if one has been specified in the Check Title text box on the check's properties dialog box

If a title has not been specified, the value is Check Name (Feature Class 1, Subtype).

Total Records

The total number of features that have been validated by the check or batch job

Total Results

The total number of features or rows in the Origin table when the report was generated.

Total Percent Accuracy

The accuracy of the data, based on the number of results from the total records in the Origin table

This is calculated as

(1 - (Total Results / Records Validated)) * 100

Distinct Results

The number of unique results from the total number of records in the Origin table

In instances where a feature is a result for multiple checks, it would only be counted as a distinct result once.

Distinct Percent Accuracy

The accuracy of the distinct results

This is calculated as

( 1 - (Distinct Results /  Records Validated)) * 100

Columns in the Report By Total Record Count report

Sampling Report

The Sampling report only contains results from the Sampling check. By default, there are four worksheets created in the Excel workbook: one for each of the possible sampling methods. The results of the check only appear on the worksheet that corresponds with the sampling method you chose for the Sampling check. For instance, if you use a polygon grid to determine what data is going to be sampled, information only appears on the Grid worksheet. The other worksheets contain header information but no other information.

The following columns are included in this report:

Column name

Description

Notes

Check Title

The title of the check, if one has been specified in the Check Title text box on the check's properties dialog box.

If a title has not been specified, the value is Check Name (Feature Class 1, Subtype).

Date/Time

The date and time on which the Sampling check was run

Grid Name

The cell number in the polygon grid that is part of the sample.

This column only appears if the Use Grid method has been used to create the sample.

Origin Table

The name of the feature class or table that has been sampled using the check.

Subtype

The name of the feature class subtype that has been sampled.

Total Records

The total number of records in the feature class.

Confidence Level

The confidence level specified on the Sampling Check Properties dialog box.

This is the level of confidence that the sample size is statistically significant.

This column only appears if the Auto Calculate method has been used to create the sample.

Margin of Error

The margin of error value specified on the Sampling Check Properties dialog box.

This is the acceptable margin of error in the confidence level.

This column only appears if the Auto Calculate method has been used to create the sample.

Sampling Number

The number of features included in the sample.

If the Use Grid method has been used, a total number of features is provided for the grid cell, then for each Origin Table within the cell.

Sampling Percentage

The percentage of features included in the sample from the feature class. This number is based on the weight assigned to the feature class on the Sampling Check Properties dialog box.

The column only appears if the Percentage method has been used to create the sample.

Acceptable Error Percentage

The acceptable error percentage specified on the Sampling Check Properties dialog box.

This value indicates the acceptable error ratio.

This column only appears if the Auto Calculate method has been used to create the sample.

Acceptable Error

The number of errors the feature class can contain before it is considered invalid given the specified confidence interval, acceptable error percentage, and sampling size.

This column only appears if the Auto Calculate method has been used to create the sample.

Number of Errors

The total number of sampled features that are considered errors.

The number of errors is determined by the number of records from the sample that have been updated with a status of Failed.

Percent Accuracy

The percentage of sampled records that are correct based on the number of features included in the sample and the number that have a status of Failed.

This column is displayed on all sampling reports except when the Auto Calculate method is used.

This value is calculated as

(1 - (Number of Errors / Sampling Number)) * 100

Pass/Fail

Indicates whether the feature class passes or fails the quality control process based on the number of errors versus acceptable errors.

This column only appears if the Auto Calculate method has been used to create the sample.

If the number of errors exceed the acceptable errors, the feature class has a value of Fail.

QC Complete

Indicates whether quality control is complete for the sampled features.

This column only says Yes if the sampling records for a feature class have all been reviewed and their status changed to something other than Needs Review.

Columns in the Sampling report

Other types of reports that can be created

In addition to the reports that can be generated from the Reports command on the Reviewer Table window, you can also create a text file that contains statistics from the Reviewer table or export the entire table to an Excel spreadsheet.

Learn more about generating Reviewer table statistics

Learn more about exporting the Reviewer table to an Excel spreadsheet


9/30/2010