how to find customers with in radius circle
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi team.
I have Customers data with latitude and longitude and
store data with coordinates.
how to find customers with in 2 miles radius.
please help. Thanks in advance.
help me with the approach.
I have got the customers in the radius but unable to filter those customers in the radius
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A spatial match between your trade area circle and the points and then when the circle contains points should filter the data to only the relevant values.
So in the input anchor for points you want a row for each person. Then for the other input anchor a row for each circle that you are checking
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ed_hayter thank you so much I will check that
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @rag329
Another way of approaching this problem, you can calculate the distance between each customer and the store, and then filter the distances that are acceptable. The example of the distance tool is a good way of showing what i mean, just put a filter after of the result of this tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ed_hayter i have tried but in match anchor i should get those 8 points but it didnt happen. guide me
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So for your universe anchor it is going to match for each circle you generate. So it is matching for each trade area generated returning all the points within each one. You can either only send through the one trade area of interest into the universe anchor. Or Filter the outcome to only the spatial object of interest after the match So you need to filter on the trade area that contains those 8 points of interest.
