This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi @cbozarth, assuming you have access to the add-on Core Data bundle package, you could use the US ZIP9 Coder Tool in Alteryx to fetch FIPS code. Alternatively, you could make an API call to a 3rd party URL by passing the relevant lat/longs.
In the attached example I manually construct the URL for every combination of lat/longs in your dataset and make an API call to get back data in JSON format, which is parsed downstream to get FIPS code. The data has other attributes that come back as part of the API call, so maybe there is more available for you to leverage than what you are looking for.
To link restaurant locations to a FIPS code, you need a FIPS code/county boundary.
I've taken your data, created a point for each location using the latitude and longitude with the Create Points tool but once you're there, you need some way to link it to a county (FIPS code). You can download the free census data to get the county boundaries (and FIPS codes) and then use the Allocate input (to bring in the county boundaries) and then use the spatial match tool to identify which county each restaurant falls in and then append the FIPS code from it.
Here is my workflow and the output file in an Alteryx export package. You need to install the free census data for it to work. The free census data can be found where you download the Alteryx software in the Data Packages area.
Hi @cbozarth, as long as you have access to additional data package add-on's you can use Alteryx's US ZIP9 Coder tool to get FIPS. Alternatively you can make an API call to a 3rd party service by passing your lat/longs.
In the attached solution, I artificially create URL's using your lat/longs and pass it through the Download tool, which makes the API calls for us and fetches data back in JSON format. I use a JSON Parse tool and get the data we need downstream.