Measuring & Analyzing Households by Social Class by PUMA

.. a social class is a population or household group typically referred to as a lower, middle and upper class. The size of the population or households in a social class is often determined in relationship to an interval related to the median household income of an area — from two-thirds of median household income to twice the median household income (MHI). Subsequent blog posts will address a broader definition for class determination. By better understanding composition and determinants of social class for an area, we might better understand and improve on income inequality and create new opportunities. This is a multi-part blog post on social class analytics. Click Follow at right to receive updates.

Percent Population in Households by Social Class by PUMA
.. Los Angeles area .. click for larger view.

Los Angeles metro area by social class .. PUMAs shown with black boundaries; pointer at Los Angeles-Orange County line

Percent of Households by Social Class by PUMA
.. Los Angeles area .. click for larger view.

Los Angeles metro area by social class .. PUMAs shown with black boundaries; pointer at Los Angeles-Orange County line

Using American Community Survey Microdata
We use of the American Community Survey microdata or “public use microdata samples” (PUMS) http://proximityone.com/pums.htm to develop estimates of population and households by middle class, lower class and upper class by “public use microdata area” (PUMA) http://proximityone.com/puma.htm. Microdata files are comprised of anonymized individual respondent data within PUMAs. The approximate 2,800 PUMAs cover the U.S. wall-to-wall and must have 100,000 population or more. 2010 and 2020 vintages PUMAs may be examined and compared with other geography using the VDA Web GIS http://proximityone.com/vda.htm with the MetroDynamics Project.

Social Class Participation by PUMA
Using custom software, the PUMA (ACS 2021 1 year data in this case), individual housing records are summarized for each PUMA. An estimate is developed for the lower, middle and upper class based on an algorithm.

Examine patterns of social class stratification using VDA Web GIS anywhere in U.S.
The estimates are then integrated into a PUMA shapefile. The PUMA shapefile is added to a Geographic Information System (GIS). Access this shapefile/layers using VDA Web GIS to examine patterns of social class, such as the graphics shown above, or in combination with other geography and subject matter.

About VDA GIS
VDA Web GIS is a decision-making information resource designed to help stakeholders create and apply insight. Use VDA Web GIS with only a Web browser; nothing to install; GIS experience not required. VDA Web GIS has been developed and is maintained by Warren Glimpse, ProximityOne (Alexandria, VA) and Takashi Hamilton, Tsukasa Consulting (Osaka, Japan).

Data Analytics Web Sessions
Join us in the every Tuesday, Thursday Data Analytics Web Sessions. See how you can use VDA Web GIS and access different subject matter for related geography. Get your geographic, demographic, data access & use questions answered. Discuss applications with others.

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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. Join Warren on LinkedIn.

118th Congressional District Demographic Characteristics

.. what are the geographic, demographic, economic characteristics of a congressional district of interest? What are peer group congressional districts based on these characteristics? How might coalitions on selected topics better evolve? How can you communicate more effectively on policy issues to your congressional district leadership? How can you vote in a more informed manner by better understanding these matters? Use the VDA Web GIS Congressional Districts project to get these answers using only a Web browser. Learn more about Geographic Information Systems (GIS). This is a multi-part blog post on congressional district analytics. Click Follow at right to receive updates.

The November 2022 elections determined the representatives for the 118th Congressional Districts (CDs). The 118th Congress is in session from January 2023 to December 2024. The 118th Congressional District boundaries reflect the redistricting process based on Census 2020 results. While CDs have about the same population size within a state, the demographic composition varies widely. Use the VDA Web GIS Congressional Districts project to examine CD demographic-economic characteristics. Selected highlights are reviewed below.

These illustrative thematic pattern maps are based on data from the American Community Survey 2021 1-year estimates. Create your own maps and perform geospatial analyses using the VDA Web GIS with the Congressional Districts project. Nothing to install. Access using a Web browser. Start here. Sign up and login. Select the Congressional Districts project.

General Demographics — Percent Majority-Minority
Examine general demographics characteristics like topics on age and race/origin.

Social Characteristics — Educational Attainment
Examine social characteristics like household composition, mobility, enrollment, educational attainment.

Economic Characteristics — Economic Prosperity
Examine economic characteristics like labor force attributes, employment by occupation industry, income and benefits.

