What is the solution to the 1,000 record limit for some tools and AGOL processes?

[DaveGrolling1]

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.

[DanPatterson_Retired]

It isn't available in Pro... check the docs http://pro.arcgis.com/en/pro-app/tool-reference/appendices/unavailable-tools.htm

[CarmelConnolly]

Hi Dave, 

Do you get an error when you attempt to run the analysis?

If you're performing the analysis in ArcGIS Online, you might be limited by the Max Record Count of the feature service which is set to 1000 by default. It's possible to change this by republishing the layer from ArcMap and changing the figure through Parameters, or by changing it in the REST endpoint: Updating Hosted Feature Services in ArcGIS Online | ArcGIS Blog  

I'd recommend trying this with a test layer first to see if the process actually works. 

Carmel

[DaveGrolling1]

@Carmel_Connolly: Yes, I get the error when I either run it in ArcGIS Pro or ArcGIS Online. I've played with the max record count issue by changing it when publishing the service and also from the REST endpoint by updating the feature definition. Neither of these modified thresholds worked. My concern is that the tool specifically says, "for records up to 1,000".

[DaveGrolling1]

@Dan_Patterson: The tool in ArcGIS Pro is called Find Closest Facilities; the tool in ArcGIS Online is called Find Nearest

[DanPatterson_Retired]

Yes.. in Pro Find Closest Facilities isn't available as per my link.  Perhaps ArcMap, but then you mayrun into memory limitations

[DaveGrolling1]

In ArcMap, you need the Network Analyst extension, which I don't have.

[CarmelConnolly]

If it states it in the help that it's limited to 1000 features, then I doubt there's an out of the box work around: FindClosestFacilities—Help | ArcGIS Desktop 

Have you considered running it in batch? Potentially using model builder/python?

Carmel

[DaveGrolling1]

The drawback of running it in batches is that the layer that I'm using for Facilities, is over 1,000 (it's at 11,000). I couldn't whittle that down in batches; I would be changing the overall result of the found routes.

[CarmelConnolly]

Ah I see - tagging https://community.esri.com/community/gis/analysis/network-analyst?sr=search&searchId=e7ed56fd-4173-4... to see if it catches more eyes. 

Carmel