Category Archives: Census Bureau

Location-Based Demographics Update

.. tools you can use to examine characteristics of addresses/locations .. many of us are interested in knowing attributes of addresses or locations. Often knowing address latitude-longitude is important so that the addresses can be viewed on a map .. see below.  Some might need to know what census block, or other geography, in which an address is located .. or what school district is an address located in.  Others need to know demographic-economic attributes of the neighborhood or area where an address is located.  These types of attributes can be obtained for addresses using the Location-Based Demographic (LBD) tools.  The LBD tool has just been made a part of the CV XE GIS software.  The LBD tool is available in all versions of CV XE GIS, including the no fee User Group version. See more about using the LBD tools to look-up and analyze address/location attributes.

Viewing Geocoded Addresses on a Map – automatically
The following view shows addresses geocoded using the LBD tool. Markers show addresses of 27 Trader Joe’s locations in the Los Angeles area. LBD automatically creates a shapefile that is added to your GIS project. The markers are labeled with population ages 18 and over in the corresponding census tract. Marker color/styles reflect different levels of median household income. A separate census tract layer shows patterns of economic prosperity.

Click graphic for larger view. Expand browser window. A mini profile is displayed showing demographic-economic attributes for the marker at pointer.

View the locations without the tract thematic pattern layer:

Make similar views for your addresses.

Get Started Using the LBD Tool
1 – join the User Group .. click here to join (no fee).
2 – run the installer to install on a Windows machine .. requires your userid.
3 – with CV XE GIS running, click Tools>Find Address/LBD
    enter an address .. a form appears showing characteristics of the address.
4 – see more about using the tools on the LDB page.

GeoStatistical Data Analytics Learning Sessions
We are developing a series of “GeoStatistical Data Analytics” (GSDA) Learning Sessions/modules. One of these is focused on using the LBD tools and methods in the broader context of data analytics. We plan to develop the GSDA models for self-guided use by analysts/practitioners as well as in the classroom setting with teacher/student materials. Upcoming blog posts will describe the program in more detail.

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.

Redistricting & Census 2020

.. most states will not have new redistricting plans until after Census 2020. Redistricting is the process of developing a redistricting plan for 2 or more areas (districts) disjoint and contiguous that are contained within the collective area of all districts based on some criteria. Redistricting is perhaps most familiar with regard to congressional districts and state legislative districts based on a set of demographic characteristics … but may apply to many other types of geographies. This post briefly reviews the Census 2020 & Redistricting Program.

Redrawing the Pennsylvania 115th Congressional Districts
The following views show Pennsylvania 115th Congressional Districts in their gerrymandered configuration (old) and the redrawn configuration (February 2018, new). Counties shown with light gray boundary. Click graphic for larger view. Expand browser window for best quality view.
Pennsylvania 115th CDs — Old

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

Pennsylvania 115th CDs — New, redrawn February 2018

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

Census 2020 & Redistricting Program
The ProximityOne Census 2020 & Redistricting Program enables participants to engage now in preparation for redistricting based on Census 2020. Use resources and processes provided by ProximityOne and the Congressional Districts/State Legislative Districts Group (CDSLD) .. participate in hands-on redistricting for your areas of interest. We start now using Census 2010 redistricting data, current congressional districts and state legislative districts, and related data/tools. Progressively, we move toward accessing the live Census 2020 redistricting data (March 2021). There is no cost to participate. See more about the Census 2020 & Redistricting Program at http://proximityone.com/cen2020_redistricting.htm. Join the CDSLD Group via this form to receive updates on the program and begin participation.

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 the Census 2020 redistricting Program. 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.

How & Why State Demographics Are Changing

.. to examine how and why state demographics are changing, we look at the state as the sum of its parts — counties. Here we review tools and data to examine how and why state/county population is changing … is the population moving away or into your areas 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? See related Web section for more detail on topics covered here and access interactive table.

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

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

The above graphic provides a visual summary of how and why demographics are changing from 2010 to 2017 in terms of components of change: births, deaths and migration. See the underlying data in this interactive table.

Change in the population from births and deaths is often combined and referred to as natural increase/change. The other way an area population changes is through migration (net international, net domestic, net migration). Examining an area’s unique combination of natural change and migration provides insights into why its population is changing and how quickly the change is occurring.

