finding the distance between two address along network

1986
4
11-20-2010 03:15 PM
VadivelanPalanichamy
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)
0 Kudos
4 Replies
JaySandhu
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
0 Kudos
VadivelanPalanichamy
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. "...
0 Kudos
JaySandhu
Esri Regular Contributor
0 Kudos
VadivelanPalanichamy
New Contributor II
Thanks. Jay Sandhu
0 Kudos