Tag Archives: American Community Survey

Census Block, Block Group & Census Tract GeoDemographics

Census tracts, block groups and blocks are the important small area statistical geographic areas for which data from Census 2010 are tabulated. Data for census tracts and block groups are also tabulated annually from the American Community Survey. For example. in December 2018, we will have new “richer demographics” annual estimates centric to each year 2008 through 2015 for Census 2010 tracts and block groups … data such as educational attainment, language spoken, housing and household characteristics,  income characteristics and employment and other demographic-economic attributes.

Largest Population New York City (NYC) Census Blocks
The following graphic shows the NYC Census 2010 census block having the largest Census 2010 population that is not a group quarters population block. The Lincoln Center census block shown in the graphic (red boundary) has 4,067 population and 2,922 housing units.

– click graphic for larger view; view developed using CV XE GIS

This block (36 061 015500 6000) occupies 0.033 square miles. It has a population density of 122,333 (population per square mile). The NYC block with the largest population is on Rikers Island and has a group quarters population of 8,634 and 0 housing units. For Census 2010, there were 350,169 census blocks covering the state of New York; 13,356 census blocks were water blocks. For the State of New York, as of Census 2010 the average census block population was 55 (57 excluding water blocks).

Census 2010 and Census 2020
These geographies have generally stable geographic areas and codes from one decennial census (e.g., Census 2010) to the next (e.g., Census 2020). Many of these areas will change in terms of code and area for Census 2020, though the geographic changes will typically be small or not at all.

Census 2020 block, block group and tract codes and geometry will be available in late 2020. Initial block level demographics will be available in March 2021.

Census 2010 & Current GeoDemographics
These areas cover the U.S. from wall-to-wall and generally non-changing in terms of boundary and geographic code (geocode) until Census 2020. This section provides a summary of new Web pages with more detail about each of these geographies:
census tracts and tract codes .. 73,056 areas
census block groups and block group codes .. 217,740 areas
census blocks and block codes .. 11,078,297 areas

Each of these pages provides an interactive table to view tallies of Census 2010 for each of these small area geographies.

Combining Address Data with Small Area Geography
The address of the Office of the California Secretary of State, located at 1500 11th St, Sacramento, CA 95814, was geocoded using the APIGeocoder and converted into a shapefile for Geographic Information System applications.  The location is shown as a red marker in the map views shown below, illustrating each type of small area geography: tracts. block groups and blocks.

Census Tracts
Tracts are labeled with green tract codes. Address 1500 11th St, Sacramento, CA 95814 is shown by red marker.  The address is in tract 06067001101.

View created using CV XE GIS.

Block Groups
Block groups are labeled with red block group codes.  Tract 06067001101 is comprised of block groups: 060670011011 and 060670011012.  See pointer in map view; the block group within tract boundary.

View created using CV XE GIS.

Zoom-in to Census Block
Blocks are labeled with yellow block codes. The address is located in block 060670011011085.

View created using CV XE GIS.

Further Zoom-in Showing Streets
Streets are labeled with street names. Identify tool is used to show mini-profile for 1500 block of 11th Street.

View created using CV XE GIS.

Is the tract code 11.01 or 001101?
Both. Census tracts within a county are identified by a 4-digit basic code between 0001 and 9999, and may have a 2-digit suffix ranging from .01 to .98; for example, 6059.02. The decimal point separating the 4-digit basic tract code from the 2-digit suffix is shown in Census Bureau printed reports and maps. For geo-referencing, the decimal point is implied and does not appear; the 6-character tract code with lead zeroes is used — a character string with no blanks and all numbers.

Accessing and Using these Geographies & Related Demographics
There are several ways these geographies can be used.
• The geocodes are the “handles” to access demographic-economic statistical data.
• The geographies may be visually, geospatially, related as shapefiles.
.. the Census Bureau makes these shapefiles available for use in user appications.
.. the shapefiles typically do not include demographic-economic data.

Access Census 2010 Census Block (and Block Group/Tract) data:
• P.L. 94-171 Redistricting Data — http://proximityone.com/cen2010_pl94171.htm
• Summary File 1 — http://proximityone.com/cen2010_sf1.htm

Access Census Block Group and Tract richer demographics:
• 2016 American Community Survey (ACS) 5-year estimates
  — http://proximityone.com/acs1216.htm
• Access annual counterparts to above section
• Census blocks — http://proximityone.com/cenblk.htm
• Census block groups — http://proximityone.com/blockgroups.htm
• Census tracts — http://proximityone.com/tracts.htm

Alternatively use the Census Bureau APIs or CV XE GIS APIGateway.

