topic Re: Examples for Connecting and Querying GIS Data from Census Dataset in Alteryx Designer Desktop Discussions

Examples for Connecting and Querying GIS Data from Census Dataset

bdanielatl — Thu, 24 May 2018 04:29:03 GMT

I am very new to Alteryx (and I don't have a lot of time).

I have a list of customers with both addresses and lat-lon coordinates. I need to do a lookup to find their Census Block Groups. I have downloaded the and installed the Census dataset from Alteryx. I used Allocate to build a dataset of the Block Group codes. Can anyone point me to a basic tutorial of how to combine my list of customer points with the shapefiles to do a look up of the block codes.

Thanks,

Ben

Re: Examples for Connecting and Querying GIS Data from Census Dataset

bdanielatl — Fri, 17 Nov 2017 11:59:01 GMT

I may have just solved my own problem. I found a sample workflow under Help -> Sample Workflows -> Clean and Prepare Data -> Infer Zip Codes from Lat / Lon.

While the workflow doesn't do everything I need, it sets me up for getting the information I need. See the Dynamic Input Step. First, I pull in the GIS data with the data input step, then use a dyanmic input to do the lookup with my customer lat/lon and then pass the blockcode field.

Re: Examples for Connecting and Querying GIS Data from Census Dataset

jrgo — Fri, 17 Nov 2017 14:02:56 GMT

@bdanielatl,

If I'm understanding correctly, if you approach it like below, this should get you what you need.

Re: Examples for Connecting and Querying GIS Data from Census Dataset

bdanielatl — Mon, 27 Nov 2017 16:45:24 GMT

Thanks, this is exactly what I was looking for!