Tag Archives: Atlanta

Examining County Gross Domestic Product

.. what is the annual per capita real-valued output of counties of interest? How is this measure trending? Why is this important? This section reviews tools and data to examine county-level Gross Domestic Product (GDP) trends and patterns. The first ever county-level GDP estimates to be developed as a part of the official U.S. national scope GDP estimates were released in December 2018. The county GDP estimates join the county-level personal income by major source, both now part of the Regional Economic Information System (REIS). See more detail about topics reviewed in this post in the related County GDP web section.

Patterns of Real Per Capita GDP by County
The graphic below shows patterns of per capita real GDP, 2015, by county.

– View developed using CV XE GIS and related GIS project.
– create custom views; add your own data, using the GIS project.

Gross Domestic Product (GDP) by county is a measure of the value of production that occurs within the geographic boundaries of a county. It can be computed as the sum of the value added originating from each of the industries in a county.

Example … use this interactive table to see that 2015 Los Angeles County, CA total real GDP of $656 billion was just slightly larger that than of New York County, NY (Manhattan) at $630 billion. Yet, the total 2015 population of Los Angeles County of 10.1 million is 6 times larger than that of New York County of 1.6 million — see about steps. GDP provides very different size measures, and economic insights, compared to population.

In 2015, real (inflation adjusted) Gross Domestic Product (GDP) increased in 1,931 counties, decreased in 1,159, and was unchanged in 23. Real GDP ranged from $4.6 million in Loving County, TX to $656.0 billion in Los Angeles County, CA.

This post is focused on U.S. national scope county level estimates of Gross Domestic Product (GDP) annually 2012 through 2015. This marks the first time county level GDP estimates have been developed, a part of the Regional Economic Information System (REIS). Use the interactive table to rank, compare, query counties based on per capita GDP, current GDP, real GDP by type of industry. Use the related GIS project to develop thematic map views such as the one shown below. See more about these data.

Current Annual Estimates & Projections
ProximityOne uses these and related data to develop and analyze annual Situation & Outlook demographic-economic estimates and projections. GDP items included in the table below are included in the “annual 5-year” projections as shown in the schedule of release dates; next release April 18, 2019 and quarterly.

Examining County GDP Using GIS Tools
Use the County REIS GIS project. Make your own maps; select different item to map; modify colors, labels. Zoom in views of selected states shown below. Graphics open in a new page; expand browser window for best view. Patterns: see highlighted layer in legend to left of map; MSAs bold brown boundaries with white shortname label
counties labeled with name and 2015 per capita real GDP
.. Arizona .. Alabama .. California .. Colorado .. Iowa .. Georgia .. Kansas .. Missouri
.. New York .. Nevada .. North Carolina .. South Carolina .. Nevada .. Texas .. Utah .. Vermont

Using the County GDP Interactive Table
The graphic below illustrates use of the interactive table. Tools below the table have been used to view only per capita real GDP for all sectors (total sources) and for county with total population between 50,000 and 60,000. Counties were then ranked on 2015 per capita real GDP (rightmost column).

– click graphic for larger view.

Using County GDP: 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.

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 Monthly Residential Construction by Metro Updates

.. tools, data & methods to assess the housing situation, examine housing supply and demand market conditions, and how metros of interest are changing.  New July 2016 building permits (new housing units authorized) and over-the year monthly data are now available for each metropolitan statistical area (MSA).

Use the interactive table to view, query, rank, compare data by metro. Map and geospatially analyze construction patterns with the CV XE GIS software and ready-to-use GIS project/datasets – see details.

Updated Resources to Examine Residential Construction Patterns
Metro Situation & Outlook Reports
.. metro by metro … examples: Houston, Los Angeles, Chicago, Atlanta.
County Annual U.S. by county
County & City/Place Monthly

Patterns of New Authorized Residential Units by Metropolitan Area
The following graphic shows value of single unit structures units authorized  by metro. Larger view shows more details including a mini-profile of housing units authorized detail. Create similar views for preferred time periods and different residential unit attributes using the GIS project.  Zoom-in to areas of interest.  Label the geography as desired.  Add your own data.

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

