2

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?

Improve this question
1
  • 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 ♦
    Commented Mar 26, 2017 at 16:06

3 Answers 3

Reset to default
1

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

Improve this answer
1
  • 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
    Commented Mar 27, 2017 at 9:29
1

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?

Improve this answer
9
  • 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
    Commented Mar 30, 2017 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
    Commented Mar 30, 2017 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
    Commented Mar 30, 2017 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
    Commented Mar 31, 2017 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
    Commented Mar 31, 2017 at 15:49
1

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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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