We’re aware of an issue with email notifications. If you notice you’re not receiving emails from the Community, please check your SPAM folder and release the emails. This should temporarily resolve the problem while we work behind the scenes to solve the larger issue with our mail sender. Thank you for your patience!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Pulling ZIP + 4 Data

RCOOK
5 - Atom

I would like to know if it is possible to pull the zip + 4's for a state?

Thanks,

Robbie

5 REPLIES 5
CharlieS
17 - Castor
17 - Castor

@RCOOK

 

Are you interested in a list of string values, or spatial polygons? Neither one has a great answer that I'm aware of since the Post Office doesn't do list rentals or build spatial files.

 

I just found this good summary of ZIP and ZIP+4 methodology for anyone interested:

https://smartystreets.com/articles/zip-4-code

 

5d1d10f276fba2cbb339da423757a0e6

 

 

neilgallen
12 - Quasar

@RCOOK depending on what you're looking for, I believe this information is available in the US Census dataset that can be downloaded  from alteryx themselves. This can be brought into your workflow using the allocate input tool. However, this is census based and may not be current for all ZIP codes, which can change frequently.

 

 

There are a number of other resources out there if you do some quick google searches.

CharlieS
17 - Castor
17 - Castor

Good call, @neilgallen. The data packages Alteryx offers do provide ZIP spatial files. These are very similar to (but not identical to) the Census Bureau ZCTA polygons.. 

 

ZIP Code Tabulation Area (ZCTA) Information:

https://www.census.gov/geo/reference/zctas.html

 

Download ZCTA and other TIGER/Line Shapefiles from the Census Bureau:

https://www.census.gov/geo/maps-data/data/tiger-line.html

 

Here are some highlights from my ZIP code soapboxing:

- They are created and assigned by the USPS to organize mail delivery points/routes. By their point-only definition, they do not account for the area between these points.

- Different sources of data will have different methods on how to "fill" the area between the points. It's not uncommon for the USPS website, Google Maps, the Census ZCTA, and the Experian/Alteryx provided polygons to all be slightly different.

- Like @neilgallen mentioned, ZIP/ZIP+4 assignment can change frequently. This link shows 8 updates in the first 7 months of this year.

- ZIP+4 is just a further extension of these points: it's a mail delivery system and there are no "official" polygons for them.

RCOOK
5 - Atom

Thanks for your response Neil. I found a source for the zip plus 4 data which will include updates. Thanks for your advice.

nikolaushengel
5 - Atom

Would you mind sharing the source? We have a similar need.

Labels