Tag Archives: Census Bureau

How America’s Cities are Changing

… tools, data and insights into how America’s cities are changing, 2010-to 2017.  Of the nation’s 325.7 million people, an estimated 205.0 million (62.9%) live within an incorporated place as of July 1, 2017. 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 in this related section. See three related static tables below showing characteristics the 15 largest cities. Use the U.S. by cities shapefile with your GIS projects. See related GIS & mapping details. See more about the sources and uses of these data in this related section.

Mapping America’s 15 Largest Cities
The following view shows cities with 2017 population of 874,000 or more in blue. Labels show rank among all cities based on 2017 population. These 15 cities have a total 2017 population of 30.6 million of the 205 million total population in all U.S. cities (15%). Click graphic for larger view; expand window to full screen.
… click links in Table 3 below to view maps of these cities.

– View developed using the CV XE GIS software.

Patterns of City Percent Change in Population 2010-17
— Cities in the Los Angeles Area
The following view shows thematic patterns of population percent change, 2010-17 for cities in the Los Angeles, CA area. See color/interval assignment in legend. Click graphic for larger view; expand window to full screen. Larger view shows city names and 2017 population.

– View developed using the CV XE GIS software.
– Flexibly create your own views using the cities GIS project.
– Examine city population trends, patterns; zoom to desired areas; label as needed; integrate other data.

Tables Showing the Largest 15 cities
Data/characteristics shown in the following static tables may also be viewed in the interactive table above with more flexibility and details.

Table 1. 15 Cities With the Largest Numeric Increase, 7/1/16-7/1/17
.. cities with populations of 50,000 or more in 2016

Table 2. 15 Fastest-Growing Large Cities, 7/1/16-7/1/17
.. having populations of 50,000 or more in 2016

Table 3. 15 Most Populous Cities as of July 1, 2017
These 15 cities have a total 2017 population of 30.6 million of the 205 million total population in all U.S. cities (15%).

Mapping & GeoSpatial Analysis of the Largest 15 Cities
Click link in the list below to view map of city shown in the above table.
1 New York
2 Los Angeles
3 Chicago
4 Houston
5 Phoenix
6 Philadelphia
7 San Antonio
8 San Diego
9 Dallas
10 San Jose
11 Austin
12 Jacksonville
13 San Francisco
14 Columbus
15 Fort Worth

City/Place Demographics in Context & Related Data
• State & Regional Demographic-Economic Characteristics & Patterns
.. individual state sections with analytical tools & data access to block level
• Metropolitan Area Situation & Outlook
.. continuously updated characteristics, patterns & trends for each/all metros
• ACS 2016 5-year estimates
.. related City/Place Demographic-Economic Interactive Tables
.. General Demographics … Social … Economic … Housing Characteristics
• Corresponding U.S. by County 2010-2017 Estimates

Data Analytics Web Sessions
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.

State of the States: Demographic Economic Update

.. tools and resources to examine the demographic-economic state of the states .. in 2016, the U.S. median housing value was $205,000 while states ranged from $113,900 (Mississippi) to $592,000 (Hawaii). See item/column H089 in the interactive table to view, rank, compare, analyze state based on this measure … in context of related housing characteristics. These data uniquely provide insights into many of the most important housing characteristics.

Use new tools, data and methods to access, integrate and analyze demographic-economic conditions for the U.S. and states. These data will update in September 2018.

Approximately 600 subject matter items from the American Community Survey ACS 2016 database (released September 2017) are included in these four pages/tables:
• General Demographics
• Social Characteristics
• Economic Characteristics
• Housing Characteristics

GIS, Data Integration & Visual Data Analysis
Use data extracted from these tables in a ready-to-use GIS project. These ACS sourced data (from the four tables listed above) have been integrated with population estimates trend data, components of change and personal income quarterly trend data. See details in this section.

Examining Characteristics & Trends
Below are four thematic pattern maps extracted from the main sections listed above. Click a map graphic for a larger view. Use the GIS project to create variations of these views.

Patterns of Median Age by State
Yellow label shows the state USPS abbreviation; white label shows median age. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column D017 in the interactive table to view, rank, compare, analyze state based on median age.

Patterns of Educational Attainment by State
Yellow label shows the state USPS abbreviation; white label shows % college graduates. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column S067 in the interactive table to view, rank, compare, analyze state based on percent college graduates.

