AnsweredAssumed Answered

Path distance between 2 matched points

Question asked by ets189 on Sep 7, 2013
Latest reply on Sep 7, 2013 by ets189
I am trying to calculate the distance between 1 specific origin and 1 specific destination using the network analyst OD cost matrix.  Specifically, I have a file with about 9,000 geocoded home addresses of individuals and another file with their (same individuals) 9,000 geocoded work addresses. I have two problems.  I only want to calculate the path distance from each persons home address only to their specific work address.  Currently, I cannot figure out a way to not calculate the distance between an individual and every work address.  This wouldn't be such a big deal if I was able to identify (each person has a unique identifier in each file) the individual by querying on their id and finding those that match in the resulting 'lines' file.  But I cannot figure this out either.  Even if I join the unique identifiers to the origin and destination file, the resulting lines file does not generate these fields.  Does anyone have any suggestions?

Outcomes