Analyzing extended demographics by census block and higher level geographic areas ... new data resources from Census 2010.
The Census 2010 Summary File 1 (SF1) release was completed August 25, 2011.
The SF1 is the third major Census 2010 data resource following the
Demographic Profile Summary File (DPSF) data released in May 2011
and following the P.L. 94-171 redistricting data released earlier in 2011.
The SF1 contains 100 percent data asked of all people and about every
housing unit on topics such as sex, age, race, Hispanic origin, household relationship, household
type, group quarters population, housing occupancy, and housing tenure.
The SF1 is released as individual files for the U.S., each state, D.C., Puerto Rico and as a national summary file.
07.11.11. Using Census 2010 Summary File 1 with Demographic Data Analyst
Use the ProximityOne Windows-based Census 2010 Demographic Data Analyst (DDA) software to more easily
and effectively manage, integrate and analyze Summary File 1 and related data.
dBase Structure. The software can automatically convert all 47
Census 2010 Summary File 1 (SF1)
data segments into dBase structure while maintaining the original Census data file/field architecture.
The dBase structure enables the user to use the SF1 data for one or multiple states in relational database operations.
Why dBase? ... public domain architecture ... widely used in many Census related applications ... very large
number of data users are familiar with structure/use ... provides an adequate light-weight relational database structure
to meet most Census data integration and access needs ... works well with shapefiles and mapping/GIS applications.
A very few simple steps, no learning ...
• Download the Census-sourced SF1 state zip file.
• Start DDA, key in the output path and state postal code, click Go.
• The new dBase files are generated waiting to be used.
• Open the geographic header with DDA or other software and start using.
Extract Selected Items. Use a query statement to select only summary levels of interest.
Apply a query statement like to extract only county data.
Use a select-from-list/checkbox method to designate which data tables or items are to be extracted.
The extracted dBase file is a flat file containing the summary level, geocode and other fields selected by the user.
Table/item field names used in extracted files maintain the original Census assigned names so that all Census developed
documentation applies.
A very few simple steps ...
• Start DDA, set a query condition; e.g., SUMLEV='871' (all ZIP Code Tabulation Areas).
• Select subject matter items to extract ... pick from list or enter into a text file.
• Click Go. The new dBase file (optionally save as CSV or text) is ready to use.
• Extracted data are ready-to-merge/integrate into shapefiles for mapping.
Create Comparative Analysis Profiles. Once in the dBase structure, DDA can be used to display
profiles and tables (stubs and headers) in a grid. The grid display results can be output as CSV, RTF (Word) or HTM.
Display to grid and output to these formats can be performed interactively or in batch mode.
Contact us (mention DDA) or call (888)364-7656
for more information.
Use the ranking table at http://proximityone.com/zip-place.htm
to view a city/place by ZIP code and selected associated demographics for each ZIP code portion
in that city/place. Examine how split ZIP codes are split by specific place and non-place areas.
The data are also available as a national scope dataset.
Census 2010 ZIP Code Tabulation Areas (ZCTAs)
and Places geographies are both comprised of sets of census blocks.
Census block level data from the
Census 2010 Summary File 1 (SF1)
have been aggregated into ZIP code-Place parts to develop these data.
Single year of age data are are essential in many demographic analyses and the development of projections.
The Census 2000, and now Census 2010, Summary File 1 (SF1) Table "PCT12"
single year of age population data are widely used
by many types of organizations for many types of applications.
The PCT12 data uniquely provide access to "lowest common denominator"
single year of age detail from under 1 year to 100 years of age for
wide-ranging geographic areas enabling users
to construct age cohort data not otherwise available.
Table PCT12 is replicated for several race/ethnic combinations adding to analytical possibilities.
While the Census Bureau FactFinder (FF2) can be used to "call-up" and display/download the PCT12 data,
it is difficult to use the data directly, or even open downloaded data with a tool such as Excel, and easily view the data.
Effective usage challenges include:
• Age detail iterated by gender is cumbersome to aggregate.
• Comparison of aggregated gender data for one area to another is tedious.
• Labeling age detail in Excel-type applications is time consuming and challenging.
• Computing percentages requires additional steps.
• Aggregating the data across areas of interest (e.g., 5 census tracts) requires time.
Use the no cost Modeler II (M2) software to analyze the PCT12 data and resolve issues such as listed above.
These are also basic features required for the "next step" primary purpose of M2 --
developing population projections by age-gender-race/ethnicity for
census tracts and higher level aggregates of census tracts (including counties, metros, states)
as well as
cities/places,
towns, school districts, congressional districts, ZIP code tabulation areas among other geography.
Illustrative Profiles
Click on links in upper right scroll box to view full U.S. profile (with California and Texas) and profiles for other selected areas.
These profiles, and ranking table below, were developed with ProximityOne Situation & Outlook
software using the DPFS database.
Note that in comparison to the DPSF data:
• These profiles show a small subset of the scope of demographic subject matter contained in the SF1 data.
• These subject matter items may be presented at the census block
and any higher level geographic summary area for which Census 2010 data are tabulated using the SF1 data.
Develop similar comparative analysis profiles for any set of geographies in DPSF/SF1 dataset.
Contact us for more information (mention SF1).
Detail Available in SF1 Not Previously Available
• Single year of age by sex
• More detail on children, including adopted, stepchildren and grandchildren
• Race and Hispanic origin of householder
• More detail on household relationships
• Group quarters population by sex, age and group quarters type
• Housing tenure (rented or owned) by age, household type, race and Hispanic origin of householder
• Mortgage status of owned housing units
Counts about previously unreleased race and Hispanic or Latino origin groups are also available, including:
• American Indian and Alaska Native tribal groupings, such as Cheyenne, Navajo and Yup'ik
• Asian groups, such as Bangladeshi, Hmong and Pakistani
• Hispanic origin groups, such as Argentinean, Colombian and Guatemalan
• Native Hawaiian and Other Pacific Islander groups, such as Fijian, Marshallese and Tongan
Additional Information
Proximity develops geodemographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses.
Wide-ranging organizations use our resources (software, data, methodologies) to analyze their own data integrated with other data.
08.25.11. Narrated Videos Illustrating Use of Summary File 1 with Demographic Data Analyst
