Tag Archives: Census 2010

Census 2020 Residential Address Counts by Block

.. using Census 2020 residential address count data to examine change since 2010 .. the Census Bureau has released preliminary Census 2020 residential address counts by Census 2010 census block. These data, count of residential addresses and group quarters addresses, reflect updates as of October 2019 and do not represent final Census 2020 counts. The data will continue to be updated to support Census 2020. See related Web section with more detail and updates.

Importance and Use
These data are of immediate value in determining and analyzing how the number of housing units have changed, 2010 to 2019. Since the data are at the census block level, they may be aggregated to any other Census-defined summary level/type of geographic area such as block group, tract, ZIP code, city, county, school district, etc. These data are also important as they give us a “year in advance look” at how small area demographics are changing since 2010. Before this, the most recent census block data were from Census 2010. A lot has happened in many areas. These data provide insights into that change. The Census 2020 block level data will be released in early 2021 for Census 2020 census block geography. So, another important feature of these data is that they are summarized for Census 2010 census block boundaries. Census 2010 and 2020 block boundaries may differ, particularly in areas experiencing larger demographic growth/change. An important limitation is that they are counts, subject to change as the Census data are collected/tabulated.

Comparing Census 2010 Housing Units with Census 2020 Address Counts
The following graphic shows patterns of Census 2010 housing counts with the Census 2020 (late 2019 vintage) residential address counts by census block. This view is focused on census tract 3608100700 (tract 000700) in Queens County, NY (code shown near center of graphic). Individual blocks are labeled with block code (4 digits) with the Census 2010 housing units (yellow label) and Census 2020 residential address count (green label) shown below the block code. As an example, the block located at the pointer has block code 3006 (or full national scope unique block code 36-081-00700-3006) with a Census 2010 count 44 housing units and a Census 2020 (late 2019 count) of 232 residential addresses. Click graphic for larger view. Expand browser window to full screen for best quality view.

.. view created with ProximityOne CV XE GIS software and related GIS project.

More About Using these Data
We have summarized these data at the census tract level and are evaluating their use, in combination with other data, to develop current estimates and projections to 2025.

Data Analytics Web Sessions
Join me in a Demographics 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.

Relating ZIP Codes and Census Tracts

.. what census tracts intersect with a ZIP code of interest? There are many reasons for the underlying the need to convert/equivalence ZIP codes to/from census tracts. Some organizations have to provide census tract codes for addresses/ZIP codes of clients to be in compliance with a law or regulation. Some organizations have addresses/ZIP codes of clients/locations for which they would like to determine the corresponding census tract codes to analyze census tract demographics. This post reviews tools and options for these operations. See related Web section to access interactive table and learn more about mapping and geospatially relating these two geographies.

Phoenix/Scottsdale, AZ ZIP Code-Census Tract Relationship
The following graphic illustrates the relationship between ZIP code area 85258 (orange fill pattern) with census tracts (green boundaries and geocode labels).
(StCtyTract=04013216813).
.. view created with ProximityOne CV XE GIS software and related GIS project.

Create your own maps of areas relating ZIP codes and census tract, in context of other geography. Use the CV XE GIS with shapefiles.

Using the Interactive Table
Use the ZIP code to census tract interactive table (opens new page) to answer questions such as:
• Which census tracts intersect with a ZIP code of interest?
• Which ZIP code(s) intersect with census tract(s) of interest?
• What is the Census 2010 population for a census tract and ZIP code combination?

The interactive equivalence/look-up table shows a row for each unique combination of a Census 2010 ZIP code area and Census 2010 census tract. The start-up view is sorted on the State-County-Tract column (StCtyTract). View ZIP codes in one state using the State selection button. To locate a ZIP code of interest, either use the Find ZIP query or sort on the ZIP code column and then scroll down the table until the ZIP of interest is located.

Example. Click Find ZIP button using the interactive table (opens new page) to view only the tracts intersecting with ZIP code 85258 (as shown in map view above). The Location 1 marker (see pointer in map) is located in the area intersecting ZIP code 85258 and census tract 2168.13. The refreshed table view is shown by the graphic below. There are nine tracts intersecting with this ZIP code; see the tract codes in the table.

