Category Archives: Census 2010

Congressional District & State Legislative District Data Analytics

.. updates on tools, data resources and methods to analyze congressional districts and state legislative districts. Join the Congressional District/State Legislative District Group to receive updates. See details.

Visual Analysis of 115th CDs & 2016 Cycle SLDs
Topeka, KS metro and Kansas State House Districts

Topeka, KS metro: bold brown semi-transparent boundary
115th Congressional Districts: bold orange boundary.
State house districts: black boundary; yellow label showing code.
Topeka city: green fill pattern (entirely with in 115th CD KS02)

See related Web section with more detail.

Analyzing Congressional Districts & State Legislative Districts
– in context of other geography
Illustrative GIS views of examining CDs & SLDs in context
using GIS tools and data

New ACS 2016 1-Year Demographic-Economic Estimates
– American Community Survey 2016 (ACS2016) data for each 115th CD
– Released 9/14/17
… upcoming … interactive tables using these data
… similar to ACS2015 interactive tables

New 115th CD & 2016 SLD Shapefiles
– New 2017 TIGER/Line shapefiles to be released in September
– See about related 2016 vintage data
– These shapefiles may be used with most any GIS software
… map the most current CDs/SLDs in context with other geography

New 115th CD & 2016 SLD Equivalence File
– Flat files with a record for each intersecting SLD and CD
– Developed by ProximityOne; available October 2017
– Functionally similar to relating ZIP codes to census tracts

New Census 2010 Summary File 1 Data for 115th CDs & 2016 SLDs
– Updated Census 2010 Summary File 1 data
– Provides Census 2010 demographic data for 115th Congressional Districts
– Expected October 2017

Ahead in December
– Demographic-economic data for each 2016 cycle state legislative district
– Based on American Community Survey 2016 5-year estimates (ACS1116)
– See related SLD 2014 main page

Related sections & Resources
115th Congressional Districts interactive table with incumbent details
Making Custom 115th CD maps and geospatial analysis
– Congressional Districts main page — http://proximityone.com/cd115.htm

CD & SLD Data Analytics
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.

Important Upcoming Data Releases: September 2017

.. monthly updates on recent & upcoming data analytics tools & resources .. this section provides a monthly update on important new data developments and applications/developments to further their use in data analytics. A focus of this section is on new or revised geographic, demographic and economic data. Most of these data are used to develop and update ProximityOne census tract-level up demographic-economic projections to 2022 and county-level up population by single year of age projections to 2060. See about September projection updates below on this page. This section is organized into recent past data updates and upcoming (month ahead) data releases and may be updated to reflect new or extended details. See related news and updates:
• What’s New daily updates
• Situation & Outlook Calendar

See related Web section.

Recent Past Data Releases/Access

U.S. by Census Tract 2017 HMDA Low & Moderate Income (FFIEC)
• Release date — 8/17; next update — mid 2018
• 2017 annual HMDA data — covers all income levels not only LMI
• New 2017 HMDA data
• See more information – access data.

U.S. by County Population by Single Year of Age (NCHS)
• Release date — 8/22/17; next update — mid 2018
• 2010 through 2016 annual population by single year of age
• New 2016 data extending annual series 2010 forward
• See more information – access updates.

Housing Price Index (FHFA)
• Release date — 8/22/17; next update — 11/28/17
• Quarterly HPI
• New 2017Q2 data extending quarterly time series.
• See more information – access updates.

Quarterly Gross Domestic Product by State (BEA)
• Release date — 9/20/17; next update — 11/21/17
• Quarterly GDP by Industry
• New 2017Q1 data extending quarterly time series.
• See more information – access data.

Upcoming Data Releases/Access 

2017 TIGER Digital Map Database (Census)
• Expected ~ 9/7/17
• Topologically Integrated Geographic Encoding & Referencing (TIGER) data.
• Geographic data; predominately shapefiles.
.. intersection to intersection road segment geography and attributes.
• New 2017 GIS/mapping shapefiles for use with wide-ranging data
.. including with Census 2010, ACS 2016 & other subject matter.
• See more information – updates to access summarized in that section.

Census of Employment and Wages (BLS/CEW)
• Release date — 9/6/17; next update — 12/5/17
• AKA ES-202 data — establishments, employment & wages by NAICS code/type of business
• U.S. by county.
• New 2017Q1 data extending quarterly time series.
• See more information.

2016 American Community Survey 1-year estimates (Census/ACS)
• Release date — 9/14/17
• Wide-ranging demographic-economic data for areas having population 65,000+
.. all states, CDs, PUMAs, MSAs and larger cities/CBSAs/school districts/counties (817 of 3142)
• New 2016 estimates.
• See more information – updates to access summarized in that section.

