topic Re: Add first and last stop in Route Solver in ArcGIS Network Analyst Questions

Add first and last stop in Route Solver

sotokan80_ — Fri, 19 Jan 2018 18:00:02 GMT

I m using ArcGIS 10.4.1 and NetworkAnalyst. The following part of code is used in order to solve a route layer. i am using the same starting and ending point. It works ok if i only have one route. But if i have more than one routes it doesn't work.

fieldMappings = arcpy.na.NAClassFieldMappings(outNALayer, stopsLayerName)

fieldMappings["RouteName"].mappedFieldName = "Group_ID"

#Add locations as Stops. T

#ADD FIRST STOP
arcpy.na.AddLocations(outNALayer, stopsLayerName, inStops_1, fieldMappings1, "300 meters", "FID", [["roadNetwork_ND", "MIDDLE"], ["roadNetwork_ND_Junctions", "NONE"]], "MATCH_TO_CLOSEST", "CLEAR", "NO_SNAP", "", "", "")

arcpy.na.AddLocations(outNALayer, stopsLayerName, inStops_2, fieldMappings, "300 meters", "FID", [["roadNetwork_ND", "SHAPE"], ["roadNetwork_ND_Junctions", "NONE"]], "", "APPEND", "SNAP", "", "", "")

#ADD LAST STOP

arcpy.na.AddLocations(outNALayer, stopsLayerName, inStops_1, fieldMappings1, "300 meters", "FID", [["roadNetwork_ND", "MIDDLE"], ["roadNetwork_ND_Junctions", "NONE"]], "MATCH_TO_CLOSEST", "APPEND", "NO_SNAP", "", "", "")

#Solve the route layer.
arcpy.na.Solve(outNALayer)

FYI The solved routes

the stops attribute table

the depots attribute table

Do you have any suggestions for what should i do to adapt my code so that all the routes start and finish at the same point, (a company's depot)?

Re: Add first and last stop in Route Solver

JaySandhu — Tue, 23 Jan 2018 00:30:03 GMT

What are your route analysis layer optimization settings? That is, after you add the first stop, a second stop and then the first stop again, are you solving for best order? If yes, then it will redo the sequence and visit the first and last stop at the same time. You should set it to preserve first and last.

Generally for each unique route name, the stops are visited in sequence order. So each route for every unique routename can start and end at the same location not just one only.

Jay Sandhu

Re: Add first and last stop in Route Solver

sotokan80_ — Tue, 23 Jan 2018 08:14:47 GMT

My route analysis layer optimization settings are "FIND_BEST_ORDER", and "PRESERVE_BOTH". My goal is to assign the same starting and ending to point to many routes without having to use VRP solver. inStops_2 refers to a table with which has different routenames (see the attached stops attribute table)