Outlook 2060

.. reach this blog at http://outlook2060.com .. see related Demographics 2060 .. this blog focuses on topics regarding the current situation and outlook .. what is happening now, historical trends and into the future .. geographic, demographic and economic characteristics for wide-ranging types of geography .. what will change where, when, by how much .. and how change might it impact you .. data resources and tools enabling a deeper dive; relating to decision-making. Get email updates when posted, click button at right. Planned topics in week of (month ahead):
.. what these new data are telling us in context of other data; accessing the data ..

The Value of Demographic Insights

.. its a global thing, a community thing, a business thing, a personal thing … demographics tell us about how, when, where we have changed and how we might change in the future .. and how that change might impact you .. us.

How & Why are County Demographics Changing?
The following graphic shows how counties have gained population (blue and green) and lost population (orange and red) during the period 2010 to 2018. Click graphic for larger view; expand browser window for best quality view. What are the insights from these data, this view? How are the insights developed? Their application and use creates the value. .
– developed using ProximityOne CV XE GIS.

Access these data for areas of interest:
– U.S. by state interactive table.
– U.S. by metro interactive table.
– U.S. by county interactive table.
– U.S. by city interactive table.
– U.S. by census tract interactive table.

An example of the “tip of the iceberg,” the above model-based demographic data have been developed for use in developing the more detailed American Community Survey annual demographic data — annual updates on demographics down to the block group level of geography. ~217,000 areas covering the U.S. wall-to-wall.

Valuation of Demographic Insights
Having the required demographic data is needed before value can be assigned to their use. It’s really not possible to value demographic data or insights on a financial basis alone. But here are some considerations. One way to assign a value to demographic data is on the cost basis. The above data have been developed by the Census Bureau. But they are not free to develop — the costs for the Federal programs to produce them and the cost for others providing access to the data and using them.

These demographic data enable an unestimable number of studies that result in an unestimable set of decisions in the private and public sector. Many evolve into useful insights, but certainly not all.

Census 2020 is will cost in excess of $16 billion. That’s just to get the data out there. The value of these demographic data have to be in the many trillions or much more. Plus, these demographics enable things that can be done that cannot be done with any other set of demographic data. This “uniqueness thread” runs through many demographic data programs. What is the value of being able to apportion Congress, state legislatures and thousands of other governmental bodies?

How to assign value to one decision based substantially on geodemographics?

What about the byproducts? Census 2020 relies heavily on the Census produced (with the indispensable involvement of regional governments) TIGER/Line geographic database. In essence, we have a demographic data program producing a geographic database. It can be argued that the public use TIGER database is the most valuable past of the decennial census. TIGER provides the digital map database undergirding all widely used mapservers such as Google maps and Bing. It provides the unique and near comprehensive set of standardized geographic data going down to the intersection-to-intersection street segment. It enables a near infinite set of Geographic Information System (GIS) applications.

The above addresses mainly matters of demographic data developed on a national scale. All businesses deal in their own demographics daily. This set of demographic data minimally includes staff and related consultants, etc. plus prospects and clients/customers. Many businesses do not take advantage of the potential benefits of having these data. They can often do more to use their own data, and data of competitors and about the market, to develop improved plans to meet their goals.

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.

  

County Housing Patterns & Trends

.. at a time when “housing costs are going through the roof” and “affordable housing” are topics widely in play, current housing data at the county level are essential for business and public policy planning. In this section, new Census Bureau U.S. by county 2018 housing unit estimates are viewed .. and tools to access and use these data.

Patterns of Housing Unit Percent Change by County: 2010-2018
The graphic below shows patterns of county housing unit percent change from 2010 to 2018. Click graphic for larger view showing more detail.

– view developed using CV XE GIS software and associated GIS project.
– create similar maps for counties/areas using CV XE GIS & associated GIS project.

This section reviews the new 2018 county housing unit estimates (released May 2019) and tools and applications to analyze them. See more about topics covered here in this related Web section.

The U.S. housing stock grew by more than 1.15 million from 2017 to 2018, reaching over 138.5 million units. The growth rate of 0.8 percent from 2017 to 2018. The national housing stock increased by 6.7 million units (5.1 percent) between 7/1/2010 and 7/1/2018. But housing stock change was far from even as shown in the graphic presented above.

Total housing units are the “tip of the iceberg” to examine housing market characteristics. Yet, there are no other Federal statistical data for any other housing attribute for every county more recent than circa mid-2015. Those data are from the American Community Survey 5-year estimates for the period 2013-2017 — data going on 4 years old. For example, there are no Federal statistical data for all counties for the 2018 number of households or vacant units … let alone measures that would enable computing the size and location of affordable housing, one of many important housing market attributes. Use related 2018 and projected housing market data developed by ProximityOne available as part of the Situation & Outlook demographic-economic estimates and projections. Examine these data in context with other geographic and market characteristics in the metro Situation & Outlook reports.

