Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I would like to collect some census data for every block group in New England. I'm primarily interested in median income and median age, and ideally I'd like a large .csv file with one row per census block group and one column per variable (e.g. id variables, median_income, etc.).

American FactFinder seems almost useless for this kind of thing. Does the census have a "bulk data export" option?

share|improve this question
    
census.gov/cgi-bin/geo/shapefiles2010/main download shapefile for the states that cover New England –  Mapperz Feb 23 '12 at 15:39
    
@Mapperz: Will that include information other than the boundaries? –  Zach Feb 23 '12 at 16:18
add comment

2 Answers

From http://www.census.gov/newsroom/releases/archives/2010_census/cb11-cn151.html, there's a link for the Census Bureau's FTP site. You'll have to know how to decipher the file names to get what you want, but since you're looking for bulk data, I assume you know how to do that. You'll want an FTP client for bulk download. Then you can use your unzipper to extract the data. At the end you'll need to merge all the data, but it's actually manageable. I've done it for selected block group data for 3 states.

share|improve this answer
add comment

I'd recommend using the ACS Summary File Retrieval Tool. It's a macro-enabled Excel workbook that allows for the batch downloading of ACS data for all tracts and block groups within an entire state. This makes it more powerful than the FactFinder website, but it does the downloading of the text files and linking LOGRECNOs for you. Takes less than 30 seconds per state per table. Here's a screenshot:

enter image description here

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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