Category Archives: Maps

Mapping Census Tracts & Opportunity Zones

.. using the U.S. by census tract shapefile in the CV XE GIS US1 GIS project .. a no fee resource to ProximityOne User Group members (a no cost program, join here) .. view, locate, examine, map, geospatially analyze census tract geodemographics — in context of other geography and subject matter.

Census Tracts in Las Vegas Area

– create this type of map for any area in the U.S.
– use the CV XE GIS software with the default US1 GIS project.
– no cost to ProximityOne User Group members.

Click graphic above for larger view showing zoom-in. Tracts in larger view are labeled with tract code and ACS 2017 total population. See related ACS 2017 census tract interactive table with extended demographics.

The U.S. census tract shapefile has been added to the ProximityOne “US1” GIS project (included with installation). We have made it easy and free to visually locate census tracts of interest and view the boundaries in context of counties and general topology. Install CV XE GIS or run update if already installed. Examining tracts related to the Opportunity Zones? Each tract includes an identifier enabling you to select or find only those tracts.

See step-by step details on using these resources.

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

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

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.

State of the States: 2018 Population & Components of Change

.. Welcome to 2019 .. how the U.S., states and world population are changing … the Census Bureau estimates the U.S. population is 328,231,337 as of January 1, 2019. This represents an increase of 2,013,241, or 0.62 percent, from New Year’s Day 2018 (326,218,096). The population as of Census Day (April 1) 2010, was 308,745,538 and has grown by 19,485,799, or 6.31 percent.

This section updates January 2020, with corresponding 2019 updates and additional details. Follow (click follow button at upper right) to receive updates on this and geographic, demographic and economic change with drill-down to the street intersection level.

In January 2019, the U.S. is expected to experience one birth every 8 seconds and one death every 11 seconds. Meanwhile, net international migration is expected to add one person to the U.S. population every 29 seconds. The combination of births, deaths and net international migration will increase the U.S. population by one person every 19 seconds … one net international migrant every 34 seconds.

The world population on January 1, 2019 is estimated to be 7,541,221,651. The world has experienced a population increase of 96,777,770, or 1.3 percent, from New Year’s Day 2018 (population 7,444,443,881). During January 2019, 4.8 births and 1.9 deaths are expected worldwide every second.

Patterns of Population Change by State, 2010-2018
The following graphic shows patterns of percent population change from 2010 to 2018. Use the associated GIS project to examine different years or subject matter items. Click graphic for larger view; expand browser window for best quality view.

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

How the U.S. Population is Changing
The following graphic shows how the population of the U.S. has changed from 2010 to 2018 and how the population might change 2019 through 2020. Click graphic for larger view; opens in new page. The population is as of July 1 for each year. The components of change (birth, deaths and migration) are for the period July 1 through June 30 for that year.

Population for each year is computed by the population identity equation:
  P[t]=P[t-1] + B[t,t-1] -D[t,t-1] + M[t,t-1]
Viewing the larger image, see how each of the components of change are impacting the total population and population change.
… see more detail about these data for the U.S. and by state at http://proximityone.com/states2018.htm.

More About Population Trends, Patterns and Characteristics
See more about how population dynamics; use the interactive tables in these sections:
  • School Districts — http://proximityone.com/sdtrends.htm
  • Cities — http://proximityone.com/places2017.htm
  • Counties — http://proximityone.com/countytrends2017.htm
  • Metros — http://proximityone.com/metros.htm
  • States — http://proximityone.com/states2018.htm

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.

Housing Price Index 2017Q3-2018Q3

.. this past week the 3rd quarter 2018 (2018Q3) Housing Price Index (HPI) was released for the U.S., states and metros. As a leading economic indicator, the HPI often gives insights into how the housing market and economy might be changing in the months ahead. The fact that the HPI data are quarterly and become available with a short lag time makes the measure even more valuable. This section provides an update on the HPI 2018Q3 and quarterly data for the past year. See the related Web page for more detailed data and access to the HPI data via interactive table.

Visual Analysis of 2017Q3-2018Q3 HPI Patterns
The following graphic shows housing value appreciation 2017Q3-2018Q3 by metro based on the HPI.

Click graphic for larger view and details. This view developed using CV XE GIS and related GIS project. Members of the ProximityOne User Group (join now, no fee) may used the CV XE GIS software and GIS project to create similar views with different HPI measures. Zoom-in. Add labels. Add other geography/data. Create views/graphics for reports and stories.

