Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I started this quite awhile ago before I really knew spatial tools. Used it as practice to make a batch macro (create a table with all values), then never finished the workflow. Picked it back up again now that I have studied the spatial tools and reworked to the finished solution. I did get far enough with the macro solution that it would have given the same answer.
Good exercise. Betting there are simpler ways, but I am learning more and more about spatial tools (no pun intended)
Spoiler
Process:
- Calculate trade area
- Find Nearest tool to determine how many facilities within 200 miles of each facility
- Rank by facility with greatest FindNearestRank
- Select first record
- Append this facility to all others
- Calculate distance to each facility
- Sort by distance (asc)
- Filter out those more than 200 miles away (results include the target facility as well as the other 4)
- Poly-build tool to build convex hull on Source_Spatial Object
- Calculate trade area
- Find Nearest tool to determine how many facilities within 200 miles of each facility
- Rank by facility with greatest FindNearestRank
- Select first record
- Append this facility to all others
- Calculate distance to each facility
- Sort by distance (asc)
- Filter out those more than 200 miles away (results include the target facility as well as the other 4)
- Poly-build tool to build convex hull on Source_Spatial Object
