Currently I am unable to use Alteryx's spatial calculations in completing required reporting for CMS. Its unfortunate, because in my mind Alteryx is a superior approach allowing for customization and seamless integration with varied data sources used within our company.
You might ask, why don't you just use actual driving distance? The datasets that we are measuring are enormous. +60M member files are being compared to 70K providers. Alteryx is missing a huge opportunity to get into this market.
Reference
https://www.cms.gov/Medicare/Prescription-Drug-Coverage/PrescriptionDrugCovContra/downloads/hsd_meth...
Travel Distance to Providers and Facilities
The second component of the review process tests the percentage of beneficiaries resident in a given county with access to a particular specialty type within the maximum travel distance. For a given county and specialty type, CMS uses the geographic coordinates for the associated providers or facilities and the geographic coordinates for the beneficiaries resident in the county and calculates the travel distance between them. The travel distance is calculated using a formula to determine the estimated driving distance (miles) between the latitude and longitude coordinates and provides an average for the total beneficiaries in the given county