SY 2015-16 Annual School & School District Characteristics (NCES)
• Expected ~ 9/14/17
• National school school & school district characteristics.
• New 2015-16 school year administratively reported data.
• Schools … see more information – access updates.
• School District … see more information – access updates.

2016 Annual Gross Domestic Product by Metro (BEA)
• Release date — 9/20/17
• GDP by Industry by Metro
• New 2016 data extending time series
• See more information – access updates.

Census Tract Estimates and Projections to 2022 — ProximityOne
• Release data ~ 9/27/17
• National census tract and higher level geography demographic-economic updates
• Annual estimates & projections; 2010 through 2022
• Updated to reflect/integrate data released through 9/2017 as summarized above   • See more information.

County Population by Single Year of Age Projections to 2060 — ProximityOne
• Release data ~ 9/27/17
• National county and higher level geography demographic updates
• Annual estimates & projections; 2010 through 2060
• Updated to reflect/integrate data released through 9/2017 as summarized above.   • See more information.

Notes [goto top]
– BEA – Bureau of Economic Analysis
– BLS – Bureau of Labor Statistics
– Census – Census Bureau
– FFIEC – Federal Financial Institutions Examination Council
– FHFA – Federal Housing Finance Agency
– NCES – National Center for Education Statistics
– NCHS – National Center for Health Statistics

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 Population & Components of Change Trends 2010-2016

.. tools and data to examine how the U.S. by metro population is changing. Is the population moving away or into metros of interest? What are the trends; what is causing the change? What are the characteristics of the population moving in and out? How might this impact your living environment and business?

This section provides information on how and why the population is changing by metro from 2010 to 2016 in terms of components of change: births, deaths and migration. It provides a summary of tools, interactive table and GIS project, to analyze population change by metro using latest Census Bureau estimates through 2016. These data are used by ProximityOne to develop/update annual demographic-economic projections.  See related Web page to access full interactive table and more detail.

Patterns of Population Change by Metro, 2010-2016
The following graphic shows how metros (MSAs – Metropolitan Statisticsl Areas) changed from 2010 to 2016 based on percent population change. Click graphic for larger view; expand browser window for best quality view.

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

Narrative Analysis of Metro Demographic Change in Context
A narrative summary and analysis of metro demographic characteristics and change, contextually with other data and geography, is provided for each metro in the Situation & Outlook Reports. See more about the wide-ranging subject matter that are knitted together in the schedule of updates. Examine metro dynamics in context of the U.S. overall and related states and counties.

The nation’s 382 Metropolitan Statistical Areas (MSAs) had a population of 277.1 million in 2016 (86% of the total population). MSAs increased by 2.3 million people from 2015. The nation’s 551 Micropolitan Statistical Areas (MISAs) had a population of 27.7 million in 2016 (9% of the total population). MISAs increased by 16,000 people from 2015. See more highlights below

MSAs and MISAs together, or metro areas, comprised the set of Core-Based Statistical Areas (CBSAs). Each metro/CBSA is defined as a set of one or more contiguous counties.

Related Sections
• Metros Main
• Situation & Outlook Reports
• City/Place Population Trends
• County Population Trends
• County Population Projections to 2060
• ProximityOne Data Service

Examining Population Components of Change
Population change can be examined in terms of components of change. There are three components of change: births, deaths, and migration. The change in the population from births and deaths is often combined and referred to as natural increase or natural change. Populations grow or shrink depending on if they gain people faster than they lose them. Examining a county’s unique combination of natural change and migration provides insights into why its population is changing and how quickly the change is occurring.

See more about these topics below:
• Natural Increase/Change; birth & deaths
• Migration; net international, net domestic, net migration

Using the Interactive Table – Peer Group Analysis
Use the full interactive table to examine U.S. national scope metros by population and components of change. Consider an application where you want to study metros having a 2016 population between 250,000 and 300,000. Use the tools below the interactive table to select these metros as illustrated in the graphic shown below. The graphic shows these metros ranked on the overall U.S. metro rank (percent population change 2010-2016). As shown in the graphic, the Greeley, CO metro was ranked 11th among all metros and the fastest growing metro in this group. Use the tools/buttons below the table to create custom views.

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.

TractWatch — Examining Small Area Change

Understanding the demographic-economic landscape for small area geography and how it is changing is vital for many stakeholders. Businesses and other organizations need to know how their market/service areas are changing … getting answers to questions like knowing about recent trends, where we are now and the how/where/how much things might change in the future.

Examining Tract Change
The following view shows census tracts (black boundary) located in the northeast Houston, TX area. Tracts are labeled with 2017 population estimates and percent population change from 2010 to 2017. Tract geography and characteristics are shown in context of three cities/places — Houston (orange cross-hatch), Humble (blue) and Atascocita CDP (green). It is easy to see what census tracts intersect with what cities and where. The pointer/hand is located in census tract 48-201-240902, partly intersecting with Humble city. The tract 2017 population of 12,984 reflects an increase of 10.4% since 2010. The dark brown bold boundary at the top of this tract is the Harris County, TX boundary.

