Transform Route Events (Linear Referencing)

License Level:BasicStandardAdvanced

Summary

This tool transforms the measures of events from one route reference to another and writes them to a new event table.

Usage

Syntax

TransformRouteEvents_lr (in_table, in_event_properties, in_routes, route_id_field, target_routes, target_route_id_field, out_table, out_event_properties, cluster_tolerance, {in_fields})
ParameterExplanationData Type
in_table

The input event table.

Table View
in_event_properties

Parameter consisting of the route location fields and the type of events in the input event table.

  • Route Identifier Field—The field containing values that indicate along which route each event is. This field can be numeric or character.
  • Event Type—The type of events in the input event table (POINT or LINE).
    • POINT—Point events occur at a precise location along a route. Only a from-measure field must be specified.
    • LINE—Line events define a portion of a route. Both from- and to-measure fields must be specified.
  • From-Measure Field—A field containing measure values. This field must be numeric and is required when the event type is POINT or LINE. Note when the Event Type is POINT, the label for this parameter becomes Measure Field.
  • To-Measure Field—A field containing measure values. This field must be numeric and is required when the event type is LINE.
Route Measure Event Properties
in_routes

The input route features.

Feature Layer
route_id_field

The field containing values that uniquely identify each input route.

Field
target_routes

The route features to which the input events will be transformed.

Feature Layer
target_route_id_field

The field containing values that uniquely identify each target route.

Field
out_table

The table to be created.

Table
out_event_properties

Parameter consisting of the route location fields and the type of events that will be written to the output event table.

  • Route Identifier Field—The field that will contain values that indicate along which route each event is.
  • Event Type—The type of events the output event table will contain (POINT or LINE).
    • POINT—Point events occur at a precise location along a route. Only a single measure field must be specified.
    • LINE—Line events define a portion of a route. Both from- and to-measure fields must be specified.
  • From-Measure Field—A field that will contain measure values. Required when the event type is POINT or LINE. Note when the Event Type is POINT, the label for this parameter becomes Measure Field.
  • To-Measure Field—A field that will contain measure values. Required when the event type is LINE.
Route Measure Event Properties
cluster_tolerance

The maximum tolerated distance between the input events and the target routes.

Linear Unit
in_fields
(Optional)

Specifies whether the output event table will contain route location fields plus all the attributes from the input events.

  • FIELDSThe output event table will contain route location fields plus all the attributes from the input events. This is the default.
  • NO_FIELDSThe output event table will only contain route location fields plus the ObjectID field from the input events.
Boolean

Code Sample

TransformRouteEvents example (Python window)
import arcpy
from arcpy import env

env.workspace = "C:/Data"
arcpy.TransformRouteEvents_lr("pavement.dbf", "route1 LINE begin_mp end_mp", "hwy.shp", "route1", "hwy_new.shp", "route1", "trans_out1.dbf", "route1 LINE fmp tmp", "0.1 meters"  )
TransformRouteEvents example 2 (Stand-alone Python script)

The following demonstrates how to use the TransformRouteEvents function in a stand-alone Python script using file geodatabase data:

# Name: TransformRouteEvents_Example2.py
# Description: Transform point events (input table is in a file geodatabase)
# Author: ESRI

# Import system modules
import arcpy
from arcpy import env

# Set workspace
env.workspace = "C:/Data/pitt.gdb"

# Set local variables
in_tbl = "accident"
in_props = "route1 POINT measure"
in_rt = "roads/hwy"               # hwy exists in the roads feature dataset 
in_rid = "route1" 
target_rt = "roads/hwy_new"       # hwy_new exists in the roads feature dataset 
target_rid = "route1" 
out_tbl = "trans_out2"
out_props = "route1 POINT mp"
tol = "0.1 meters"  

# Execute TransformRouteEvents
arcpy.TransformRouteEvents_lr(in_tbl, in_props, in_rt, in_rid, target_rt, target_rid, out_tbl, out_props, tol)
TransformRouteEvents example 3 (Stand-alone Python script)

The following demonstrates how to use the TransformRouteEvents function in a stand-alone Python script using personal geodatabase data:

# Name: TransformRouteEvents_Example3.py
# Description: Transform point events (input table is in a personal geodatabase)
# Author: ESRI

# Import system modules
import arcpy
from arcpy import env

# Set workspace
env.workspace = "C:/Data/pitt.mdb"

# Set local variables
in_tbl = "accident"
in_props = "route1 POINT measure"
in_rt = "roads/hwy"               # hwy exists in the roads feature dataset 
in_rid = "route1" 
target_rt = "roads/hwy_new"       # hwy_new exists in the roads feature dataset 
target_rid = "route1" 
out_tbl = "trans_out2"
out_props = "route1 POINT mp"
tol = "0.1 meters"  

# Execute TransformRouteEvents
arcpy.TransformRouteEvents_lr(in_tbl, in_props, in_rt, in_rid, target_rt, target_rid, out_tbl, out_props, tol)
TransformRouteEvents example 4 (Stand-alone Python script)

The following demonstrates how to use the TransformRouteEvents function in a stand-alone Python script using ArcSDE data:

# Name: TransformRouteEvents_Example4.py
# Description: Transform point events (input table is in an enterprise geodatabase)
# Author: ESRI

# Import system modules
import arcpy
from arcpy import env

# Set workspace
env.workspace = "Database Connections/Connection to Jerry.sde"

# Set local variables
in_tbl = gp.QualifyTableName("accident", wkspc) 
in_props = "route1 POINT measure"
in_rt = gp.QualifyTableName("hwy", wkspc) 
in_rid = "route1" 
target_rt = gp.QualifyTableName("hwy_new", wkspc) 
target_rid = "route1" 
out_tbl = "trans_out3"
out_props = "route1 POINT mp"
tol = "0.1 meters"  

# Execute TransformRouteEvents
arcpy.TransformRouteEvents_lr(in_tbl, in_props, in_rt, in_rid, target_rt, target_rid, out_tbl, out_props, tol)

Environments

Related Topics

Licensing Information

ArcGIS for Desktop Basic: Yes
ArcGIS for Desktop Standard: Yes
ArcGIS for Desktop Advanced: Yes
3/3/2014