Spatial Analysis
- 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,
I am new to Alteryx Spatial Analysis concept so it would be great if anyone help me on the below.
I need to Calculate the number of patients that fall within 10, 20 and 30 miles of each hospital location. I have attached my dataset.
Below is the workflow which i have tried but I didn't get the correct output.
Solved! Go to Solution.
- Labels:
- Spatial Analysis
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Let's start by looking at those hospital locations. You have address information, but to find out where those addresses are, you need to "geocode" them to get Latitude/Longitude values. This can be done for free by Googling each address, or by using a paid service like the spatial "Location Insights Dataset" available from Alteryx or using an API available from various third-party vendors.
Now that you have Latitude/Longitude values, you can use the Create Points tool to create spatial objects in Alteryx. A Trade Area tool can then draw the requested 10, 20, and 30-mile rings around each point.
Now that those trade areas are prepared, prepare the patient records by geocoding them and using the Create Points tool to assign a point spatial object to each record. In the attached example, I randomly generated patient records to show the rest of the matching process.
Once you have prepared spatial objects for the trade areas and patients, use a Spatial Match tool and then Summarize the results.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Charlie,
Thank you so much for helping me to understand the concept in detail!
I tried with different scenarios it's working fine.