Housing Characteristics — Housing Value
Examine housing characteristics like owner/renter, units in structure, year structure built, housing value, rent, housing cost burden.

What’s Ahead — Upcoming Congressional District Blog Posts
This section has introduced tools to examine congressional districts at the national/regional level. The same tools and Congressional District project can be used to drill-down to the neighborhood level. Examine how characteristics within a congressional district vary within the district .. to be covered in subsequent posts. Learn more about examining these data in a tabular manner and geospatial analysis.

Upcoming topics .. drill-down analytics like this illustrative view
.. Atlanta, GA area .. CDs bold boundary labeled with CD code.
.. patterns of economic prosperity (median household income) by census tract
.. pointer & Atlanta city in GA05
.. easy to see how GA05 and GA06 radically different

About VDA GIS
VDA Web GIS is a decision-making information resource designed to help stakeholders create and apply insight. Use VDA Web GIS with only a Web browser; nothing to install; GIS experience not required. VDA Web GIS has been developed and is maintained by Warren Glimpse, ProximityOne (Alexandria, VA) and Takashi Hamilton, Tsukasa Consulting (Osaka, Japan).

Data Analytics Web Sessions
Join us in the every Tuesday, Thursday Data Analytics Web Sessions. See how you can use VDA Web GIS and access different subject matter for related geography. Get your geographic, demographic, data access & use questions answered. Discuss applications with others.

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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. Join Warren on LinkedIn.

Examining City GeoDemographic Drilldown; Intersecting Tracts and Places

.. how can “our city” do a better job of providing housing for low-income individuals and families? One part of a successful program involves looking at attributes of the neighborhood, or census tract, geography across the city. We need to analyze needs by city component census tracts, areas averaging 4,000 population. Here is how that might be approached — determining which census tracts. And while this applies to low income housing, it applies to many other planning topics.

Relate census tract geography to city/place geography using GIS tools for analytical purposes … determine which tracts intersect a city/place. This section considers intersecting tracts and places for illustrative purposes. But the methodology, and tools to do this, involve many, many other types of geography .. geographic spatial intersection. The inputs in this case are U.S. national scope 2020 census tracts (85,190 areas covering the U.S. wall-to-wall) and U.S. national scope 2020 places (32,188 areas). The output from the process of intersecting these geographies are tract-place intersecting parts (119,906 areas). There are 32,146 tracts that are wholly contained in places.

Developing Intersect Files
Tracts intersecting with cities can be determined using the VDAGIS Intersect tool. Select the two input shapefiles and name the intersect output shapefile. The intersect shapefile is added to the GIS project being used.

Focusing on a City
What tracts intersect a city of interest? By having this information, stakeholders, policymakers can study and better understand inequities, differences and needs across the city. Consider Santa Ana, CA (Orange County). There are 65 tracts that intersect with the city of Santa Ana. This could be any city across America. The following view shows Santa Ana with intersecting tracts.

By viewing the intersecting file in VDAGIS, intersecting tracts can be examined. The graphic below shows a zoom-in to tract 06059089102 (blue boundary). This tract is shown at the pointer in the above graphic. in the following zoom-in view, the white label shows the tract code for the whole tract and the two split parts are shown with the same code. The part to the right in Santa Ana city, the part to the left is in Garden Grove city.

Using the intersecting file, the list (a partial list) of these tracts and tract codes can be determined as shown below. By knowing the tract codes, detailed demographic-economic data can be pulled using DEDE and tract characteristics can be studied. Inequities ab be examined, special needs can be determined, east versus west tract groups might identify patterns to facilitate collaboration and policy development. What are the patterns of affordable housing across the city?

About VDAGIS
VDA Web GIS is a decision-making information resource designed to help stakeholders create and apply insight. Use VDA Web GIS with only a Web browser; nothing to install; GIS experience not required. VDA Web GIS has been developed and is maintained by Warren Glimpse, ProximityOne (Alexandria, VA) and Takashi Hamilton, Tsukasa Consulting (Osaka, Japan).

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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. Join Warren on LinkedIn.

Examining Ukraine and Region using VDA

Ukraine is a country that is now on many people’s minds. It is easy to examine the geography of Ukraine in context of the region using VDA Web GIS.

The Visual Data Analytics (VDA) Web GIS supports worldwide applications. Explore characteristics of Ukraine and the surrounding area with only a browser. There is no cost. Follow the steps described below to get started.

