Category Archives: decision-making information solutions

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.

Outlook 2060

.. reach this blog at http://outlook2060.com .. see related Demographics 2060 .. this blog focuses on topics regarding the current situation and outlook .. what is happening now, historical trends and into the future .. geographic, demographic and economic characteristics for wide-ranging types of geography .. what will change where, when, by how much .. and how change might it impact you .. data resources and tools enabling a deeper dive; relating to decision-making. Click the follow button at right to receive automatic updates.

World by Country Population Projections to 2050

.. updated world population estimates and projections by country show that the world population is projected to grow from 6.9 billion in 2010 to 9.4 billion by 2050, an increase of 2.5 billion (36.5%). This section summarizes access to tools to view, compare, analyze these projections, develop alternative scenario projections, and examine underlying data used to develop the projections. Assess the implications of changing geopolitical, demographic and economic factors and how they might impact future change for areas and matters of interest. See more about these data and alternative scenario projections and impact assessment.  See related main Web section.

Largest 10 Countries based on 2050 Total Population (millions)

The following graphic shows percent change 2010-2050 by country and country code. Click graphic for larger view. Larger view shows legend with intervals/color assignment and population percent change 2010-2050 and country name as labels. Expand browser window to full screen for best quality view.

Rank/Compare Countries with the Interactive Table
The following graphic illustrates use of the  interactive table. The graphic shows countries in Asia-Oceania ranked in descending order based on 2050 population. Examine your regions of interest.

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.
 

Congressional District 2015 Demographic-Economic Characteristics

.. congressional districts vary widely in demographic-economic characteristics.  We have new data for 2015 providing insights to characteristics of the 114th Congressional Districts.  This section summarize a few of these characteristics and provides access to a wide range of data that you can use to view, sort, rank, and compare congressional districts using interactive tables.

Patterns of 2015 Educational Attainment
The following graphic shows patterns of educational attainment (percent college graduate) by congressional district in the Los Angeles area. White label shows the congressional district code; yellow label shows percent college graduate. Legend shows color patterns associated with percent college graduate intervals.

– View developed using CV XE GIS software and associated GIS project.

How Congressional Districts Compare
Reference items refer to items/columns shown in tables described below.

.. general demographics: congressional district UT03 has the smallest median age (27.5 years — item D017) and FL11 has the highest median age (53.5 years).

.. social characteristics: congressional district KY05 has the fewest number of people who speak English less than “very well” (2,676 — item S113) and FL27 has the largest number (281,053).

.. economic characteristics: congressional district ND00 has the lowest unemployment rate (2.6% — item E009) and MI13 has the highest unemployment rate (14.6%).

.. housing characteristics: congressional district MI13 has the lowest median housing value ($63,100 — item H089) and CA18 has the highest median housing value ($1,139,900).

Access the Detailed Interactive Tables
Click a link to view more thematic pattern maps and use the interactive tables.
.. General Demographics
.. Social Characteristics
.. Economic Characteristics
.. Housing Characteristics

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.

Largest School Districts Enrollment Characteristics

..  while school district enrollment is reported by school districts, only public school enrollment is reported. Public and private school enrollment are available by district from the American Community Survey (ACS 2015).  With few exceptions, school districts do not report on demographic-economic characteristics of the school district.  These data are only available from ACS. See the related interactive table to access and compare enrollment characteristics of school districts of interest.

In 2015, there were 1,016 school districts with total population of 65,000 or more (of total 14,650) for which “1-year estimates” were tabulated.  These estimates are based on respondent data for calendar year 2015.  This section summarizes selected enrollment characteristics of the largest districts and provides access to much more detail for each of these districts.

Largest 10 School Districts
The following graphic shows the largest 10 school districts based on the size of the 2015 school age population ages 5-to-17. Click graphic for larger view.

Mapping the Largest School Districts
The following graphic shows locations of the largest school districts as red markers. Click graphic for larger view that opens in a new window. Expand browser window for bets quality view. The larger view shows school district locations on context of metropolitan statistical areas (MSAs).

  view created using CV XE GIS software and related GIS project.

School Districts Tabulated in ACS 2015
ACS 2015 data are tabulated for 14,650 school districts (among many other wide-ranging geography). The following table shows the number of districts for which 1-year estimates and 5-year estimates are tabulated. There are 1,016 districts for which 1-year estimates were tabulated.

These data show enrollment of residents of the district whether enrolled in that district or otherwise. Enrollment data are provided for preschool, K-12 and college and not enrolled.

Using the School District Enrollment Interactive Table
The following graphic illustrates use of the interactive table (click that link to use the table) showing enrollment in kindergarten by school district ranked in descending order.

– click graphic for larger view.

Using the table, you can select total, public or private enrollment for selected grade ranges.

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.