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.

Examining How Metro GDP is Changing

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

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

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

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

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

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

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

Try using the interactive table to examine metros of interest.

Demographic-Economic Analytics Web Sessions
Join me in a Demographics Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

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

The Local Area Monthly Employment Situation

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

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

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

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

Click graphic for larger view.

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

Demographic-Economic Analytics Web Sessions
Join me in a Demographics Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

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

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.

Block Group Demographic Data Analytics

.. use tools described here to access block group data from ACS 2016 (or ACS2017 in December 2018) using a no cost, menu driven tool accessing the data via API. Select from any of the summary statistic data. Save results as an Excel file or shapefile. Add the shapefile to a GIS project and create unlimited thematic pattern views. Add your own data. Join us in a Data Analytics Web session where use of the tool with the ACS 2017 data is reviewed.

See related Web section for more details.
– examine neighborhoods, market areas and sales territories.
– assess demographics of health service areas.
– create maps for visual/geospatial analysis of locations & demographics.

Illustration of Block Group Thematic Pattern Map – make for any area

– click graphic to view larger view
– pointer (top right) shows location of Amazon HQ2

Topics in this how-to guide (links open new sections/pages)
• 01 Objective Thematic Pattern Map View
• 02 Install the CV XE GIS software
• 03 Access/Download the Block Group Demographic-Economic Data
• 04 Download the State by Block Group Shapefile
• 05 Merge Extracted Data (from 03) into Shapefile (04)
• 06 Add Shapefile to the GIS Project; Set Intervals
• 07 Viewing Profile for Selected Block Group
• 08 BG Demographics Spreadsheet
• 09 Block Group Demographics GIS Project
• 10 Why Block Group Demographics are Important

Data Analytics Web Sessions
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 Block, Block Group & Census Tract GeoDemographics

Census tracts, block groups and blocks are the important small area statistical geographic areas for which data from Census 2010 are tabulated. Data for census tracts and block groups are also tabulated annually from the American Community Survey. For example. in December 2018, we will have new “richer demographics” annual estimates centric to each year 2008 through 2015 for Census 2010 tracts and block groups … data such as educational attainment, language spoken, housing and household characteristics,  income characteristics and employment and other demographic-economic attributes.

Largest Population New York City (NYC) Census Blocks
The following graphic shows the NYC Census 2010 census block having the largest Census 2010 population that is not a group quarters population block. The Lincoln Center census block shown in the graphic (red boundary) has 4,067 population and 2,922 housing units.

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

This block (36 061 015500 6000) occupies 0.033 square miles. It has a population density of 122,333 (population per square mile). The NYC block with the largest population is on Rikers Island and has a group quarters population of 8,634 and 0 housing units. For Census 2010, there were 350,169 census blocks covering the state of New York; 13,356 census blocks were water blocks. For the State of New York, as of Census 2010 the average census block population was 55 (57 excluding water blocks).

Census 2010 and Census 2020
These geographies have generally stable geographic areas and codes from one decennial census (e.g., Census 2010) to the next (e.g., Census 2020). Many of these areas will change in terms of code and area for Census 2020, though the geographic changes will typically be small or not at all.

Census 2020 block, block group and tract codes and geometry will be available in late 2020. Initial block level demographics will be available in March 2021.

Census 2010 & Current GeoDemographics
These areas cover the U.S. from wall-to-wall and generally non-changing in terms of boundary and geographic code (geocode) until Census 2020. This section provides a summary of new Web pages with more detail about each of these geographies:
• census tracts and tract codes .. 73,056 areas
• census block groups and block group codes .. 217,740 areas
• census blocks and block codes .. 11,078,297 areas

Each of these pages provides an interactive table to view tallies of Census 2010 for each of these small area geographies.

Combining Address Data with Small Area Geography
The address of the Office of the California Secretary of State, located at 1500 11th St, Sacramento, CA 95814, was geocoded using the APIGeocoder and converted into a shapefile for Geographic Information System applications.  The location is shown as a red marker in the map views shown below, illustrating each type of small area geography: tracts. block groups and blocks.

Census Tracts
Tracts are labeled with green tract codes. Address 1500 11th St, Sacramento, CA 95814 is shown by red marker.  The address is in tract 06067001101.

View created using CV XE GIS.

Block Groups
Block groups are labeled with red block group codes.  Tract 06067001101 is comprised of block groups: 060670011011 and 060670011012.  See pointer in map view; the block group within tract boundary.

