Tuesday 24 September 2019

Where to get 2010 Census Block data?


I would like to download 2010 Census Block Data for several towns and I can't seem to find it on American Factfinder.


Is it there? And if not, does anyone know where I could find it?



Answer



It is on the new version of American Factfinder and don't feel bad, even Census Bureau employees are confounded by the new site.


Example for population and housing for Newark, DE:



Start searching for the theme you're after:





  1. Under Topics choose People > Basic Count/Estimate > Population Total and Housing > Basic Count/Estimate > Housing Units - or whatever you're interested in. Your results will show up in the table list in the main window.



    • See your current filter in the 'Your Selections' window in the top left-hand window




  2. Click on Geographies, a window for selecting geographies opens. Note if you select a geography where the table above is not available, you'll get a message and your options will reflect what is available at this geographic level.



    • Select a Geographic Type ie. Block Group - 150


    • Select a State

    • Select a County

    • Click from the available geographic unit from the 'Select one or more geographic areas...' and choose Add to your selection

    • Your geography is added to the 'Your Selections' window

    • Close the Select Geographies window.

      • Note if you want to download tables for multiple counties, go through the Geographies window again and you'll see each one added to 'Your Selections'







  3. If you want to further filter your results to a race/ethnic group, click Race and Ethnic groups



    • Note if you have chosen a topic that doesn't allow a filter by race/ethnicity, you should clear that from 'Your Selections' window and choose a different topic (or leave it blank)




  4. Click from the table list in the main window to add to your download list




    • note these




  5. Click the download button and verify your .zip creation and download




  6. When your download is finished, open the .zip and see the file ending with _with_ann.csv



    • This is your data that you will load into your database or join to your shapefile


    • Note the GEO.id2 column - this is the BLOCKGROUP ID that will link to the same column in your Blockgroup Shapefile




Here is an image showing how to open the CSV in LibreOffice - ensure the GEO.id2 column is read as 'TEXT' so that leading 0's are kept (and ensure you set up the proper column data type if you import into PostgreSQL)


enter image description here


And lastly the data in LibreOffice, showing that when you do import the data somewhere, discard the second and third columns so you only keep the header and data:


enter image description here


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...