I am using ArcGIS Pro 2.9.3 with the Location Referencing extension.
I am trying to create an LRS dataset with and LRS Network, and then to Append Routes into that LRS Network from a test polyline feature class.
The test polyline feature class looks like this - it has two polylines making up Route1 and one polyine making up Route2.
The empty LRS dataset, empty LRS Network and the test polyline feature class are created using the code below. The last step of the code is to use the Append Routes tool to try and append routes from the test polyline feature class into the LRS Network and create centerlines in the Centerline feature class. It is at the last step that I get an error.
# This script is intended to create an empty LRS dataset and load
# the geometries of a test polyline feature class with route IDs (TEXT),
# Route Names (TEXT) and from/to measures (DOUBLE) into it so that an
# LRS Line Network with those routes can be created
import arcpy
arcpy.env.overwriteOutput = True
srWGS84 = arcpy.SpatialReference("GCS_WGS_1984")
arcpy.management.CreateFileGDB(r"C:\temp","test")
gdb = r"C:\temp\test.gdb"
# Create empty TestLRS dataset with default names for three feature classes
# (Calibration_Point,Centerline,Redline) and an LRS Hierarchy (TestLRS)
# within it, and three tables (Centerline_Sequence, Lrs_Edit_Log,Lrs_Locks)
print("Creating LRS dataset named {0} in {1}".format("TestLRS",gdb))
arcpy.locref.CreateLRS(gdb,"TestLRS","Centerline","Calibration_Point",
"Redline","Centerline_Sequence",srWGS84)
lrsFD = r"{0}\{1}".format(gdb,"TestLRS")
# Create empty feature class and its schema
testFC = r"{0}\testFC".format(lrsFD)
print('Creating "route-ready" polyline feature class ({0}) in LRS dataset ({1})'.format(testFC,lrsFD))
arcpy.management.CreateFeatureclass(lrsFD,"testFC","POLYLINE")
arcpy.management.AddField(testFC,"TestFCRouteID","TEXT", None, None, 10)
arcpy.management.AddField(testFC,"TestFCRouteName","TEXT", None, None, 10)
arcpy.management.AddField(testFC,"TestFCFromMeasure","DOUBLE")
arcpy.management.AddField(testFC,"TestFCToMeasure","DOUBLE")
arcpy.management.AddField(testFC,"FromDate","DATE")
arcpy.management.AddField(testFC,"ToDate","DATE")
# Write two lines and their attributes to the feature class
cursor = arcpy.da.InsertCursor(testFC,["SHAPE@","TestFCRouteID","TestFCRouteName","TestFCFromMeasure","TestFCToMeasure"])
array = arcpy.Array([arcpy.Point(0.0,0.0),
arcpy.Point(0.0,1.0)])
polyline = arcpy.Polyline(array,srWGS84)
cursor.insertRow([polyline,"Route1","Route1",0.0,1000.0])
array = arcpy.Array([arcpy.Point(0.0,1.0),
arcpy.Point(1.0,1.0)])
polyline = arcpy.Polyline(array,srWGS84)
cursor.insertRow([polyline,"Route1","Route1",1000.0,2000.0])
array = arcpy.Array([arcpy.Point(1.0,1.0),
arcpy.Point(1.0,0.0)])
polyline = arcpy.Polyline(array,srWGS84)
cursor.insertRow([polyline,"Route2","Route2",0.0,999.0])
del cursor
arcpy.management.CalculateField(testFC, "FromDate", "datetime.datetime.now()", "PYTHON3", '', "TEXT", "NO_ENFORCE_DOMAINS")
# Create empty TestLRSNetwork in TestLRS dataset
print("Creating LRS Network ({0}) in LRS dataset ({1})".format("TestLRSNetwork","TestLRS"))
arcpy.locref.CreateLRSNetwork(gdb, "TestLRS", "TestLRSNetwork",
"TestFCRouteID", "TestFCRouteName", "FromDate", "ToDate", "DO_NOT_DERIVE", '',
"DO_NOT_INCLUDE", "LineId", "LineName", "LineOrder", "METERS")
lrsNetworkFC = r"{0}\{1}".format(lrsFD,"TestLRSNetwork")
# Append routes from testFC into TestLRSNetwork which should append them into Centerline feature class at the same time
print("Appending Routes from {1} into LRS Network ({1}) in LRS dataset ({2})".format(testFC,"TestLRSNetwork","TestLRS"))
arcpy.locref.AppendRoutes(testFC,lrsNetworkFC, "TestFCRouteID", "TestFCRouteName", "FromDate", "ToDate", None, None, None, None, "ADD")
Start Time: Saturday, 25 June 2022 6:22:00 PM
Creating LRS dataset named TestLRS in C:\temp\test.gdb
Creating "route-ready" polyline feature class (C:\temp\test.gdb\TestLRS\testFC) in LRS dataset (C:\temp\test.gdb\TestLRS)
Creating LRS Network (TestLRSNetwork) in LRS dataset (TestLRS)
Appending Routes from TestLRSNetwork into LRS Network (TestLRSNetwork) in LRS dataset (TestLRS)
Traceback (most recent call last):
File "\\...\test.py", line 66, in <module>
arcpy.locref.AppendRoutes(testFC,lrsNetworkFC, "TestFCRouteID", "TestFCRouteName", "FromDate", "ToDate", None, None, None, None, "ADD")
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\locref.py", line 193, in AppendRoutes
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\locref.py", line 190, in AppendRoutes
retval = convertArcObjectToPythonObject(gp.AppendRoutes_locref(*gp_fixargs((source_routes, in_lrs_network, route_id_field, route_name_field, from_date_field, to_date_field, line_id_field, line_name_field, line_order_field, field_map, load_type), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: Validation of route attributes failed. See log for details.
More details can be found at '\\...\GP_7CB24.txt'.
Failed to execute (AppendRoutes).
Failed script test...
Failed to execute (test).
Failed at Saturday, 25 June 2022 6:22:56 PM (Elapsed Time: 56.43 seconds)
When I examine \...\GP_7CB24.txt it has this content:
The following duplicate route IDs with an overlapping time representation were found in the source data. A route ID must only have one representation at a given point in time.
Object ID Route ID From Date To Date
1 Route1 25/06/2022 6:22:38 PM NULL
2 Route1 25/06/2022 6:22:38 PM NULL
Why is it that the first route in my polyline feature class (which is made up of two features with the same route ID and name) cannot be appended into my LRS Network?