Data Analytics Web Sessions
.. is my area urban, rural or …
.. how do census blocks relate to congressional district? redistricting?
.. how can I map census block demographics?
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Creating Custom Demographic Datasets with API Tools

.. develop national scale spreadsheet files with virtually no learning time .. easy-to-use API operations to create national scope demographic-economic datasets based on American Community Survey 2016 1-year estimates .. custom subject matter selections. See more detail in related web sections ACS2016 and ACS2016_API.

Benefits and utility … how to acquire a spreadsheet showing the population of all cities with population estimates based on the ACS 2016 1-year data? … or, housing units, median household income, median housing value, etc.? Variations of this need frequently arise — what is the list of largest California counties sorted on total population: What are the 25 metros having the highest median household income? Which 10 congressional districts have the highest poverty incidence? Which urban areas have the highest educational attainment?

Use simple API calls described below to get answers to these types of questions — and more.  Create files that can be used for recurring applications. An example …

Urban Areas with 2016 Population 65,000+ Population
… results from using the API downloaded data … the following graphic shows urban areas with 65,000 or more 2016 population; zoom-in to Texas. The full national scope GIS project is available as described below; examine U.S. or any region. The file used to develop this view was created using the results of the API call reviewed below (requires integration of those data into the urban areas shapefile). Click graphic for larger view; expand browser window. Larger view shows urban areas labeled with name and mini profile for Dallas UA showing all subject matter items downloaded (via API) as described below.

… View developed using CV XE GIS.
… See more about Urban Population & Urban Areas.

Access ACS 2016 1-Year Data Using API Tools
Here are the API links … use these API calls to access/download selected items for selected geographies. See more about using API tools. Click a link and receive a return page with CSV-like structured data. See usage notes below. As these are ACS 2016 1 year estimates; geographies are only available for areas 65,000+ population.
Click a link:
• All U.S. cities/places
• All U.S. counties
• All U.S. CBSAs
• All U.S. Urban Areas
• All 115th Congressional Districts
• All U.S. states
• U.S. only

The following data retrieval operations are by state. These are examples using Arizona (FIPS state code 04).
• All [within state] Elementary School Districts
• All [within state] Secondary School Districts
• All [within state] Unified School Districts

API Call Returned Data Usage Notes
Clicking the All U.S. cities/places link above generates a new page with content very much like a CSV file. Try it .. click an above link.

See the related ACS2016_API web section for more details.

Items Retrieved in the API Calls
The sample header record above shows the subject matter item listed at the left in the following set of items. Modify API call and use other subject matter items. See full array of subject matter – xlsx file.
.. B01003_001E – Total population
Age
.. B01001_011E — Male: 25 to 29 years (illustrating age cohort access)
.. B01001_035E — Female: 25 to 29 years (illustrating age cohort access)
Race/Origin
.. B02001_002E – White alone
.. B02001_003E – Black or African American alone
.. B02001_004E – American Indian and Alaska Native alone
.. B02001_005E – Asian alone
.. B02001_006E – Native Hawaiian and Other Pacific Islander alone
.. B02001_007E – Some other race alone
.. B02001_008E – Two or more races
.. B03001_003E – Hispanic (of any race)
Income
.. B19013_001E – Median household income ($)
.. B19113_001E – Median family income ($)
Housing & Households
.. B25001_001E – Total housing units
.. B25002_002E – Occupied housing units (households)
.. B19001_017E — Households with household income $200,000 or more
.. B25003_002E — Owner Occupied housing units
.. B25075_025E — Housing units value $1,000,000 to $1,499,999
.. B25075_026E — Housing units with value $1,500,000 to $1,999,999
.. B25075_027E — Housing units with value $2,000,000 or more
.. B25002_003E – Vacant housing units
.. B25077_001E – Median housing value ($) – owner occupied units
.. B25064_001E – Median gross rent ($) – renter occupied units

The rightmost fields/columns in the rows/records contain the area name and geographic codes.

Using API Tools for Data Analytics
Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on L

State of the States: Demographic Economic Update

.. tools and resources to examine the demographic-economic state of the states .. in 2016, the U.S. median housing value was $205,000 while states ranged from $113,900 (Mississippi) to $592,000 (Hawaii). See item/column H089 in the interactive table to view, rank, compare, analyze state based on this measure … in context of related housing characteristics. These data uniquely provide insights into many of the most important housing characteristics.

Use new tools, data and methods to access, integrate and analyze demographic-economic conditions for the U.S. and states. These data will update in September 2018.

Approximately 600 subject matter items from the American Community Survey ACS 2016 database (released September 2017) are included in these four pages/tables:
• General Demographics
• Social Characteristics
• Economic Characteristics
• Housing Characteristics