• Start VDA Web GIS using a browser .. link to start VDA Web GIS.
– you will need to sign-up, then you can easily revisit.
• Open the Situation & Outlook Project.
– next you will see a form asking you to select a project.
– select the Situation & Outlook project.
– the opening view is the U.S. by county.
– note that for the VDA Level 1 free version, the session closes in 10 minutes.
– just start over … you are now more familiar with operations.
– if you are new to VDA, please review getting started.
• Check on “OpenStreetMaps” in Legend Panel; left of Map Window toward bottom:

• Navigate to Kyiv, Ukraine
– Key in the name Kyiv in Find Address edit box and click Find Address button
– the view refreshes; a marker (for Kyiv location) shows in the Map Window:

• In the legend panel, click on the “Country Projections to 2050” layer
• Zoom-out to Ukraine country view
– click zoom-out button below map window 6 times (or use zoom window).
– navigate in the map window to obtain this view of the region:

• To get the above view, with Ukraine the selected country, proceed as follows:
– select “Country Projections to 2050” in the “Select Layer” dropdown (upper left)
– click anywhere in map window on Ukraine
– the crosshatching appears; a profile of Ukraine appears in lower left Profile Panel.
– click the HTML button (lower left) to view this profile in HTML format.
– browser must be enabled to show popups.
– in the HTML profile, see that the 2022 Ukraine population is 43.5 million.
• Examining Ukraine provinces — Luhansk Oblast (eastern Ukraine):
– select “Country by State” in the “Select Layer” dropdown (upper left)
– navigate to eastern Ukraine
– click anywhere on Luhansk Oblast map and the following view appears:

– the crosshatching appears showing this Oblast.
– a profile of Luhansk Oblast appears in lower left Profile Panel.
– click the HTML button (lower left) to view this profile in HTML format.
– in the HTML profile, see the Oblast VDA computed area is 26,310,276,552 sqmt
… or 10,158 square miles (26310276552/2589988).

About VDA Web GIS
VDA Web GIS is a decision-making information resource designed to help stakeholders create and apply insight. VDA Web GIS has been developed and is maintained by Warren Glimpse, ProximityOne (Alexandria, VA) and Takashi Hamilton, Tsukasa Consulting (Osaka, Japan).

About the Author
Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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. Join Warren on LinkedIn.

U.S. Demographic-Economic Insights

The results of the Census 2020 will not provide us with a good picture of the United States demographic-economic situation, mainly as a result of limited scope subject matter. While the Census 2020 data are important due to their more accurate and up-to-date small area demographics, and data tabulated by census block, only a small number of demographic subject matter items are available from Census 2020. The scope of subject matter is limited by items tabulated based on the questionnaire.

In comparison, the annual American Community Survey (ACS) data provide a much broader range of subject matter. Based largely on the 2019 ACS (the most up-to-date with data for small area geography .. released in December 2020), ProximityOne has developed tools/data to develop demographic-economic insights for the most widely used types of geography.

Demographic-Economic Insights Role & Scope
ACS and related data and ProximityOne tools have been used to develop the U.S. demographic-economic insights report, reviewed here, illustrating the scope and organization of the data and how it can be used. You can develop similar comparative analysis reports for your areas of interest. See more about the role and scope of the Demographic-Economic Insights.

U.S. National Scope Demographic-Economic Insights
View the U.S. National Scope Demographic-Economic Insights report develop using the ProximityOne Insights tool. This report is organized into two subject matter description columns, four statistical data columns and four subject matter groups. The first two statistical data columns present data based on the ACS 2019 1-year estimates. The second set of statistical data columns show data based on the 2019 ACS 5-year estimates (values centric to mid 2017). This report is a useful resource to compare/contrast data values based on the 1-year estimates side-by-side with the 5-year values. The four subject matter groups are reviewed below.

General Demographics
Graphic shows partial list of “D” items .. click graphic for larger view.
.. view this section in the U.S. Insights report.

Social Characteristics
Graphic shows partial list of “S” items .. click graphic for larger view.
.. view this section in the U.S. Insights report.

Economic Characteristics
Graphic shows partial list of “E” items .. click graphic for larger view.
.. view this section in the U.S. Insights report.

