Category Archives: American Community Survey

Examining Houston Metro Demographic-Economic Characteristics

.. tools & data to examine metro demographic-economic characteristics .. this Houston, TX metro focused section is one of several similar metro sections that will be covered in weeks ahead.  Each metro-focused section provides a summary of tools and data that can be used to view, rank, compare, analyze conditions and trends within the metro and this metro relative to other metros, regions and the Nation.  The ready-to-use GIS project/datasets provide the basis for extended data/geographic views and analysis immediately.  See more detail about topics covered in this related Web section.

Relating your data to demographic-economic characteristics and trends in a region involves more than information provided by a report or set of statistical tables. It is important to use your data to be able to identify areas of missed opportunity and competitive position. It is important to have a “10,000 foot” view as well as understanding individual neighborhoods and market/service areas. Geographic Information System (GIS) tools, with the right set of geographic, demographic and economic data can facilitate decision-making through the use of visual and tabular data analytics.

This section provides information on installing and using the Houston Metro Demographic-Economic GIS software and project/datasets. This same scope of data, tools and operation is available for any metro, state or combination.

10,000 Foot View
The following graphic shows patterns of median household income by census tract for the Houston metro area. This is the start-up view when using the GIS tools and data described below. The color patterns/intervals are shown in the highlighted layer in legend at left of map window. Use the GIS tools described below to develop thematic pattern maps for a range of data and criteria.

.. view developed using the CVGIS software.

See more about census tracts; see tracts main page.

Several additional views follow, developed using this same GIS project. These views illustrate different levels of geographic granularity and patterns of different subject matter.

Median Household Value by Block Group
See more about block groups; see block groups main page.

.. view developed using the CVGIS software.

Population/Housing Unit by Block
See more about census blocks; see census block main page.

.. view developed using the CVGIS software.

Zoom-in to Sugarland/Fort Bend County
See more about cities/places; see cities/places main page.
Access data for any city using interactive table.

.. view developed using the CVGIS software.

Further Zoom-in Showing Street/Road Detail
See more about streets.

.. view developed using the CVGIS software.

Additional Information
See the related Houston metro Situation & Outlook Report.

Using the GIS Software and Project/Datasets
(requires Windows computer with Internet connection)
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… requires UserID; take all defaults during installation
2. Download the Houston Metro GIS project fileset
… requires UserID; unzip Houston Metro GIS project files to local new folder c:\p1data
3. Open the c:\p1data\us1_metros_houston.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\p1data\us1_metros_houston.gis
4. Done. The start-up view is shown above.

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.

115th Congressional Districts: Analysis and Insights

.. interpretative data analytics; tools, data & methods ..  this section is focused on 115th Congressional District geographic, demographic and economic patterns and characteristics. Use tools and data reviewed here to examine/analyze characteristics of one congressional district (CD) or a group of CDs based on state, party or other attribute. Use the GIS resources described here for general CD reference/pattern/analytical views, to examine current demographics and demographic change and for redistricting applications. See this related Web section for more details.

Examining the 115th Congressional Districts
• the 115th Congress runs from January 2017 through December 2018.
• FL, MN, NC, VA have redistricted since the 114th CD vintage;
  .. some 115th CDs have new boundaries compared the 114th CDs.
• view, rank, compare CDs using the interactive table.
  .. table uses ACS 2015 data for 115th CDs & include incumbent attributes.
  .. examine districts by party affiliation.
• use these more detailed 114th CD interactive tables
  .. data based on 2015 American Community Survey – ACS 2015.
  .. corresponding data for the 115th CDs from ACS 2016 available Sept 2017.
• use the new GIS project including 114th & 115th CDs described below.
  .. create CD thematic and reference maps;
  .. examine CDs in context of other geography & subject matter.
• join us in the April 25 Data Analytics Lab session

Visual Analysis of Congressional Districts
The following views 1) provide insights into patterns among the 115th CDs and 2) illustrate how 114th to 115th geographic change can be examined. Use CV XE GIS software with the GIS project to create and examine alternative views.

Patterns of Household Income by 115th Congressional District
The following graphic shows the patterns of the median household income by 115th Congressional District based on the American Community Survey 2015 1-year estimates (ACS2015). The legend in the lower left shows data intervals and color/pattern assignment

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

