Monthly Archives: October 2015

Mapping ZIP Code Demographics

.. there are 26 ZIP codes in the U.S. that have a median housing value in excess of $950 thousand .. find out about the demographics for your ZIP codes of interest .. view ZIP code areas and demographics in context of other geography.

Create custom thematic pattern ZIP code area maps for any area in the U.S. using tools and data described in this section. Use the no fee CV XE GIS software with the associated no fee ZIP Code demographics GIS project and datasets to develop maps for areas of interest. This section provides an overview. See related Web section for step-by-step instructions to get started. These tools and data are not demos. The software and datasets are accompanied by an interactive table in this section. Use the interactive table to view, compare, contrast, rank or query ZIP code areas and associated demographic-economic characteristics. More about ZIP Code areas and data resources.

Median Household Income by ZIP Code Area; Los Angeles Area
Larger view illustrates ZIP code area labeling and use of mini-profile feature

View developed with CV XE GIS software. Click graphic for larger view.

Where are ZIP code areas that meet a certain criteria? The next graphic illustrates use of the tools to develop a 48-state zoom-out view showing ZIP code areas with two selected income intervals.

View developed with CV XE GIS software. Click graphic for larger view.

ZIP Code Demographic-Economic Characteristics — Interactive Table
Use the interactive table in related Web section to view ZIP code characteristics in an interactive tabular format. The following graphic illustrates use of the table to rank ZIP codes in descending order on median housing value (rightmost column). Housing value estimates are top-coded at $1,000,001.

Click graphic for larger view.

Data Analytics Lab Session
Join me in a Data Analytics Lab session. There is no fee. Discuss how tools and methods reviewed in this section can be applied to your situation.

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.

Neighborhood Analysis: Block & Block Group Demographics

.. steps to analyze NYC Chelsea area demographics that can be applied to any neighborhood … demographic characteristics of the Chelsea area in New York City, an area west of Avenue of the Americas between 14th and 34th Streets, is radically different from adjacent areas. This topic was covered in a “great wealth divide” New York Times story. This section reviews how census block and block group demographic-economic data can be used to examine these patterns. A GIS project is used that associates census block and block group data for visual analysis Methods summarized here can be applied to any area. Use the tools described in this section to obtain demographic-economic profiles for any neighborhood based on an address. See related Web page for more detail.

See related post on Most Populated New York City Census Blocks.

Study Area in Context of Broader Area
The study area, a group of selected census tracts, is shown as the red cross-hatched area in context of lower Manhattan in the view below.

  — view created using CV XE GIS and associated GIS Project

Zoom-in View of Study Area
The next view shows a zoom-in to the study area. Block groups are shown with a red boundary. Chelsea Park is visible as the green area above the pointer south of 29th street.

  — view created using CV XE GIS and associated GIS Project

Census Block Demographics in Context of Block Groups
The next view shows a further zoom-in showing census blocks with black boundary and block groups with red boundary. Census blocka are shown with a semi-transparent yellow fill pattern (population greater than 4) and gray fill pattern (blocks with population less than 5). The block group containing Chelsea Park (green area above pointer) contains three census blocks, 2 with no population and one with 1,010 population. Block data are from Census 2010; there are no post-Census 2010 block level demographics available. The analysis could be extended to shown wide-ranging demographics at the block level.

  — view created using CV XE GIS and associated GIS Project

Examining Socioeconomic Attributes
In this further zoom-in, Chelsea Park (green area) is shown near the pointer. Census block population labels are turned off for blocks with 5 or more population to help show a less cluttered view. Block groups are labeled with two values. The yellow upper label shows the median housing value (MHV). The green lower label shows median household income (MHI). Both data items are based on the American Community Survey 5-year estimates (ACS 2013) are centric to 2011. The ACS data are updated annually; as of October 2015, the latest data are from ACS 2013; the ACS 2014 data become available December 2015. The ACS 2013 5 year estimates are top-coded at $1,000,001 for MHV and $250,001 for $MHI.


  — view created using CV XE GIS and associated GIS Project

