I'm trying to find ZIP Code Tabulation Areas for the list of 2010 Census block codes.

How to get ZIP Code Tabulation Areas for Census block code?

  • 1
    Welcome to GIS SE! As a new user please take the tour to learn about our focused Q&A format. The tour states there should be just one question per Question, however here you have asked several. Please edit your question to focused on a single specific question. This also looks like it may be off-topic as there doesn't appear to be any GIS component to the question. – Midavalo Mar 26 '17 at 16:06

I have not used ZCTAs before but in reading the Census Bureau description it appears that they may not match block groups completely. Having said that, there does not appear to be an attribute for a ZCTA in the block group level data within those available from American FactFinder.

One potential solution could be to perform a spatial join with the TigerLine geographies that are matched with the FactFinder data. If you are using ArcGIS your could look here for guidance: http://pro.arcgis.com/en/pro-app/tool-reference/analysis/spatial-join.htm

  • 1
    You are right regarding block groups but as I've read the block codes (15 figures) should belong to ZCTA. Actually I need ZIP-to-block code correspondence table but ZCTA is ok as well. Does ArcMap allows to realize this solution? – Andrey Mar 27 '17 at 9:29

This example uses ArcGIS Desktop 10.4 with shapefiles downloaded from TigerLine. Blocks are for Denver County, CO and the ZCTA file is for the entire state. In this case a spatial join was performed with these parameters:

enter image description here

This produced the table found here which is the dbf file for the shapefile. This may be opened as a spreadsheet. The attribute "GEOID 10" is the 15 figure code for the block while "ZCTA CE10" is the corresponding ZCTA code in which that block exists.

Does that table suffice?

  • Thank you. I'm trying to make the test. I have few questions? Did you use ArcMap (this is the only one I happened to install)? If Did you use tl_2010_08_county10 as county data? – Andrey Mar 30 '17 at 18:27
  • I'm away from my laptop right now. I'll confirm the file name in about an hour but I believe that is correct. I used ArcMap 10.4. ArcGIS Pro would be able to do this as well but the process is different. – SteveC Mar 30 '17 at 19:32
  • Actually that is incorrect. I used the file "tl_2010_08031_tabblock10" as the basis for my join and joined features as shown above from "tl_2010_08_zcta510". The file you are referring to is geography for counties, not blocks. You can find the block shapefile in the same area but you need to select blocks from the pull-down if you are using the web interface. – SteveC Mar 30 '17 at 20:42
  • I've loaded both shapefiles and imported them with "Add data" menu. Then I clicked on 'tl_2010_08031_tabblock10' and selected these menus: 'Join and Relates' -> 'Join'. Then I've tried to choose the result file but the only working option for 'Save as type' was 'shapefile'. When I've tried to save it as 'Database feature classes' I got an error: 'An error occured trying to save object named "Join_Output"'. I also tried to save the result as shape file and then to make 'Export Data' as 'Database feature classes' but the same problem appears. – Andrey Mar 31 '17 at 15:07
  • You don't need to export to dbf. After you complete the join and view the attribute table to make sure the join worked you will export the joined file to a new shapefile. The dbf is one of several files included in what is referred to as a shapefile. If you use your file explorer in Windows to navigate to the location where you exported the newly joined layer you will see several files with the name of the shapefile followed by a unique extension. In Excel or some other spreadsheet software open the file with the ".dbf" extension at that location. That should be the table you want. – SteveC Mar 31 '17 at 15:49

Well, it sounds like you found a reasonable work-around for your issue.

I know that the LEHD contains crosswalk information on many different levels of geography relating to a Census 2010 Block. The documentation explains the layout of the data, which are located by state in this ftp repository.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.