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:
| Workflow | Supported | Licensing |
|---|---|---|
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.
Attribute Rule syntax
The following table describes the validation attribute rule parameters:
| Parameter | Required | Description | Workflow |
|---|---|---|---|
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:
| Parameter | Required | Description |
|---|---|---|
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 |
|
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.