The time lag from reference date to access date of these data is one month, contributing to both the freshness of the data and importance of the data as a leading economic indicator. The importance of these data transcends issues concerning housing market conditions alone.  These data are one part of a mix of demographic-economic factors required to understand housing market conditions and the local/regional economy. These data are a part of the process to develop the ProximityOne county and sub-county demographic-economic estimates and projections.

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 by Metro: What $100 Buys

.. data and tools to examine the purchasing power of the incomes in different metros and states … this section reviews how you can access to data on what $100 buys by state and metro. Examine patterns of what $100 buys by year, 2008-2014, for all items and by type of goods & services category. Use the interactive table to view, rank, compare the Buying Power Index for each/all states and metros (MSAs). See the main Web page for more details.

What $100 Buys by Metro: 2014
The following graphic shows patterns of 2014 all items buying power of $100 by metro (MSAs). The color patterns/intervals are shown in the inset legend. Click graphic for larger view. Expand browser to full window for best quality view. Use GIS tools to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CV XE GIS software.
.. click map for larger view and details.

Varying prices by region can be normalized using Regional Price Parities (RPP). The RPP is a weighted average of the price level of goods and services for the average consumer in one geographic region compared to all other regions in the U.S. See more about RPP measures. Using the RPP data, what $100 will buy can be determined by state and metro for the categories of all goods and services, goods, services-rents and other services. See about RPP goods and services types.

In the Boston metro, $100 buys about 90.7 percent of all items goods and services due to the high prices there. $100 in Boston seems more like $90.70 compared to the national average. In the Jefferson City, MO metro, the opposite is true. $100 buys all items goods and services due to lower prices in that metro. $100 in the Jefferson City, MO metro is the equivalent of $121.65 of all items goods and services compared to the national price levels.
• the Boston metro all items buying power index is 90.70
• the Jefferson City, MO metro all items buying power index is 121.65

Interactive Table – Top 10 Metros
The following graphic illustrates use of the Buying Power Index interactive table. This graphic shows the 10 metros that have the all items highest Buying Power Index. Use the interactive table to view/examine areas of interest.

– click graphic for larger view.

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 Quarterly Establishments, Employment & Earnings by Industry

.. data, tools and methods to analyze metro business  patterns and trends .. the most current and comprehensive measures of business activity by county, metro and higher level geography are provided by the Establishments, Employment & Earnings (EEE) database. Use the resources described here to analyze establishments, employment and wages by metro for the most recent quarter and over-the-year change — by quarter 2013 through 2015.  Updated quarterly, the 2016Q1 data become available September 7, 2016. See the related Web section for more details.

These metro by metro EEE datasets are  closely integrated with the metros Situation & Outlook reports. Click a CBSA code in the “Code” column in that table then select related section 6.6. to access/download quarterly data for a metro.

Where Does America Make Things?
The graphic below shows percent employment in the manufacturing sector (employment in the private manufacturing sector as a percent of total private sector employment by county). This view illustrates how the EEE data can be used to develop insights.  Click graphic for larger view providing more detail. Use the GIS tools to analyze similar patterns for any industry. Interpreting this map graphic and alternative data resources … join us in a Data Analytics Lab session where we discuss making and interpreting this map view and alternatives.

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

Two Key Data Resources
1) Use the interactive table in the Web section to example total establishments, employment and wages for any selected MSA and/or in comparison with other MSAs.

