Category Archives: decision-making information solutions

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.

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.

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.