Optimizing Organic Waste Diversion Using a Vehicle Routing Model

Table of Contents

  1. Optimizing Organic Waste Diversion Using a Vehicle Routing Model
  2. Setting up Your Workspace
  3. Preparing the Data
  4. Skill Drill: Clip the Roads Layer to the City of Eureka
  5. Skill Drill: Add a Time Cost Attribute to the Roads Layer
  6. Skill Drill: Adding XY Data
  7. Skill Drill: Geocoding an Address  and Creating a CSV Table to Import As XY Data
  8. Creating A Network Dataset
  9. Setting up a Vehicle Routing Problem (VRP)
  10. Loading Orders into the Model
  11. Loading the Depot into the Model
  12. Adding Route Parameters into the Model
  13. Adding a Route Renewal into the Model
  14. Adjusting the Analysis Setting of Model
  15. Running the Vehicle Routing Model
  16. Skill Drill: Adding a Second Garbage Truck to the Model
  17. Skill Drill: Adjusting the Model to include Rear-Loading Trucks
  18. Skill Drill: Creating a Map of the Results

Setting up Your Workspace

By now you should be familiar with file management protocols for GIS. In a workplace setting, having consistent file management rules is necessary to prevent errors and lost data. In this course, we will be using a particular folder structure. For each lab activity, you will start by creating your workspace folder on the local hard drive. If you are a registered student at Humboldt State University working in a computer lab, you will use the desktop as your local hard drive location. You may also use an external USB drive if you plan to work in multiple places.

Avoid using networked drives such as Google Drive. Networked drives can increase processing time and cause technical glitches.

The top level folder should indicate the lab assignment. Within this folder, create the following three subfolders: original, working, and final. Your original folder will contain original unaltered data. Your working folder will contain data you create or alter through GIS analysis operations. The final folder contains any output, such as JPG, PDF maps, QAQC forms, or lab reports in the form of Microsoft Word documents. This organization represents the core folder structure you should maintain. You can create more detailed organizational structures within these folders if you wish.

An image of the Vehicle Routing Model workspace folder structure.
A basic folder structure used in this course.

Disable Background Geoprocessing

In the ArcGIS software, the Background Geoprocessing setting is often turned on by default. This setting allows users to continue to work while a tool is running in the background. However, sometimes this setting will stop tools from running or cause other unforeseen problems. To reduce that chances of the ArcGIS software crashing during this exercise, I recommend turning this setting off. After launching ArcMap, open the Geoprocessing options from the Geoprocessing menu. Under Background Geoprocessing, uncheck the box next to the word Enable.

 Network Analyst Extension

The steps in this activity involve using the Network Analyst extension. After launching ArcMap, make sure this extension is activated. You will also need to open the Network Analyst Toolbar and dock it near the top of your window for easy access. Click on the Show/Hide Network Analyst Window button to open the Network Analyst Window.  Locate this button on the Network Analyst Toolbar.

An image of the Network Analyst toolbar
The Network Analyst toolbar docked at the top of the ArcMap window. The arrow points to the Show/Hide Network Analyst Window button.

The Network Analyst Window is where you will enter or modify your vehicle routing model parameters. After running the model, the results load into a series of feature classes that appear in the Table of Contents. Novices tend to confuse the Table of Contents and the Network Analyst Window during this activity. For clarity, I recommend that you dock the Network Analyst Window on the right side of your screen while keeping the Table of Contents to the left.

An image of the Network Analyst Window docked on the right and the Table of Contents on the left.
The Table of Contents docked on the right and the Network Analyst Window docked on the left.