Housing Characteristics
Graphic shows partial list of “H” items .. click graphic for larger view.
.. view this section in the U.S. Insights report.

Creating Insights and Talking Points
The four subject matter groups provide a dense array of tabular statistical data that can be overwhelming to consume. Yet, not every topic can be distilled to just a few numbers. The scope of key data depends on the objective presentation, audience and desired talking points.

For example, a briefing or synopsis might include only 10-15 subject matter items such as … this report tells us that in 2019 (based on 2019 1-year estimates), the total resident population was estimated to be 328,239,523. The median age was 38.5 years. The percent high school graduates was 88.6%. The number of housing units was 139,686,209. The percent owner occupied housing units was 64.1%. These measures are roughly the same today, at the end of 2020, even with the pandemic impact. Some other measures in the report as not as reflective “as of today”.

While data shown here do not fully summarize the state of the Nation, there provide many insights. The same can said for any of the geographic areas covered. To obtain a better picture of the state of the Nation, we need supplementary subject matter, more up-to-date data and trending data that give clues into what’s happening.

Learn more — Join me in the Situation & Outlook Web Sessions
Join me in a Situation & Outlook Web Session where we discuss topics relating to measuring and interpreting the where, what, when, how and how much demographic-economic change is occurring and it’s impact.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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.

America’s Cities: Situation & Outlook

.. the path forward .. planning for the future .. in April 2019, the employment in Houston, TX was 1,111,283 with an unemployment rate of 3.2%. In April 2020, the employment in Houston, TX was 927,105 with an unemployment rate of 14.9%. What will the 2020 annual look like? 2021? There are many paths to get to 2021 and beyond. What policy and action measures might work best? What about your cities of interest? See the related Web section for more details.

Houston characteristics: Demographic .. Social .. Economic .. Housing
Get for any city/area .. e-mail your request

The pandemic impacts on America’s cities in different ways .. some experiencing little change, others with massive change. When, where and how will these disparate patterns change in cities and communities of interest? How might this change impact you and your community? A comprehensive plan needs to be developed and set in motion to achieve best outcomes. This section provides access to tools and data that stakeholders can use to examine America’s cities demographic-economic characteristics and trends. Examine cities of interest. Use ProximityOne data, tools, methods and advisory services to achieve improved results.

Of the nation’s 327.2 million people, an estimated 206.0 million (62.9%) live within an incorporated place. Of approximately 19,500 incorporated places, about 76 percent had fewer than 5,000 people and nearly 50 percent had fewer than 1,000 people. Examine characteristics of individual city population trends and compare cities in states, regions and peer groups using the interactive table below.

Patterns of Economic Prosperity; Cities 50,000 Population or More
The following view shows cities with 2019 population of 50,000 or more as markers .. mainly principal cities of metropolitan statistical areas (MSAs). Nationally, there are 69 cities with 2019 population of 5,000 or more (determine using interactive table below). The marker color shows the median household income; see inset legend. Click graphic for larger view; expand window to full screen.

– View developed using the ProximityOne CV XE GIS software.

Patterns of Economic Prosperity; Cities 5,000 Population or More
– zoom-in to Dallas Metro
The following view shows cities with 2019 population of 5,000 or more as polygons/city boundary-area in the Dallas metro area. There are 201 cities that intersect with the Dallas metro (code 19100); 96 of these cities have a population greater than 5,000 (determine using interactive table below). The color patterns show the median household income range; see inset legend. Click graphic for larger view; expand window to full screen.

Patterns of Economic Prosperity by Neighborhood & Adjacent Areas
The following view shows patterns of median household income by block group (sub-neighborhoods) within city (bold black boundary) in the Dallas County, TX area. In examining the situation & outlook for a city it is important to examine characteristics of drill-down geography and adjacent cities/areas. Inset legend shows median household income color intervals. Click graphic for larger view; expand window to full screen. In the larger view, a cross-hatch pattern is applied to Dallas city. It is easier to see how Dallas city is comprised of a core area as well as outlying areas and extends into adjacent counties.

Interactive Analysis of Cities: Demographic-Economic Patterns & Trends
Use the interactive table to view, rank, compare cities based on demographic-economic trends and characteristics. The following static graphics provide two examples.

 

Largest 15 U.S. Cities Ranked on 2019 Population

