Allocate/Experian Missing Geo Data

A lot of times I find myself using Allocate to retrieve the spatial object info for geo boundaries like Zips, States, etc...

It also seems like the data from Experian is often incomplete, especially in when dealing with zip codes. In most cases the missing zip is a PO Box, but occasionally it's not. I also don't have a good way to checking for missed zips and won't realize I'm missing one until I bring it into Tableau.

Here is an example:

Zips are missing from Experian listTableau ScreenshotLookup Zip data, not a PO Box

Anyone else run into this? Is there a better way to pull in zip code boundary data?

Spatial Analysis

Demographic Analysis

Accepted answers

EricM

Sure thing!

Here is a word doc that describes how to enable the Point Zips (attached).

ZIP Codes with Points.docx

All comments

EricM

Hi @mstern,

In Allocate, only polygon based ZIPs are enabled by default. Point ZIPs are also included as part of the US Spatial data and can be enabled through the Allocate GUI. There are about 31K ZIP polygons in the latest (Q2) data, and an additional 10K ZIP points.

Here is a link to an Alteryx Knowledge Base post that explains how to enable point ZIPs.

I hope this is helpful!

Cheers,

Eric

mstern

Thanks for responding @EricM!. Unfortunately I'm getting an "access denied" message when I click your link. Are there non public knowledge base articles? I also tried to search for the article based on the URL name with no luck.

Anyway, hopefully that article will address the PO Box issues, but I'm not sure why my example above had 3 missing polygons. Do you see anything on your end why zips 08858, 07977, 07939 wouldn't be included in the zip poly list?

Thanks!

EricM

@mstern, if you reach out to community@alteryx.com, they can grant you access to the Data Products Knowledge Base.

mstern

Thanks @EricM. I reached out to the email below. I also did some testing last night and think I see how to import the additional Allocate Workspaces, but I couldn't locate the zip point file. I am a licensee of the Core Data Bundle, but didn't see anything that looks like this dataset on the 2017 Q2 data updates. I also looked on your website and community board thinking there might be a link to download them, but had no luck. Can you point me in the right direction?

Thanks!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317