Charlotte NC-SC Metro Area
  – with 114th/115th Congressional District 12

The following graphic shows North Carolina CD 12 with 114th boundary (blue) and 115th boundary (pale yellow) and Charlotte metro bold brown boundary. Click graphic for larger view with more detail. Expand browser window for best view.

.. view developed using the CVGIS software.

• View zoom-in to Charlotte city & Mecklenburg County.

115th Congressional District Interactive Table
Use the interactive table to examine characteristics of one congressional district (CD) or a group of CDs. The following graphic illustrates use of the interactive table. First, the party type was selected, Democratic incumbents in this example. Next, the income and educational attainment columns were selected. Third, the set of districts were sorted on median household income. It is quick and easy to determine that CA18 has the highest median household income and that the MHI is $1,139,900. Try using the table to examine districts 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.

County 5-Year Trends: Income & Income Inequality

.. tools and data to examine how the U.S. by county household income and income inequality are changing … how is household income changing in counties of interest? What are the trends; what is causing the change? What are the characteristics of income inequality and how is it changing? How might this change impact your living environment and business?

This section provides access to tools and data to examine U.S. by county measures of household income and income inequality between two 5-year periods (2006-10 and 2011-2015). These data can provide insights into how household income and income inequality are changing for one county, a group of counties and the U.S. overall. Use the interactive table to view median household income and measures income inequality for all counties. See more detail about these topics here. Measures of income inequality can be estimates/examined using the Gini Index.

The Gini Index & Measuring Income Inequality
The Gini Index is a dimensionless statistic that can be used as a measure of income inequality. The Gini index varies from 0 to 1, with a 0 indicating perfect equality, where there is a proportional distribution of income. A Gini index of 1 indicates perfect inequality, where one household has all the income and all others have no income.

At the national level, the 2015 Gini index for U.S. was 0.482 (based on 2015 ACS 1-year estimates) was significantly higher than in the 2014 ACS Index of 0.480 (based on 2014 ACS 1-year estimates). This increase suggests that income inequality increased across the country.

Examining Household Income & Income Inequality Patterns & Change
The following two graphics show patterns of the GIni Index by county. The first view is based on the American Community Survey (ACS) 2010 5-year estimates and the second is based on the ACS 2015 5-year estimates. The ACS 2010 estimates are based on survey respondents during the period 2006 through 2010. The ACS 2015 estimates are based on survey respondents during the period 2011 through 2015. One view compared with the other show how patterns of income inequality has changed at the county/regional level between these two 5-year periods.

Following these Income Inequality views are two corresponding views of median household income; using data from ACS 2010 and ACS 2015. Use CV XE GIS software with the GIS project to create and examine alternative views.

Patterns of Income Inequality by County; ACS 2010
The following graphic shows the patterns of the Gini Index by county based on the American Community Survey 2010 5-year estimates (ACS1115). The legend in the lower left shows data intervals and color/pattern assignment

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

Patterns of Income Inequality by County; ACS 2015
The following graphic shows the patterns of the Gini Index by county based on the American Community Survey 2015 5-year estimates (ACS1115). The legend in the lower left shows data intervals and color/pattern assignment

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

Patterns of Economic Prosperity by County; ACS 2010
The following graphic shows the patterns of median household income ($MHI) by county based on the American Community Survey 2010 5-year estimates (ACS1115). The legend in the lower left shows data intervals and color/pattern assignment

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

Patterns of Economic Prosperity by County; ACS 2015
The following graphic shows the patterns of median household income ($MHI) by county based on the American Community Survey 2015 5-year estimates (ACS1115). The legend in the lower left shows data intervals and color/pattern assignment

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

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.

Creating Custom School District Maps

…tools & data to map & geospatially analyze school districts. Ready-to-use state-by-state GIS projects may be downloaded enabling you to view and create custom maps almost instantly. Benefit from the power of using GIS software to perform tasks not available on Web-based mapping options. Use the latest school district and related shapefiles. See more information about using these resources in this related Web section.

Federal Revenue per Student by School District
Create views similar to the one shown below. Optionally combine layers as illstrated here by showing four Texas metros.

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