Try this for a ZIP of interest:
• View the interactive table (opens new page).
• Click the Showall button below table.
• Key in your 5-digit ZIP code in edit box where 85258 now shows.
• Click Find ZIP button.
• Table refreshes showing only tracts intersecting with this ZIP code.

Scope of Tracts and ZIPs in Table
There are 150,806 rows in the table, each showing a unique combination of a census tract (73,057 Census 2010 tracts) and ZIP code area (33,120 Census 2010 ZCTAs). Each row represents an intersection of the specified census tract and ZIP code area and corresponds to a geographic area of one census block or more. The total population and housing units values have been derived by summing component census block values. The sum of the population column is 308,745,538, the United States Census 2010 total population.

Situation & Outlook Weekly Web Sessions
Join me in a Situation & Outlook web session to discuss more details about demographic-economic estimates and projections.

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.

Census 2020 P.L. 94-171 Redistricting Data Updates

.. we are just two years away from the first census block level data from Census 2020.  The initial block level data will be the P.L. 94-171 redistricting data.  But before that, the initial Census 2020 TIGER/Line shapefiles/GIS files, the geography, will become available in November 2020, maybe earlier.  Stakeholders will be able to see how block and tract codes and geography have changed in many areas since 2010.  The prototype P.L. 94-171 data (see final file layout and subject matter items) are expected in the last week of March 2019 and will cover the Providence County, RI area. This post shows illustrative views and related details about the area. The Census 2020 P.L. 94-171 program and plans are reviewed in this Federal Register notice.

The applications/views shown below have been developed using the ProximityOne CV XE GIS software and related GIS project.

Census 2020 Data Access and Use Program
ProximityOne operates a comprehensive Census 2020 Data Access and Use Program providing tools to integrate and analyze these data with other data for redistricting, planning, evaluation, management, general analysis and policy-related applications. Contact us for more information; mention Census 2020 Data Access and Use Program in text section.

Providence, RI Census 2020 P.L. 94-171 Prototype
The Census 2020 P.L. 94-171 prototype covers Providence County, RI, part of the Providence-Warwick, RI-MA MSA (39300) — see Situation& Outlook report. Providence County is shown with cross-hatch pattern in the following graphic.

The next graphic shows a zoom-in to the county with cities/places shown with green fill pattern.

The next graphic shows patterns of economic prosperity for the county based on ACS 2017 median household income by census tract — blue, higher and red, lower.

The next graphic shows Census 2010 blocks for the county. Demographics described in the P.L. 94-171 file described about will be provided at the census block level.

Census block boundaries are primarily defined by roads. Providence County roads are shown in the next view.

The next view shows a zoom-in to the downtown Providence city area. Census blocks are shown with red boundaries and labeled with the 15-character U.S. national scope unique census block code. The pointer is located in census block 440070012001001, or 44-007-001200-1001, expressed as SS-CCC_TTTTTT-BBBB. Access these Census 2010 data (an example) using the Census FactFinder tool via this link. This is the “P1 RACE” table. The Census 2010 population of the block was 598. This census block is one of 13,597 Census 2010 census blocks comprising Providence County.

Rhode Island 116th Congressional Districts 01 and 02 (labeled) split Providence city (cross-hatch pattern) as shown in the graphic below. Pointer shows CD boundary.

Similar to above, the graphic below shows census blocks in context of Providence city (bold green boundary) and CDs 01 and 02.

Next Steps
This section provides a geographic orientation the Census 2020 P.L. 94-171 prototype area. A subsequent post (March 2019) will extend on this post with Census 2020 P.L. 94-171 data and related details. Use the downloadable project and software to examine geodemographics and redistricting operations.

Data Analytics Web Sessions
See these applications live/demoed. Run the applications on your own computer.
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.

 

Mapping Census Tract Demographics

.. using visual data analytics and developing business intelligence .. this section provides a 4-step procedure to develop thematic pattern and reference maps for census tracts. The focus of this section is on mapping Census 2010 census tracts using data from the 2014 American Community Survey (ACS2014). A similar set of steps could be followed for Census 2000 tracts with Census 2000 data or Census 2010 tracts with Census 2010 demographics or different vintage ACS data. Steps summarized here can be used with most any Windows-based computer having Internet access. See the related full Web section with more details.

• how do customers and sales relate to market area characteristics?
• is their a better configuration of locations or service areas?
• how can you more effectively examine customer and sales patterns?
• what and where are areas of missed opportunities?

See related sections:
Using GIS & Data Analytics
Mapping Statistical Data

Benefits of this section include providing help for those:
• having a specific interest in mapping census tract demographics.
• with little or no experience in using GIS.
• getting started with CVGIS.

These resources and instructions provide a real, not demo, valuable tool that anyone can use, without fee, to create county by census tract thematic pattern maps. Use any of the “richer” demographic-economic data (not just median household income) from the latest ACS 5-year data (see scope — table shells xls).

The steps described below can be performed with any version of CVGIS, including the no fee version. Start from scratch and develop thematic pattern maps like that shown below. Questions, need help? See the FAQs. Call with questions – 888.364.7656. Or, use this form and put questions in the text section.

While this application is focused on ACS 2014 median household income for Dallas County, TX census tracts, you can follow these steps for other areas and subject matter. In your own applications, choose any ACS subject matter for any county/area of interest. The following view shows the end result of steps described below. Choose your own county of state; choose your own subject matter; select your own colors and labeling; choose your own zoom view; and more. Dallas Metro Situation & Outlook.

Patterns of Economic Prosperity; Dallas County, TX by Tract

Mapping Census Tracts Demographics Steps
These steps should take an inexperienced user 10-15 minutes to develop a new CVGIS project view. Steps can be performed at separate times.
Click on a link to view step-by-step instructions.
1. Install CVGIS
2. Get census tract shapefile
3. Get census tract subject matter data (median household income or other)
4. Create map view(s)

Create your own maps for your own county/tracts for your own subject matter.

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.

Navigating the U.S. Federal Statistical System

.. an overview of the Federal statistical system and how to access data  .. the U.S. Federal Statistical System offers a vast array of diverse data resources that are useful in wide-ranging planning and analytical applications. Many of these data resources, such as census block level demographics from the decennial census, are unique in scope and content; in many cases there are no alternative data resources.

But there are issues/challenges for the data user to navigate the Federal Statistical System. Examples … the Bureau of Labor Statistics releases total employment data by county quarterly and monthly through multiple programs. The data values differ, for methodological reasons, but the net result can be confusion. The Census Bureau releases total employment data from many statistical programs by county both annually and more frequently. Where are these alternative total employment data and how can they be accessed? How do these various measures differ and which data are right for my situation? This section provides basic statistical program information. Subsequent updates will provide more detail.

This section provides an overview of the U.S. Federal Statistical System (FSS) and information that can help stakeholders navigate access to selected types of data produced by the FSS. While the FSS is focused on agencies that collect, develop and make available statistical data, there is a broader set of data and resources that relate to accessing and using these data. As technology and related data analytics resources have evolved, access to and use of these data is closely associated with the development of geographic data by Federal statistical and other agencies and Geographic Information Systems (GIS).

The FSS is a decentralized set of agencies that collect, develop and make available statistical and geographic data. The OMB Office of Statistical Programs and Standards (SPS) provides a FSS coordinative role. The SPS establishes statistical policies and standards, identifies priorities for improving programs, evaluates statistical agency budgets, reviews and approves Federal agency information collections involving statistical methods, and coordinates U.S. participation in international statistical activities.

