Tag Archives: Maps

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.

Assessing Why and How the Regional Economy is Changing

.. data, tools and insights .. which counties are experiencing the fastest economic growth? by what economic component? what does this look like on a per capita level? how might county economic change impact you? Use our county level annual estimates and projections to 2030 to get answers to these and related questions. Get started with the interactive table that contains a selection of these data for all counties and states.

Visual Analysis of Per Capita Personal Income Patterns
The following map shows changing patterns of economic prosperity, U.S. by county, based on percent change in per capita personal income, 2010 to 2017. Create variations of this view — this view uses a layer in the “US1.GIS” GIS project installed by default with all versions of the CV XE GIS software.
– click graphic for larger view.
– view developed with CV XE GIS software.

Measuring the economy and change. One important part of this is Personal Income and components of change. Personal income is the income available to persons for consumption expenditures, taxes, interest payments, transfer payments to governments and the rest of the world, or for saving. Use the interactive table to examine characteristics of counties and regions of interest; how they rank and compare. The table provides access to 31 personal income related summary measures — the interactive table shows data for one of eight related subject matter groups. See more about the scope of subject matter descriptions.

Assessing How the Economy is Changing and How it Compares
The U.S. Per Capita Personal income (PCPI) increased from $40,545 in 2010 to $51,640 in 2017 — a change of $11,095 (27.4%). Compare the U.S. PCPI (or for any area) to a state or county of interest using the table. For example, Harris County, TX (Houston) .. click the Find GeoID button below the table .. increased from $45,783 in 2010 to $53,188 in 2017 — a change of $7,405 (16.2%).

Economic Profile; 2010-2017 & Change — An Example
The following graphic shows and example of the economic profile for Harris County, TX (Houston). Access a similar profile for any county or state.

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.

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.

New 2018 Vintage Metropolitan Areas

.. new, September 14, 2018 vintage, Core-Based Statistical Area (CBSA) delineations have been released by the U.S. Office of Management and Budget (OMB).  Among other things, the new delineations specify which counties are included in each CBSA.  CBSAs. an OMB standards term, are metropolitan areas comprised of Metropolitan Statistical Areas (now 384 MSAs in the U.S.) and Micropolitan Statistical Areas (now 542 MISAs in the U.S.).

How Metros Change Geographically
The following graphic, focused on the Charlotte, NC-SC MSA region, illustrates how MSAs are changing. 2017 vintage MSAs are shown with bold green boundary, yellow fill pattern. Cross-hatched areas are 2018 vintage MSA counties. As of the 2018 vintage, note that …
• Anson County, NC (to right of pointer) has been added to the Charlotte, NC-SC MSA.
• Union County, SC has been removed from the Spartanburg, SC MSA.
• Harnett County, NC has been added to the Fayetteville, NC MSA.

— graphic developed using CV XE GIS software and related GIS project.

What About My MSAs of Interest?
See detailed information about the 2018 vintage CBSAs/MSAs and their component counties at http://proximityone.com/cbsa2018.htm.

Impact of the 2018 Delineations
The new delineations take place immediately and have numerous impacts.  Going forward, Federal statistical agencies will develop statistics and use the new names and geocodes as set forth in the new delineations (most names and geocodes remain the same).  For CBSAs affected, which are numerous, this will result in challenges for longitudinal analyses where consistently defined geography over time is required.  The total 2017 official population estimates are affected for three of the largest 10 CBSAs using the 2018 delineations compared to the 2017 delineations.  More immediately, it may become confusing whether the 2018, 2017, 2015, or an earlier vintage CBSA geography is being referenced.  On a positive note, the 2018 vintage CBSAs are believed to best reflect the set of counties comprising a CBSA as an entity of highly related demographic-economic conditions.

Keeping Up-to-Date with Metro Demographic-Economic Data
Metropolitan Statistical Areas (MSAs/metros), comprised of one or more contiguous counties, are important for many reasons. Business, demographic and economic data for these 384 areas, each developed around an area of large population concentration, provide a “10,000 foot” view of these characteristics and how they are changing. As they are comprised of county groups, much of the subject matter data are also available for drill-down analysis at the county and sub-county levels. Metro boundaries change some over time … as more peripheral counties are added or removed depending on their demographic-economic affinity with central county(s).

