Would anyone like to volunteer to test out these directions and then report back to the CTPP listserv on how well it worked?

 

http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWithSummaryFile1.pdf

 

Sometimes when I send an email, the link gets broken.  The full link ends in “….pdf”

 

In the meantime, I am testing out the data access system at the Missouri

data extractor (Dexter/uexplore) to look at Summary File 1.  It is pretty easy, so far.

http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010  

   on this page, select the FIRST LINE “Datasets.html”   then I selected Colorado.

    I chose counties  in Denver 08031  using the FILTER (first set of boxes) and selected “tracts”  and then I selected Table H 12 and got a comma-delimited file, which I read into excel.   You have to select BOTH the geography fields in the LEFT box as well as the table (variable) fields in the RIGHT box.   If you forget to select the geography fields,  you will get the table variables without any corresponding geography, which is not very useful. Ask me how I know. J

 

Finally, I thought that when the Census released the Summary File 1 files on the ftp site that it meant the data would also be in AFF2, but apparently this is not true.  There are “quick tables” in AFF2, and these may satisfy your needs, but it is not the full set. 

 

Elaine Murakami

FHWA Office of Planning

206-220-4460