.. view developed with ProximityOne CV XE GIS and related GIS project.
.. create views like this for any area in the U.S.; add your own data.

TractWatch tells us which tracts in a region of interest changed during the past year based on quarterly observable data with only a one quarter lag.

Census Tracts & TractWatch
TractWatch is a new tool/service focused on examining recent demographic-business change for each census tract. These approximate 74,000 geographic areas cover the U.S. wall-to-wall and averaged 4,000 population as of Census 2010. Tracts have a generally stable geography between decennial censuses and are coterminous with county boundaries. Tracts cover the U.S. with more than a 2-to-1 ratio compared to ZIP code areas (see tract-ZIP relationship table).

Integrated with Situation & Outlook
TractWatch insights are developed through the use of the ProximityOne Situation & Outlook (S&O) database and information system — a part of S&O demographic-economic estimates and projections developed and updated annually. The 2017 vintage tract estimates and projections (annual data) cover the period 2010 through 2022 (5-year projection).

TractWatch – Monitoring Change
As a part of the S&O annual estimates and projections development, a range of measures are updated quarterly at the census tract level. Quarterly data are developed that include population, housing units, vacant units, households and business establishments.

There is only a one-quarter lag in the availability of observable census tract data. For example, observable 2017Q1 data can be added to the S&O database in July 2017. Data are analyzed and converted into a TractWatch national dataset.

Situation & Outlook Reports
The Situation & Outlook Reports (S&O Reports) are updated weekly, for the U.S. and each county, metro and state. TractWatch is a part of the “Recent Change and Outlook” S&O Report section and updated quarterly. See schedule of updates the shows when TractWatch is updated.

The S&O Reports (metro and county) Recent Change and Outlook section includes a list of census tracts which have shown significant change over the past year for that geography. A table of typically 10-to-25 key tracts are listed in a table with selected demographic-business change attributes.

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.

Relating ZIP Codes to City/Places

.. relating ZIP codes to cities .. 214 ZIP code areas intersect with New York city — what are these ZIP codes, their population and how many are completely within the city? What part of a ZIP code area of interest intersects with what city? Conversely, what ZIP code areas intersect with a city of interest? This section provides data and tools that can be used to answer these types of questions and gain insights into geospatial relationships. See more detailed information in the related full Web section.

The 2010 ZIP Code Tabulation Area (ZCTA) to City/Place relationship data provide a means to equivalence ZCTAs with Census 2010 cities/places. ZCTAs are geographic areas defined as sets of Census 2010 census blocks closely resembling USPS ZIP codes (lines, not areas). ZCTA boundaries are fixed for the intercensal period 2010 through 2020. Census 2010 vintage city/place areas are likewise defined as sets of Census 2010 census blocks. The ZCTA-City/place relationship data are developed through the use of the intersecting census block geography and associated Census 2010 Summary File 1 demographic data.

ZCTA-Place Relationships
The following graphic shows relationships between two selected ZCTAs (red boundaries) and related cities/places (blue fill pattern) in the Pima/Cochise County, AZ area. Relationships between these geographies are reviewed in examples shown below.

– View developed using CV XE GIS and related GIS project.

Using the ZCTA-Place Relationship Data
Two examples illustrating how to use the ZCTA-place relationship data are provided below. The examples are interconnected to the GIS project used to develop the map views, interactive table and data file described in this section. Example 1 describes how to use the data for a ZIP code area entirely located within one city/place. Example 2 describes how to use the data for a ZIP code area located in more than one city/place and area not located in any city/place.

ZCTA to Place Relationships: Example 1
In this example, ZCTA 85711, highlighted in red in the graphic shown below, falls wholly within place 77000, outlined in bold black below. As a result, there is only one corresponding record for ZCTA 85711 in the relationship file. The 2010 Census population for this relationship record is 41,251 (POPPT) which is equal to the 2010 Census population for ZCTA 85711 (ZPOP). See more details about this example.

ZCTA to Place Relationships: Example 2
In this example, ZCTA 85630, highlighted below in red in the graphic shown below, contains two places: all of place 62280 and part of place 05770, both are outlined in black below. As a result, there are two corresponding relationship records in the relationship file. For the first relationship record, the total 2010 Census population for ZCTA is 2,819 (ZPOP). See more details about this example.

Using the Interactive Table
Use the full interactive table to examine U.S. national scope ZCTA-city/place relationships. The following graphic illustrates how ZIP code can be displayed/examined for one city — Tucson, AZ. Each row summarizes characteristics of a ZIP code in Tucson. The last row in the graphic shows characteristics of ZIP code 85711 — the same ZIP code reviewed in Example 1 above.

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.

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.

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.