The block group containing Chelsea Park has a median household income of $26,440; the median housing value estimate is not available (too few owner-occupied units to develop MHV estimate). The Chelsea Park block group code is “360610097002” — this code uniquely identifies this block group among all other block groups in the U.S.

The block group immediately to the south of the Chelsea Park block group median household income of $21,750; the median housing value estimate is $1,000,001 (top-coded). The code for this block group code is “360610093006”.

While the MHI for BG 360610093006 might seem like it should be higher, a look at the number of households by income interval explains this number. Almost half of the households in the BG have a household income below $20,000. Analytical options that might be considered include using mean household income or mean family income instead of median.

Compare number of households by household income intervals for these two block groups.

Compare Your Block Group of Interest to Chelsea Park BG
Compare the above BG attributes to any BG of interest:
1. Copy and paste this string into text editor (eg, Notepad) window (do not press enter after paste):
http://factfinder.census.gov/bkmk/table/1.0/en/ACS/13_5YR/B19001/1500000USXXXXXXXXXXX|1500000US360610097002

2. Click here, key in an address then click Find to locate the 11 character BG code.
— scroll down to “2010 Census Blocks” and then further to “GEOID”
— copy the first 11 digits of the GEOID value to clipboard see illustrative graphic.

3. Paste those 11 characters into the URL, replacing the “XXXXXXXXXXXX”; this modification must be exact.

4. Press Enter. A profile appears comparing your BG to the Chelsea Park BG 360610097002.

Data Analytics Lab Session
Join me in a Data Analytics Lab session. There is no fee. Discuss how tools and methods reviewed in this section can be applied to your situation.

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.

World Statistics Day & Statisticians

Official statistics help decision makers develop informed policies that impact millions of people. Improved data sources, sound statistical methods, new technologies and strengthened statistical systems enable better decisions that eventually result in better lives for all of us. World Statistics Day was proclaimed by the United Nations General Assembly in 2010 to recognize the importance of statistics in shaping our societies. October 20, 2015 marks the day around the world in over 100 countries.

More than 200 countries have national statistical agencies. Most countries have a central statistical agency. The Federal statistical system of the U.S. is highly decentralized and includes more than 120 agencies. This structure works well for the U.S. aside from certain redundancies and issues regarding public data access and use. See more about Navigating the Federal Statistical System.

Locations of America’s Largest Businesses
Statisticians collect and tabulate data about people, businesses and other entities that then enable the development of visual analysis of these data such as shown in the following graphic. This graphic shows locations of America’s largest businesses. Actuaries, economists, epidemiologists — wide-ranging occupations — develop statistical data often blurring the roles and functions between occupations.

— view created using CV XE GIS and associated GIS Project
— click graphic for larger showing details.

Statisticians in the U.S.
Statisticians use statistical methods to collect and analyze data and help solve real-world problems in business, engineering, the sciences, or other fields. Statisticians are a part of the fast growing science, technology, engineering and math (STEM) workforce. Occupationally, statisticians are classified as part of the “Mathematical Science Occupations”, a part of the “Computer and Mathematical Occupations” group. The typical level of education that most workers need to enter this occupation is a Master’s degree.

The Bureau of Labor Statistics (BLS) estimates there are 26,970 statisticians (Occupational Employment Statistics-OES) in the U.S. with median annual wages $79,990 (May 2014). 4,190 of these statisticians are in the U.S. government Federal Executive Branch. Among metropolitan areas, the Washington, DC metro (metropolitan division) has more than twice the employment level of any other metro.

Based on data from the OES, states with the highest statistician employment levels include Maryland (2,910), California (2,680), Massachusetts (2,310), Pennsylvania (1,990) and New York (1,280). Using a base of 27,600 employment in 2012, BLS projects this occupation will grow to 35,000 (27%) by 2022. Probably low.

