I have two point layers, one has 900 records, and the other has about 11,000. I need to run the 'Find Closest Facility' tool on these data. I have tried to find a solution in ArcMap, ArcGIS Pro, and AGOL, to no avail. Does anyone know how I can run this tool for data greater than 1,000 records? Or provide an alternative function that I'm not privy to?
Already tried hosted feature layer and web feature service type storage when executing the tool in AGOL.
dtrolling - A couple questions:
Matt
Hi Matt,
1) Trying to find the closest 1 facility of 11,000 points for each of the 900 incidents; but the export would include drive time, not just distance;
2) Yes, it would be OK to do that; that solution is the only thing I've come up with. In Pro, you can generate a Near Table, so I was thinking about sub-setting the 11,000 points to just 900 by picking up the closest (in distance) single facility, and then trying to run the Closest Facilities tool in Pro or AGOL;
3) The points cover the entire U.S., including AK, HI, PR;
4) Just time/distance to each closest facility;
5) experience with Python mostly, some SQL and web programming languages.
Dave
HI Dave.
It seems to me that there are alternative methods to approach the problem.
I assume that you do not have ArcMap (including Network Analyst).
If you do not need the shape of the specific route, then I would recommend using the Origin-Destination tool. It will provide an O-D table with both Drivetime and Length.
BUT: If you did have Network Analyst, then other ways to address the problem could include implementing a Cut-off distance in the analysis settings to drastically reduce the problem that needs to be solved. That might do the trick in itself.
Alternatively you could apply fairly big Service Areas to all Facilities (without overlapping buffers), then use a Spatial Join from your Service Areas towards your incidents. Now you have established the closest facility for every incident. The final step then is to iterate (Python) specific routes, between pairs of Incidents and Facilities.
But the OD-Matrice is my best bet. It is quite fast because is doesn't need to write the shape of every route.
Kind regards
Kristoffer Waage Beck
Dang.. I just did some further reading on the O-D documentation for ArcGIS Online..
Seems we have same problem at hand. There is a maximum of 5000 Routes.
So we are back at ArcMap and Network Analyst Extension.
But in ArcMap you would have the below settings (and It's fast):
My bad.
Kind regards
Kristoffer
Given the input size being over 1000 features, you're going to have to chunk up the problem. There are various different ways to do this. Here's one workflow that should be easy to automate and doesn't consume many credits:
This workflow could be automated using python (so you don't have to do this process 900 times). However, I'm not a python programmer so can't really help with the automating step of it.
Notes on the above steps:
Hope this helps,
Matt