The Larger Picture
The HPI is calculated using home sales price information from Fannie Mae- and Freddie Mac-acquired mortgages. By itself, the HPI provides limited insights into the broader picture of “the why” and “how otherwise” states and metros are changing. The Situation & Outlook Metro Profiles provide an integrated view of the HPI measure in combination with other economic, demographic and business activity measure. View the HPI integrated with other subject matter … choose a metro. Metro Profiles are updated continuously and are available for each of the metropolitan area.

HPI Interactive Table
Use the HPI interactive table to view/rank/compare the non-seasonally adjusted “all transactions” HPI for the most recent 5 quarters for all Metropolitan Statistical Areas (MSAs), states and the U.S. The graphic shown below illustrates use of the interactive table to rank all metros in descending order on the percent change over the past year.

Updates & Related Measures
Quarterly HPI measures are used to updated the interactive table, GIS project and Metro Profiles. HPI by county, ZIP Code and census tract are updated annually. The 2018 county, ZIP Code and census tract HPI data are scheduled for release in February 2019.

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.

How the New York Metro is Changing

.. or more precisely, how the New York Metropolitan Statistical Area (MSA) is changing. As of Census 2010 the New York MSA (officially the New York-Newark-Jersey City, NY-NJ-PA MSA) consisted of 20 counties. With the new OMB metropolitan statistical areas defined as of February 2013, the New York MSA became 22 counties, absorbing the Poughkeepsie, NY MSA two counties (Dutchess and Orange). The Poughkeepie MSA was removed from the official MSAs. The delineation remained that way until the new September 2018 delineations when the Census 2010 delineation was restored. Now, the Poughkeepsie, NY MSA exists as a 2 county area and the New York MSA exists as a 20 county area (both as they existed geographically in Census 2010).

These metro-county relationships are shown in the graphic presented below. The Poughkeepsie, NY MSA is shown with the blue cross-hatch to the north and the New York MSA is shown with the salmon color pattern.

– view developed using the CV XE GIS software and related GIS project.
– see the related New York Metro Situation & Outlook report.

What Difference Does it Make?
A lot! First, during the interim period 2013-2018, the Poughkeepsie, NY MSA lost the metropolitan area identity/status as conferred by the OMB delineations. It might have been omitted from size class market development and research analyses. Related, that metro was not included as a tabulation or estimation area of MSAs by Federal statistical agencies. An example of the impact is that the official demographic estimates for the Poughkeepsie, NY MSA developed by the Census Bureau were not tabulated as such and omitted from various statistical reports. Also, the removal of designation and now adding the designation back, creates a hiccup in the time series — affecting both the Poughkeepsie NY MSA and the New York MSA.

Detailed Demographic Profiles for New York MSA and Poughkeepsie, NY MSA
.. click link to view profile.

New York-Newark-Jersey City, NY-NJ-PA MSA
  Bergen County, NJ (34003)
  Essex County, NJ (34013)
  Hudson County, NJ (34017)
  Hunterdon County, NJ (34019)
  Middlesex County, NJ (34023)
  Monmouth County, NJ (34025)
  Morris County, NJ (34027)
  Ocean County, NJ (34029)
  Passaic County, NJ (34031)
  Somerset County, NJ (34035)
  Sussex County, NJ (34037)
  Union County, NJ (34039)
  Bronx County, NY (36005)
  Kings County, NY (36047)
  Nassau County, NY (36059)
  New York County, NY (36061)
  Putnam County, NY (36079)
  Queens County, NY (36081)
  Richmond County, NY (36085)
  Rockland County, NY (36087)
  Suffolk County, NY (36103)
  Westchester County, NY (36119)
  Pike County, PA (42103)

Poughkeepsie-Newburgh-Middletown, NY (CBSA 39100)
  Dutchess County, NY (36027)
  Orange County, NY (36071)

Looking Forward
The September 2018 CBSA delineations define counties that will be used for Census 2020 (likely, there could be yet further changes) — 384 MSAs in the U.S. In the cases of the New York MSA and the Poughkeepsie, NY MSA, it appears that the geography (component counties) used for Census 2010 will be the same as for Census 2020. Going forward, ProximityOne estimates and projections will use the most current vintage of CBSAs.

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.