Find Orphan Events

Available with ArcGIS Pro Standard and Data Reviewer licenses.

Summary

The Find Orphan Events check finds linear referenced events that have no association to a route feature. Events without an association may include routes that do not exist in the linear referencing system (LRS), or retired routes associated with active events.

Supported workflows

ArcGIS Data Reviewer checks support multiple methods for implementing automated review of data. The following table identifies the supported implementation methods for this check:

ValidationConstraint

Reviewer batch job

Attribute (validation) rule

No

Yes

Yes

(ArcGIS Pro 3.1 and ArcGIS Enterprise 11.1 or later)

Overview

The Find Orphan Events check identifies detached linear referenced events from an associated route, such as events that are no longer associated to an active route in a LRS.

Industry scenarios

This check can be used in the following scenarios:

  • In roadway or pipeline management, find an event feature that has a NULL RouteId field value.
  • In roadway or pipeline management, find an event feature with a RouteId field value that does not correspond to an existing route in the LRS.

Examples

The following image illustrates error events in red that are associated to a route that doesn't exist or where the relationship is broken.

Orphan events

Syntax

ParameterRequiredExplanationWorkflow

Subtype

No

The subtype to which the rule is applied.

Validation

Attribute

No

A query that identifies the features to which the rule is applied.

Validation

Event Properties/Route Identifier

Yes

The name of the field that contains values used to associate events to routes.

The field must be a numeric data type.

Validation

Event Properties/From Measure

Yes

The name of the field that contains the starting measure value for a point or linear event feature.

The field must be a numeric data type.

Validation

Event Properties/To Measure

Yes

The name of the field that contains the ending measure value for a linear event feature.

The field must be a numeric data type.

Validation

Event Properties/Event From Date

Yes

The name of the field that contains values that define the starting date for a point or linear event feature.

The field must be a date data type.

Validation

Event Properties/Event To Date

Yes

The name of the field that contains values that define the ending date for a point or linear event feature.

The field must be a date data type.

Validation

Route Properties/Input Route

Yes

The input route feature to which the event is referenced.

Validation

Route Properties/Route Identifier

Yes

The name of the field that contains values used to associate events to routes.

The field must be a numeric data type.

Validation

Route Properties/Route From Date

Yes

The name of the field that contains values that define the starting date for a route.

The field must be a date data type.

Validation

Route Properties/Route To Date

Yes

The name of the field that contains values that define the ending date for a route.

The field must be a date data type.

Validation

Name

Yes

A unique name for the rule.

This information is used to support data quality requirement traceability, automated reporting, and corrective workflows.

Validation

Description

No

A description you define of the error when a noncompliant feature is found.

This information is used to provide guidance to facilitate corrective workflows.

Validation

Severity

No

The severity of the error assigned when a noncompliant feature is found.

This value indicates the importance of the error relative to other errors. Values range from 1 to 5, with 1 being the highest priority and 5 being the lowest.

Validation

Tags

No

The tag property of the rule.

This information is used in rule authoring and management workflows to support traceability and reporting of data quality requirements.

Validation

Notes

Keep the following in mind when using the check:

  • This check supports validation of events stored in point and line feature classes.
  • This check supports validation of events that are stored in an enterprise geodatabase and registered with the linear referencing system (LRS) of either ArcGIS Roads and Highways or ArcGIS Pipeline Referencing.
  • For partially retired routes with active associated events, the entire length of the route is captured as an error.
  • The Attribute filter parameter is limited to comparison (=, <>, >, <, >=, <=) and logical (AND/OR, IN/NOT IN, LIKE/NOT LIKE, IS NULL) operators.