Using the Interactive Table
Use the interactive table to view, rank, compare states and counties based on number of units annually 2010 to 2018 and related measures. Compare counties among metros or states .. or peer groups based on size. Here are two examples of using the table.

Largest Counties based on 2018 Housing Units
.. ranked on 2018 housing units .. click for larger view

Counties with 10,000 or more 2018 Housing Units
.. ranked on percent change 2010-2018 .. click 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.

Examining Economic Well-Being by Metro

.. examining the state of economic well-being: 2008-2017 .. expanding insights through data analytics .. tools and data to examine how and where the U.S. by metropolitan area real personal income is changing.  Real per capita personal income (RPCPI) is the best single measure of personal economic-well being. By examining RPCPI trends over a period, stakeholders can better determine if the area in improving, stable or declining. Still, RPCPI is but one important measure among many others, such as the Regional Price Parities (RPP). Use the interactive table, and related GIS tools, to examine these and other real personal income measures for the Nation’s 383 Metropolitan Statistical Areas (MSAs). See related Web section for more detail.

Based on data released by the Bureau of Economic Analysis in May 2019, see about in statistical release dates, real state personal income grew 2.6 percent in 2017, after increasing 1.5 percent in 2016. Real state personal income is a state’s current-dollar personal income adjusted by the state’s regional price parity and the national personal consumption expenditures price index. Across metropolitan areas, the percent change ranged from 14.8 percent in Midland, MI to -5.9 percent in Enid, OK

Visually Examining Patterns of Economic Well-Being
Geographic Information Systems (GIS) tools provide a powerful to explore these data. The following graphic shows a view of real per capita personal income (RPCPI), 2017, for Texas MSAs. Color patterns for levels of RPCPI are shown in the inset legend. MSAs are labeled with the 2017 RPCPI rank among all U.S. MSAs. Click graphic for larger view; expand browser window for best quality view. The larger view shows MSAs labeled with short name and a mini-profile for Harris County (pointer).

.. view developed with ProximityOne CV XE GIS and related GIS project.

Using the Interactive table
The interactive table (click link to view/use) includes a row for the U.S., U.S. nonmetro area and each Metropolitan Statistical Area (383). Each row provides a 2008-17 annual time series for four items (and derived items): real per capita personal income, regional prices parities-all items, total real personal income, implicit regional price deflator.

The following graphic shows these areas ranked on RPCPI in 2017. See rightmost column rank. Click graphic for larger view. Midland, TX MSA has the 4th highest 2017 RPCPI (shown in blue; also shown in blue in the map graphic above). But … that metro experienced a decrease of 12.1 percent over the period 2010-2017 .. and down from a high RPCPI of $115,069 in 2014. The dynamics of the oil industry!

Data Analytics Web Sessions
See these applications live/demoed. Run the applications on your own computer.
Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Mapping Census 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.

America’s Cities: Examining Characteristics & Trends

… examining city/place demographic-economic characteristics .. of the approximate 29,323 U.S. cities/places, there are just 548 “large cities” .. those with population of 65,000 population or more.  A semi-arbitrary classification, these are cities/places that meet a size criteria for which American Community Survey (ACS) 1-year estimates are developed annually.  This results in the availability of extensive annual demographic-economic data that are much more current than available for all other cities/places (incorporated cities and CDPs).  Click this link to display a list of these cities/places that include 42 CDPs.  They comprise 2017 population of 119,342,501 of the total U.S. population 325,719,178 (36.6%).

Visual Analysis of City/Place Population Dynamics
Use the CV XE GIS software with city/place GIS project to examine characteristics of city/place population. The following view shows patterns of population percent change by city in the Charlotte, NC/SC metro area.

… view developed using the CV XE GIS software.
… click map for larger view and details including city name.

Access updated city/place for all 29,323 U.S. cities/places based on data from American Community Survey 5-year estimates (ACS2017).  Only here, for example, can you compare income characteristics and educational attainment, and much more, among all cities/places or peer groups .. or examine one/a few of interest to you.

Interactive Tables
Use interactive tables to view, rank, compare cities for any selected item; examine peer groups. Four pages/tables:
• General Demographics
• Social Characteristics
• Economic Characteristics
• Housing Characteristics
Related:
• City/Place GeoDemographics Main Section
• Annual City/Place Population Estimates & Trends
• Similar ACS tables: Census Tracts | ZIP Codes | State, Metro & County

Using API Tools to Access Trend Data; Build Data Files
An example: Examine Citizen Voting Age Population; 2014-2017 annually
Using API Tools to access ACS 2017 1 year estimates for all cities/places:
.. item D084 (CVAP: citizen voting age population) in the interactive table
.. click here to view list of places 65,000 population and over and CVAP
.. join us in the Data Analytics Web Sessions to learn more

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.

