Getting a list of Zip codes
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
we are looking to get all the zipcodes and names for entire US, we have access to the CASS and spatial data and were looking to see if we can get it from that
Allocate input tool has zipcodes but doesnt have PO Box Zipcodes.
not sure if we can read the underlying files in CASS to get a list any guidance would be appreciated.
Anuj
Solved! Go to Solution.
- Labels:
- CASS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Anuj Wherever you have installed that Alteryx data (it can be either locally or on the network), there should be a folder called "ZIP9CODER". Inside there will be a subfolder like "Zip9Coder_2019_Q2". Inside there is a yxdb file called "Zip4Code.yxdb". That should be able to get all of the zip codes and fips codes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks thats very helpful , but it doesnt have corresponding name for the zipcode
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I don't recall if any of the alteryx data could be used to go from FIPS code to FIPS name. Perhaps this site could provide it based on matching to fips codes: https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
i just passed the zip through the CASS tool and that gives me the city Name.. thanks so much
the zip type is null probably because the address is blank. it would have been nice if the zip type was dependent on Zip and not address
