We have been approached by our Public Works Department to try and optimize their routing for street sign inspections to improve efficiency and productivity. We are unsure of the best way to go about creating the routes. All of the signs are in a database, there are roughly 55,000 signs that need to be inspected. All trucks would leave from the same location and return to the same location each day. We are using ArcGIS 10.1.
Responding to comments below
The tool suggested is the solution we'd like to use, however, it seems to max out at 1000 stops. The stops are only a couple minutes long so it is possible to do a large number of stops per day, spread out over 4 or 5 trucks. So we are trying to figure out the best way to divide our county up into smaller chunks to be able to meet the 1000 stop threshold.