NOTES ON CTPP 2000 PROFILES
Darft 1: EM (October 28, 2002)
Draft 2 (NS – October 29, 2002 at 1:20 am)
EM Oct 29
The first data product of the Census Transportation Planning
Package 2000 (CTPP2000) is now available.
The Census Bureau has prepared profile sheets for States and Counties,
which are posted on the AASHTO web page at http://ctpp.transportation.org in
both html format and pdf format. The
html format can be read easily into a spreadsheet. One convenience of these profile sheets is that they include data
from both 1990 and 2000 for some basic characteristics such as household size,
vehicle availability, means of transportation to work, and travel time to
Notes for the CTPP profiles:
LEVEL REPORTED: Data are limited
in most cases to State and County totals.
In six states, (Maine, Vermont, New Hampshire, Massachusetts, Rhode
Island, and Connecticut), MCDs are included.
ROUNDING: In CTPP 2000 and other special tabulations from Census 2000,
figures that do not duplicate data released in standard census products
are being rounded. Therefore,
certain tables in the CTPP profile sheets contain rounded numbers. In these tables values from 1 through 7
have been rounded to 4, and values greater than or equal to 8 have been
rounded to the nearest multiple of 5.
SOURCE IS DECENNIAL CENSUS LONG FORM:
All of the data in the CTPP Profile is from the “long form.” The data will not match the short form
(100% count) data exactly.
- MICROSOFT EXCEL 97
PROBLEM: There is a display
problem when the CTPP2000 profiles in html format are opened in Microsoft
Excel 97. The problem is that the
second column (column B) of the spreadsheet is hidden from view. To display column B, right-click the
mouse over either the column A or column C header, and choose Unhide from
the pop-up menu. This problem
appears to be corrected in later versions of Microsoft Excel.
- MEANS OF TRANSPORTATION TO
WORK: Public transportation
includes bus or trolley bus, streetcar or trolley car, subway or elevated,
railroad, ferryboat, and taxicab.
In subsequent CTPP2000 tabulations, taxicab will generally be
included in the “other means” category.
However, in the CTPP profiles taxicab has been included in public
transportation, similar to aggregations used in the Census 2000
TIME TO WORK: In the 1990 Census
(including the CTPP data), the maximum travel time assigned to any worker
was 99 minutes. Workers who
reported travel times of 100 minutes or more were coded to 99 minutes in
1990. The maximum travel time was
increased to 200 minutes for Census 2000, thus the 2000 data are more
accurate because they include the actual value for these long trips. The impact of this coding change is
that increases in travel time between 1990 and 2000 are somewhat
over-stated. At the national
level, the Census Bureau estimates that about 29% (0.9 minutes) of the
3.1-minute increase in average travel time is attributable to the coding
- HOUSEHOLD INCOME IN 1999: In a small number of cases, the mean
household income and median household income figures shown in the CTPP2000
profiles differ from those published in other Census 2000 products. These differences of one dollar are the
result of software rounding differences and hardware numeric precision
differences between the two platforms used to create the products.
- VEHICLES AVAILABLE: The data in CTPP2000 on vehicles
available are tabulated for households.
This is different than in standard census products, where data on
vehicles available are tabulated for housing units. Although the estimates are usually
quite close, the number of housing units is not always equal to the number
of households, because the Census Bureau calculates weights differently
for housing units and households.
Therefore, the distribution of vehicles available shown in CTPP2000
will not exactly match the distribution presented in standard census
A data CD will be sent to State DOTs and MPOs, however, we
expect that most users will be able to get everything they need from the AASHTO
We expect CTPP Part 1 to begin data release by the end of
November, and run through December.
CTPP Part 1 will include many more details of geographic reporting,
including places, census tracts and Traffic Analysis Zones. Similar to Summary File 3, the data is
limited to residential geography only, but the tables are designed specifically
for transportation planning purposes.
For a complete list of tables, please see
Although no official release date has been set yet, the
Census Bureau hopes to release county-to-county flow data (count of workers) by
the end of calendar year 2002. The
first workplace data and flow data to be released from CTPP 2000 is not
expected until April 2003.