Find places within zipcode range

hitsdoshi

Very new to Alteryx - I have database for all the Providers (Hospitals) address and I would like to enter a zip code and give user to set distance (10mi-25mi) and depending on selection - I want to list down providers fall in that...

Is there a known macro or any easier way to achieve this?

Thank you in advance !

MarqueeCrew

@hitsdoshi,

Given an input address or ZIPCode, you can create a trade area of any distance.  You can then perform a spatial match to find the providers that exist within that trade area.  There are multiple ways to achieve this goal.  But before doing so, I have a question or two for you:

• Are you interested in entry of a ZIPCode and finding the providers who are within 20 miles of the center of the ZIPCode or from any point within the ZIPCode plus those 20 miles away from the edge of the ZIPCode?
• Did you purchase the spatial data that Alteryx offers?
• Did you purchase the data bundle that includes D&B data?

If your providers are stored (with their spatial objects) in a Calgary Database, then you can use a calgary join tool and match the spatial object from the creation of the trade area.  This is a very fast lookup.  An alternative is to use the spatial match tool.

Tigerline shapefiles exist on https://www.census.gov/geo/maps-data/data/tiger-line.html and are useful for creation of data like you are seeking.  The alteryx Street Geocoder will provide you with ZIP answers.  Depending upon your needs, a combination of these resources might be helpful.  I have access to the spatial and data packages and make full use of them.

There is a training session available for finding customers within a trade area.  This training video should get you on your way:  https://community.alteryx.com/t5/Live-Training/Live-Training-Spatial-Analytics-for-Beginners/m-p/43863#U43863 (@LeahK).

Cheers,

Mark