Category Archives: Maps

Population Living Alone & Age 65 Years and Over

.. how many people are living alone in your community, neighborhood? How does this population impact the community? What are their special needs? How does this population vary by area and population group? There were 37.9 million one-person households, 29% of all U.S. households in 2022. In 1960, single-person households represented only 13% of all households. These estimates are based on the 2022 Current Population Survey (CPS). Moving forward, the number of one-person households, people living alone, will increase at the rate of one million or more per year. People in households exclude people living in group quarters. This post examines patterns of people living alone with focus on people living alone age 65 year and over and distribution by small area geography.

While the CPS data provide a current snapshot of the number of people living alone, we have to use data from the American Community Survey to obtain data for smaller area geography like counties and census tracts.

Population Living Alone by Census Tract –Visual Data Analytics
The four graphics below show patterns of the population living alone by census tract. These views have been developed using the Visual Data Analytics (VDA GIS) tools with integrated demographics. Develop variations on these views using the VDA Web GIS using only a web browser.

Patterns of Population Living Alone by Tract

.. click graphic for larger view.

Patterns of Population 65 and Over Living Alone by Tract

.. click graphic for larger view.

Patterns of Population Living Alone by Tract — Houston Metro Area

Patterns of Population 65 and Over Living Alone by Tract — Houston Metro Area

Examine the Data in More Detail
As noted in this related New York Times story, nearly 26 million Americans 50 or older now live alone, up from 15 million in 2000. Older people have always been more likely than others to live by themselves makes up a bigger share of the population than at any time in the nation’s history. The trend has also been driven by deep changes in attitudes surrounding gender and marriage. People 50-plus today are more likely than earlier generations to be divorced, separated or never married. Similar ACS data as used to develop the graphics shown above are available by race/origin. These data are based on the ACS 2020 data; the same scope of data will be available from ACS 2021 to be released in December 2022.

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

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.

Naturally Occurring Retirement Communities in Path of Hurricane Ian

.. 25.8 million U.S. households had a head of household age 65 years or over in 2010; 22.1% of total households. 3.1 million households with head of household 65 years or over were located in 10,201 “naturally occurring retirement communities” (NORCs) — areas where the percent of head of household age 65 or over is 40 percent or more. Has the number of NORCs tripled by now? Where and how much .. a next blog.

Here, we review Naturally Occurring Retirement Communities in the Path of Hurricane Ian by block group (BGs) in Lee County, FL … using VDA Web GIS. The same process can be applied to any area.

The following view shows a map view of the BGs meeting the criteria. A partial list of the BGs are shown in the table below the map. In the graphic, BGs meeting the criteria show with blue cross-hatch. Zoom in, label, get a profile if viewing real-time. In the graphic, for example, BG 120710019151 (state 12, county 171, tract 001951, BG code 1) has a total Census 2020 population of 2,061.

vda_lee_norc_bgs

Step-by-Step Guide
See this VDA Web GIS tutorial showing how to develop a similar view for areas of interest.

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.

Housing Price Index by ZIP Code – How Housing Markets are Trending

.. housing prices can impact residential investment and affect economic growth, business opportunities and the housing market. The Housing Price Index (HPI) is one measure of how housing prices are changing. The HPI by ZIP code, as reviewed here, is an index based on the year 2000=100. Changing trends in the HPI can used used the determine the relative costs of housing and change in housing valuation. Hosing prices, and the HPI, are only one part of determining how housing markets are trending. Other measures important to examine include building permits and new construction.

Examining Housing Price Trends
Use the VDA Web GIS tool to examine the Housing Price Index for ZIP Codes of interest. Create maps and tabular profiles such as the one shown below.

Video of Steps to Explore HPI by ZIP Code
Click graphic to view video showing how to use VDA Web GIS to access a ZIP Code profile.

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 Housing Price Index
The Housing Price Index used here is developed by the Federal Housing Fiance Agency (FHFA). The FHFA House Price Index is the nation’s only public, freely available house price indexes that measure changes in single-family home values based on data from all states that extend back to the mid-1970s.

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.

New Authorized Monthly Residential Construction by City 

.. access/analyze monthly building permits data for any/all of 7,700 cities in a few minutes via a web browser. Building permits data, a leading economic indicator, are one of the few current indicators available at the city level to examine characteristics and trends. These data can provide insights into the type and value of housing that is being added. Use the VDA Web GIS to examine how the housing situation is changing for cities of interest.

The VDA Web GIS MetroDynamics city layer/dataset is updated with the most recent 6 months of the number of housing units by type and value. The current data provide monthly aggregated data for January 2022 through June 2022. The layer/dataset includes many other attributes (see details). Of the ~19,000 U.S. cities, ~7,700 issue monthly building permits and accessible via this resource.

Examining City Housing Characteristics & Trends
An example: cities in the Phoenix, AZ area labeled with the total building permits.

.. table under map view shows cities with largest number of building permits.
.. see steps to develop the above map and table.

Illustrative Profile for Surprise, AZ
.. selected items from MetroDynamics City layer/dataset
.. integrated subject matter from several sources
.. building permits most current

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 Building Permits Data
Building permits data are collected monthly by the Census Bureau from permit issuing agencies. Monthly data are reported for access within one month of the reporting date. Data are collected on the number of new housing units authorized by type of units in building by value.

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.

