Hello,
I have a survey with the 5-digit ZIP codes (not ZIP+4) of our respondents' residence, and I am trying to use the "distance" spatial tool to calculate the distance in miles between their residence and the schools they are interested in applying to, which we have location data (longitude and latitude) on.
Is there any way to geocode this 5-digit ZIP for our respondents? Are there any limitations here?
Thanks for any help!
Solved! Go to Solution.
Hi. Do you license the US Data or Spatial Bundle? If so,
Limitation - make sure your input list has a leading zero(s) for ZIP Codes on the East Coast or those associated with Forests, Counties, etc., which may have more than one leading zero. There is a great Alteryx sample to do this: Formula_Append_Leading_Zeros.yxmd.
Thank you for the quick and thorough reply. Yes, I license the Spatial Bundle and Data, and was able to get the output I needed.