finding the distance between two address along network

[VadivelanPalanichamy]

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,

[JaySandhu]

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

[VadivelanPalanichamy]

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. "...

[JaySandhu]

See the following post for more details:

http://forums.arcgis.com/threads/12128-add-origin-amp-destination-locations-from-the-same-row-to-a-r...

Jay Sandhu

[VadivelanPalanichamy]

Thanks. Jay Sandhu