View created using CV XE GIS.

Zoom-in to Census Block
Blocks are labeled with yellow block codes. The address is located in block 060670011011085.

View created using CV XE GIS.

Further Zoom-in Showing Streets
Streets are labeled with street names. Identify tool is used to show mini-profile for 1500 block of 11th Street.

View created using CV XE GIS.

Is the tract code 11.01 or 001101?
Both. Census tracts within a county are identified by a 4-digit basic code between 0001 and 9999, and may have a 2-digit suffix ranging from .01 to .98; for example, 6059.02. The decimal point separating the 4-digit basic tract code from the 2-digit suffix is shown in Census Bureau printed reports and maps. For geo-referencing, the decimal point is implied and does not appear; the 6-character tract code with lead zeroes is used — a character string with no blanks and all numbers.

Accessing and Using these Geographies & Related Demographics
There are several ways these geographies can be used.
• The geocodes are the “handles” to access demographic-economic statistical data.
• The geographies may be visually, geospatially, related as shapefiles.
.. the Census Bureau makes these shapefiles available for use in user appications.
.. the shapefiles typically do not include demographic-economic data.

Access Census 2010 Census Block (and Block Group/Tract) data:
• P.L. 94-171 Redistricting Data — http://proximityone.com/cen2010_pl94171.htm
• Summary File 1 — http://proximityone.com/cen2010_sf1.htm

Access Census Block Group and Tract richer demographics:
• 2016 American Community Survey (ACS) 5-year estimates
  — http://proximityone.com/acs1216.htm
• Access annual counterparts to above section
• Census blocks — http://proximityone.com/cenblk.htm
• Census block groups — http://proximityone.com/blockgroups.htm
• Census tracts — http://proximityone.com/tracts.htm

Alternatively use the Census Bureau APIs or CV XE GIS APIGateway.

Data Analytics Web Sessions
.. is my area urban, rural or …
.. how do census blocks relate to congressional district? redistricting?
.. how can I map census block demographics?
Join me in a Data Analytics Web Session, every Tuesday, where we review access to and use of data, tools and methods relating to GeoStatistical Data Analytics Learning. We review current topical issues and data — and how you can access/use tools/data to meet your needs/interests.

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.

Accessing & Using ZIP Code Demographics

.. tip of the day .. a continuing weekly or more frequent tip on developing, integrating, accessing and using geographic, demographic, economic and statistical data. Join in .. tip of the day posts are added to the Data Analytics Blog on an irregular basis, normally weekly. Follow the blog to receive updates as they occur.

… February 2017 updates .. 5 ways to access/analyze the most recent estimates of median housing value and other subject matter by ZIP Code area .. updates on accessing/downloading/using American Community Survey (ACS1115) 5-year estimates. See more detail in related Web section.

Site analysis (Option 5 below)
– create site analysis profiles from a location/ZIP code.

Contents
Five data access and use options, listed in the links below, are reviewed. Each method illustrates how ZIP code demographic-economic data can be accessed/ analyzed/used in different contexts. The most basic data access/data download is illustrated in Option 3. The following links open new windows that take you to the related section with more detail.
• Option 1 – View the data as a thematic pattern map.
• Option 2 – View, compare, rank query data in interactive tables.
• Option 3 – Access data using API Tools; create datasets.
.. Option 3a – Extended ZIP Code subject matter access.
.. Option 3b – ZIP code urban/rural data access.
.. Option 3c – Additional API ACS data access resources.
• Option 4 – View $MHI in structured profile in context of related data.
• Option 5 – Site analysis – view circular area profile from a location.

Related ZIP Code Data Access & Use sections
• Interactive access to demographics based on an address
• Summary of ZIP Code Data Resources & Tools
• 10 Reasons to use Census Tracts Versus ZIP Codes
• Analyzing Census Tract Demographics by ZIP Code Area
• ZIP Code to Census Tract Equivalence Table
• ZIP Code Urban/Rural Geography & Demographics
• Mapping ZIP Code Demograhics
• Housing Price Index by 5-digit ZIP Code – time series; annual updates
• Housing Price Index by 3-digit ZIP Code – time series; quarterly updates
• ZIP Code Business Establishment, Employment & Earnings by industry
• ZIP Code Retail Trade Establishment & Sales by industry
• ZIP Code Equivalence Tables — ZIP Code to School District

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.