Distance Between Tow layers Based on Unique field with network analysis

2040
10
04-05-2011 06:25 AM
YonatanIlan
New Contributor
Hi
I'm Trying to Calculate the Shortest Distance Between Tow points within tow layers using unique code, based on network analyst.
The number of records in each table is similar.
Closest Facility does not match with my goal, because the output is a matrix from each point in the Base layer to each point in the Target Layer.
I can't do this manually, because the layers has more then one million records

My request  is, for example - to count the distance from field to filed that has the same unique number :
the distance field result should be: from unique 1 in layer A to Unique 1 in layer B
The number of records should be equal to the number of records in each table
I attached excel file for demo

Is their a Script, a Patch or Manual that preform this kind of function?

Thank you Very Much!
Locking foreword to your Answer
Tags (2)
0 Kudos
10 Replies
YonatanIlan
New Contributor
Hi
Since you where very help full, i have a new question please.
If i would like to calculate run away of a person by foot(or anything else using runaway speed), and i have his first run away direction, will i be able to tell, where are the possible places he would be, after 1,2,3 min etc.?

i have attached a photo, hope it will be help fall. Thank you

The Target is to locate possible places of an offender, using eye witnesses by 3 characters:
1. run away technique (car, bike, foot, etc...)
2. time after run away
3. first run away direction

Thank you,
Yonatan
0 Kudos