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

[MarcusPercival1]

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

[LR]

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.

[MarcusPercival1]

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

[JoshuaBixby]

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

[MarcusPercival1]

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

[JoshuaBixby]

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

[JohannesBierer]

Could this help you:

Performing Point Distance analysis using Basic level license of ArcGIS for Desktop? - Geographic Inf... 

[MervynLotter]

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.