New Monthly Residential Construction

.. staying ahead of how and where demographics are changing. Among all monthly new authorized residential construction permit issuing cities/places, Raleigh, NC led the U.S. with 1,749 total units followed by Austin, TX with 1,563 total units in February 2021. See more about this leading economic indicator for cities/places using interactive table below. Data on housing patterns and trends are essential for wide-ranging decision-making applications. Using ProximityOne resources to examine housing characteristics and trends ..

We post monthly and more frequent updates on what New Authorized Residential Construction data are telling us. The March 2021 city/county data will be released this week. Access the latest data for your areas of interest. Click the Follow button at right to keep up-to-date.

Monthly New Authorized Residential Construction
ProximityOne maintains a national monthly time-series database providing access to new authorized residential construction data.  The table presented below summaries key subject matter items available at the city and county level.. These data are one of eleven leading economic indicators. The housing market is often one of the first economic sectors to expand or contract when economic conditions improve or decline. With only a one month lag from reference data to availability date, these measures are early indicators of housing market change. This change typically leads to other types of economic change.

Patterns of New Residential Construction: February 2021; Phoenix Area
Using GIS tools to examine new authorized residential construction .. as an example, the following graphic shows that the City of Phoenix had 1,373 new authorized total units in February 2021. Cities/places shown with black outline.

View Most Month in Tabular Form
Use the interactive table to view these data in a tabular form as shown below.

Scope of Subject Matter
The database is updated monthly and contains monthly and annual data. The scope of subject matter is illustrated as shown below — the number of new units authorized and value by type of structure for Fresno County, CA.

Learn more — Join me in the Data Analytics Web Sessions
Join me in a Accessing & Using GeoDemographics 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.

Examine Neighborhood Demographics for any City

.. examine neighborhood demographics for any city (or county, school district ..) using the no fee, no registration new beta version of the Visual Data Analytics (VDA2) Web GIS. Nothing to install, access with any Web browser. Use this unique and powerful resource to make custom maps similar to the one shown below.

Patterns of Economic Prosperity by Neighborhood in Tampa, FL Area
Examine patterns of economic prosperity by neighborhood in context of a selected county, city or other geography. The following view shows patterns of median household income by census tract in Tampa, FL area. The bold black border shows the city boundary for Tampa; the thematic pattern shows colors associated with intervals of median household income ($MHI). The $MHI layer is set with a see through transparency enabling a view of the underlying topology. Create a view similar to this for any of the 19,500 cities in the U.S. See detailed steps to develop this view in the notes below the graphic.

Map Your Own Map View
Follow these stpe to create your own neighborhood by city map view.  Use other features of VDA2 to access demographic-economic data in a tabular or visual form.

More About VDA2 Web GIS
New in VDA2, not available in VDA1, are the table/query operations. View/analyze data for any layer in a spreadsheet/grid form.  Sort and perform queries on subject matter of interest. Click a button in the data grid to zoom to that geographic area in the map window.  The following graphic shows the VDA2 start-up view after clicking the Query/Table On/Off button. This button (shown below map window at right by pointer) toggles the table view on/off.

.. click graphic for larger view.

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.

Housing Value Appreciation

.. U.S. housing prices rose nationwide in August, up 1.5% from the previous month, based on the FHFA Housing Price Index (HPI). Housing prices rose 8.0% from August 2019 to August 2020.

If you purchased a housing unit in 2019Q2 at $260,200 (the ACS 2019 median housing value), the value of the unit in 2020Q2 would be $271,000, an increase of 4.2%. A good deal in this era of low interest rates.

U.S. housing prices posted a strong increase in August .. the 1.5% increase is the largest one-month price increase observed since the start of the HPI measurement in 1991. This large month-over-month gain contributes to an already strong increase in prices over the summer. These price gains can be attributed to the historically low interest rates, rebounding housing demand and continued supply constraints.

The HPI has various limitations as a measure to assess the housing market. One important limitation is that it a measure in isolation; other related demographic-economic measures are not included. This is unlike the American Community Survey (ACS) estimates of the median housing value ($MHV), used as an annual, year-over-year measure of housing value appreciation.

Median Housing Value
The U.S. ACS 1-year estimate of median housing value ($MHV) increased from $229,700 in 2018 to $240,500 in 2019. The ACS 2020 estimate, which will be impacted by the pandemic, will not be available until September 2021. The ProximityOne 2020 estimate of $MHV is $270,500.

Click this API link to view a CSV-like file showing the 2019 median household income and median housing value by state. Join me in a Data Analytics Web Session (see below) to integrate these data into a map view like shown below. Add other data.

Patterns of Median Housing Value by State

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

An advantage of using the ACS or ACS-like $MHV data is that this measure is synchronized with other related measures, like total population, total housing units, housing units by tenure and age built and so on. Though a popular measure to assess geographically comparable housing values, the $MHV has many limitations. A key limitation is that few survey responders really know the value of their home. Other limitations have to do with the definition itself and how the data are collected/developed. ACS $MHV measures value of only occupied housing units and excludes houses on 10 or more acres and housing units in multi-unit structures. See more. While there are other Federal sources of $MHV, it remains that the usabilty aspects of the ACS or ACS-like measures are second to none.

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.

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.