GIS, Data Integration & Visual Data Analysis
Use data extracted from these tables in a ready-to-use GIS project. These ACS sourced data (from the four tables listed above) have been integrated with population estimates trend data, components of change and personal income quarterly trend data. See details in this section.

Examining Characteristics & Trends
Below are four thematic pattern maps extracted from the main sections listed above. Click a map graphic for a larger view. Use the GIS project to create variations of these views.

Patterns of Median Age by State
Yellow label shows the state USPS abbreviation; white label shows median age. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column D017 in the interactive table to view, rank, compare, analyze state based on median age.

Patterns of Educational Attainment by State
Yellow label shows the state USPS abbreviation; white label shows % college graduates. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column S067 in the interactive table to view, rank, compare, analyze state based on percent college graduates.

Patterns of Economic Prosperity by State
Yellow label shows the state USPS abbreviation; white label shows $MHI. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column E062 in the interactive table to view, rank, compare, analyze state based on median household income.

Patterns of Median Housing Value by State
Yellow label shows the state USPS abbreviation; white label shows $MHV. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column H089 in the interactive table to view, rank, compare, analyze state based on median housing value.

Examining Characteristics & Trends; Using Data Analytics
Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Tools to Analyze County Demographic-Economic Characteristics

.. demographic-economic characteristics of counties are essential for business development, market analysis, planning, economic development, program management and general awareness of patterns and trends. This section provides access to data and tools to examine these data for all counties in the U.S. This annual update includes geographic area characteristics based on ACS 2015 data.  The tools/data are organized into four related sections summarized below.

1. General Demographics
View interactive table at http://proximityone.com/us155dp1.htm
Patterns of School Age Population by County
Use GIS tools to visually examine county general demographics as illustrated below. The following view shows patterns of percent population ages 5 to 17 years of age by county — item D001-D004-D018 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

2. Social Characteristics
View interactive table at http://proximityone.com/us155dp2.htm 
Patterns of Educational Attainment by County
– percent college graduate
Use GIS tools to visually examine county social characteristics as illustrated below. The following view shows patterns of percent college graduate by county — item S067 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

3. Economic Characteristics
View interactive table at http://proximityone.com/us155dp3.htm 
Patterns of Median Household Income by County
Use GIS tools to visually examine county economic characteristics as illustrated below. The following view shows patterns median household income by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

4. Housing Characteristics
View interactive table at http://proximityone.com/us155dp4.htm 
Patterns of Median Housing Value by County
Use GIS tools to visually examine county housing characteristics as illustrated below. The following view shows patterns median housing value by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Largest School Districts Enrollment Characteristics

..  while school district enrollment is reported by school districts, only public school enrollment is reported. Public and private school enrollment are available by district from the American Community Survey (ACS 2015).  With few exceptions, school districts do not report on demographic-economic characteristics of the school district.  These data are only available from ACS. See the related interactive table to access and compare enrollment characteristics of school districts of interest.

In 2015, there were 1,016 school districts with total population of 65,000 or more (of total 14,650) for which “1-year estimates” were tabulated.  These estimates are based on respondent data for calendar year 2015.  This section summarizes selected enrollment characteristics of the largest districts and provides access to much more detail for each of these districts.

Largest 10 School Districts
The following graphic shows the largest 10 school districts based on the size of the 2015 school age population ages 5-to-17. Click graphic for larger view.

Mapping the Largest School Districts
The following graphic shows locations of the largest school districts as red markers. Click graphic for larger view that opens in a new window. Expand browser window for bets quality view. The larger view shows school district locations on context of metropolitan statistical areas (MSAs).

  view created using CV XE GIS software and related GIS project.

School Districts Tabulated in ACS 2015
ACS 2015 data are tabulated for 14,650 school districts (among many other wide-ranging geography). The following table shows the number of districts for which 1-year estimates and 5-year estimates are tabulated. There are 1,016 districts for which 1-year estimates were tabulated.

These data show enrollment of residents of the district whether enrolled in that district or otherwise. Enrollment data are provided for preschool, K-12 and college and not enrolled.

Using the School District Enrollment Interactive Table
The following graphic illustrates use of the interactive table (click that link to use the table) showing enrollment in kindergarten by school district ranked in descending order.

– click graphic for larger view.

Using the table, you can select total, public or private enrollment for selected grade ranges.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

New ACS 2015 1-Year Demographic-Economic Data

