The LC Routing Project is a web-based tool designed to analyze, compare, and optimize logistics routes for landfill and haul operations. Users can upload CSV files containing stop data and landfill information, visualize routes, and generate optimized paths for improved efficiency in waste collection and transportation.
- Upload and analyze CSV files for stops and landfill sites
- Visual route selection interface for user-friendly interaction
- Route optimization at the click of a button
- Compare actual and optimized routes side-by-side
- Detailed breakdown of each route segment
- DRT to SWG conversion toggle available
The app requires two CSV files:
- Stops Array CSV – Contains a list of route stops to be analyzed
- Haul and Landfill CSV – Contains landfill and haul site information
These files should come from a prior data transformation process.
- Open the web interface by navigating to the service URL.
- Upload the Stops Array CSV and Landfill CSV files.
- After a successful upload, select a route from the interface.
- Click "Optimize Route" to generate a new optimized route.
- Use "Compare Routes" to view differences between actual and optimized paths.
- Scroll down to view detailed segment information.
- If supported, toggle DRT to SWG conversion as needed.
For a detailed breakdown of the methodology used in route optimization, see the companion Medium article: 👉 Optimizing Large Container Routes with GIS, Gurobi, and Python – A Real World Guide (Part 1: CSV)
- Export of optimized routes
- Integration with mapping APIs (e.g., Google Maps, Mapbox)
- Mobile support for field use
- Advanced analytics on route efficiency and cost savings
This project is licensed under the MIT License. See LICENSE file for more information.
Special thanks to the data transformation and logistics teams involved in preparing the input datasets for the routing process.