community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Zip Code Lists

Fireball

Hi,


Does anyone know where I can download a free list of 9 digit zip codes?  Having no luck with the google. 

Alteryx Certified Partner
Alteryx Certified Partner

@jbh1128d1,

 

I suppose the real question should be, what business case am I trying to solve for?  9 digit zip codes are not free.  I don't think that they are static either.  As delivery routes are updated with new construction (an example) new codes are created.  I'm sure that there is some logic where values like 0000 don't exist and if you see that number then it could be fake.  

 

Generally, firms need the value as part of CASS certification requirements for postal discounts.  The value alone might give you an idea of the deliverability of an address if you assume that the presence of a non-empty value means that at some point in time, the address was verified.  Alteryx provides CASS as a data service within Alteryx ($ extra).  You might look to MellisaData for other lookup needs.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Fireball
Thanks Mark. We have CASS but it’s missing around 300 zips for Illinois that we need to map as part of a territory production workflow.

Maybe I can justify the purchase. Had to do due diligence before asking for funds though.

Jordan

Sent from my iPhone

***** PLEASE NOTE ***** This E-Mail/telefax message and any documents accompanying this transmission may contain privileged and/or confidential information and is intended solely for the addressee(s) named above. If you are not the intended addressee/recipient, you are hereby notified that any use of, disclosure, copying, distribution, or reliance on the contents of this E-Mail/telefax information is strictly prohibited and may result in legal action against you. Please reply to the sender advising of the error in transmission and immediately delete/destroy the message and any accompanying documents. Thank you.*****
Highlighted
Alteryx
Alteryx

Hi @jbh1128d1

 

The missing ZIPs that you mentioned may be point based ZIP codes. By default, only Polygon ZIPs are enabled in the Allocate Input tool.  Enabling point zips gives you access to an additional ~10K ZIPs.  

 

 

Here is a link to an Alteryx Knowledge Base post that explains how to enable point ZIPs (also attached the article to this post).  

 

I hope this is helpful!

 

Cheers, 

 

Eric

Fireball

Thanks @EricM.  The link did not work but the document did.  Unfortunately, I couldn't locate the point zip files.  I'll continue to try and locate the files but I'll consider this a solution.

Meteoroid

I am not sure if you are still on this project.  I have been using this website to get all postal codes.  Link is below

http://download.geonames.org/export/zip/

 

Labels