nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to calculate distance of multiple points?

JoseBarrios2

Need help on how to calculate distance of multiple points. I have two layers : an input feature(office) and near feature ( projects). I want to know the distance of the projects for each office. The near tool won't work (It calculate the distance to all points) unless I run the tool for each office...any ideas?

Thanks,

Find more posts tagged with

Accepted answers

All comments

BenKeller

Ahh yes. Well if some of them are offshore then I am not sure if that would work, but ESRI's street basemap has a network embedded in it and will allow you to use the Network Analyst toolset. I think it's worth checking out, I have run this before locating multiple location distances from the airport I work at. An O/D Cost Matrix may work as well. Good Luck!

OD cost matrix analysis—Help | ArcGIS Desktop

-Ben

JoseBarrios2

Thanks Ben,

I don't think that the Network Analysis Tool (closest facility tool) will give the output that I need. I don't have a network data set ( I have point features) and I need to find the closest, the further and the mean distance of each project from its office. The problem is that the table from the near distance analysis only report two fields - the id of the project and the id of the office. When I run the near tool I end up with 7000 measurement for each office (almost 900,000 records). The office ID and the projects ID are basically duplicated 128 times. I can't find a solution for this yet.. I started exporting each office and each projects to individuals data sets. so I can run the near tool..lots of work...!

DanPatterson_Retired

except some of the locations are offshore

BenKeller

Network Analyst toolset - Closest Facility tool.

That would do this no problem.

DanPatterson_Retired

I think the biggest problem is to how to dissect what you have.... one to many relationship... within a loop. The distance calculations are trivial. I will look around to see if someone already has a solution to this portion of the problem

JoseBarrios2

YES. I have a common field that identify each office and link to projects. My Phython skills are very limited

JoseBarrios2

I have two data sets (.shp) and a common key field ID ( with one - to many). Yes, both files are on the same projection (USA_Contiguous_Equidistant_Conic) and YES they cover very large distance (more than 100 miles)

ChrisDonohue__GISP

Another option is Generate Near Table—Help | ArcGIS for Desktop

I guess a big question going forward with this is the sorting down of the results to just the applicable projects for each office, as many of the possible solutions (Pointdistance, Generate Near Table) would provide output of all the Offices to all the Projects, generating one large table, which would be unwieldy.

Is there currently in your data field(s) that identify information on which Projects belong to which Offices? If that relationship mechanism could be identified, it may be very possible to generate the desired output so it is limited to just the projects for each office; however, we would need to know how that is structured so as to come up with an effective solution. Possibilities include employing Modelbuilder or Python as part of the data processing. For example, one could loop through each office and only find the distance the projects associated with that office. Again, it would be dependent on how the data is structured.

What is ModelBuilder?—ArcGIS Pro | ArcGIS Desktop

Chris Donohue, GISP

JoseBarrios2

My INPUT is office location (point) and my NEAR is projects locations (point). Some offices are very close on location and some offices travel very far for projects so I can not use the search radius. For every office there is a set of projects and I want to know the max, min and average distance of those projects!

DanPatterson_Retired

This can be done but the ease at which it can be done depends on the format of your data.

Are all the locations in the same file? ie the origins and their associated destinations or are they in separate files.

or are the origins in one file and all the destinations in another file which has a key to associate each destination with one origin?

Are all the files in a projected coordinate system?

Do they cover great distances (ie 10's, 100's 1000's of kilometers)

Any substantive information on the existing data structures and input coordinate systems would be helpful.

AbdullahAnter

Could I ask you What was the layer that you set as Input features and what was the Near Features in the tool?

JoseBarrios2

The near tool and point distance calculate the distance to ALLL point (projects) and I need to calculate the distance to the points that belong to each office. The only way around is exporting the projects that belong to each office ant run the near tool for each set of projects...I have 120 offices and 5000 projects ...

JayantaPoddar

Near Tool

Calculates distance and additional proximity information between the input features and the closest feature in another layer or feature class.

Point Distance

Determines the distances from input point features to all points in the near features within a specified search radius (you could keep it empty).

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.