Route Layer Field Mappings

sotokan80_

I m using ArcGis 10.4.1 and network analyst extension where i create a Route Analysis layer.  The following code's part is used:

#add a depot as stop.

fieldMappingsStore = arcpy.na.NAClassFieldMappings(outNALayer, stopsLayerName)
fieldMappingsStore["RouteName"].mappedFieldName = "Group_ID" #correlates fields ie naStops attribute table with inStores attribute table

fig.1 stores attribute table

#add stops

fieldMappingsStops = arcpy.na.NAClassFieldMappings(outNALayer, stopsLayerName)
fieldMappingsStops["RouteName"].mappedFieldName = "Group_ID" #correlates fields ie naStops attribute table with inStores attribute table

fig.2 stops attribute table

#AddLocations_na
arcpy.na.AddLocations(outNALayer, stopsLayerName, inDepots, fieldMappingsStore,................)
arcpy.na.AddLocations(outNALayer, stopsLayerName, inOrders, fieldMappingsStops,.................)

Apparently something is wrong with the above approach because the route layer is solved i get the following, where we can see that the first location for RouteName 1012 has SourceOID =-1 .

fig.3 Route Analysis layer stops attribute table

I don want want to use VRP because it is slower. Do i have to change my approach and merge the two shapefiles(stores and stops) or i can still use the above approach?

Melinda Morang

Hello sotokan80.  The problem here actually has nothing to do with field mapping.  Your field mapping looks fine (though you actually only need one field mapping object that you can use for both input tables).

When you see a -1 for SourceOID and the icon with a ? on it, this means that the stop is unlocated.  Note that the Status field shows a status of 1, which means "Not located".  (Status 0 means "OK".)  For some reason, when you ran Add Locations, it could not determine the network location of that particular stop.  The stop is probably far away from the network or something like that.  Perhaps the lat/long of the original point are incorrect, or perhaps the search distance you've used as an option in Add Locations is too small.