Patterns of Economic Prosperity by State
Yellow label shows the state USPS abbreviation; white label shows $MHI. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column E062 in the interactive table to view, rank, compare, analyze state based on median household income.

Patterns of Median Housing Value by State
Yellow label shows the state USPS abbreviation; white label shows $MHV. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column H089 in the interactive table to view, rank, compare, analyze state based on median housing value.

Examining Characteristics & Trends; Using Data Analytics
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.

Important Upcoming Data Releases: September 2017

.. monthly updates on recent & upcoming data analytics tools & resources .. this section provides a monthly update on important new data developments and applications/developments to further their use in data analytics. A focus of this section is on new or revised geographic, demographic and economic data. Most of these data are used to develop and update ProximityOne census tract-level up demographic-economic projections to 2022 and county-level up population by single year of age projections to 2060. See about September projection updates below on this page. This section is organized into recent past data updates and upcoming (month ahead) data releases and may be updated to reflect new or extended details. See related news and updates:
• What’s New daily updates
• Situation & Outlook Calendar

See related Web section.

Recent Past Data Releases/Access

U.S. by Census Tract 2017 HMDA Low & Moderate Income (FFIEC)
• Release date — 8/17; next update — mid 2018
• 2017 annual HMDA data — covers all income levels not only LMI
• New 2017 HMDA data
• See more information – access data.

U.S. by County Population by Single Year of Age (NCHS)
• Release date — 8/22/17; next update — mid 2018
• 2010 through 2016 annual population by single year of age
• New 2016 data extending annual series 2010 forward
• See more information – access updates.

Housing Price Index (FHFA)
• Release date — 8/22/17; next update — 11/28/17
• Quarterly HPI
• New 2017Q2 data extending quarterly time series.
• See more information – access updates.

Quarterly Gross Domestic Product by State (BEA)
• Release date — 9/20/17; next update — 11/21/17
• Quarterly GDP by Industry
• New 2017Q1 data extending quarterly time series.
• See more information – access data.

Upcoming Data Releases/Access 

2017 TIGER Digital Map Database (Census)
• Expected ~ 9/7/17
• Topologically Integrated Geographic Encoding & Referencing (TIGER) data.
• Geographic data; predominately shapefiles.
.. intersection to intersection road segment geography and attributes.
• New 2017 GIS/mapping shapefiles for use with wide-ranging data
.. including with Census 2010, ACS 2016 & other subject matter.
• See more information – updates to access summarized in that section.

Census of Employment and Wages (BLS/CEW)
• Release date — 9/6/17; next update — 12/5/17
• AKA ES-202 data — establishments, employment & wages by NAICS code/type of business
• U.S. by county.
• New 2017Q1 data extending quarterly time series.
• See more information.

2016 American Community Survey 1-year estimates (Census/ACS)
• Release date — 9/14/17
• Wide-ranging demographic-economic data for areas having population 65,000+
.. all states, CDs, PUMAs, MSAs and larger cities/CBSAs/school districts/counties (817 of 3142)
• New 2016 estimates.
• See more information – updates to access summarized in that section.

SY 2015-16 Annual School & School District Characteristics (NCES)
• Expected ~ 9/14/17
• National school school & school district characteristics.
• New 2015-16 school year administratively reported data.
• Schools … see more information – access updates.
• School District … see more information – access updates.

2016 Annual Gross Domestic Product by Metro (BEA)
• Release date — 9/20/17
• GDP by Industry by Metro
• New 2016 data extending time series
• See more information – access updates.

Census Tract Estimates and Projections to 2022 — ProximityOne
• Release data ~ 9/27/17
• National census tract and higher level geography demographic-economic updates
• Annual estimates & projections; 2010 through 2022
• Updated to reflect/integrate data released through 9/2017 as summarized above   • See more information.

County Population by Single Year of Age Projections to 2060 — ProximityOne
• Release data ~ 9/27/17
• National county and higher level geography demographic updates
• Annual estimates & projections; 2010 through 2060
• Updated to reflect/integrate data released through 9/2017 as summarized above.   • See more information.

Notes [goto top]
– BEA – Bureau of Economic Analysis
– BLS – Bureau of Labor Statistics
– Census – Census Bureau
– FFIEC – Federal Financial Institutions Examination Council
– FHFA – Federal Housing Finance Agency
– NCES – National Center for Education Statistics
– NCHS – National Center for Health Statistics

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 County Migration: 2010-2016

