CV XE GIS Home Page

  ProximityOne Home

  Situation & Outlook

  Data Resources Guide

  Related Sections
  - Applications Gallery
  - States
  - Congressional District
  - School Districts
  - Counties
  - Cities/Places
  - Tracts/Neighborhoods
  - Block Groups
  - Census Blocks

  - ZIP Codes
  - Urban Areas


  GIS Thematic Mapping
    Visual Analysis Tools

  Ranking Tables
    National Scope
    Demographic Change
  - States
  - Metros
  - Congressional District
  - School Districts
  - Counties
  - Cities/Places
  - Census Tracts

Decision-Making Information
  information resources & solutions
  (888) DMI-SOLN
  (888) 364-7656

Visual analysis with ProximityOne tools
click graphic for info; hover to pause

visually analyze clients/markets
site analysis using 1 mile radius


$median household income
patterns by census tract - Houston

hover to pause

113th Congressional Districts

Click for info

US Asian Indian population 2010

Click for info

geocoded students and school
McKinney ISD, TX

Click for info

geocoded students and school
with tax parcels & streets

Click for info

high school attendance zones
with schools by type

Click for info

%high school graduates by
census tract - Puerto Rico

Click for info

Austin, TX MSA counties &
places 10K+ population markers

Click for info

Appalachia counties (green) &
coalfield counties (orange)

Click for info

China provinces percent urban &
cities (markers) by state plan

Click for info

Honolulu census tracts (red)
& census blocks

Central Park area NYC

Click for info

Kansas City Metro & Counties
Home Depot locations (markers)

Click for info

World Cities; focus on Spain

Click for info

Data Analytics Blog
Mapping Statistical Data

Support & Technical Assistance
help using these resources

Assigning Census Tract/Block Codes to Addresses
  -- using the Census Tract/Block Street Index

The ProximityOne "Census Tract/Block Street Index" (CTBSI) provides an easy-to-use means to associate addresses with a Census 2010 census tract or census block -- and other geography. Use those codes to meet reporting requirements and determine demographic-economic attributes for addresses of interest.

This section reviews use of the CTBSI files developed in part using the Census 2010 and post Census 2010 TIGER/Line files and related data. By assigning the census block (in which the address is located) code to an address, many other types of geography can be determined. These geographies include state, county, city/place, legislative and congressional districts, school districts, ZIP code areas, block groups among other political/statistical areas. By having the census block/tract code, demographic attributes can also be accurately assigned to each address.
  • View/use CTBSI data in the interactive table below.
  • View/use CTBSI data in downloadable Excel file via links below.

ProximityOne corrects and extends data in the Census TIGER/Line files. The TIGER/Line file have missing or incorrect values for road names, address ranges, ZIP codes and other key attributes. We continuously develop and update those data from local sourced data. No adjustment is made to the assignment of geographic codes. The CTBSI is a part of the ProximityOne Digital Map Database (DMD).

Uses & Benefits
The CTBSI provides an important alternative to geocoding. Geocoding is the process of determining/assigning the latitude-longitude of an address and geocodes (e.g., census block) for the location. CTBSI provides a county-by-county text file/lists where each row corresponds to a street segment and includes the street name, low and high address range, city, county, state and census tract/block codes. The CTBSI contains no demographic data itself but provides a means of linking to those data.

Often the census tract code is required to meet government compliance regulations. Also, by having the geocode, demographic attributes can be accurately assigned to each address to facilitate marketing, planning/evaluation, risk assessment and a range of other business uses. The main advantages of using the Census CTSI included simplicity, little or no software, and cost -- it was free.

There are many providers of geocoding services and tools. With these geocoding services come several disadvantages. One is accuracy, it is difficult to verify the accuracy of a large number address geocoded results. Another is "terms of use." Some of the more popular geocoding services place such constraints on the use of geocoded results that they are very limited use. Another is processing speed -- API-based or similar Web-based tools tools are very slow. Another issue can be security; generally to use a geocoding service the address file is released to an outside party. Another issue can be cost. We can provide CTBSI files for as little as $500 per county.

CTBSI is available for use on your computer. Alternatively, we process address files as a service and return the original address data appended with geocodes and optionally subject matter data. Contact us for additional information; mention CTBSI in text section; or call (888) 364-7656.

CTBSI Geography & GIS Applications
Geographic Information System (GIS) software is not required to use the CTBSI data/file. However, the CTBSI data are derived from GIS applications, are compatible with GIS applications and CTBSI value can be enhanced through use of GIS software.

The graphic below shows a map of the location of the first street segment shown in the interactive table further down in this section. The pointer is located at that street segment. As shown in the table, the left side of that segment has potential address range from 6301 to 6399. Click graphic for a larger view. Expand browser window for best quality view. The larger view also shows a mini-profile for that segment. See that the ID shown in the mini-profile, and address ranges, are that same as in the interactive table.

  -- view developed using CV XE GIS and related GIS project

The next view shows a zoom-in view to that street segment (see pointer). Census blocks are shown with red boundaries and geocode (GeoID) as yellow labels. Compare the GeoIDs shown on the left and right side of the segment are the same as shown in the table below.

  -- view developed using CV XE GIS and related GIS project

The next view shows a zoom-out view to that street segment (see pointer). Census tracts are shown with blue boundaries and geocode (state-county-tract) as yellow labels. Compare the GeoIDs shown on the left and right side of the segment are the same as shown in the table below (the segment is not on a tract boundary).

  -- view developed using CV XE GIS and related GIS project

