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

Skill Drill: Geocoding an Address  and Creating a CSV Table to Import As XY Data

The Eureka Garbage Dump will be used in the vehicle routing model as a place where the route will begin and end. It will also serve as the location for route renewals. Without a route renewal, the garbage trucks will eventually fill to capacity. At this point, the route will end whether or not all of the locations have received service. By adding a route renewal location to our model, the garbage trucks will navigate back to garbage dump, unload the cargo, and then continue to service the next business on the route.

The Eureka Garbage Dump is located at the following address:

1059 W Hawthorne St, Eureka, CA 95501

Use Google Maps or another online service to geocode the address and obtain the latitude and longitude values for this address in decimal degrees. Many websites will geocode a single address for free. Be sure to find out which spatial reference system the website uses to generate the decimal degree values. The most common spatial reference on the web is WGS 1984. In Microsoft Excel, create a CSV table with the following field headers: name, latitude, longitude. You may use Eureka Garbage Dump as the name attribute for the route renewal. Enter the latitude and longitude values in the appropriate fields. Save as a CSV table and close Excel.

Eureka Garbage Dump 40.xxxx -124.xxxxx

In ArcMap, add the CSV table as XY data, using the same workflow as for the businesses above. Use the Project tool if necessary. In the end, you should have a shapefile of the Eureka Garbage Dump using the NAD 83 UTM Zone 10 spatial reference system.

An image of the Garbage Dump layer added to ArcMap.
The Eureka Garbage Station is indicated here as a black square.