finding the distance between two address along network

1762
4
11-20-2010 03:15 PM
Highlighted
New Contributor II
Hi,

I am having a pair of lat/longs around 50k rows.  I want to know the route distance between these start and end lat/long.

I have NA extension and NA dataset.  I am able to do route problem manually.

I want to know how to batch work for 50k rows ?  any idea or any vba code for this ? 

I need only the route distance..

Thanks,
Tags (2)
Reply
0 Kudos
4 Replies
Highlighted
Esri Regular Contributor
You can create one Route Analysis Layer and load all your 50K rows and solve.
To do this, make sure you have an ID on each row, say a number from 1 to 50k.
Load your first lat/long pairs and map the ID as the RouteName as Stops
Then load your second lat/long pairs mapping the same ID as the RouteName.
Now you will see 50k distinct route pairs in a single route analysis layer.
Solve. You will get 50k paths and you can export out the data as needed.
Jay sandhu
Reply
0 Kudos
Highlighted
New Contributor II
Hi,

Could you some more steps on this "Load your first lat/long pairs and map the ID as the RouteName as Stops Then load your second lat/long pairs mapping the same ID as the RouteName. "...
Reply
0 Kudos
Highlighted
Esri Regular Contributor
Reply
0 Kudos
Highlighted
New Contributor II
Thanks. Jay Sandhu
Reply
0 Kudos