Solved! Go to Solution.
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?
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?