topic Re: Network distance between specific paired points by ID in ArcGIS Network Analyst Questions

Network distance between specific paired points by ID

KentaOkuyama — Thu, 10 May 2018 08:07:48 GMT

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.

Re: Network distance between specific paired points by ID

MelindaMorang — Thu, 10 May 2018 15:11:50 GMT

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.

Re: Network distance between specific paired points by ID

KentaOkuyama — Fri, 11 May 2018 00:32:39 GMT

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

Re: Network distance between specific paired points by ID

KentaOkuyama — Fri, 11 May 2018 02:40:39 GMT

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.

Re: Network distance between specific paired points by ID

MelindaMorang — Fri, 11 May 2018 15:09:19 GMT

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.

Re: Network distance between specific paired points by ID

KentaOkuyama — Sat, 12 May 2018 02:38:33 GMT

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!

Re: Network distance between specific paired points by ID

JamieTratalos — Thu, 30 Aug 2018 12:51:23 GMT

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!

Re: Network distance between specific paired points by ID

DanPatterson_Retired — Thu, 30 Aug 2018 13:28:49 GMT

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

Re: Network distance between specific paired points by ID

JamieTratalos — Thu, 30 Aug 2018 13:41:05 GMT

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!

Re: Network distance between specific paired points by ID

DanPatterson_Retired — Thu, 30 Aug 2018 14:13:23 GMT

duly noted

Re: Network distance between specific paired points by ID

JamieTratalos — Thu, 30 Aug 2018 14:15:58 GMT

Hi Melinda, Dan,

I've worked it out now. Thanks for your help. To clarify - go to the Network Analyst Toolbar, create a new route using the 'New Route' option, Select the 'Network Analyst Window' from the Network Analyst Toolbar - a window should appear on you screen showing the contents of the network analyst. Use this window to add the origins and destinations in the way suggested by Melinda

Re: Network distance between specific paired points by ID

AzadPalmqvist — Wed, 13 Jan 2021 12:11:05 GMT

I have almost the similar issue, I have to pint feature classes with many attributes .

1- A feature class for students (about 2500 students).

2- A feature class for Schools (30 schools).

I have a commom attribute in both dataset (School name)

I want to calculate the closest distance for each student to her or his corresponding school.

And I need to get all attributs returned in my result list.

Re: Network distance between specific paired points by ID

MelindaMorang — Tue, 04 Apr 2023 21:41:12 GMT

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!!