.. essential data to assess where we are, how things have changed and how things might change in the future down to the sub-neighborhood level. The American Community Survey (ACS) is a nationwide survey designed to provide annually updated demographic-economic data for national and sub-national geography. ACS provides a wide range of important data about people and housing for every community across the nation. The results are used by everyone from planners to retailers to homebuilders and issue stakeholders like you. ACS is a primary source of local data for most of the 40 topics it covers, such as income, education, occupation, language and housing. ProximityOne uses ACS to develop current estimates on these topics and 5-year projections. This section is focused on ACS 2015 data access, integration and use and is progressively updated.

New ACS 2015 1-year estimates are available as of September 15, 2016.

Importance of ACS: Assessing Demographic-Economic Change
Oil prices plummeted in late 2014. How has this affected people and households in areas hardest hit? Find out for wide-ranging geographies using the ACS 2015 1-year estimates. Compare to ACS 2014 1-year estimates. Use the ACS 2016 1-year estimates (September 2017) to see how the impact has continued. Demographic-economic conditions change for many reasons; oil price changes are just one.

Keep informed about ACS developments and related tools and applications:
• Updates are sent to ProximityOne User Group members (join here).
… access special extract files and GIS projects available to members.
• ACS updates and applications are covered in the Data Analytics Blog.
• ACS data access, integration & use … join us in a Data Analytics Lab session.

In the weeks ahead, the following ProximityOne information resources will be updated with new ACS 2015 1-year data:
U.S.-State-Metro Interactive Tables
• Demographic component section of Metro Situation & Outlook Reports .. example for Dallas metro
• Housing characteristics component section of Metro Situation & Outlook Reports .. example for Dallas metro
Demographic-Economic Trend Profiles
• Special study reports.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Children’s Demographics by School District

.. data and tools to analyze children’s demographics by school district ..  the ACS 2014 median household income for the Houston ISD, TX (HISD) was $46,069 (all households) compared to $41,896 (grade relevant children’s households). How does economic prosperity (or choose from many other attributes) vary between the total population of an area and to those of total children or grade relevant children by type of enrollment in districts of interest? See related Web section with interactive table.

This section summarizes data and tools to access to the children’s demographic-economic data, based on the 2014 American Community Survey (ACS 2014) school district special tabulation (SDST), for each/all school districts. These data provide insights into the population, social, economic and housing characteristics of total children and grade relevant children — in contrast to the total population and housing. Use the interactive table below to view, rank, compare, query children’s characteristics.

Patterns of Economic Prosperity by School District; Children’s Households
— Median Household Income for Grade Relevant Children Households
The following thematic map shows patterns of median household income for grade relevant children households by school district for Texas and adjacent states. Click graphic for larger view (shows metros). Expand browser to full extent for best quality view.

View developed using CV XE GIS software and associated GIS project.

Additional Views:
Dallas metro area
Houston metro area
Los Angeles metro area

Importance of these Data
The annually updated SDST data are a unique source of data to help stakeholders understand demographic-economic characteristics of total children as well as grade relevant children. The real power of these data is that they enable analysis of children’s living characteristics by type of enrollment (enrolled in public school, enrolled in private school, not enrolled) by school district. For example, in this Houston ISD, TX profile it can be determined that of those grade relevant children who ‘speak English less than “very well”.
– enrolled in public school
… 36,995 or 18.7% of total grade relevant children enrolled public
– enrolled in private school
… 810 or 3.9% of total grade relevant children enrolled private (very low)
– not enrolled
… 3,265 or 30.9% of total grade relevant children not enrolled (very high)

How does Houston ISD compare to Dallas ISD? … to Los Angeles Unified? … use these data to find out. Whether ability to speak English, or other living/demographic environmental characteristics, these are among the factors that can primarily influence educational outcomes.

Comparing the Number of Households
The total number of households compared to the number of households with grade relevant children is often in the range of 3-to-4 to 1. The following table shows illustrative examples for selected districts.

Scope of the School District Special Tabulation
The School District Special Tabulation is a tabulation of the characteristics of children who reside within the boundaries of a school district. Note that such residents/children might attend a school located outside of the school district of residence. Subject matter items are tabulated for these seven universes:
• all children — population ages 0-19, 18 & 19 not high school graduates
• all school age, grade relevant children
– children enrolled
– children enrolled in public school
– children enrolled in private school
– relevant children not enrolled
See about related data

Children’s Demographics by Type of Enrollment
  — Interactive Table
The following graphic illustrates use of the interactive table to rank districts by total relevant children and views percentage distributions by type of enrollment. Note that among the largest 10 districts, Las Vegas (Clark County, NV) has the largest percent not enrolled (12.x% — far right column). Use the full interactive table to compare contrast district based on your criteria.

– click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn