Category Archives: TIGER/Line

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.

Neighborhood Median Family Income: Measuring Economic Well-Being

.. Median Family Income ($MFI) and Median Household Income ($MHI) are two measures of economic well-being. Based on the 2018 American Community Survey 1-year (ACS) data, the U.S. 2018 $MFI was estimated to be $76,401 while the $MHI was estimated to be $61,937 .. both in 2018/current dollars. Create insights into patterns of well-being by neighborhood using geospatial analysis. $MFI patterns are illustrated by the following thematic pattern map.

Patterns of Economic Prosperity by Neighborhood/Census Tract
The following view shows patterns of $MFI by census tract for the inner beltway area of Houston/Harris County, TX. Income interval color patterns are shown in the inset legend. Tracts are labeled with $MFI. Click graphic for larger view. Expand browser window for best quality view. Larger view shows tracts labeled with tract code. It is easy to see how west Houston and east Houston areas differ.

– view developed with ProximityOne CV XE GIS software and related GIS project.
– these $MFI data are based on the 2018 ACS 5-year estimates.

This section focuses on $MFI but could just as well focus on $MHI and yet other related income measures. $MFI will almost always be greater that $MHI, generally by a large margin. See the U.S. 2018 $MFI and $MHI in context of related demographic-economic measure here. See more about the distinctions/definitions of families and and households below.

The ACS data are a unique source of income and related data at the neighborhood or sub-county level. View more about accessing and using the 2018 ACS 5-year estimates.

Family Definition
A family is a group of two people or more (one of whom is the householder) related by birth, marriage, or adoption and residing together; all such people (including related subfamily members) are considered as members of one family. The number of families is equal to the number of family households. However, the count of family members differs from the count of family household members because family household members include any non-relatives living in the household.

Related … an unmarried partner, also known as a domestic partner, is specifically defined as a person who shares a close personal relationship with the reference person. … Same-sex unmarried-partner families or households – reference person and unmarried partner are both male or female.

Household Definition
A household consists of all the people who occupy a housing unit. A house, an apartment or other group of rooms, or a single room, is regarded as a housing unit when it is occupied or intended for occupancy as separate living quarters; that is, when the occupants do not live with any other persons in the structure and there is direct access from the outside or through a common hall.

A household includes the related family members and all the unrelated people, if any, such as lodgers, foster children, wards, or employees who share the housing unit. A person living alone in a housing unit, or a group of unrelated people sharing a housing unit such as partners or roomers, is also counted as a household. The count of households excludes group quarters. There are two major categories of households, “family” and “nonfamily”.

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.

Examining How Metro GDP is Changing

.. which metros had the largest 2018 real GDP? How did they change since 2010? How to they compare on a per capita basis? What about metros of interest to you? Read on …

As an investor, business or stakeholder in a metro, it is important to know how and where the economy is changing … and how one or selected metros relate to the U.S. and other metros. Is metro X changing in a different direction than metro Y? By how much, why and is there a pattern? What does the healthcare sector, for example, contribute to a metro’s gross domestic product (GDP)? How does it compare to peer metros? How is the healthcare industry trending? Metro GDP data can provide insights and answers to these important questions.  See related main Web page.

In 2018, per capita real gross domestic product (GDP) in MSAs ranged from $19,299 (The Villages, FL MSA) to $196,277 (Midland, TX MSA). The percent change in per capita real GDP by metro, 2010 to 2018 ranged from -24% (New Orleans-Metairie, LA MSA) to 126.6% (Midland, TX MSA). Use the interactive table to view these and related data.

Change in Per Capita Real GDP by Metro; 2010-2018
The following graphic shows patterns of change in per capita real GDP by metro (MSA) from 2010 to 2018. Label shows 2018 rank of the metro among all 384 MSAs based on 2018 per capita real GDP. Click graphic for larger view. Expand browser to full window for best quality view.

— view created using ProximityOne CV XE GIS and associated GIS project

Top 25 Metros (MSAs) based on 2018 per capita real GDP
The following graphic shows the top 25 metros (MSAs) based on 2018 per capita real GDP labeled with rank. Click graphic for larger view. Expand browser to full window for best quality view.

— view created using ProximityOne CV XE GIS and associated GIS project
 
