Category Archives: Maps

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.

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.

Examining HMDA/CRA Census Tract Demographics

.. the ability to effectively analyze low, moderate, middle, and upper income population and households by small area geography is important to housing market stakeholders, lenders, investors, cities/neighborhoods and others. Low and moderate income data by block group and census tract are used for compliance, eligibility determination and program performance in many Federal programs and agencies. See the main Web page for more detail.

This section reviews the scope and use of the FFIEC 2019 HMDA/CRA census tract data (released September 2019). Use the interactive table to view, rank, compare selected items from these updated data for any/all tracts. Use GIS tools with these data to map and geospatially analyze these data as illustrated and further described as illustrated here. See more about banking, CRA and LMI tracts and more about these data.

Visual Analysis of Banks in Context Census Tract Demographics
Click graphic for larger view; expand browser window for best quality view.

– view developed using CV XE GIS and related GIS project.
– install this GIS tool and related GIS project on your computer to examines patterns, market share and more.

Low & Moderate Income Population by Census Tract
Low, moderate, middle, upper income classification by census tract is based on the median family income of a specific census tract relative to the metropolitan statistical area (MSA) or non-MSA area in which the tract is located. The FFIEC data include a “low and moderate income indicator”:
1 – Low — MFI is less than 50% of the MSA/parent area MFI
2 – Moderate — MFI is from 50% to 80% of the MSA/parent area MFI
3 – Middle — MFI is from 80% to 120% of the MSA/parent area MFI
4 – Upper — MFI is 120% or more of the MSA/parent area MFI
0 – NA — MFI is 0 or not available
where MFI is the Median Family Income

Low and moderate income designation is closely associated with implementation of the Home Mortgage Disclosure Act (HMDA) and the Community Reinvestment Act (CRA) and is a widely used in many other applications as a measure of economic prosperity.

Using the Interactive Table
Use the interactive table to examine individual tracts or sets of tracts as to their low and moderate income status and related demographics. The following view illustrates use of the table. Clicking buttons below table, this sequence of steps was used to obtain this view:
– click ShowAll
– click “Find CBSA; Low & Mod Tracts”
  >this selects tract in CBSA 26420 (Houston) that are low or mod
– click “Status Cols”
The table refreshes to show 470 tracts that are low/mod in this metro.
Finally, click the column header “Tract MFI %Region” to sort in descending order.

View your areas of interest. Start the steps over and use your CBSA code for a metro of interest.

Bankers Analytics Tools Web Sessions
Join me in a Bankers Analytic Tools Lab session (every Wednesday 3:00 pm ET) 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.
Topics:
• mapping and geospatially analyzing your data with FFIEC data
• tract demographic vintages and trends
• issues regarding MSA/MD vintage, change; about the 2018 vintage CBSAs
• defining and using assessment area geography
• examining the community & neighborhoods in context of assessment areas
• using the FDIC bank location/deposits data with FFIEC/ACS demographics
• using the FFIEC/ACS interactive table below
• alternative methods of accessing census tract ACS data

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.

The Local Area Monthly Employment Situation

.. in June 2019, the local area unemployment rate ranged from 1.3% (Lyon County, IA) to 19.6% (Yuma County, AZ) among the lower 48 states. 133 counties had an unemployment rate of 7% or more during June 2018 through June 2019. Over the past year, as shown in the this interactive table, the unemployment rate has generally decreased among all counties. We track the local area employment situation historically and develop alternative scenario projections. See the related Web page for more information.

Patterns of Unemployment Rate by County
The following graphic shows patterns of the estimated June 2019 unemployment rate by county. Use the GIS tools and data to develop variations of this view optionally integrated with other data. Click graphic for larger view. Expand browser window for best quality view.

— view created using the ProximityOne CV XE GIS and associated GIS Project

Examine Areas of Interest
This graphic illustrates the monthly over the year employment situation for the Houston, TX metro using the interactive table.

Click graphic for larger view.

Create a similar table for any metro:
Open the interactive table (green and white table midway down).
Click ShowAll button below table.
Key in a 5-character metro code in edit box at right of FindCBSACode.
    … get from scroll list at upper right of table.
    … e.g., 19100 for Dallas, TX metro.
Click FindCBSACode; table refreshes showing only counties in this metro.
Click Current Situation button below table; table refreshes with selected columns.
Click the Pop2018 column header cell twice to rank-order the columns.
Done .. try these steps for an area 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.

Census Tract Demographic-Economic Characteristics & Trends