California Cities Ranked on Educational Attainment

Learn more — Join me in the Situation & Outlook Web Sessions
Join me in a Situation & Outlook Web Session where we discuss topics relating to measuring and interpreting the where, what, when, how and how much demographic-economic change is occurring and it’s impact.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for national scope statistical programs and 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.

Financing America’s Schools

.. as we look to restarting America’s economy, the nation’s public school systems face many questions and logistical issues.  Among these issues are a wide range of financial challenges.  Financing America’s public K-12 schools is supported by a mix of Federal, state and local funding.  In FY 2017, 13,311 regular public school districts reported total revenues of $679,925 billion derived from $51,212 billion federal (7.5%), $317,434 billion state (46.7%) and $311,278 billion local (45.8%) sources. These data are based on the school district finances (F-33) program data released by the Census Bureau in May 2019. States and individual school districts vary widely on the make-up/distribution of these federal, state and local sources.  See more about this topic and related K-12 schools topics in the ProximityOne K-12 schools main Web section.

Use tools and data reviewed here to examine K-12 school district finances — sources and uses of funds for FY 2017. View, sort, query, compare school district sources and uses of funds using the interactive table below in this section. Create/view profiles for district(s) of interest.

Data and resources reviewed here update in early May 2020 with new FY 2018 sources and uses of funds data and related school/school district financial data. We examine the implications of COVID-19 for school systems as we look to Restarting the Economy. Join the User Group to receive updates.

Percent Federal Revenue by School District, FY 2017
The following graphic shows patterns of percent Federal revenue by school district (unified and secondary), FY 2017. Click graphic for larger view. Expand browser to full window for best quality view.

– view developed using ProximityOne CV XE GIS software and related GIS project.
– use these tools on your computer to examine these data & related data.

Percent State Revenue by School District, FY 2017
The following graphic shows patterns of percent State revenue by school district (unified and secondary), FY 2017. Click graphic for larger view. Expand browser to full window for best quality view.

– view developed using ProximityOne CV XE GIS software and related GIS project.
– use these tools on your computer to examine these data & related data.

Interactive Table
The following static graphic shows the 10 Texas school districts having the largest Federal revenue. Sources of Federal revenue by program are also shown. Create views like this for any of the sources and uses of funds items for your selection of school districts. Use the interactive table (separate page) for dynamic analysis of individual school districts in context of U.S. overall, states or metros. Select by state or metro and rank based on any of several selected revenue by source and per student expenditure by category.

– click graphic for larger view

Situation & Outlook Web Sessions
Join me in a Situation & Outlook Web Session where we discuss topics relating to measuring and interpreting the where, what, when, how and how much demographic-economic change is occurring and it’s impact.

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.

American Community Survey 2018: Geography & Access

.. there are 519 core-Based Statistical Areas (metros & micros) included as American Community Survey (ACS) 2018 tabulation areas. 2018 demographic-economic estimates are included for these and many other types of political/statistical areas — the subject of this section. This is the first in a series of posts about accessing, integrating and using the ACS 2018 data. Learn more about effective ways to use these and related data. See the main web section for more detail and access to the interactive table. The release date for the ACS 2018 data is September 26, 2019.

ACS 2018 1-year Tabulation Areas: 519 Core-Based Statistical Areas
— MSAs and MISAs

– view developed using ProximityOne CV XE GIS and related GIS project.
– geospatial analyze ACS 2018 1 year estimates integrated with your data to examine patterns; gain insights.

The 2018 American Community Survey (ACS 2018 main) 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.

Determining What Data are Tabulated
The graphics below illustrate 1) the scroll section that lists the types of tabulation areas (summary levels) and 2) use of the interactive table to display a selection of CBSAs/metros (summary level 310).

ACS 2018 1-Year Summary Levels
The scroll section (see in web page) shows the summary level code (left column), part or component if applicable and summary level name.

ACS 2018 1-Year Estimates — Areas Published — Interactive Table
The interactive table (click link to view actual interactive table) enables you to list the geographic areas tabulated. This graphic shows CBSAs (MSAs and MISAs) tabulated. GeoID1 shows the unique tabulation area geocode for an area among all areas. GeoID1 inlcudes the summary level (first 3 characters), followed by state FIPS code where applicable, ‘US’ and finally the geocode for the specific area.

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.