topic Re: finding route distances in batch in Transportation Questions

finding route distances in batch

BarryDurand — Wed, 23 Feb 2011 15:23:21 GMT

After over a week of fighting with it, I have figured out how to find the "as the crow flies" distance between two addresses.

Here is the simple python window code:
import arcpy
arcpy.env.workspace = "C:\Documents and Settings\bpdurand\My Documents\ArcGIS\Default.gdb"
arcpy.PointDistance_analysis("address","hospital","howfar")

Now what I need to do, is something similar but get route distance (via roads) and if possible route time. This needs to be done in a many-to-one address relationship. For example, I need to find out how far driving distance it is from multiple specific addresses (which will be geocoded) to one specific address. More specific example, I need to know how far it will be for specific people to drive to a hospital or something similar. FYI, can't really use nearest facility because the destination address will be specified.

I have been looking for something similar to PointDistance_analysis but I can not find anything. Is what I am trying to do even possible? Is there a function similar to PointDistance_analysis or will it be much more complicated, as it looks like it may. If there is a function what is it? If it will be more complicated, a link to an example or something similar would be appreciated.

Thank you,

Barry

Re: finding route distances in batch

MartinHermann — Mon, 05 Nov 2012 13:39:54 GMT

Does that help you? http://forums.techguy.org/windows-server/956066-need-help-batch-route-table.html

Re: finding route distances in batch

BarryDurand — Mon, 05 Nov 2012 13:43:47 GMT

Thanks but not really. This is a totally different kind of "route" (car route/driving distance) not IP routing.

Re: finding route distances in batch

MartinHermann — Mon, 05 Nov 2012 13:47:56 GMT

I'm sorry...I was just reading the headline and flying with my eyes over the text. 😉 Next time I'll read more carefully!

Re: finding route distances in batch

shieldr2025 — Tue, 01 Oct 2013 14:37:31 GMT

Did you ever get an answer ? And I ask becauause I need to do precisely what you are doing. Is the "Route Tool" the way to go ? Can it even be adjusted with a Python script for such ?

Re: finding route distances in batch

Jim_Gay — Tue, 16 Jun 2015 13:37:07 GMT

I am looking for the exact same solution. Did anyone find out how to do this?

I'm going to explore using a model and toolboxes but I'm not at all sure how to go about this. Any help would be great.

Re: finding route distances in batch

RichardFairhurst — Fri, 19 Jun 2015 21:22:37 GMT

This is a Network Analyst problem if you are using a road network. That requires a separate extension license to use it. This post relates to the problem and how best to set it up, since it matters what is defined as an incident and what is defined as an origin.

Re: finding route distances in batch

mneer — Wed, 24 Jun 2015 15:48:56 GMT

Richard is correct, I believe you may want to look into the cost matrix of a network.