Using the Interactive Table – 10 largest metros based on 2018 real GDP
— insights into comparative analytics and trends.
— view, rank, compare districts based on your criteria.
— example, which metros have the largest 2018 real GDP?
Use the interactive table to examine GDP characteristics and trends of metros. The following view illustrates use of the table. This view shows use a query to show the ten metros ranked on 2018 real GDP. Click graphic for larger view.

Try using the interactive table to examine metros of interest.

Demographic-Economic 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.

116th Congressional Districts & Patterns of Economic Prosperity

.. Congressional District Analysis and Insights .. tools to examine patterns of median household income .. median household income is one measure of economic prosperity. This section reviews patterns of median household income (MHI) by 116th Congressional Districts based on the 2018 American Community Survey 1-year estimates (ACS 2018). View, rank, compare the MHI by congressional district, among related demographic attributes using the interactive table on the main Congressional Districts page.

116th Congressional District Analysis & Insights
.. patterns of household income & economic prosperity:
Based on the ACS 2018 median household income (MHI):
• the MHI among all districts was $60,291
• the U.S. overall MHI was $61,937
As of November 2019:
• the 19 districts with highest MHI have Democrat incumbents
• the 10 districts with the highest Gini Index have Democrat incumbents
• there are 69 Republican incumbent districts above the all districts MHI
• there are 149 Democrat incumbent districts above the all districts MHI
• the MHI of the 236 Democrat incumbent districts is $66,829
• the MHI of the 199 Republican incumbent districts is $56,505
Median household income is only one measure of economic prosperity.
See more at http://proximityone.com/cd.htm.

Patterns of Economic Prosperity 116th Congressional District
The following graphic shows patterns of 2018 median household income by 116th Congressional District. Use GIS tools/data to generate similar views for any state and/or drill-down. Click graphic for larger view with more detail. Expand browser window for best quality view.

– view developed using ProximityOne CV XE GIS and related GIS project.

Using the Interactive Table
— view, rank, compare districts based on your criteria.
— example,which districts have the highest median household income?
Use the interactive table to examine incumbency and and demographic characteristics of the 116th Congressional Districts (CDs). The following view illustrates use of the table. This view shows use a query to show the ten CDs having highest 2018 median household income.

Try using the interactive table to existing districts and categories of interest.

Congressional District/State Legislative District Group
Join in .. be a part of the Congressional Districts/State Legislative District (CDSLD) group. Access analytical tools and data. Learn about CDSLD analytics, patterns and trends. Share insights with like-minded stakeholders.

Demographic-Economic 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.

Personal Consumption Expenditures by Type & State

.. using Personal Consumption Expenditures (PCE) measures to monitor/examine the strength of a regional economy and consumer buying trends in that region and compare among regions … PCE estimates released in October 2019, show that state personal consumption expenditures increased 5.1 percent in 2018, an acceleration from the 4.4 percent increase in 2017. The percent change in PCE across all states ranged from 7.3 percent in Utah to 3.6 percent in West Virginia.

In 2018, across all states and D.C., per capita PCE was $42,757. Per capita PCE by state ranged from a high of $55,095 (MA) to a low of $31,083 (MS). Per capita PCE in D.C. $63,151. Use the interactive table to example per capita and total PCE by state for 24 categories annually 2010 to 2018.

Per Capita Personal Consumption Expenditures by Category; U.S. 2018
— how does your situation and areas of interest compare to U.S. overall?
— view, sort, query by state and year in the interactive table

Goods and services purchased by people are personal consumption expenditures (PCE). These data provide insights into the strength of a state economy and consumer buying trends. As a major component of GDP, PCE growth has recently accounted for much of the GDP growth. The data reviewed in this section are developed by the Bureau of Economic Analysis (BEA, released each October). ProximityOne develops regional PCE estimates by metro and county. More about PCE.

See related sections:
• State Real Median Household Income
• State Annual Gross Domestic Product by Industry

Per Capita Consumption Expenditures by State, 2018
The following graphic shows patterns of 2018 per capita personal income expenditures (PCE). Intervals show distribution in quintiles, equal number of states per interval. The 2018 U.S. per capita PCE was $42,757. Use CV XE GIS project to examine PCE by types, per cpaita vs total, different years and change. Integrate additional subject matter and types of geography. Click graphic for larger view with details. Expand browser window for bets quality view.

– view developed with ProximityOne CV XE GIS and related GIS project & datasets.

