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.