topic Re: Is it possible to list closest facilities in one field? in ArcGIS Network Analyst Questions

Is it possible to list closest facilities in one field?

claykitchens_fd — Fri, 14 Jun 2024 19:05:06 GMT

Hello!

I performed a closest facilities analysis for 8 locations, but I would like to have those locations listed in order, nearest to farthest, in one field. Is it possible to perform this with ArcMap or ArcGIS Pro?

Thank you in advance!

Re: Is it possible to list closest facilities in one field?

JaySandhu — Fri, 14 Jun 2024 20:28:36 GMT

Yes. It is possible. Here is one way: Use the Summary Statistics GP tool. The input should be the routes feature class from your Closest Facility layer. Open the route table, and sort ascending on the Facility Rank Column. Then right-click the Facility ID column and bring up the Summary Statistics. Choose the FacilityID as the statistics field and pick Concatenate from the list of statistics type drop down. Then type in a comma in the concatenate separator and run the tool. It will output a new table with a field that has all the FacilityID's separated by comma. See screen shot below.

Jay Sandhu

Re: Is it possible to list closest facilities in one field?

claykitchens_fd — Thu, 20 Jun 2024 13:57:52 GMT

Thank you, Jay!

One item I failed to include is that I'm trying to perform this action for 15 locations and 397 incidents. I followed the workflow you provided and received the following results.

How should the workflow be adjusted to accommodate 397 incidents?

Thank you!

Re: Is it possible to list closest facilities in one field?

JaySandhu — Thu, 20 Jun 2024 15:35:00 GMT

The display only shows a limited amount. You can increase the width of the field display in the UI. But how do you plan to use this information? For example, you can use the GP tool Export table and output to a text file. You can also choose to only export that one field you want like so:

Jay

Re: Is it possible to list closest facilities in one field?

claykitchens_fd — Thu, 20 Jun 2024 21:52:30 GMT

Thank you for the clarification!

We are using this to build the response sequence for fire station responses. We have 397 response districts and 8 stations (we have 7 additional "stations" loaded into the Computer Aided Dispatch (CAD) system. We would like to list the order of the station response for all 15 stations to the 397 response districts. Each response district polygon has been changed to a point using the "Feature to Point" tool so it can be used as an Incident.

Re: Is it possible to list closest facilities in one field?

JaySandhu — Fri, 21 Jun 2024 15:10:53 GMT

Just an FYI, Mike Price has written numerous articles about fire station response. You can read some of them here: Mike Price, Author at Esri

and

Mapping Current and Proposed Effective Fire Response (esri.com)

Measuring Firefighter Performance with ArcGIS Pro (esri.com)

Regards,

Jay Sandhu

Re: Is it possible to list closest facilities in one field?

claykitchens_fd — Fri, 21 Jun 2024 15:52:27 GMT

Thank you for sharing these!

Re: Is it possible to list closest facilities in one field?

claykitchens_fd — Fri, 21 Jun 2024 15:59:21 GMT

I attempted this workflow again, but I still received the same output.

What I hoped I would see is the Incident ID field and the concatenated Facility ID values in another field (ConcatenatedIDs).

Incident ID | Concatenated IDs

1 | 2,1,3,5,4,6,10,9,8,11,7,15,13,14,12

2 | 1,3,7,4,10,13,14,2,6,5,9,8,12,11,15

... and this could continue to Incident ID 397.

Thank you so much for your help with this! I hope you will be able to provide a solution with this additional information.

Re: Is it possible to list closest facilities in one field?

claykitchens_fd — Tue, 25 Jun 2024 19:30:39 GMT

Hi, Jay-

I made a change to the Summary Statistics parameters and I received the desired results.

I added IncidentID to the Case Field section and it produced the desired results.

Thank you again for taking the time to help!