While the FSS spans more than 100 agencies, the 13 “principal statistical agencies” have statistical work as their principal mission. Excluding funding for the decennial census ($919.3 million requested for the Decennial Census for FY 2016), approximately 38 percent ($2,486.9 million of the $6,486.6 million total proposed for FY 2016 President’s budget request) of overall funding for Federal statistical activities (of the Executive Branch) provides resources for these 13 agencies. The principal statistical agencies include:
Census Bureau (Commerce)
Bureau of Economic Analysis (Commerce)
Bureau of Justice Statistics (Justice)
Bureau of Labor Statistics (Labor)
Bureau of Transportation Statistics (Transportation)
Economic Research Service (Agriculture)
Energy Information Administration (Energy)
National Agricultural Statistics Service (Agriculture)
National Center for Education Statistics (Education)
National Center for Health Statistics (CDC/HHS)
National Center for Science and Engineering Statistics NSF/Independent
Office of Research, Evaluation, and Statistics — SSA/Independent
Statistics of Income (IRS)

The remaining 62 percent of the FY 2016 budget involves more than 100 programs that conduct statistical activities in conjunction with another program mission. These statistical programs are components within a Federal department or other agency. They include a broad set of centers, institutes, and organizations in addition to the 13 principal statistical agencies.

There are also Federal agencies whose statistical activities are not part of the Executive Branch. These agencies include the Congressional Budget Office, which develops and applies projection models for the budgetary impact of current and proposed Federal programs; the Federal Reserve Board, which compiles the widely used Flow of Funds report and other statistical series and periodically conducts the Survey of Consumer Finances; and the U.S. Government Accountability Office, which uses statistical data in evaluations of government programs.

Guide to Navigating the Federal Statistical System
The following graphic is a snapshot of the Guide to Navigating the Federal Statistical System. See http://proximityone.com/fss.htm to access the entire guide.

– 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

User Group Notes Updated

.. new ProximityOne User Group notes were posted today, June 28, 2016.  See updates at http://proximityone.com/usergroup_notes.htm.

Join the no fee ProximityOne User Group … connect with like-minded folks interested in developing, integrating and using decision-making information. The User Group provides software, data access and application support privileges only available to members.

.. see more information. Join in.

Population by Age, Gender & Race/Origin 2010-2015

.. tools to examine characteristics and patterns of U.S. & state population by age, gender & race/origin, 2010-2015 annually .. access individual state and area profiles.

What are the 10 states with the largest Hispanic population? How is Hispanic population distributed by age in the U.S. or any particular state? In which states does the Hispanic population comprise more than half of the total population? And by age? Get answers to these types of questions using data access and analytical tools described in this section.

Using the Interactive Table
The following graphic illustrates use of the interactive table. Tools are used to select only 2015 and show only the total and Hispanic columns, then rank in descending order on Hispanic population. It is easy to see which states have the largest Hispanic population and in relation to the total population.

Tip of the Iceberg
It’s not just about Hispanic and total population; perform similar queries/analyses by gender and for each of the five major race groups. These data are based on the latest Census Bureau 2015 model-based population estimates released in June 2016. The data options are not limited to the 2015 data; annual revised data for 2010 through 2015 are included. Find out about the size and trends for specific age groups of interest.

More about the Interactive Table
Use the interactive table to perform other types of queries/analyses described above. Click a link in the table to view an extended profile for each area. The profiles are developed using the Regional Demographic-Economic Modeling System (RDEMS). When a profile is opened (new web page), analyze these population by age by gender by race/origin in context of related wide-ranging, multi-sourced data. Access the profiles for drill-down geography including counties and other areas.

Use the RDEMS current estimates (2016) and annual 5-year projections (to 2021) to examine this same scope of subject matter to the county level.

The interactive table includes a row for the U.S. and each state. Column structure and content are described below the table.
• Click the “link” (column 3) to view the RDEMS POP1 profile.
• See about more operations and usage notes below table.

Viewing Extended Profile for an Area
Clicking the link for Arizona, as illustrated above, shows the full “POP1” table/profile for Arizona. Clicking the link is equivalent to clicking this link: http://proximityone.com/rdems/1/rdems04000pop1.htm.
  • click the above link now to view the full profile.
  • California profile
  • Texas profile
  • Access any state using the interactive table

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.