Examine States of Interest
Click a state link to view details about specific states …
Alabama .. Alaska .. Arizona .. Arkansas .. California .. Colorado .. Connecticut .. Delaware .. Florida .. Georgia .. Hawaii .. Idaho .. Illinois .. Indiana .. Iowa .. Kansas .. Kentucky .. Louisiana .. Maine .. Maryland .. Massachusetts .. Michigan .. Minnesota .. Mississippi .. Missouri .. Montana .. Nebraska .. Nevada .. New Hampshire .. New Jersey .. New Mexico .. New York .. North Carolina .. North Dakota .. Ohio .. Oklahoma .. Oregon .. Pennsylvania .. Rhode Island .. South Carolina .. South Dakota .. Tennessee .. Texas .. Utah .. Vermont .. Virginia .. Washington .. West Virginia .. Wisconsin .. Wyoming

Situation & Outlook Briefing Sessions
Join me in a Situation & Outlook Briefing Session, every Tuesday, where we review the where, what, how, and when of demographic-economic-business change – and how change might impact you.  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.

 

Communities of U.S. Foreign Born Population

.. examining the U.S. foreign born population and how/where foreign born by country of origin communities exist .. the U.S. foreign born population includes anyone who is not a U.S. citizen at birth, including those who have become U.S. citizens through naturalization. The native born population includes anyone who is a U.S. citizen at birth, including those who were born in the U.S., Puerto Rico, a U.S. Island Area or abroad to U.S. citizen parent(s). Use the interactive table to examine foreign born population by country by census tract.

As of 2016, the U.S. foreign born population was estimated to be 43,739,345 compared to the total U.S. population of 323,127,515 (13.5%). See the related Web section for more detailed information about the U.S. foreign born population.

Chinese Foreign Born Population & $MHI Patterns; New York City Area
– red markers show census tracts with 500 or more Chinese foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Importance of the Foreign Born Data … knowing about the geographic, demographic and economic attributes of the foreign born population tells us about the size, distribution and characteristics of the immigrant population. Projections of the foreign born population tell us how our country will grow. See more in this related section.

An Illustrative View. The Chinese foreign born population is used in the graphic below to illustrate the distribution of U.S.national scope foreign born population. Other population groups could have been used. Based on the ACS 2016 5-year estimates, there are 851 census tracts having 500 or more Chinese foreign born population (of a total 73,056 tracts). Twenty of the 25 tracts having the largest number of Chinese foreign born population are located in New York City. Determine which tracts using the related interactive table.

Chinese Foreign Born Population Patterns
– China is one of 162 country/country groups reviewed in this section
– red markers show census tracts with 500 or more Chinese foreign born
– the distribution is wide and difficult to gain insights

– view developed with CV XE GIS software using related GIS project and datasets.

Communities of Foreign Born Population
These additional views illustrate how selected foreign born country population clusters in many cases. Some develop communities without formal boundaries or any formally designated structure. Use the GIS project and tools to develop your own views for country combinations and areas of interest.

