topic Re: Finding distance from one xy-point to several within another feature class in ArcGIS Pro Questions

Finding distance from one xy-point to several within another feature class

MarcusPercival1 — Wed, 23 Oct 2019 08:21:58 GMT

Hi,

I have a table of bakeries (large scale factories actually) with XY-coordinates. In another table I have suppliers of Milk, Nuts and Honey listed. Example data in Excel below:

Bakeries:

Suppliers:

Is there a way to calculate distance from each supplier to Bakery1. Bonus question, is there a way to calculate distance from Bakery1 to all suppliers within 100km?

I currently have a standard license of ArcGis Pro.

Kind regards,

Marcus

Re: Finding distance from one xy-point to several within another feature class

LR — Wed, 23 Oct 2019 11:48:00 GMT

Smells like homework

Try "XY to line". "Construct sight lines" is also useful for 1:n scenarios. As for the second, just do a spatial selection first.

Re: Finding distance from one xy-point to several within another feature class

JoshuaBixby — Wed, 23 Oct 2019 17:12:42 GMT

There is a tool specifically made for this: Generate Near Table—Help | ArcGIS Desktop

Re: Finding distance from one xy-point to several within another feature class

MarcusPercival1 — Fri, 25 Oct 2019 10:40:47 GMT

Thank you will try this and report back

Actually not homework, tried to simplify the problem to be able to explain. The industry is automotive and the categories are around 100

Re: Finding distance from one xy-point to several within another feature class

MarcusPercival1 — Fri, 25 Oct 2019 10:41:58 GMT

Thanks. I know there is Generate Near Table my problem is that it is an Advanced license to use it and I only have access to standard license. So unfortunately not a solution for me

Re: Finding distance from one xy-point to several within another feature class

JohannesBierer — Fri, 25 Oct 2019 11:08:14 GMT

Could this help you:

Performing Point Distance analysis using Basic level license of ArcGIS for Desktop? - Geographic Information Systems Sta…

Re: Finding distance from one xy-point to several within another feature class

MervynLotter — Fri, 25 Oct 2019 11:20:20 GMT

You can also try a Spatial Join and under Match Option, select Closest. This will then add a field in your attribute table with the closest distance. You can then also limit this search distance to say 100 km if you set a value in the Search Radius field.

Re: Finding distance from one xy-point to several within another feature class

JoshuaBixby — Fri, 25 Oct 2019 13:54:42 GMT

Ah, OK. Have you checked out /blogs/dan_patterson/2017/01/23/generate-near-table-for-points