AnsweredAssumed Answered

Network distance between specific paired points by ID

Question asked by kenta215ok0 on May 10, 2018
Latest reply on Aug 30, 2018 by JamieTratalos



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.