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; } } }

Network distance between specific paired points by ID

KentaOkuyama

Hello,

I'm trying to figure out a better way to calculate network distance between origins (home) and destinations (office) based on ID.

I want to get a commute distance for all subjects in my data (homeaddress point to workaddress point)

I'm using ArcGIS Pro 2.0.

I have 2 separate point datasets which are already geocoded:

Each data set has 2 columns

data_house = personID, homeaddress

data_office = personID, workaddress

I would like to get an output dataset which has personID and distance from homeaddress to workaddress.

I thought it would be very easy in the beginning, but looks like there is no specific analysis tool to get distance by ID at once. I am using OD cost matrix tool, which produces an output with distance for all origin-destination points.

I can create my desired dataset by using "summary statistic tool" or "dissolve analysis" by ID, but I don't think it would be efficient once the data got big (ex. I do not really want to do OD cost matrix for 30000 x 30000 pair...).

If anyone has an idea I will greatly appreciate it.

Najděte více příspěvků označených jako

Accepted answers

Melinda Morang

The way to do this is to use the Route tool instead of OD Cost Matrix. First add your data_house layer to Stops, and use field mapping to map the personID field to the RouteName field. Then, add your data_office layer to Stops (making sure to append rather than overwrite what's already in there), and again use field mapping to map the personID field to the RouteName field. When you solve the Route layer, it will solve a separate route for each RouteName, so you'll get the path from each personID's home to work.

All comments

Melinda Morang

Hello Kenta, Jamie, and anyone else reading this thread who might be doing similar workflows.

Esri’s Network Analyst Team is doing some research about customer workflows involving solving routes or calculating travel times and distances between known or preassigned pairs of origins and destinations. It sounds like that's what you're doing here, although I know this thread is pretty old at this point. We’d like to better understand our customers’ needs in this area and may use this information to design and develop improved tools and workflows.

If this workflow is still relevant to you and you have a few minutes and are willing, could you please fill out the attached survey and return it to the e-mail address included inside the document? Alternatively, you can reach out to me (my e-mail address is in the document) to set up a meeting.

Thank you so much!!

UserQuestionnaire_PreassignedODPairs.docx

223782image.png

JamieTratalos

Hi Dan, no I have not confused them - please read my message carefully - I have looked at both - thanks. There is no 'Route tool' in either (although there is 'New Route' in the Network Analyst tool bar). Melinda, where is the 'Route tool' - thanks!

DanPatterson_Retired

perhaps you are confusion the network analyst toolbar with the network analyst tools in arctoolbox.

here is the link to the toolbar and what it looks like

Creating a network analysis layer in ArcMap—Help | ArcGIS Desktop

JamieTratalos

Hi Melinda,

I can't find the 'Route tool' you are referring to. I'm using ArcGIS 10.1, advance licence. I've looked in the Network Analyst tool bar (there is 'New Route' but not 'Route tool') and in the Network Analyst Tools part of ArcToolbox, but I can't find anything called 'Route tool' in either location.

Please help - I have > 100,000 origins and a similar number of destinations, so I need a solution which pairs each origin with it's destination.

Thanks!

KentaOkuyama

Thank you so much Melinda. I thought crow-fly distance will execute quicker than network distance. If it requires that kind of scripting (select one by one), I assume it would not be that quick. Once I get familiar with scripting more, I will try that. I really appreciate your help!

Melinda Morang

Near and Generate Near Table will do more like OD Cost Matrix and calculate the distance from each origin to all destinations. I'm not seeing a tool that would do it based on ID fields, but this is a little bit out of my area. You could solve the problem by iteratively selecting the points with each ID one by one and calculating Near, using a python script or model, but this would probably be pretty slow.

KentaOkuyama

It worked out perfectly. Thank you so much!

Is there a way to do this with crow-fly distance also?

I'm looking into Near or Generating Near Table, but I don't know if I'm on the right place.

KentaOkuyama

@Melinda Thank you so much!! I will try that out, seems it will work the best.

Melinda Morang

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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