SOLVED
Find number of stores within specific radius
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
prravich
7 - Meteor
12-21-2017
03:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 ?
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 ?
Solved! Go to Solution.
Labels:
- Labels:
- Spatial Analysis
4 REPLIES 4
KaneG
Alteryx Alumni (Retired)
12-21-2017
04:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
12-21-2017
04:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Alteryx Alumni (Retired)
12-21-2017
04:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
12-22-2017
07:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