India Foreign Born Population & $MHI Patterns; New York City Area
– red markers show census tracts with 500 or more India foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Asia Foreign Born Population & $MHI Patterns; Houston, TX Area
– red markers show census tracts with 500 or more Asia foreign born
.. all Asia countries (item 047 in country list above in this section
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Cuba Foreign Born Population & $MHI Patterns; Miami, FL Area
– red markers show census tracts with 500 or more Cuba foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Vietnam Foreign Born Population & $MHI Patterns; Los Angeles, CA Area
– red markers show census tracts with 500 or more Vietnam foreign born
– neighborhood level views provide insights into patterns of economic prosperity
– census tract thematic patterns of median household income

– view developed with CV XE GIS software using related GIS project and datasets.

Using the Interactive Table
— Foreign Born Population by Country by Census Tract

The following graphic illustrates use of the interactive table to examine census tracts in Queens County, NY (code 36081, New York City). South East Asia countries (columns) have been selected and sorted in descending order on China. The table shows the size of the China foreign born population by census tract; the census tract code is shown in the left column.

Use the interactive table and examine areas of interest to you.

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.

 

Examining America’s Cities: Demographic-Economic Updates

.. of the approximate 29,500 U.S. cities and places — geographic areas of population concentration — 301 had an ACS 2016 5-year estimated population of 100,000 or more. The median household income among these places, one measure of economic prosperity, ranged from $26,249 (Detroit, MI) to $117,642 (Frisco, TX).

What are the demographic-economic characteristics of your cities/places of interest? How do these compare to peer groups or a metro/state of interest. Learn more using the new city/place demographic interactive tables. Its about more than economic prosperity — using these data provide otherwise unknowable attributes about the demographic, social, economic and housing characteristics of individual cities/places.

Visual Analysis of City/Place Population Dynamics
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.
… more about above view in City/Place Economic Characteristics section.

Patterns of Economic Prosperity ($MHI) by City/Place
— Northern Virginia, DC, Maryland; part of the Washington, DC metro.

… view developed using the CV XE GIS software.
… click graphic for larger view with places labeled by name and $MHI.

Interactive Tables — new January 2018
Use these interactive tables to get answers, build insights:
• General Demographics
• Social Characteristics
• Economic Characteristics — used to develop data at top of section
• Housing Characteristics
Related:
• City/Place GeoDemographics Main Section
• Annual City/Place Population Estimates & Trends
• Similar ACS tables: Census Tracts | ZIP Codes | State, Metro & County

More About City/Place GeoStatistical Data and Data Analytics
The term “places” as used here refers to incorporated places and Census Designated Places (CDPs). Incorporated places are political areas having certain governmental powers designated by the corresponding state. Unincorporated places, or Census Designated Places (CDPs), are statistical areas having no official standing and no governmental powers but are recognized as being areas of population concentration. Wide-ranging demographic-economic estimates are developed annually for the approximate 29,500 incorporated cities and CDPs based on the American Community Survey 5-year estimates. See more about the ACS 2016 5-year estimates.

Many cities have planning and data development operations that develop important local data including tax parcel data, building permit data, transportation and infrastructure data … bit generally not the data reviewed in this section. Many cities have no planning department to develop, organize and analyze geographic, demographic, economic data … making these data even more essential.

Increasingly in core sections of metropolitan areas, as shown in the above graphics, a large number of cities/places are contiguous. Many retain their own character evolving over many years. Having the detailed ACS demographic-economic data makes it possible to compare places side by side. Use the same data for related drill down geography such as census tracts and block groups to examine neighborhoods and market areas.

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.

Metro 2016 Demographic-Economic Data Analytics: Social Characteristics

.. part one of four parts focused Metro 2016 Demographic-Economic Data Analytics.  This post is on Social Characteristics; ahead: general demographics, economic characteristics and housing characteristics. See related Web section.

Patterns of Educational Attainment by Metro
The following graphic shows patterns of educational attainment (percent college graduate) by Metropolitan Statistical Area (MSA). Legend shows color patterns associated with percent college graduate values.

– View developed using CV XE GIS software and associated GIS project.
– use these resources to develop similar views for any area.
– modify subjects, zoom, colors, labels, add your data.

A Selected Social Characteristic & How Metros Vary
In 2016, the U.S. percent college graduates was 31.3 percent (of the population ages 25 and over) while Metropolitan Statistical Areas (MSAs) ranged from 11.3% (Lake Havasu City-Kingman, AZ MSA) to 60.6% (Boulder, CO MSA). See item/column S067 in the interactive table to view, rank, compare, analyze metros based on this measure for 2016 … in context of related social characteristics. These data uniquely provide insights into many of the most important social characteristics.

Social Characteristics – Subject Matter Covered
– Households by Type
– Relationship
– Marital Status
– Fertility
– Grandparents
– School Enrollment
– Educational Attainment
– Veteran Status
– Disability Status
– Mobility; Residence 1 Year Ago
– Place of Birth
– Citizenship Status
– Year of Entry
– Region of Birth
– Language Spoken at Home
– Ancestry
– Computers & Internet Use

Metro Data Analytics
Use tools, resources and methods to access, integrate and analyze social characteristics for metropolitan areas or Core-Based Statistical Areas (CBSAs). The table includes data for 382 Metropolitan Statistical Areas (MSAs) and 129 Micropolitan Statistical Areas (MISAs). 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 — reviewed here
• Economic Characteristics
• Housing Characteristics
See related Metro Areas Population & Components of Change time series data.

Focusing on Specific Metros & Integrated Multi-sourced Data
While these data provide a good cross section of data on social characteristics, this access structure is a) for one time period and b) data sourced from one statistical program. Also, there is a lot going on in metros; these are typically large areas with many important and diverse smaller geographies such as cities, counties and neighborhoods among other others.

Use the Metropolitan Situation & Outlook (S&O) reports to develop extended insights. See this example of the Washington, DC MSA S&O Report. Examine trends and projections to 2030. Inegrate your own data.

Using the Interactive Table
The following example illustrates use of the metro social characteristics interactive table … try using it on areas of interest. This view, showing metros partly or entirely in Arizona, was first developed by using the state selection tool below the table Next the selected columns button the table is used to examine educational attainment columns/items. The final step was to click the header cell on the “S067” item to sort metros on percent college graduates. It is easy to determine that the Flagstaff metro has the highest percent college graduates (home to Northern Arizona University).

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.

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.