Do you know how they classify a ZIP code that crosses a county boundary, especially if it is means that part of the ZIP code is in one metropolitan area and another is either out totally or in a different one?
I'm sure that there are such ZIP codes, but I haven't hit on any examples yet. Unlike those lists that are carved up by county, I couldn't find an obvious one.
That said, I tried to call the federal DOL, but could find no one who could answer my question, though, to be fair, maybe he or she is at lunch.
I put this data into a simple website that maps ZIP to MSA and MSA to ZIP. www.msa-zip.com You can also download the data in a CSV file, as the link to the government website above is no longer working.
I have started a small project site that distributes licensed USPS zip code data. I started the site because I was frustrated by this exact question on how to link to MSAs!
I don't know how much you know this, but there are HUGE amounts of changes to Zip codes all the time based on changes to carrier postal routes. We receive monthly updates at a zip+4 level (which also allows you to link zip codes to census block, congressional district and the like - great fun.) Anyway, point being that links to MSA and zip codes rapidly go out of date. The ones from the census are quite old (based of 2000 data.)
I've put up a download here that links all the MSAs, CBSAs, Combined Statistical Areas, and Metropolitan Divisions that we update monthly with the most accurate zip codes. A sample file is up for download as well so you can get a feel for it...
9 comments:
Do you know how they classify a ZIP code that crosses a county boundary, especially if it is means that part of the ZIP code is in one metropolitan area and another is either out totally or in a different one?
I'm sure that there are such ZIP codes, but I haven't hit on any examples yet. Unlike those lists that are carved up by county, I couldn't find an obvious one.
That said, I tried to call the federal DOL, but could find no one who could answer my question, though, to be fair, maybe he or she is at lunch.
I put this data into a simple website that maps ZIP to MSA and MSA to ZIP. www.msa-zip.com You can also download the data in a CSV file, as the link to the government website above is no longer working.
You write very well.
This was usefull thanks! But I wanted to say THANK YOU to charlie for the website he put together, that is an awesome resource.
Thank you.
Yeah, I agree with Mia. Charlie, your website saved me a lot of time. Thanks!
See more up-to-date source here.
I have started a small project site that distributes licensed USPS zip code data. I started the site because I was frustrated by this exact question on how to link to MSAs!
I don't know how much you know this, but there are HUGE amounts of changes to Zip codes all the time based on changes to carrier postal routes. We receive monthly updates at a zip+4 level (which also allows you to link zip codes to census block, congressional district and the like - great fun.) Anyway, point being that links to MSA and zip codes rapidly go out of date. The ones from the census are quite old (based of 2000 data.)
I've put up a download here that links all the MSAs, CBSAs, Combined Statistical Areas, and Metropolitan Divisions that we update monthly with the most accurate zip codes. A sample file is up for download as well so you can get a feel for it...
http://www.zipcodeinsights.com/zip/zip-code-data-downloads/msa-cbsa-csa-division-to-zip-code.html
Zip codes to msa cbsa csa and division
Hope this is helpful and love your site - a great read for a data guy!!
Post a Comment