.. tools and data to examine U.S. by county migration 2010 to 2016 … is the population moving away or into your counties of interest? What are the trends; what is causing the change? What are the characteristics of the population moving in and out? How might this impact your living environment and business?

The total net international migration among all counties 7/1/2010 – 7/1/2016 was 5,641,260, an annual average of 940,432. The sum of net domestic migration among counties is zero by definition, but domestic migration among counties varies radically by size and direction. This section is focused on U.S. by county migration from 2010 to 2016. Migration is one component of change used to develop population estimates. See more about county population estimates and components of change in this related Web section.

Largest 10 Counties Based on 2016 Population
This table shows how domestic migration varies widely among the most populated counties. Use this interactive table to develop your own custom views for counties of interest.

Patterns of Population Change by County, 2010-2016
– the role and impact of migration
The following graphic shows how counties have gained population (blue and green) and lost population (orange and red) during the period 2010 to 2016. Click graphic for larger view; expand browser window for best quality view.

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

Examining Population Components of Change
– net migration and natural change
Population change can be examined in terms of components of change. There are three components of change: births, deaths, and migration. The change in the population from births and deaths is often combined and referred to as natural increase or natural change. Populations grow or shrink depending on if they gain people faster than they lose them. Examining a county’s unique combination of natural change and migration provides insights into why its population is changing and how quickly the change is occurring.

Using the Interactive Table
– examining migration by county
Use the interactive table to examine characters of counties by states, metro or peer group. The following graphic illustrates use of the interactive table to view net migration for the Houston metro by county. The net migration button was used to select only the net migration columns, FindCBSA button used to show only counties in this metro and the final step was to sort the resulting table on 2016 population. Click graphic for larger view.

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.

New ACS 2015 1-Year Demographic-Economic Data

.. essential data to assess where we are, how things have changed and how things might change in the future down to the sub-neighborhood level. The American Community Survey (ACS) 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. ProximityOne uses ACS to develop current estimates on these topics and 5-year projections. This section is focused on ACS 2015 data access, integration and use and is progressively updated.

New ACS 2015 1-year estimates are available as of September 15, 2016.

Importance of ACS: Assessing Demographic-Economic Change
Oil prices plummeted in late 2014. How has this affected people and households in areas hardest hit? Find out for wide-ranging geographies using the ACS 2015 1-year estimates. Compare to ACS 2014 1-year estimates. Use the ACS 2016 1-year estimates (September 2017) to see how the impact has continued. Demographic-economic conditions change for many reasons; oil price changes are just one.

Keep informed about ACS developments and related tools and applications:
• Updates are sent to ProximityOne User Group members (join here).
… access special extract files and GIS projects available to members.
• ACS updates and applications are covered in the Data Analytics Blog.
• ACS data access, integration & use … join us in a Data Analytics Lab session.

In the weeks ahead, the following ProximityOne information resources will be updated with new ACS 2015 1-year data:
U.S.-State-Metro Interactive Tables
• Demographic component section of Metro Situation & Outlook Reports .. example for Dallas metro
• Housing characteristics component section of Metro Situation & Outlook Reports .. example for Dallas metro
Demographic-Economic Trend Profiles
• Special study reports.

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.

New Monthly Residential Construction by Metro Updates

.. tools, data & methods to assess the housing situation, examine housing supply and demand market conditions, and how metros of interest are changing.  New July 2016 building permits (new housing units authorized) and over-the year monthly data are now available for each metropolitan statistical area (MSA).

Use the interactive table to view, query, rank, compare data by metro. Map and geospatially analyze construction patterns with the CV XE GIS software and ready-to-use GIS project/datasets – see details.

Updated Resources to Examine Residential Construction Patterns
Metro Situation & Outlook Reports
.. metro by metro … examples: Houston, Los Angeles, Chicago, Atlanta.
County Annual U.S. by county
County & City/Place Monthly

Patterns of New Authorized Residential Units by Metropolitan Area
The following graphic shows value of single unit structures units authorized  by metro. Larger view shows more details including a mini-profile of housing units authorized detail. Create similar views for preferred time periods and different residential unit attributes using the GIS project.  Zoom-in to areas of interest.  Label the geography as desired.  Add your own data.