..  Census tract demographics are used in wide-ranging public and private sector applications to examine patterns and characteristics of sub-county areas. Tract level data from Census 2000Census 2010 and the American Community Survey (ACS) can be used to analyze trade/market areas, neighborhoods and other small area study areas. But what about more current data and trends since 2010? What about business establishment data and other subject matter not included in either the census or ACS data?

There are no current demographic-economic census tract data available from the Census Bureau or other Federal statistical programs. Annually released ACS 5-year estimates are available by census tract but are for 5-year periods and dated. The most recent census tract level ACS data are based on the ACS 2017 5-year estimates (ACS 1317). Those data are not for the year 2017 but estimates for ACS survey respondents for the 5 year period 2013-2017; centric to mid-2015.

Patterns of Median Household Income %Change by Census Tract
The graphic below shows patterns of economic prosperity change based on median household income percent change ACS 2012 to ACS 2017 by tract in the Dallas metro area.

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

Using the Interactive Table
Use the interactive table .. click this link .. to view, query, rank, compare selected characteristics of the population, housing, educational attainment and income for census tracts based on ACS 2012 5-year, and ACS 2017 5-year data. Hundreds of additional items are available. See about related census tract data resources and applications.

Try it yourself ..
Tracts with ACS 2017 population 3,500-4,500 ranked on change in $MHI:
Replicate the following graphic using the interactive table. This view was produced by clicking the Pop17 button below the table to select only tracts with a ACS 2017 population between 3,500 and 4,500. Then the $MHI columns button was clicked to view only selected columns. Finally the qualifying tracts were sorted in descending order by clicking the $MHI Change column header cell.

Based on these estimates, tract 04013105004 in Maricopa County, AZ is top ranked, where the $MHI increased by $97,723 from the ACS 2012 5-year period to the ACS 2017 5-year period.

Corresponding API calls to access the $MHI for this tract (click links to access data):
ACS 2012 $MHIACS 2017 $MHI
Join us in an upcoming Data Analytics Web Session (see below) to learn more about using APIs to access these data and similar data.

Access more detailed ACS 2017 tract interactive tables:
  General demographics .. Social .. Economic .. Housing

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

State of the States: 2019

.. the State of the States reports and information service provide insights into demographic, economic & business characteristics.  Unique in their composition,  updated daily/weekly, the reports summarize what’s changing where & when and assessing what’s ahead. It organizes disparate Federal statistical data and presents those data in an organized, consumable manner. A resource to help determine how change might affect you, it is an indispensable resource for investors, leaders, policymakers, researchers and decision-makers. See State of the States main section for more information.  Your briefing notes, organized by state.

Some details .. the U.S. economy is slowing, dragged down by trade tensions and weak growth overseas. But there are few signs that the decade-long expansion is on the verge of stalling out. Real Gross Domestic Product (RGDP), the broadest measure of goods and services produced in the economy, rose at a 2.1 percent annual rate in 2019Q2, down from 3.1 percent in 2019Q1, according to preliminary data released by the Bureau of Economic Analysis on 7/26/19.

But what about the states, and what about related measures? In Texas, the 2019Q1 change from 2018Q4 was 5.1 percent annual rate. Texas ranked 2nd among all states. The 2019Q2 state GDP will be posted in section 6.5 on Nov. 7, 2019 (see in scheduled updates). How does Texas compare to other states and the U.S.  Answers are organized in the reports.  Create insights. Share with others.

Part of a multi-dimensional information resource, the state of the states report has been derived from the Situation & Outlook (S&O) database, updated daily. ProximityOne uses the historical S&O database to develop current demographic-economic estimate and projections.

View the U.S. or a State Report .. click a link
.. illustrative reports .. see more about report structure & options in report.
United States
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
District of Columbia
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin

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

Mapping Census Tracts & Opportunity Zones

.. using the U.S. by census tract shapefile in the CV XE GIS US1 GIS project .. a no fee resource to ProximityOne User Group members (a no cost program, join here) .. view, locate, examine, map, geospatially analyze census tract geodemographics — in context of other geography and subject matter.

Census Tracts in Las Vegas Area

– create this type of map for any area in the U.S.
– use the CV XE GIS software with the default US1 GIS project.
– no cost to ProximityOne User Group members.

Click graphic above for larger view showing zoom-in. Tracts in larger view are labeled with tract code and ACS 2017 total population. See related ACS 2017 census tract interactive table with extended demographics.

The U.S. census tract shapefile has been added to the ProximityOne “US1” GIS project (included with installation). We have made it easy and free to visually locate census tracts of interest and view the boundaries in context of counties and general topology. Install CV XE GIS or run update if already installed. Examining tracts related to the Opportunity Zones? Each tract includes an identifier enabling you to select or find only those tracts.

See step-by step details on using these resources.

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.