2) Download metro quarterly Establishments, Employment & Earnings (EEE) by type of business data. Click a quarterly download link in Section 6.6 for a selected metro (see above note) and download the full 6-digit NAICS detail data for any/all quarters starting with 2013Q1 (CSV structure). These files provide 6-digit NAICS type of business code detail and included columns for :
for the most recent quarter ..
• establishments
• 1st, 2nd, and 3rd month employment
• total wages and average weekly wages
• establishments location quotient
• 1st, 2nd, and 3rd month employment location quotient
• wages and average weekly wages location quotient
for over-the-year change (previous year, same quarter ..
• establishments
• 1st, 2nd, and 3rd month employment
• total wages and average weekly wages
• establishments location quotient
• 1st, 2nd, and 3rd month employment location quotient
• wages and average weekly wages location quotient

Using the Interactive Table
Updated quarterly, use the interactive table in the Web section to view, rank, compare individual metros with other metro. The following graphic shows metros ranked in descending order by 2015Q4 average weekly wages. Columns to the right show over-the-year (2014Q4-2015Q4 in this case) characteristics.

– click graphic for larger view.

Using the Downloaded Data
Access/download quarterly establishments, employment & earnings data by detailed NAICS category using theSituation & Outlook Metro Reports. Select a metro from the interactive table by click a link in the “Code” column. The S&O metro report opens in a new page. In the table of contents, select section 6.6. from the table of contents (Establishments, Employment & Earnings by Detailed Type of Business). See this example for the Chicago metro.  See the related Web section for more details on using the download data files. .

Location Quotients
Pre-computed location quotients are included in the downloadable files. Location quotients (LQ) are ratios (indicators) that measure the concentration of an industry within a specific area (metro in this case) to the concentration of that industry nationwide.

If an employment LQ is equal to 1, then the industry has the same share of its area employment as it does in the nation. An employment LQ greater than 1 indicates an industry with a greater share of the local area employment than is the case nationwide. For example, Las Vegas will have an LQ greater than 1 in the Leisure and Hospitality industry because this industry makes up a larger share of the Las Vegas employment total than it does for the nation as a whole.

Employment LQs are calculated by first, dividing local industry employment by the all industry total of local employment. Second, national industry employment is divided by the all industry total for the nation. Finally, the local ratio is divided by the national ratio.

LQs are provided in the downloadable file for:
a) the reference quarter for each of establishments, employment and wages, and
b) over-the-year change for each of establishments, employment and wages.

Location Quotients will be reviewed in more detail in an upcoming blog post.

Important features of these data
• Tabulated for all counties, metros, states and the U.S.
• Tabulated for detailed types of business (6-digit NAICS).
• Tabulated quarterly and annually, the data enable time-series modeling.
• Employer-based administratively collected data; not estimates.
• Short lag (5 months) between reporting date and date of data accessibility
– data for first quarter 2016 (2016Q1) are available mid-September 2016.

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.

Analyzing ACS 2014 1-Year Supplemental Data

.. examining 2014 characteristics of areas with population 20,000 and over  .. this section summarizes how to use the America Community Survey (ACS2014) “supplemental” data (ACS2014S) to access more current estimates than otherwise available. The America Community Survey “supplemental” data are just that, a supplemental set of ACS 2014 1-year estimates — for areas 20,000 population and over. See the related Web section providing more detail.

The importance of the ACS 2014S data are two fold.
1 – 2014 1-year estimates for a larger number of areas than available from the ACS 2014 1-year (ACS2014) estimates.
2 – more current (2014) data for those areas only available from the 5-year estimates (centric to 2012) that are between 20,000 and 65,000 population.

The ten cities/places with the highest 2014 median family income based on 1-year estimates were all under 65,000 population. These cities were not included in the ACS 2014 1-year standard estimates but were included in the ACS 2014 1-year supplemental estimates. See list below.

This section provides an overview of the ACS 2014 supplemental data and provides a summary of tools, interactive table and GIS project, to analyze characteristics of these areas. These data are used by ProximityOne to develop/update annual county demographic-economic projections. See schedule of related 2016 updates.

Scope of Expanded Geography Available
As shown in the table below, 2014 1-year “supplemental” estimates are available for more than twice as many counties from the ACS2014S compared to the ACS2014 “standard” 1-year estimates. However, there area a more limited set of subject matter data available from the ACS2014S data compared to both the ACS 2014 1-year and 5-year estimates.

MSA/MISA: Metropolitan Statistical Areas/Micropolitan Statistical Areas Counties: county and county equivalent

ACS 2014S Data Availability by County
The following graphic shows the additional counties for which ACS 2014 1-year estimates are available using the “supplemental” data.
• ACS 2014 1-year “standard” estimate counties — blue fill pattern
• ACS 2014 1-year “supplemental” estimate counties — orange fill pattern
• Only ACS 2014 5-year estimates available for remaining counties
Click graphic for larger view; expand browser window for best quality view. The larger view shows metropolitan area (MSA) boundaries. Note that for example, ACS 2014 1 year data are available for all counties in the Austin and San Antonio metros (see pointer) — previously unavailable..