Extending Reference and Analytical Possibilities

Texas by School District
Examine reference maps at the state, regional or local level. Optionally combine with roads/streets and other layers.

Patterns of Economic Prosperity by School District
Select from many ready-to-use demographic-economic subject matter items to create custom pattern views.

Drill-down — Houston Metro Area by School District
Zoom-in to a school district of interest. Set attributes of district as shown here.

County/School District
Visually examine the boundaries or school districts and counties. This view shows Harris County, TX area; select a county of interest.

Drill-down to Street Level
Add road/street and other layers. Drill-down within Fort Bend ISD, Houston metro, showing general earth surface features with streets layers. Mouse used to click on street (see pointer) and display mini-profile of street segment attributes.

Use for Analysis, Reference or in the Classroom
Schools and teachers: consider using these resources for classroom use. Familiarize students about how GIS resources can be used with a minimum of learning time and no cost. Enable students to use their own geography and adapt that learning to more general geography. See related Mapping Statistical Data ready-to-use GIS projects.

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.

Tools to Analyze County Demographic-Economic Characteristics

.. demographic-economic characteristics of counties are essential for business development, market analysis, planning, economic development, program management and general awareness of patterns and trends. This section provides access to data and tools to examine these data for all counties in the U.S. This annual update includes geographic area characteristics based on ACS 2015 data.  The tools/data are organized into four related sections summarized below.

1. General Demographics
View interactive table at http://proximityone.com/us155dp1.htm
Patterns of School Age Population by County
Use GIS tools to visually examine county general demographics as illustrated below. The following view shows patterns of percent population ages 5 to 17 years of age by county — item D001-D004-D018 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

2. Social Characteristics
View interactive table at http://proximityone.com/us155dp2.htm 
Patterns of Educational Attainment by County
– percent college graduate
Use GIS tools to visually examine county social characteristics as illustrated below. The following view shows patterns of percent college graduate by county — item S067 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

3. Economic Characteristics
View interactive table at http://proximityone.com/us155dp3.htm 
Patterns of Median Household Income by County
Use GIS tools to visually examine county economic characteristics as illustrated below. The following view shows patterns median household income by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

4. Housing Characteristics
View interactive table at http://proximityone.com/us155dp4.htm 
Patterns of Median Housing Value by County
Use GIS tools to visually examine county housing characteristics as illustrated below. The following view shows patterns median housing value by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

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.

America’s Cities: Demographic-Economic Characteristics Annual Update

.. tools and data to interactively examine demographic-economic characteristics of America’s 29,321 cities/places .. understanding demographic-economic characteristics of cities and places is essential for business development, market analysis, planning, economic development, program management and general awareness of patterns and trends. This section provides access to data and tools to examine characteristics of all cities/places in the U.S. This annual update includes data for 29,321 cities/places based on ACS 2015 data.

Accessing the Data; Using Interactive Tables
Each of the four links below opens a new page providing access to U.S. by city/place interactive tables — by type of subject matter. Use tools and usage notes below table to select operations to perform queries, sort and select columns.
General Demographics
Social Characteristics
Economic Characteristics
Housing Characteristics

How the the Tables/Data Can be Used
The following table shows data derived from the Economic Characteristics table. The top 10 cities/places having the highest median household income ($MHI) are shown. The table also shows population, median family income ($MFI) and per capita income ($PCI). The $250,000 value is a cap; the actual value is $250,000 or higher. Use the interactive tables to create similar views for states of interest. Use the button below the table to select/view cities within a selected metro. Compare attributes of cities of interest to a peer group based on population size.

Visual Analysis of City/Place Population Patterns
Use GIS resources to visually examine city/place demographic-economic patterns. The following view shows patterns of population percent change by city in the Charlotte, NC-SC metro area.

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

Related Data
Cities/Places Main Section
Citie Population Estimates & Trends, 2010-15

More About Using These Data
Using ACS 1-year and 5-year data

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.

Developing Geographic Relationship Data

.. tools and methods to build and use geographic relationship files … which census blocks or block groups intersect with one or a set of school attendance zones (SAZ)? How to determine which counties are touched by a metropolitan area? Which are contained within a metropolitan area? Which pipelines having selected attributes pass through water in a designated geographic extent? This section reviews use of the Shp2Shp tool and methods to develop a geographic relationship file by relating any two separate otherwise unrelated shapefiles. See relasted Web page for a more detiled review of using Shp2Shp.

