Trash Collection Study For Sparta, TN

1. Trash Collection Study For Sparta, TN Daniel Marcum

2. The Introduction • Perform a cost analysis of the current Residential Trash Collection Route. • Use GIS to create a new route that is more efficient and cost effective. • Requirement for new route: Garbage truck should only run three days per week.

3. The Data • Roads (from tngis.org) • Parcels (from State of TN) • City Limits (from Sparta GIS)

4. The Methodology • Loaded necessary files into ArcMap. • Used “polygon to point” tool to create points from parcel polygons. • Used Network Analyst to try to create an efficient route. • Loaded points into “stops” in Network Analyst.

5. The Methodology • Set options to re-order stops to optimize route. • Crashed ArcMap… 5 times… • Decided to resort to old school methods of calculating efficiency… calculator and common sense.

6. The Results • The current routes are being ran 5 days per week (103 miles/week). • The current route costs $891.64 per week ($46,365.28/yr). • The new, three-day route(80 miles/week) will cost $855.39 per week ($44,480.28/yr).

7. The Result

8. The Results • 3.4 mph • 27 miles/day • 3 days/week • 649 stops/day (1,947 stops/week) • 82 stops/hour (about 45 seconds/stop) • 60 miles of road (allowing for 80 miles per week)

9. The Results

10. The Results

11. Thank You Questions ?