topic Re: finding distance from one point to multiple points. in ArcGIS Network Analyst Questions

finding distance from one point to multiple points.

HakanUslu — Thu, 01 Nov 2012 20:24:47 GMT

For my research project, I need to find the distances from one fast food restaurant to multiple residential areas. anybody knows how to find these distances using GIS network analysis?

Re: finding distance from one point to multiple points.

JaySandhu — Thu, 01 Nov 2012 22:11:47 GMT

You can use the OD Cost Matrix to compute distances between two sets of locations. Here is a link to a tutorial that you can run through to see how to use Network Analyst for that purpose:
http://resources.arcgis.com/en/help/main/10.1/#/Exercise_5_Calculating_service_areas_and_creating_an_OD_cost_matrix/004700000060000000/

Jay Sandhu

Re: finding distance from one point to multiple points.

HakanUslu — Fri, 02 Nov 2012 17:05:05 GMT

Thank you for the answer but, OD cost matrix gives the direct (aerial) distances from one location to multiple locations. How can I get the distances by using the streets.???

Re: finding distance from one point to multiple points.

JaySandhu — Fri, 02 Nov 2012 17:51:17 GMT

The OD Cost matrix does NOT give direct/aerial distances. It computes the network shortest paths. But, for performance, it does not return back the route geometries of the path taken and simply draws a straight line to indicate the pair for which the network cost is computed. It is designed to return a matrix of distances. If you need to get the route geometries as well then use the Closest Facility solver. It does what OD does but also returns the route shapes. Make sure to set the number of facilities to find to the number you have (destinations) as the default is to find 1.

Jay Sandhu

Re: finding distance from one point to multiple points.

HakanUslu — Fri, 02 Nov 2012 19:22:10 GMT

I could not understand exactly what you mean with your last sentence "Make sure to set the number of facilities to find to the number you have (destinations) as the default is to find 1.:???

Re: finding distance from one point to multiple points.

RamB — Sun, 04 Nov 2012 08:14:24 GMT

I could not understand exactly what you mean with your last sentence "Make sure to set the number of facilities to find to the number you have (destinations) as the default is to find 1.:???

He means that by default the tool looks for ONLY one destination (facility) unless you specify explicitly the exact number of destinations. In other words, the tool does a one-to-one and not one-to-many. Usually the "analysis settings" tab has this option. You can set it to "All" if it is not set already.

Re: finding distance from one point to multiple points.

shamsadirin — Mon, 09 Dec 2013 13:40:13 GMT

How can i find distance from each of multiple points to all multiple points using road network?

Re: finding distance from one point to multiple points.

RamB — Tue, 10 Dec 2013 10:29:32 GMT

you can use the OD matrix tool, and the result will give you a matrix of distances as you ask for.

regards,

Re: finding distance from one point to multiple points.

shamsadirin — Tue, 10 Dec 2013 13:39:33 GMT

Thanks a lot! It works! but i have another problem. i have 4000*800 matrix. so the result becomes very big and i cannot export the full result file to excels.Do anyone have any suggestion how to export huge data set into excels from GIS?

Re: finding distance from one point to multiple points.

MelindaMorang — Tue, 10 Dec 2013 14:10:18 GMT

Do you know any python? If so, you can solve the OD Cost Matrix and then use a search cursor and a for loop to read the values of the table and write them out to a csv file using python's csv module. But, the file may still be too large to open in Excel (which is a limitation of Excel and not ArcGIS). What do you ultimately want to do with the OD Matrix output?

Re: finding distance from one point to multiple points.

shamsadirin — Tue, 10 Dec 2013 14:18:27 GMT

ok. i don't know python. i need the result to find distance between origin & destination.

Re: finding distance from one point to multiple points.

MelindaMorang — Tue, 10 Dec 2013 14:21:15 GMT

Okay. Python would definitely help you out here. But, what I was asking is what you want to do with the data after you've found the distances between origin and destination. Do you just want to read it from a table or are you using as input for something else? Putting it into a database? The end goal can help us figure out how best to export the data from ArcMap in a format that works for the end goal.