VRP schema changes

With Network Analyst now supporting the creation of the VRP layer from the Network Analysis drop-down gallery on the Analysis tab, there are a few schema changes to note when creating a layer in ArcGIS Pro or migrating your workflows from ArcGIS Desktop to ArcGIS Pro.

If you have a saved VRP .lyr file in ArcGIS Desktop, you can import it to ArcGIS Pro and the application will convert the layer to the new schema.

Learn more about the vehicle routing problem analysis layer

Note:

The Solve Vehicle Routing Problem geoprocessing tool and the ready-to-use tool still use the schema from ArcGIS Desktop. However, the new schema in ArcGIS Pro 2.6 is applied to all the VRP sublayers when the analysis layer is created using the Make Vehicle Routing Problem Analysis Layer geoprocessing tool or from the Network Analysis drop-down gallery.

Note:

Don't use a Vehicle Routing Problem analysis layer created in ArcGIS Pro 2.6 in earlier versions of ArcGIS Pro as these versions don't include the supporting schema.

The table below lists only those tables or feature classes in which the schema changes have been introduced. The right column lists the corresponding changes to the fields listed in the left column.

Schema differences

Orders table DeliveryQuantities PickupQuantities SpecialtyNames TimeWindowStart1 TimeWindowEnd1 MaxViolationTime1 ViolatedConstraints	Orders table DeliveryQuantity_1 through DeliveryQuantity_9 fields added PickupQuantity_1 through PickupQuantity_9 fields added SpecialtyNames field is deleted TimeWindowStart TimeWindowEnd MaxViolationTime ViolatedConstraint_1 through ViolatedConstraint_4
Routes table Capacities SpecialtyNames ViolatedConstraints	Routes table Capacity_1 through Capacity_9 fields added SpecialtyNames field is deleted ViolatedConstraint_1 through ViolatedConstraint_4
Breaks table	Breaks feature class
Specialties table	Specialties table is now split into two tables: Order Specialties Route Specialties
Depots table TimeWindowStart1 TimeWindowEnd1	Depots table TimeWindowStart TimeWindowEnd
DepotVisits table TotalLoadedQuantities TotalUnloadedQuantities	DepotVisits table LoadedQuantity_1 through LoadedQuantity_9 UnloadedQuantity_1 through UnloadedQuantity_9
Route Seed Points	Spatial Clustering parameter. Note: Static seed points are not supported in ArcGIS Pro.