nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Closest Facility: only have 1000 Incidents but get "The maximum records for Incidents limit of 5000 has been exceeded."

RyanSnead

As the title says, I am running Closest Facility under the Network Analyst toolset. I have over 9000 institutions but I have broken up my shapefiles so there are only 1000 in each. When I run the analysis with one of my 1000 row features, I still receive this error: "The maximum records for Incidents limit of 5000 has been exceeded.". Does it matter how many facilities I have? The feature I'm currently using for facilities only has 117. I have others that I plan on using which have over 1000. Regardless, why do I keep getting this error when I am using far fewer than the 5000 Institution limit? This is ArcGIS Pro.

Thanks for your help!

Find more posts tagged with

Accepted answers

Melinda Morang

Correct, the Ready-to-Use tools are a separate way of running a Closest Facility problem from the standard network analysis layer workflow. In fact, the Network Analyst Ready-to-Use tools will be deprecated in the forthcoming ArcGIS Pro 3.1 release because they represent an older workflow we no longer wish to support, so it's best if you avoid this tool and instead use the layer workflow.

You can follow this tutorial to learn how: https://pro.arcgis.com/en/pro-app/latest/help/analysis/networks/closest-facility-tutorial.htm The tutorial shows how to complete the workflow using a local network dataset, but you can use the exact same workflow using ArcGIS Online as the network data source.

Please give this a try and see if you still run into the same credit usage limitation (you shouldn't).

All comments

Melinda Morang

Hello. The answer likely depends on how you're doing this Closest Facility calculation. I can't quite tell from your question. Did you create a Closest Facility layer, and are you using the Add Locations tool to insert the incidents? If this is what you're doing, then perhaps you have forgotten to uncheck the "Append" option. So each time you add a chunk of incidents, they're being added to the incidents already in the layer, so your layer has more than 5000 incidents in it.

But if your workflow is different, please describe it in more detail so we can figure out where the problem is.

Also, I presume from your question that you're using ArcGIS Online as your network data source. Could you please confirm that this is what you're doing?

RyanSnead

Thank you! Yes, I am using ArcGIS Online. I was using the Closest Facilities analysis from the Ready-to-Use Tools. I don't think this is the same as making the Closest Facility layer.

Melinda Morang

Please give this a try and see if you still run into the same credit usage limitation (you shouldn't).

RyanSnead

Alright, I did this and my first issue was solved but now when I run the Closest Facilities analysis it says all my facilities and institutions are unlocated. I'm using point data and the attribute table has longitude/latitude. Do I need street address? Or could their be some other issue? I followed the tutorial you sent as close as I could.

RyanSnead

After lots of tinkering with the coordinate system, I was able to get everything lined up and the analysis ran successfully! Thank you again! Now I want to merge the results of the length of time it took to get to the closest facility from the institution back to the originally imported layer. Do you know if this is possible?

Melinda Morang

Great to hear!

For the outputs, the FacilityID and IncidentID fields in the Routes sublayer refers to the ObjectID in the Facilities and Incidents sublayer, so you can use these reliably for joins. See https://pro.arcgis.com/en/pro-app/latest/help/analysis/networks/closest-facility-analysis-layer.htm for a description of all fields in the Closest Facility layer.

The trick is to then have some reliable way to join the Incidents sublayer back to the original input data. If you mapped a reliably unique field like Name (or it got mapped automatically), you can probably use that to join the results back to your original input. If not, you may need to run the analysis again, but first making sure to include a joinable field.

One easy way is to map something unique to the Name field using the field mapping control in Add Locations. Alternatively, you can run the Add Field To Analysis Layer tool to create a new field in the Incidents sublayer and then use field mapping to map your unique ID to that new field.

So, in total, you need two joins:

Join Routes back to the Incidents sublayer using Routes.IncidentID and Incidents.ObjectID (or use the Join Field tool to transfer only the field(s) you care about).
Join the Incidents sublayer back to the original input layer using whatever field you have available for doing that join.

RyanSnead

Thank you! I really appreciate your help. Separately, do you know of a resource to purchase road network datasets? Having thousands of facilities/institutions really racks up the credits fast.

Melinda Morang

Yes, check out Esri's Streetmap Premium product: https://www.esri.com/en-us/arcgis/products/arcgis-streetmap-premium/overview

SumonMojumder

Hi All, I am getting a similar problem while doing Closest Facility Analysis. I got closest facility for 936 incidents out of 3396 incidents. Below is the description of the problem. Can you please tell me how to solve? The original question can be found here: Closest Facility: Only Few (Partial) Incidents ar... - Esri Community

I wanted to find the closest hospitals for each traffic accident.

In the closes facility window, there are six classes to be specified. I used hospital locations as Facilities and Traffic accident locations as Incidents.

I specified Length as impedance, and the direction was "Incident to Facility". I wanted to find the closest facility (hospital) for each incident (crash).

After specifying the parameters, I clicked "solve," The result only showed the closest facility for 936 incidents. But my incident was 3396. Please note that the tolerance parameter was 5000 meters.

Can you please tell me what could be the problem?

I have checked that the incidents attribute table of incidents and found only the status of 75 incidents was unlocated. But after solving the problem, 936 incidents were solved for the closest facility. Analysis setting .png Closest Facility Solver.png Error Message.png

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.