[CTPP] more on 2010 Census Summary File 1

7 States have now been released including California. I only call this out specifically since California includes 12 (?) % of the total U.S. population. http://2010.census.gov/news/press-kits/summary-file-1.html Also, below is an email from Bob Schwartz in PA, which I hope he doesn't mind my sharing with the listserv. His email has been forwarded to Census Bureau staff, but we have not gotten any response yet. In anticipation of the 2010 Census Summary File 1 for Pennsylvania, I downloaded the 2010 Census Summary File 1 for Hawaii and immediately noticed problems with the file and the documentation. 1. I unzipped the zipped file and noted that the 47 data segments have a suffix of ".sf1", which it seems to me, should be ".txt". You can rename each file to a ".txt" but why should that be necessary? 2. In the "README File for 2010 Census Summary File 1 Delivered via FTP", is the statement "This is done so that individual files will not have more than 255 fields..." WRONG! The explanation for this is that there are fewer than 255 data fields HOWEVER, EVERY DATA FILE HAS 5 FIELDS PRECEDING THE ACTUAL DATA. Therefore, if you add 5 to every number under the column "Number of data cells" to get the total number of fields, you will find 9 files with more than 255 fields! These 9 files cannot be imported into Microsoft Access which is my database. 3. In the "README File for 2010 Census Summary File 1 Delivered via FTP", is the statement "All fields classified as numeric (N) should be imported as long integers" WRONG! Tables P13, P17, P37, and H12 (and their racial files A-I) are expressed decimal fields which should not be set to integer. Bob Schwartz, Data Administrator Phone: (412) 391-5590 Ext 336 Southwestern Pennsylvania Commission FAX: (412) 391-9160 Regional Enterprise Tower E-mail: schwartz(a)spcregion.org 425 Sixth Avenue, Suite 2500 SPC web address: www.spcregion.org Pittsburgh, PA 15219-1852 My normal hours: Mon-Fri 7:15-3:30