topic Re: finding the distance between two address along network in ArcGIS Network Analyst Questions

finding the distance between two address along network

VadivelanPalanichamy — Sat, 20 Nov 2010 23:15:36 GMT

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,

Re: finding the distance between two address along network

JaySandhu — Mon, 22 Nov 2010 16:43:46 GMT

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

Re: finding the distance between two address along network

VadivelanPalanichamy — Mon, 22 Nov 2010 19:53:38 GMT

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

Re: finding the distance between two address along network

JaySandhu — Mon, 22 Nov 2010 21:12:41 GMT

See the following post for more details:

http://forums.arcgis.com/threads/12128-add-origin-amp-destination-locations-from-the-same-row-to-a-route-analysis-layer?highlight=routename

Jay Sandhu

Re: finding the distance between two address along network

VadivelanPalanichamy — Tue, 23 Nov 2010 12:27:30 GMT

Thanks. Jay Sandhu