Metros are an important part of the ProximityOne Situation & Outlook program. Metro demographic-economic estimates and projections are updated to reflect 2018 vintage metros. This includes all elements of the Census-sourced age-race/ethnicity-gender annual estimates and American Community Survey demographic-economic subject matter.

Designating Metros and Delineating Metro County Components
More detail … in consultation with Federal statistical agencies, OMB defines metropolitan statistical area boundaries. This section provides a summary of Metropolitan Statistical Areas (MSAs), and component Metropolitan Division and Counties/County Equivalents, as delineated in OMB Bulletin 18-04 issued September 14, 2018. These delineations take place immediately. This is a significant update affecting approximately 20-percent of previous MSA delineations (one or more county addition or removal).

Under the September 14, 2018 delineation, there are 938 Metropolitan Statistical Areas (MSAs) and Micropolitan Statistical Areas (MISAs) in the U.S. and Puerto Rico, collectively referred to as Core-Based Statistical Areas (CBSAs). There are 392 MSAs (384 in the U.S. and 8 in Puerto Rico). 11 MSAs contain a total of 31 Metropolitan Divisions. There are 546 MISAs (542 in the United States and 4 in Puerto Rico).

The 384 U.S. MSAs comprise 1,181 counties of total 3,142 U.S. counties. The total 2017 population of these metros was 280,468,904 of total 325,719,178 U.S. population (86.1%).

See related sections:
• Metros Main Section
• Metros Situation & Outlook Reports
.. click link in column 3 in table in above page to view detailed report
• Metro Demographic-Economic Interactive Tables
• County Population/Components of Change Interactive Table

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 State-to-State Geographic Mobility

.. tools, resources and insights to examine U.S. by state migration 2011-2017 and migration flows in 2016 .. this post is an excerpt from the more detailed Web page http://proximityone.com/statemigration.htm.

In examining future demographic trends, the most challenging component of change to project (develop data values into the future) is migration. Migration, comprised net domestic and net international migration, is a function of many factors whose cause and effect behavior can change year by year, and geographic area by area. While this section is focused on states, the same scope of data is available to the county and sub-county levels. In this section, U.S. by state migration is examined using two data sources: annual population and components of change model-based estimates (2010-2017 model-based estimates) and annual American Community Survey estimates (ACS 2016 estimates). While these Census Bureau programs are highly related, the migration data/subject matter differ some.

State Net Domestic Migration, 2011-2017
The following graphic shows patterns net domestic migration for the period 2011-2017, based on the model-based estimates. The patterns of migration change, direction and magnitude are immediately evident. Click on the graphic to see a larger view showing more detail. Expand browser to full screen for best quality view. The larger view shows a portion of a mini-profile for Florida. The mini-profile illustrates how these data are comprised … annual net domestic migration estimates and the sum over the years 2011-2017. See the interactive table to view these data, and related components of change, in a tabular, numeric form. Use the GIS project (details here) to create similar views for any state; visual analysis of outmigration for any state showing outmigration by destination state. Label areas as desired. Add other layers. Add your own data.

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

State OutMigration by Destination State
The model-based estimates, reviewed above, do not provide detail on state-to-state migration. Those data are provided by the related ACS 2016 estimates. Note that the ACS 2016 1-year estimates are for the calendar year 2016. From these data we can get the following migration detail … In 2016, there were an estimated 605,018 people who moved from a residence 1 year earlier, in a different state, to Florida. Florida experienced the largest number of movers (inflows) from other states among all states. 60,472 of these movers were from New York. See the interactive table in this section to examine similar characteristics for any state. These data are based on the 2016 ACS 1 year estimates. See about related data.

The American Community Survey (ACS) asks respondents age 1 year and over whether they lived in the same residence 1 year ago. For people who lived in a different residence, the location of their previous residence is collected. The state-to-state migration flows are created from tabulations of the current state (including the District of Columbia) of residence crossed by state of residence 1 year ago.

Movers Within and Between States & Selected Areas During 2016
Use the interactive table to examine state outmigration by destination state. View, compare, query, rank and export data of interest.

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.

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.

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.