The OES is an establishment-based survey. The Census Bureau conducts the American Community Survey (ACS), a household survey, that also produces annual estimates of statisticians. The ACS 2014 estimated number of statisticians is 32,115 (full-time, year-round civilian employed population 16 years and over) with a median income of $83,461. The Census Bureau does not produce occupational projections.

Many statisticians remain heavily engaged in the field of statistics and data analytics through their careers but become identified in managerial and multi-occupational activities as their career advances.

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.

Analyzing Competitive Position: Trader Joe’s & Whole Foods

.. at $3.99 for Triple Ginger Snaps, it doesn’t seem that you can go wrong … this is a Trader Joe’s product that is configured correctly, priced right, conveniently available and positioned as part of a related broader mix of products (how about Dark Chocolate Covered Caramels at $3.99?). Product attributes are one element that need to be considered in business data analytics.

Business Data Analytics can help any business more effectively reach goals and objectives. Whether a new or established business, serving a county or national market, similar tools and methods apply. This section illustrates GIS views taken from the associated GIS project and datasets. These analytical depictions can be developed for any organization and facilitate strategic planning and decision-making.

Trader Joe’s & Whole Foods
Here we take a look at Trader Joe’s and Whole Foods stores in context of GIS analyses and market characteristics.  The following graphic shows Trader Joe’s and Whole Foods locations in the Washington, DC area.

— view created using CV XE GIS and associated Business Patterns GIS Project
— click graphic for larger showing details.

Trader Joe’s & Whole Foods on a National Scale
How do the competitive relationships look on a national scale? See the comparison graphics below. Using GIS project and tools, show the Trader Joe’s location above the Whole Foods layer — or vice-versa. Using the GIS project and tools, zoom into any location.

Trader Joe’s layer shown above Whole Foods layer

Whole Foods layer shown above Trader Joe’s layer

Market Characteristics — Higher Income Households
Back to the DC area … the following graphic shows patterns of the number of households by tract with a household income of $200,000 or more. The number of households having $200,000 and higher household income intervals/color correspondence shown in legend at left of the map. Using GIS data and tools, ranges can be customized/shifted to suit. Similarly, the number of households by different income levels can be set. Select from hundreds of relevant subject matter items.

— view created using CV XE GIS and associated Business Patterns GIS Project
— click graphic for larger showing details.

Helping Your Organization Thrive
  — Enhancing Your Data Analytics Skills

Join me at the upcoming Business Data Analytics Workshop to be held in Alexandria, VA on December 1, 2015. Get experience with computer hands-on data and data analytics tools and methods. Network with peers having similar interests. Register here.

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.

Congressional District Incumbents by Location; Income & Housing Value

.. examining patterns/characteristics of 114th Congress incumbents and congressional districts … in 2014, the median family income among all 114th Congressional Districts ranged from $27,410 (NY15) to $136,376 (CA33). How do districts of interest compare? How are income and housing value among these districts changing? Use the interactive table in this section to query, view, rank, compare demographic-economic attributes among the 114th Congressional Districts. Where are incumbents located within their district? View incumbent locations and attributes in context patterns/characteristics of congressional districts using GIS tools and data. See details below. See related Web section with interactive ranking table by incumbent with district attributes.

2014 Median Household Income by 114th Congressional District
The following graphic illustrates use of the ACS 2014 data to develop a thematic pattern map of median household income by 114th Congressional District. This graphic makes use of one subject matter item among hundreds of ACS subject matter items tabulated. Click graphic for larger view showing legend and mini profile example.

— view developed using CV XE GIS software and related GIS project.
— see details for information about the data used to develop the above view.
— click graphic for larger view with county overlay.
    … larger view illustrates mini-profile for CD Missouri 04 (see pointer in map).

114th Congressional District Members by Location & Party
— showing incumbents as markers by party
Republicans as blue square markers; Democrats as red circular markers.
114th Congressional Districts with patterns of 2014 median family income.

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

