Summary
This tool transforms the measures of events from one route reference to another and writes them to a new event table.
Usage
Transforming events allows you to use the events from one route reference with another route reference having different route identifiers and/or measures.
Any whole or partial event that intersects a target route is written to the new event table.
The best results will be achieved when the source routes and the target routes closely overlay.
The output event type (POINT or LINE) must match the input event type.
Use the Make Table View tool prior to this tool to effectively reduce the number of events that will be processed.
The output table can be displayed in ArcMap using the Make Route Event Layer tool or using the Display Route Events command in ArcMap.
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})
Parameter | Explanation | Data 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 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 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.
| 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)
# 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)
# 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)
# 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
Licensing information
- ArcGIS Desktop Basic: Yes
- ArcGIS Desktop Standard: Yes
- ArcGIS Desktop Advanced: Yes