View created with CV XE GIS. Click graphic for larger view.

The time lag from reference date to access date of these data is one month, contributing to both the freshness of the data and importance of the data as a leading economic indicator. The importance of these data transcends issues concerning housing market conditions alone.  These data are one part of a mix of demographic-economic factors required to understand housing market conditions and the local/regional economy. These data are a part of the process to develop the ProximityOne county and sub-county demographic-economic estimates and projections.

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.

New 2016 Digital Roads Database

.. new resources for updated geographic reference and statistical mapping and geography for routing logistics and optimization .. The Census Bureau TIGER/Line is a continuously updated geographic database used for geographic reference and geospatial processing of data from various Census statistical programs including the decennial census Census 2010 and American Community Survey (ACS 2014). The public use version of TIGER is released annually that includes updates developed during the year. ProximityOne integrates the TIGER geographic updates in the Digital Map Database. Warren Glimpse, founder of ProximityOne, developed the GBF/DIME used as the prototype for TIGER/Line development.  See related Web section for more details, interactive table and access to GIS resources.

The TIGER database includes many types of files and data. The data are developed in the form of shapefiles and dbase files that may be used directly with the ProximityOne CV XE GIS software at no fee. Perform wide-ranging mapping and geospatial analysis applications using these GIS resources. See more aboutmapping statistical data.

TIGER/Line Roads Data
This section is focused mainly on the use of the TIGER/Line “edges” shapefile. The edges shapefile U.S. wall-to-wall street/road coverage in the form of line shapefiles. Lines classified as roads are intersection-to-intersection road segments. Line segment fields include name, left- and right-side high and low addresses, and many related attributes.

Use the U.S. by county interactive table below to examine attributes of TIGER 2016 street/road coverage. ProximityOne developed these county summary data by processing each county edges shapefile. See about using the edges shapefile with the CV XE GIS software below in this section.

Illustrative Applications
The following sequence of graphics shows an example of a “road segment” in context of related geography. These applications focus on an area in Kansas City, MO (Jackson County),. Jackson County has 52,139 TIGER 2016 road segments. See the related step-by-step summary of how you can create these and similar map views using CV XE GIS below in this section.

Road Segment Map View & Profile
– Starbucks locations shown as red markers; pointer on road segment by a Starbucks location.
– View illustrates how non-Census, non-statistical data can be integrated with TIGER.
– Clicking on the road segment (in GIS operation), a mini-profile displays.
– The profile shows attributes of the selected road segment.
.. the TLID value shows the unique ID for this segment among all segments in U.S.
.. left- and right-side high and low address ranges and included in the profile.

Corresponding Census Block Profile
– The road segments are boundaries for census blocks.
– The census block boundaries are shown using a related TIGER blocks shapefile.
– The more that 11 million census blocks cover the U.S. wall-to-wall.
– The census block code (290950073002017) is shown as a label in the map graphic and in the profile.

Neighborhood & Shopping Area View
– A zoom-out shows the location, roads and blocks for a broader areas.

Regional View
– A further zoom-out shows the focus area view in context of the metro counties (a related TIGER shapefile)
– The January 2016 Kansas City city area (orange cross-hatch pattern) is shown using a related TIGER 2016 shapefile.

TIGER 2016 Roads
TIGER/Line 2016 vintage files were released in August 2016. While many aspects of road coverage remain as described in this section, TIGER/line 2016 includes many updates as well as “new vintage” geography for school districts, state legislative districts, congressional districts and other political/statistical area geography.
• More about TIGER 2016.
• More about TIGER/Line in general.

TIGER 2016 Road/Street Name/Address Coverage
— Interactive Table
The following graphic illustrates use of the interactive table to examine the number and characteristics of road segments by county. This view shows the top 10 counties based on the number of total road segments.

– click graphic for larger view

Using TIGER/Line with CV XE GIS
These operations require a Windows computer with Internet connection
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… take all defaults during installation
2. Download the TIGER Roads project fileset
… requires ProximityOne User Group ID (join now)
… unzip TIGER Roads GIS project files to local folder c:\tiger2016
3. Open the c:\tiger2016\riger2016_kc.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\tiger2016\tiger2016_kc.gis
4. Done. The start-up view is shown at top of this section.

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.