topic Re: Connect Multiple Origins to Different Multiple Destinations in ArcGIS Pro Questions

Connect Multiple Origins to Different Multiple Destinations

SeanO_Boyle — Mon, 12 Aug 2019 16:10:33 GMT

^Updated

I would like to calculate the road network route distances from multiple origins to a different set of multiple destinations. E.g. Connect stores A, B, C, D and E to supply depots X, Y and Z. From reading any online resources and help documents such as this (Connect Origins to Destinations) it appears this is not possible. However I am at a loss as to why this functionality would allow many to many routes with the caveat that all the sources and destinations must be the same. Surely there are use cases, for example, where we want to connect multiple grocery stores to different set of mulitple supply depots to work out the travel distance from all the grocery stores to all the supply depots?

I've noticed this same issue posted by a few others but as yet there has not been any solution fiorthcoming. Can anyone provide a solution or suitable alternative workflow for thuis problem.

Thanks for any help you can provide.

Re: Connect Multiple Origins to Different Multiple Destinations

DeeleshMandloi — Mon, 12 Aug 2019 17:49:00 GMT

Hi Sean,

Currently the Connect Origins to Destinations analysis tool does not support specifying origins that connect to multiple destinations. If you have multiple destinations, the origins can only have one feature. So to achieve your workflow, you need to run the tool multiple times such that you have only one origin in each iteration and then combine the results from the iterations.

I have logged an enhancement request to update the Connect Origins to Destinations tool to support multiple origins with multiple destinations.

On a related note, to visualize the results, would you prefer a straight line connecting each origins to their destinations even though you are using network travel distance? Or in your workflow, you prefer to see the connections using the true shapes derived from the streets?

Re: Connect Multiple Origins to Different Multiple Destinations

SeanO_Boyle — Mon, 12 Aug 2019 20:15:12 GMT

Hi Deelesh,

Thanks for your response. I would prefer if we had the true shapes derived from the road/street network.

Regards,

Sean O'Boyle

Northern Ireland Water

Sent from Workspace ONE Boxer

Re: Connect Multiple Origins to Different Multiple Destinations

DeeleshMandloi — Mon, 12 Aug 2019 23:53:36 GMT

Hi Sean,

Thanks for the feedback. We plan to have the feature you requested in a future ArcGIS Online update hopefully the one that comes out around first week of December 2019. If we happen to get this out earlier, I will update this thread.

Re: Connect Multiple Origins to Different Multiple Destinations

SeanO_Boyle — Tue, 13 Aug 2019 06:56:19 GMT

Thank you. That would be very useful added functionality. It would also be beneficial in ArcGIS Pro and Portal at some stage too.

Sent from Workspace ONE Boxer

Re: Connect Multiple Origins to Different Multiple Destinations

SarahHofmeyer — Thu, 06 Feb 2020 21:42:06 GMT

Hi Deelesh,

I too would find this enhancement very valuable to my work. Is there any update on this feature? I noticed you said the Dec. '19 update would have it; but I am using AGOL for the same purpose, trying to do the same thing, and don't see any changes.

Thanks! Sarah

Re: Connect Multiple Origins to Different Multiple Destinations

DeeleshMandloi — Tue, 11 Feb 2020 18:03:10 GMT

Hi Sarah,

Connect Origins to Destinations tool was updated in December 2019 release of ArcGIS Online to support connecting many origins to their destinations. In my screenshot below, I have two stores and customers assigned to them, I am connecting them using the straight line option and using the driving distance as my travel mode.

If you cannot complete your workflow, please provide some steps to reproduce the issue and I can figure out what is missing.

Thanks

Deelesh

PS: This capability will also be available in ArcGIS Enterprise portal with version 10.8.0 or later.

Re: Connect Multiple Origins to Different Multiple Destinations

SeanO_Boyle — Tue, 18 Feb 2020 12:43:43 GMT

Hi Deelesh,

Is this functionality available in ArcGIS Pro 2.5.0?

Sean

Re: Connect Multiple Origins to Different Multiple Destinations

DeeleshMandloi — Thu, 20 Feb 2020 16:31:47 GMT

Hi Sean,

The Generate Desire Lines tool in the Business Analyst toolbox provides similar functionality. If you are signed into ArcGIS Online, you can use one of the travel modes defined in your organization when creating the desire lines.

Hope this helps

Deelesh

Re: Connect Multiple Origins to Different Multiple Destinations

SanneMikkelsen — Wed, 05 Aug 2020 12:21:10 GMT

Hi Deelesh.

This worked fine for me when i did a small test with only 10 records. Now, when i try the analysis with the whole dataset I can not perform the analysis because it says I do not have the same amount of records in the two tables, which I have, because it is made from ONE single table. What can be wrong?

Re: Connect Multiple Origins to Different Multiple Destinations

DeeleshMandloi — Wed, 05 Aug 2020 18:10:40 GMT

Hi Sanne,

Can you send me a screenshot of the error message you are getting? Also when you specify the whole dataset, does your input layer have any null values in the fields that you are specifying as ID fields?

Thanks

Deelesh

Re: Connect Multiple Origins to Different Multiple Destinations

SanneMikkelsen — Thu, 06 Aug 2020 07:36:06 GMT

Hi again Deelesh.

Here is the error i get. I have 1295 objects in the origin-layer and 1295 objects in the destination-layer.

It strikes me, that maybe the error message confuses me, and it fails somewhere else?

I have tried to run it i Chrome and in the new Edge-browser. It looks like in Edge, it comes with a warning before I run the analysis, and in Chrome the error is first discovered when i run the analysis.

Hope you can help me, otherwise i must do it the hard way, and run it several times:-)

I do not have null values in the ID fields.

/Sanne

Re: Connect Multiple Origins to Different Multiple Destinations

DeeleshMandloi — Fri, 07 Aug 2020 22:21:14 GMT

Hi Sanne,

When you run Connect Origins to Destinations tool, is the "Use current map extent" checkbox (present at the bottom of the pane) checked?

If it is checked, then the tool is only using the features visible in the map extent and that can result in different number of features in the origin and destination layers as the error message suggests. Can you try to run the tool with the use current map extent option unchecked?

If you still get this error, I would need to run the tool with your inputs to see what is going on. Can you send me the screenshot of the settings you are using when running the Connect Origins to Destinations tool as well as the input data? If your input data is a feature service, you can export the feature service as file geodatabase (from the item description page of the feature service item) and send me the zip file containing the file geodatabase. Instead of posting your data on this forum, you can send me the data via email to dmandloi@esri.com or if the zip file is too big for an email attachment, share the file geodatabase item publicly on ArcGIS Online and send me a link to the data item via email. Once I download the data, you can make the data private again.

Thanks

Deelesh

Re: Connect Multiple Origins to Different Multiple Destinations

SanneMikkelsen — Mon, 10 Aug 2020 06:52:03 GMT

Hi again Deelesh

No, I have not checked the "Use current map extent". Have tried it once, but with the whole dataset in my visible extent. Same error:-(

I will send you the feature classes on your email.

I have now made the analysis with a single destination at the time (quite time-consuming compared to what i had in mind, when I tried to run the other analysis). One of the destinations failed, I do not think it is a problem with the origin dataset, but maybe the destinations? There were no problem with georeferencing them.

The amount of records is the same.