Hard Line Republicans
Incumbents are shown as hard line republicans (red square markers) and other incumbents (yellow circle markers). Incumbent locations (city-state) were geocoded enabling the view of incumbents by their city-state location. It is easy to see in the map view that there are no Hard Line Republican Incumbents (HLRIs) in California. Click graphic for larger view showing legend and mini profile example.

— view developed using CV XE GIS software and related GIS project.
— see details for information about data used to develop the above view.
— click above graphic for larger view with county overlay.
    … larger view illustrates mini-profile for Houston district (see pointer in map).

See main Congressional Districts page and Analyzing Characteristics of 113th/114th Congressional Districts section.

Join us in a Data Analytics Lab session to explore use of these resources and how to link/analyze these data in context of other data.

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.

Housing Price Index Metro & State Trends

.. HPI quarterly update … use the Housing Price Index (HPI) to examine quarterly or annual housing value appreciation by metro or state. How is housing value appreciation changing among metros of interest? The HPI is calculated in part using home sales price information from Fannie Mae- and Freddie Mac-acquired mortgages. The U.S. HPI all transactions, non-seasonally adjusted, value increased by 5.25 percent from 2014Q2 to 2015Q2. During this period the Sebastian-Vero Beach, FL MSA experienced the highest rate of housing value appreciation among all metros.

Use the interactive table to compare and contrast HPI quarterly data for/among all metropolitan statistical areas, states and the U.S. Use the GIS tools and data resources reviewed below to visually examine and map these data. See related Web section for more detail.

Visual Analysis of 2014Q2-2015Q2 HPI Patterns
The following graphic shows housing value appreciation 2014Q2-2015Q2 by metro based on the HPI.

– click graphic for larger view and details; view developed using CV XE GIS.
Use the HPI GIS project with CV XE GIS software; create different views.
– view/analyze different HPI measures; zoom-in; add labels.
– apply queries; add other geography/data.
– create views/graphics for reports and stories.

HPI Metro & State Patterns Interactive Table
Use the 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 the start-up view of the table. The blue highlighted value shows the U.S. national annual change 2014Q2 to 2015Q2.

– click graphic for larger view

Ranking Metros
The following graphic illustrates how the table can be used to 1) select only metros and 2) rank metros in descending order based on annual change 2014Q2-2015Q2. The Sebastian-Vero Beach, FL MSA experienced the highest rate of housing value appreciation among all metros.

– click graphic for larger view

Data Analytics Lab Web Sessions
The HPI provides one part of a larger picture of demographic-economic conditions and trends. Join me in Data Analytics Lab sessions where we explore the mechanics of making the HPI thematic pattern view shown above. Examine the process of integrating other data. Create variations of this view or entirely different visual analysis GIS projects.

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.

Researcher & Story Development Tools & Resources

Innovative and results-oriented story writing often requires geographic, demographic, economic and related data. Research results and stories must increasingly use graphics and visual renderings of data  to be effective, retain reader attention and be responsive to needs. A picture is worth a thousand words. In our expanding everything-integrated world, stories must draw on a range of authoritative data resources that can be knit-together.

Journalists and authors require easy and access to these data in a consumable form. Researchers and students share these needs. Grant writers benefit by including relevant data in proposals and well as unique maps and graphics. Economists and analysts creating interpretative summaries of statistical data releases (“how does this impact us?”) require related data and tools to effectively communicate conclusions and inferences.

This section reviews access to a few of these tools and resources that are available to researchers and story writers — as well as tools to map and otherwise visualize these data. These resources offer the customization or specific detail often not available to meet specific needs. Most of the resources reviewed here are available at no fee. Some resources are available only to ProximityOne User Groupmembers. Join the User Group now. See terms of use. See related Web section.

Navigating the Federal Statistical Resources
… topics below include these and a broader set of resources.
http://proximityone.com/fss.htm

Interactive Geographic-Demographic-Economic Tables
… view, query, rank, compare attributes for many types of geography.
http://proximityone.com/rankingtables.htm