Using the Interactive Table
— which areas have the highest health care expenditures?
Use the interactive table to examine personal consumption expenditures by type and state annually for the period 2010-2018. The following view illustrates use of the table. This view shows use a query to examine only health care expenditures. The table was then sorted in descending order to show the areas with the highest per capita health care expenditures in 2018.

Try using the interactive table to existing states or categories of interest.

Demographic-Economic 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.

U.S. & State Real Median Household Income Trends

.. during the past two years, 2017 and 2018, the real median household income increased by $1,627. Some states experienced a decline in real median household income in the past two years. During the previous two years, 2015 and 2016, the real median household income increased by $3,329. See details in interactive table (opens new page).

Real median household income in the U.S. increased 0.8 percent between the 2017 ACS and 2018 ACS based on the American Community Survey (ACS 2018). The U.S. MHI, based on ACS 2018 (released September 2019), was $61,937. The national MHI has been increasing since 2013. The increase from 2017 is smaller than the prior 3 years, during which MHI increased between 1.8 percent and 3.3 percent annually. This was the second consecutive year that U.S. MHI was higher than 2007.

Household income as used here is the combined gross income of all members of a household, defined as a group of people living together, who are 15 years or older. The median household income is used to examine the economic health of an area or to compare living conditions between geographic regions.

Use the interactive table and related Geographic Information System (GIS) resources to examine income trends and geographic patterns. See details on using GIS project.

Patterns of Real Median Household Income Change; 2016-2018
— change during two calendar years labeled with 2018 real MHI
— click link for larger view; expand browser window for best quality view.

– view developed using ProximityOne CV XE GIS and related GIS project.
– geospatial analyze income characteristics integrated with your data to examine patterns; gain insights.

Median Household Income in the United States: 2005–2018

U.S. & State Median Household Income: Annually 2005–2018 — Interactive Table
The following static graphic illustrates use of the U.S. & State MHI interactive table. This view shows the 10 states/areas ranked on the 2018 real median household income. See pointer, note that D.C. had the highest real 2018 MHI.  

Try it yourself. Use the table to examine different patterns … like which states experienced a decline in a selected year or over a selected period.

Alternative Measures of MHI
There are other ways to measure/estimate MHI. Possibly the most notable alternative is the Census/BLS Current Population Survey (CPS). This topic will be covered in an upcoming blog .. and how ACS and CPS MHI estimates differ. While the CPS can be used to develop state and higher level geography estimates, ACS might be preferred as MHI estimates can also be developed for counties, cities, census tracts and block groups .. and many other political/statistical areas not possible using CPS.

Demographic-Economic 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.

Combined Statistical Area Demographic Trends

.. a Combined Statistical Area (CSA) is a group of two or more adjacent metropolitan areas; they include contiguous metro counties that have demographic-economic affinity. These 172 areas (September 2018 vintage) are important in wide-ranging geographic and demographic analysis. Based on the 2018 population estimate, these areas include 256.2 million population of the total U.S. population of 327.2 million (78.3 percent). CSAs are at least two adjacent metropolitan areas — reflecting a larger and broader market/service/impact assessment area. Due to their size (of many), it is often possible to develop more detailed custom demographic-economic estimates and projections than at the county or metropolitan area level. See more about CSAs in this related Web section.

Patterns of 2018 Population by 2018 CSA
The following graphic shows the September 2018 vintage CSAs based on the 2018 official population estimates. The intervals/colors are depicted in legend panel at left of map window. Create custom maps similar to this view for your regions of interest. Use the GIS project/datasets to examine alternative patterns such as percent change for different time periods. Set queries to include CSAs by peer group. Click graphic for larger view with more detail; expand browser window for best quality view. Larger view shows CSAs labeled with percent population chnage 2010-2018.

– view developed with CV XE GIS software and related GIS project.

Use the GISproject and datasets to examine CSAs in a mapping and geospatial analysis context. The database includes all CSAs and the subject matter described below.

Using the Interactive Table
Use the interactive table (opens new page) to examine patterns and relationships among CSAs of interest. The following static graphic illustrates how the table can be used to rank or query CSAs and display selected columns. Selecting population change columns and ranking in descending order on population change 2010-2018, shows that the Dallas CSA had the largest population … it also shows this CSA was the 7th largest CSA based on 2018 population and 9th on percent population change 2010-2018 … use the table to determine which CSA ranked first on percent population change 2010-2018.

– click graphic for larger view.

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.