.. view developed with ProximityOne CV XE GIS and related GIS project.
.. any CV XE GIS user can create this view using the default US1.GIS project

ACS2014S Tables — scroll section
The ACS 2014 supplemental data include 42 tables and a total of 229 data items. Br> The table number and descriptions are summarized below.

View full table/item detail in tables shells: ACS 2014S Table shells (xls)

ACS 2014 Selected Supplemental Items for Selected Geography
  — interactive table
The interactive table contains all geography for which the ACS2014S data have been tabulated for these geographies: U.S., state, county, city/place, 114th Congressional District, MSA/MISA, PUMA, urban area and school district. The table provides access to key selected items.

The following graphic illustrates use of the interactive table. First cities/places were selected using the Type drop-down below the table. Next, the table is ranked in descending order on median family income. As shown in the graphic the largest 10 cities/places were under 65,000 population. Click graphic for larger view.

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 by 5-Digit ZIP Code

.. tools to examine housing prices by 5-digit ZIP code and how they are changing .. of the 17,931 5-digit ZIP codes tabulated, 8,074 experienced a decrease in housing value during the period 2010 to 2015. At the same time, 8,672 ZIP code areas experienced an increase in housing value. Housing prices increased for most ZIP codes from 2014 to 2014.  Find out more about housing prices and trends for ZIP codes of interest using tools described here. These data are based on experimental estimates of the Housing Price Index (HPI) by 5-digit ZIP code based in part on home sales price data from Fannie Mae- and Freddie Mac-acquired mortgages. See more about these data.

• Use the interactive table to view, rank, compare the HPI for all 5-digit ZIP code areas tabulated.
• Use GIS tools described here to develop thematic pattern maps; add your own data & geography, select different HPI measures or criteria; zoom to different geographic extents, label and modify colors as desired.

Gaining Insights in Housing Prices, Conditions & Markets
  .. Characteristics, Patterns & Trends
  .. join in .. one hour web session — overview & connectivity details

Patterns of Housing Value Change by ZIP Code: 2010-15
The following graphic shows patterns of housing value appreciation by ZIP Code: 2010-15 for the Houston metro (bold brown boundary). The color patterns/intervals are shown in the inset legend. Data are not available, using the criteria applied (2000 base year), for areas not colored In the larger view (click graphic), ZIP codes are labeled with HPI percent change from 2010 to 2015. Click graphic for larger view. Expand browser to full window for best quality view. Use the GIS tools described here to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CV XE GIS software.
.. click map for larger view and details.

Additional views:
Atlanta area
New York City area
Washington, DC area
Los Angeles area

Examining Recent Trends; Current Estimates & Projections
The interactive table presents annual HPI data 2010 through 2015. A much larger set of these ZIP codes show a negative change between 2010 and 2015 compared to the one year change 2014-2015; The data generally show more ZIP codes experiencing housing value appreciation 2014-2015 compared to the longer period 2010 to 2015. These trends underscore the importance of having more recent data for use in analysis, planning and decision-making. The next update based on transaction data will be May 2017 or later.

ProximityOne uses the HPI transaction data with other data to develop HPI current estimates (2016) and annual projections to 2021 with quarterly updates as a part of the Regional Demographic-Economic Modeling System (RDEMS). Experimental county-up (metro, state, U.S.) and sub-county estimates and projections are planned for the fall 2016 quarterly update. The model based estimates and projections include the number of units by type and value that are added to the housing stock used to compute a variation of the HPI.

Housing Price Index by 5-Digit ZIP Code: 2010-2015
  — Interactive Table
Use the interactive table to examine the Housing Price Index (HPI) by 5-digit ZIP code. The following graphic illustrates use of the table to show the 10 ZIP codes experiencing the largest percentage increase in the HPI from 2014 to 2015. Click graphic for larger view. Examine cities or ZIP code ranges of interest using tools below the table.

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.