Find number of stores within specific radius

[prravich]

Hi all

I have a file having locations of store within US. Let’s say there are 100 rows for 100 stores. I want to find out for any given store , how many stores are within its 10 mile radius. Any thoughts on easiest way to accomplish this ?

[KaneG]

Hi @prravich,

A trade area and then Spatial Match tool will work. The Trade area will build a polygon of 10 mile radius and then plug that and the original data back into a spatial match to get all the stores falling within those Polygons.

[prravich]

I have trade area built for every store. But I’m having trouble doing spatial match for every row. I think I need to duplicate rows but figuring an easier solution. Can you please post an example with just ten rows ?

[KaneG · Accepted solution]

I've included a couple of examples. The Find Nearest Tool may even end up being easier.

Note: I've set limits to 2km, as I created my points too close together...

[prravich]

Thank you so much KaneG, that worked exactly the way I wanted to. Appreciate your help.

My distance is 50miles and the nearest distance tool only supports up to 20 nearest points so I went with spatial match tool instead.