Employment by Occupation by Census Tract; 5-Year Trends

.. data and tools to examine patterns of employment by occupation by census tract and 5-year change .. the U.S. civilian employed population increased from 142.9 million in 2012 to 155.1 million in 2017, an increase of 12.1 million (8.5%) based on the American Community Survey (ACS) 1-year estimates. See this table to see how the employed population were distributed by occupation in 2012, 2017 and the 5-year change. How did your neighborhoods or market/service areas of interest change over the past 5 years? How will occupational employment patterns by tract/neighborhood change between now and 2023?

Patterns of Percent Employed in Health Occupations by Census Tract
The following graphic shows patterns of the employed population in health occupations as a percent of total civilian employed population ages 16 and over in the Minneapolis-St. Paul metro. This view uses the occupational category MBSA40 Healthcare practitioners and technical listed in scroll section below. Tracts with blue or green pattern exceed the national average as shown in national table. Click graphic for larger view, more detail (shows schools layer) and legend color/data intervals. This map illustrates the geographic level of detail available using census tract demographics and the relative ease to gain insights using geospatial data analytics tools. View related graphic showing tract with the largest employment in the “Healthcare practitioners and technical” occupational group among all tracts.

– View developed using CV XE GIS and related GIS project.

Drill-down to Census Tract Level
Examining patterns of employment by occupation, for the same scope of subject matter, at the sub-county level can provide more insights. What is the size of the employment for a selected occupation in a neighborhood or market/service area of interest? How has the size of an occupational group by census tract changed over the past five years? How do these patterns rank/compare by tract in a particular state, metro or county? Data on employment by occupational category from the Federal statistical system on a U.S. national scale for counties, cities and census tracts are only available from the American Community Survey (ACS).

Use tools, resources and methods described here to access, integrate and analyze employment by occupation for the U.S. by census tract. Use the interactive table to view, query, rank, compare census tract occupational characteristics, patterns and trends. Data are based on the American Community Survey (ACS) 2017 5-year estimates.

Related sections with census tract interactive tables:
– General Demographics .. Social .. Economic .. Housing 

Current Estimates & Projections
ACS tract/small area estimates lag by four years or more between the current year and reference year. ACS does not produce current year annual estimates but estimates based on a 5-year period. The 2017 ACS estimates are centric to 2015. Use the ProximityOne annual tract estimates and projections 2010 through 2023 for current year (e.g., characteristics as of 2018) estimates and anticipated change 5 years ahead.

Using the Interactive Table
An example of using the interactive table to view, query, rank, compare census tract occupational characteristics, patterns and trends is shown by the graphic presented below. The table shows 6 columns of employment data for all tracts in Harris County, TX. The table is ranked on the ACS 2017 health occupations employment (MBSA40) column. Tract 48-201-312600 had largest ACS 2017 health employment of 1,078 among all tracts in the county. Compare to 2012 patterns. Use settings below table to develop a similar view your geography and occupations of interest.

Occupational Categories
The interactive table includes occupational categories listed below.
Total population
Total Civilian employed population 16 years and over
MBSA00 . Management, business, science, and arts
MBSA10 . . Management, business, and financial
MBSA11 . . . Management
MNSA12 . . . Business and financial operations
MBSA20 . . Computer, engineering, and science
MBSA21 . . . Computer and mathematical
MBSA22 . . . Architecture and engineering
MBSA23 . . . Life, physical, and social science
MBSA30 .. Education, legal, community service, arts, and media
MBSA31 … Community and social service
MBSA32 … Legal
MBSA34 … Education, training, and library
MBSA35 … Arts, design, entertainment, sports, and media
MBSA40 .. Healthcare practitioners and technical
MBSA41 … Health diagnosing & treating practitioners & other tech
MBSA42 … Health technologists and technicians
SVC00 . Service
SVC10 . . Healthcare support
SVC20 . . Protective service
SVC21 . . . Fire fighting/prevention & other protective services
SVC22 . . . Law enforcement workers including supervisors
SVC30 . . Food preparation and serving related
SVC40 . . Building and grounds cleaning and maintenance
SVC50 . . Personal care and service
SOF00 . Sales and office
SOF10 . . Sales and related
SOF20 . . Office and administrative support
NRC00 . Natural resources, construction, and maintenance
NRC10 . . Farming, fishing, and forestry
NRC20 . . Construction and extraction
NRC30 . . Installation, maintenance, and repair
PTM00 . Production, transportation, and material moving
PTM10 . . Transportation
PTM20 . . Material moving

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

Data Analytics Web Sessions
See these applications live/demoed. Run the applications on your own computer.
Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.