Daily Archives: May 23, 2016

Census Tract-City Relationship Table

.. what census tracts are located in cities of interest? What are their codes? Conversely, do you have census tract codes and need to know corresponding city(s)? Get answers here.

This section provides access to an interactive table useful to examine relationships among Census 2010 census tracts, cities/places, and counties. Many cities and counties that might be experiencing demographic-economic decline will often have bright spots that are groups of a few or many census tracts. Census tracts are important sub-county geography in data analytics. See the related section on census data analytics. See more about census tracts and data analytics below in this section.

Relating Census Tracts to Cities & Counties
Census tracts are sub-county areas and nest coterminously within counties. The 6-character tract code is unique within county. For cities 10,000 and larger, there are some number of whole census tracts within the city. But around the perimeter of cities, census tracts will often be partly within and partly outside of the city. The following graphic shows the relationship of tracts, cities and counties in the Plano city area (green fill pattern) located mostly in Collin County within the Dallas metro. Click graphic for larger view, more detail and legend color/data intervals. This map illustrates the geographic level of detail available using census tract demographics and the relative ease to gain insights using geospatial data analytics tools.

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

Using the Interactive Relationship Table
A small part of Plano is located in Denton county (see north-south bold red-brown boundary). Tract 021627 (see pointer) is located in Denton County and includes a part of Plano. To determine what geography tract 021627 intersects, click the Tract> button below the interactive table shown below. See that the tract is contained in parts of 4 cities.

Census Tract to City/Place & County Equivalence Table
The following graphic illustrates use of the interactive table to view/examine the relationship between census tract 48121021627 (in Denton County, TX) and the city of Plano, TX. Click graphic for larger view.

The above view was developed using the interactive table:
– click the ShowAll button
– click the FindTract button (preset to locate this tract).

Click the ShowAll button and enter a city/place (case-sensitive) name of interest to view the set of intersecting tracts. See the table usage notes below the table in the related Web page. We review operation of the table in the 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.