Connect Multiple Origins to Multiple Destinations

JesseBoiteau · ‎11-02-2024

Hello,

I am a new user to ArcGIS online and am trying to better understand the origins to destinations function to better fit my use case. I am looking to connect multiple origins with multiple destinations found in 2 CSVs. CSV 1 is the origins and includes unique community names and locations, as well as a column named "School" to connect to CSV 2 that includes unique school names and locations. The part that does not seem to work for me is that the school field in the community CSV has multiple entries separated by a pipe and because of this the error message I am getting is saying the origin does not match the destination as the tool is not seeing the pipe as a delimiter but rather one large destination (ex. Holy Angels|Joussard|Lac la Biche|Grouard). I was hoping this would work with the desired output being a many to many visualization of relationships between schools and communities. I will continue to test this but if someone has any advice it would be much appreciated! I will try a smaller sample size and create multiple entries in the origin CSV (community A with a link to school A in row 1, Community A to School B in row 2, and so on) but then I do not want to create multiple points on the map for School A.

Thanks in advance!

Jesse

Laura · ‎11-18-2024

You'll need to fix your data. You'll have to split your pipe fields into multiple row in excel, there should be a tool for this.

ArcPro can handle this better than agol. https://support.esri.com/en-us/knowledge-base/how-to-split-the-last-values-in-a-text-field-into-a-ne...

JesseBoiteau · ‎11-20-2024

Thanks for this, Laura! I do have a different version of each of my spreadsheets that is the base data with no delimiter, so I can create a new CSV that includes a new row of data for each relationship and see how it goes. This will generate something that looks like this:

My hesitation to do this in the beginning was that ArcGIS would see each entry as a unique value and create duplicate locations. If it does work it will save me a lot of time having to import a high volume of CSVs to generate layers of one-to-one relationships. I will report back once I've done more testing.

Thanks!

Jesse

JesseBoiteau

This did not work so I installed ArcGIS Pro to see if I can find a way to import a CSV with data representing many to many origins to destinations, or even a unique list of origins to many destinations.

Laura

This may be helpful too. This is not something I have personally done but the documentation says it is possible. https://community.esri.com/t5/arcgis-online-questions/many-to-many-connect-origins-to-destinations/t...

JesseBoiteau

Thanks, Laura! I will look into this further. At first glance it appears they are using the "Find Nearest" analysis tool, which can connect one to many based on distance up to a maximum of 100. Because my workflow is based on inherited relationships between communities and schools depending on where children came from I am not sure this will work as it is not necessarily the closest communities that relate to schools, but I will certainly play around with it.