I push back at this: it's physically possible to pick up 1000+ trash points with curbside pickup and automated arm trucks. In reality, the route will be run by only one truck. So why can't I model it as that?
If I model it as 2 routes on a set of 1000+ points, the 2 new optimized routes split up the pickup points into disparate routes run by two different trucks...therefore possibly making the combination of the routes not as efficient as modeling it as one route.
Is there a way to to run more than 1000 points on the VRP? I've seen the Auto Commit setting (under the Geodatabase section of the Environment settings) of 1000 referencing DBMS log errors...is this what I need to change?
Unfortunately, the internal solver does not support MaxOrderCount larger than 1000. There isn't any setting you can modify to change this limit.
Thanks.
Anna
How you guys are managing to get MaxOrderCount limit of 1000?
I am using VRP REST API and I am facing limit of only 200 orders per route.
Hi Adnan,
The VRP REST API runs off of the ArcGIS Online VRP service which is where the 200 max order count that you are seeing is imposed. The 1000 max order count that was being referenced above is for using the ArcMap tool with a local network dataset or through the equivalent GP tool (not the ready to use service). The GP tool can be published to create your own VRP service but would require an ArcGIS server with network analyst instead of just using service credits.
More information can be found Overview of the Network Analyst geoprocessing service examples—Documentation | ArcGIS Enterprise
You could use some preprocessing to solve a kind of high density routing problem. It's not going to be exact, but it should be pretty good.
First create one point for each side of each street segment (where each point represents all the houses on that side of the street). That would prepare the data.
Then there would be 2 main options for the analysis:
1) Use the Location-Allocation solver to solve for as many facilities as there are routes, which will generate a cluster of stops for each route. Then run a separate optimized route for each cluster. Please note that this does not optimize the drive to/from the warehouse.
2) Use a Vehicle Routing Problem solver with dynamic seed points (See Route Seed Points class in Vehicle Routing problem classes < http://arcg.is/1XxDP25 >)
This won't change the MaxORderCount issue, but the results should still simulate what you're overall goal is.
Realy disappointed to find this is still an issue in 2020 in both ArcPro and ArcMap. Are there any plans to increase this limit so that we can solve common problems like trash collection and newspaper delivery with the tool that supposedly was made for them?
Tyler,
The VRP solver is designed for delivery scenarios where stops are spread over an area. It was not designed for arc-routing applications such as residential trash collection where every house on the block is being routed to. You can reduce the density of stops by aggregating the stops to one per edge or one per side of edge and use the VRP solver. Or you can use the Route solver to optimize one route at a time with more than a 1000 stops.
What is your use case for a single route having more than a 1000 stops?
Jay Sandhu
We were evaluating the tool for a few things, one was for grassy curb strip spraying for areas off of roadways using the start, middle and end of blocks as the delivery locations. Only some areas have grassy curbs and there are multiple service vehicles. But even with that level of generalization, it is very easy for a truck to hit way more than 1000 stops before returning.
Other tasks that we would like to be able to use this for are asset status collection. Where we would use this tool to create a route for an auditor to follow and check on the status of assets using something like ArcGIS Quickcapture to collect more than 1000 locations per day per auditor.
I understand increasing the number of stops greatly increases the complexity of the problem but our test system is able to solve 24,000 locations divided among 24 routes in less than 24 hours. Even if it's not advisable it would be nice to have the option to exceed the 1000 limit with a warning.
Thanks for the additional details on what you are trying to do. In your test system, do you already have the 24,000 locations divided into 24 routes and are trying to optimize each route OR you are trying to assign the locations to 24 routes optimally and then optimize?
Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
