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:

WorkflowSupportedLicensing

Validation attribute rule

Yes (ArcGIS Pro 3.1 and ArcGIS Enterprise11.1 or later)

Available with ArcGIS Pro Standard and Data Reviewer license

Constraint attribute rule

No

N/A

Run Data Checks

Yes (ArcGIS Pro 3.5 or later)

Available with Data Reviewer license

Overview

The Find Orphan Events check identifies detached linear-referenced events from an associated route, such as events that are no longer associated with 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 with a route that doesn't exist or where the relationship is broken.

Orphan events

Attribute Rule syntax

The following table describes the validation attribute rule parameters:

ParameterRequiredDescriptionWorkflow

Subtype

No

The subtype(s) 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 of the error you define when a noncompliant feature is found.

This information is used to provide guidance for 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

Run Data Check syntax

The following table describes the Run Data Checks parameters:

ParameterRequiredDescription

Input Feature

Yes

The input feature layer that is evaluated by the rule.

Note:

You can disable a map selection or layer definition query using the toggle button that honors the selection or filter before evaluation. Layer definition queries that include a spatial clause are not supported.

Attribute Filter

No

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

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.

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.

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.

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.

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.

Route Properties/Input Route

Yes

The input route feature to which the event is referenced.

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.

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.

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.

Name

Yes

A unique name for the rule.

This information is used to support data quality requirement traceability.

Extent

Yes

  • Visible Extent—Evaluate the visible extent of the map.
  • Full Extent—Evaluate the full extent of the data.

Notes

Keep the following in mind when using the check:

  • MGDBs and FGDBs are supported.
  • This check supports validation of events stored in point and line feature classes.
  • This check supports validation of events that are stored in a geodatabase and registered with the ArcGIS Roads and Highways or ArcGIS Pipeline Referencing linear referencing system (LRS).
  • 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 <=) and logical (AND/OR, IN/NOT IN, LIKE/NOT LIKE, and IS NULL) operators.
  • The Attribute filter parameter does not support the following field types: Big Integer, Date Only, Time Only, and Timestamp Offset. If selected, the row header is marked in red and does not allow the rule to be saved.
  • Setting the default query builder mode is not supported.