I have a linear asset, such as a road, that needs work done to it. The work group can only travel 5 miles per day and can only do a maximum of 5 jobs per day. I am trying to group the locations using these constraints. Some groups may be 5 miles with 5 work locations, some may be 5 miles with fewer than 5 work locations, and some may be less than 5 miles with 5 work locations.
I have both the linear asset and the work locations as spatial data with all the appropriate attributes (road name, mile points, etc). The linear asset has measure values that correspond to mile points.
What is the best way to dynamically group the work location data based upon the above mentioned constraints?