Interactive Location-Based Demographic-Economic Data Tool
… key in address, immediate display of ACS demographic-economic data.
… block group, tract, place, county, state data; latitude-longitude, geocodes.
http://proximityone.com/location_based_demographics.htm

Custom Mapping Tools (Windows software tool)
… create custom maps for proposed service areas.
CV XE GIS

Address Code Your Data (Windows software tool)
… show your address/location data on maps.
http://proximityone.com/apigeocoder.htm

Chart Graphics; Population Pyramids (Windows software tool)
… age-cohort chart graphics for your county or school district.
http://proximityone.com/chartgraphics.htm

Demographic-Economic Data Extraction Tool (Windows software tool)
… use this API-tool to extract your selected subject matter data.
… census block, block group, other geographic levels
… Census 2000, Census 2010, ACS 2010, 2011, 2012, 2013
… create your own files for use with Excel/other software.
http://proximityone.com/dede.htm

Custom maps can enhance your proposal; make custom map graphics:

Make Custom Congressional District Maps
… create custom maps for individual or custom grouped congressional districts.
… CD 113 and CD 114 boundaries are the same, based on maps submitted by states to the Census Bureau.
http://proximityone.com/cd113_maps.htm

Make Custom City Maps
… create custom maps for cities of interest; examine in context of other geography.
http://proximityone.com/citymaps.htm

Make Custom Metro Maps
… create custom maps for metropolitan or micropolitan statistical areas.
http://proximityone.com/metromaps.htm

Make Custom Neighborhood Maps
… create thematic/pattern maps; access related demographic-economic data by neighborhood.
http://proximityone.com/neighborhood_patterns.htm

Make Custom Block Group Maps
… create custom maps for small, sub-neighborhood areas.
http://proximityone.com/mapping_bg.htm

Make Custom Census Block Maps
… create custom maps for areas by census block – smallest geographic area with detailed demographics.
http://proximityone.com/mapping_census_blocks.htm

America’s Communities Program
… demographic-economic profiles for individual cities.
http://proximityone.com/acp.htm

School District Community Profiles
… demographic-economic multi-part profiles for individual school districts.
http://proximityone.com/sddep.htm

School District Characteristics
http://proximityone.com/sddmi.htm

K-12 Public Schools Characteristics – individual and all schools
http://proximityone.com/k12publicschools.htm

K-12 Private Schools Characteristics – individual and all schools
http://proximityone.com/k12privatecchools.htm

Charter Schools Characteristics & Patterns – individual and all schools
http://proximityone.com/sch1314_charter.htm

County Population Trends; Annual Projections to 2020 by Age Group
… population trends profiles for individual counties … how is school age population changing? 65 & over?
http://proximityone.com/outlook2020.htm
most recent county official estimates – click link in table
county trend profile – example for Cook County, IL; all counties available

Metropolitan Area Characteristics
… geographic & demographic composition profiles for individual metros.
Current Vintage Metropolitan Areas
2015 Updates: New and Modified Metros
Metropolitan Area Median Income and Housing Value: 2013-14

State Legislative District Characteristics
… geographic & demographic composition profiles for individual state legislative districts.
http://proximityone.com/sld2013.htm

Congressional District Characteristics
… geographic & demographic composition profiles for individual congressional districts.
http://proximityone.com/cd113.htm
114th Congressional Districts: Median Income and Housing Value: 2013-14

Census Tract Demographic-Economic Patterns
Main Census Tracts section interactive tables includes all tracts:
General Demographics | Social Characteristics | Economic Characteristics | Housing Characteristics

ZIP Code Demographic-Economic Patterns
Main ZIP Code section … interactive tables include all ZIP code areas:
General Demographics | Social Characteristics | Economic Characteristics | Housing Characteristics

More about ProximityOne Demographic-Economic Projections
Outlook 2020 | Outlook 2030 | Outlook 2060 | Quarterly 3 year
• integrated multi-sourced Situation & Outlook demographic-economic data

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.