Table of Contents
- Optimizing Organic Waste Diversion Using a Vehicle Routing Model
- Setting up Your Workspace
- Preparing the Data
- Skill Drill: Clip the Roads Layer to the City of Eureka
- Skill Drill: Add a Time Cost Attribute to the Roads Layer
- Skill Drill: Adding XY Data
- Skill Drill: Geocoding an Address and Creating a CSV Table to Import As XY Data
- Creating A Network Dataset
- Setting up a Vehicle Routing Problem (VRP)
- Loading Orders into the Model
- Loading the Depot into the Model
- Adding Route Parameters into the Model
- Adding a Route Renewal into the Model
- Adjusting the Analysis Setting of Model
- Running the Vehicle Routing Model
- Skill Drill: Adding a Second Garbage Truck to the Model
- Skill Drill: Adjusting the Model to include Rear-Loading Trucks
- Skill Drill: Creating a Map of the Results
Skill Drill: Add a Time Cost Attribute to the Roads Layer
The vehicle routing model requires a cost attribute with time units to be present in the network dataset. Create a new field in the attribute table of the clipped-roads layer. Name this field Minutes. This field will record the travel time, in minutes, for each road segment. In most cases, the road segments will have values of less than one minute travel time. Therefore, the field type should be either a float or a double. If you are ever unsure which to choose, I recommend that you always choose the double field type since it will allow for a larger number if necessary.
To calculate the travel time, in minutes, you will use the length of each road segment along with the speed limit. The road layer should have the length of each segment recorded in the Shape_Length field. However, since we have clipped the road layer, these values will need to be updated to account for any road segments that may have been altered during the Clip operation. To update the length values, use the Calculate Geometry option in the attribute table. If you will recall from previous courses, you can access Calculate Geometry by right clicking on the field name, Shape_Length. Make sure the values are saved in meters.
Note: If you can’t find the Shape_Length field, you can create your own by adding a new field in the attribute table. Then use Calculate Geometry to populate the field.
The road layer has two attributes that record the speed limit, AB_Speed, and BA_Speed. These attributes represent the speed limit, in miles per hour, for each direction. For consistency, use the AB_Speed in your calculation. Use the Field Calculator to compute the travel time and to populate the Minutes field. Your formula should factor in the AB_Speed (miles per hour) and the Shape_Length (meters) of each road segment to determine the travel time in minutes. If you will recall from previous courses, you can access Field Calculator by right clicking on the field name, Minutes.
Coming up with the right formula will involve converting miles per hour to meters per minute. Then it requires using the length of the roads to determine the travel time in minutes.
Once you have successfully calculated the minutes, you can verify the accuracy of your calculation by checking the travel time of the HWY 255 Bridge over Humboldt Bay. Just north of the exit for Woodley Island, the travel time of the road segment on HWY 255 is 1.268598 minutes. See the image above to compare the same road segment with your own data.