CTBSI Interactive Table
An illustrative CTBSI interactive table is shown below for street segments located in Fairfax County, VA. The CTBSI database covers the U.S. wall-to-wall and is available for single counties, county groups or the U.S. There is a row for each named road segment in the county. Not all items in the CTBSI base file are shown. The table has been developed through use of several Census 2010 TIGER/Line shapefiles and related files. The table is intended to illustrate the process of associating a tract/block with an address. The actual CTBSI data/files are distributed in comma-delimited structure and contain many more fields than shown in the interactive table. See the extended field list below in this section.

Improving Census/TIGER. The original Census TIGER/Line edges shapefile used to develop the data shown in the interactive table included approximately 101,000 "edge" segments for this county. Of these. approximately 65,000 were coded as road segments (others being railroads, streams, etc.). We know that some number of the difference are actually roads but incorrectly coded. Of the approximate 65,000 coded as roads, approximately 11,000 are missing a road name. Of the remaining approximate 54,000 road segments with names, a large number have missing low or high address values. Sometimes all address fields are not available. See details on county-by-county segment counts and completeness by type attribute.

CTBSI Interactive Address to Census Tract/Block Assignment
  Uses illustrative road/street data for Fairfax County, VA; selected CTSI fields.
  Usage: click column header to sort; click again to sort other direction.

Column Headers; Item Descriptions
For each road/street segment (typically intersection to intersection)
- ID - permanent unique segment ID
- FullName/SegName - full name of road segment
Left side attributes
- AddrFL - potential left side from address
- AddrTL - potential left side to address
- StL - state FIPS code - left side
- GeoIDL - state-county-tract-block - left side
- ZIPL - ZIP code - left side
Right side attributes
- AddrFR - potential right side from address
- AddrTR - potential right side to address
- StR - state FIPS code - right side
- GeoidR - state-county-tract-block - right side
- ZIPR - ZIP code - right side

Table Usage Notes
  Click ShowAll button between queries/lookups.
  • Click on a column header to sort on that column; click column header again to sort in other direction.
  • Click ShowAll button to show all areas and restore table.
  • Key exact text (street name part) in the Find in Name
      and click Find in Name button to locate all qualifying segments.
  • The Find operation performs a query on the FullName column.

Using CTBSI Files with Excel
Click on these links to open the county CTBSI file in Excel format.
- Files contain the basic, non-extended, data (address ranges have not been updated).
- File columns are named/described above and structured as shown in the interactive table above.
- Files are sorted on SegName+AddrFL.
  • Fairfax County, VA (xls)
  • Honolulu County, HI (xlsx)
  • Montgomery County, OH (xlsx)
  • Harris County, TX (xlsx)

Extended CTBSI Data Fields/Attributes
TLID75989948Permanent segment ID
TFIDL262253026Permanent face ID left
TFIDR207019554Permanent face ID right
MTFCCS1400Feature class code
FULLNAME16th StFull name
TNIDF44912347From node ID
LATF38.7789242From node latitude
LONF-77.0613214From node longitude
TNIDT44912361To node ID
LATT38.7784701To node ID latitude
LONT-77.062474To node longitude
Left side attributes
LFROMADD6401From address number left
LTOADD6417To address number left
STATEFP10L51State FIPS code left
CTYFP10L059County FIPS code left
TRACTCE10L415200Tract Census 2010 code left
BGCE10L4Tract Census 2010 code left
BLOCKCE10L4018Block Census 2010 code left
ZIPL22307ZIP Code left
ZCTA5CE10L22307ZCTA Census 2010 code left
UACE10L92242Urban Area Census 2010 code left
PUMACE10L59302PUMA Census 2010 code left
PLACEFPL05928City/place code left
ELSDLEALElementary school district code left
SCSDLEALSecondary school district code left
UNSDLEAL01260Unified school district code left
CDFPLCongressional district code left
SLDUSTL030State legislative upper district code left
SLDLSTL045State legislative lower district code left
CSAFPL548Combined statistical area code left
CBSAFPL47900Core-Based statistical area code left
METDIVFPL47894Metropolitan division code code left
Right side attributes
RFROMADD6400From address number right
RTOADD6410To address number right
STATEFP10R51State FIPS code right
CtYFP10R059County FIPS code right
TRACTCE10R415200Tract Census 2010 code right
BLOCKCE10R4017Block Census 2010 code right
ZIPR22307ZIP Code right
ZCTA5CE10R22307ZCTA Census 2010 code right
UACE10R92242Urban Area Census 2010 code right
PUMACE10R59302PUMA Census 2010 code right
PLACEFPR05928City/place code right
ELSDLEARElementary school district code right
SCSDLEARSecondary school district code right
UNSDLEAR01260Unified school district code right
CDFPRCongressional district code right
SLDUSTR030State legislative upper district code right
SLDLSTR045State legislative lower district code right
CSAFPR548Combined statistical area code right
CBSAFPR47900Core-Based statistical area code right
METDIVFPR47894Metropolitan division code code right

Support Using these Resources
Learn more about accessing and using demographic-economic data and related analytical tools. Join us in a Data Analytics Lab session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.

ProximityOne User Group
Join the ProximityOne User Group to keep up-to-date with new developments relating to metros and component geography decision-making information resources. Receive updates and access to tools and resources available only to members. Use this form to join the User Group.

Additional Information
ProximityOne develops geodemographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses. Wide-ranging organizations use our tools (software, data, methodologies) to analyze their own data integrated with other data. Follow ProximityOne on Twitter at Contact us (888-364-7656) with questions about data covered in this section or to discuss custom estimates, projections or analyses for your areas of interest.

Copyright © . ProximityOne. All Rights Reserved.
Sitemap | Contact Us | News