As an example, use Shp2Shp to view/determine block groups intersecting with custom defined study/market/service area(s) … the only practical method of obtaining these codes for demographic-economic analysis.

– the custom defined polygon was created using the CV XE GIS AddShapes tool.

Many geodemographic analyses require knowing how geometries geospatially relate to other geometries. Examples include congressional/legislative redistricting, sales/service territory management and school district attendance zones.

The CV XE GIS Shape-to-Shape (Shp2Shp) relational analysis feature provides many geospatial processing operations useful to meet these needs. Shp2Shp determines geographic/spatial relationships of shapes in two shapefiles and provides information to the user about these relationships. Shp2Shp uses the DE-9IM topological model and provides an extended array of geographic and subject matter for the spatially related geometries. Sh2Shp helps users extend visual analysis of geographically based subject matter. Examples:
• county(s) that touch (are adjacent to) a specified county.
• block groups(s) that touch (are adjacent to) a specified block group.
• census blocks correspond to a specified school attendance zone.
• attributes of block groups crossed by a delivery route.

Block Groups that Touch a Selected Block Group
The following graphic illustrates the results of using the Shp2Shp tool to determine which block groups touch block group 48-85-030530-2 — a block group located within McKinney, TX. Shp2Shp determines which block groups touch this block group, then selects/depicts (crosshatch pattern) these block groups in the corresponding GIS map view.

Geographic Reference File
In the process, Shp2Shp creates a geographic relationship file as illustrated below. There are six block groups touching the specified block group. As shown in the above view, one of these block groups touches only at one point. The table below (derived from the XLS file output by Shp2Shp) shows six rows corresponding to the six touching block groups. The table contains two columns; column one corresponds to the field GEOID from Layer 1 (the output field as specified in edit box 1.2 in above graphic) and column 2 corresponds to the field GEOID from Layer 2 (the output field as specified in edit box 2.2 in above graphic). The Layer 1 column has a constant value because a query was set (geoid=’480850305302′) as shown in edit box 1.3. in the above graphic. Any field in the layer dataset could have been chosen. The GEOID may be used more often for subsequent steps using the GRF and further described below. It is coincidental that both layers/shapefiles have the field named “GEOID”.

Layer 1 Layer 2
480850305302 480850305272
480850305302 480850305281
480850305302 480850305301
480850305302 480850305311
480850305302 480850305271
480850305302 480850305312

Note that in the above example, only the geocodes are output for each geography/shape meeting the type of geospatial relationship. Any filed within either shapefile may be selected for output (e.g., name, demographic-economic field value, etc.)

How it Works — Shp2Shp Operations
The following graphic shows the settings used to develop the map view shown above.

See related section providing details on using the Shp2Shp tool.

Geographic Relationships Supported
The Select Relationships dropdown shown in the above graphic is used to determine what type of spatial relationship is to be used. Options include:
• Equality
• Disjoint
• Intersect
• Touch
• Overlap
• Cross
• Within
• Contains
See more about the DE-9IM topological model used by Shp2Shp.

Try it Yourself

See full details on how you can use any version, including the no fee versin, of CV XE GIS to use the Shp2Shp tools. Here are two examples what you can d. Use any of the geospatial relatoinships. Apply your own queries.

Using Touch Operation
Select the type of geographic operation as Touch. Click Find Matches button. The map view now shows as:

Using Contains Operation
Click RevertAll button. Select the type of geographic operation as Contains. Click Find Matches button. The map view now shows as:

Relating Census Block and School Attendance Zones
The graphic shown below illustrates census blocks intersecting with Joyner Elementary School attendance zone located in Guilford County Schools, NC (see district profile). The attendance zone is shown with bold blue boundary. Joyner ES SAZ intersecting blocks are shown with black boundaries and labeled with Census 2010 total population (item P0010001 as described in table below graphic). Joyner ES is shown with red marker in lower right.


– view developed using CV XE GIS and related GIS project; click graphic for larger view

See more about this application in this related Web section.

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.