Search title image
Census Transportation Planning Package Logo
     

Census Transportation Planning Package (CTPP2000)


Data Extracted for the Nine-County San Francisco Bay Area and California
(Last Update: May 9, 2005)


The CTPP Part 3 ("journey-to-work flow data") has arrived! See below for more information.

Questions on the CTPP "Flow Data"? Visit MTC's CTPP Frequently Asked Questions page. New: 5/10/2004

Commuting to Downtown Highlights (Word file, 39 KB) Added 1/28/04
Commuting to Downtown Detailed Analysis (Maps & Tables) (PDF File, 247 KB) Added 1/28/04
Commuting to Downtown Detailed Analysis (Maps & Tables) (Word File, 7.0 MB) Added 1/28/04


The purpose of this page is to provide Bay Area data users with easy access to CTPP data and documentation. The CTPP is a special product produced by the U.S. Bureau of the Census for the transportation community. More information on the CTPP is available at the links provided at the bottom of this page.


The CTPP comprises three elements: Part 1 provides tabular data by area of residence; Part 2 provides data by area of work; and Part 3 provides commuter "flow" data from area of residence to area of work. Data is available at various geographic "summary levels" including county, places (above 2,500 population), census tracts (1,405 in Bay Area), block groups (4,422 in Bay Area), census travel analysis zones (4,069 in Bay Area), and 5% PUMAs (54 in Bay Area).

The CTPP Part 1 data for California was received July 9th, 2003.

The CTPP Part 2 data for California was received January 11, 2004. The data CD that was received on 1/11/04 contains only ASCII data and SAS jobs to analyze the datasets.

The CTPP Part 3 dataset for California was released May 6, 2004. Part 3 data contains the county-to-county, place-to-place, tract-to-tract, etc., data.


Our intent is to provide CTPP data in common data formats. We are providing data in "csv" (comma-separated value) formats for importing into spreadsheet and database applications, and we are providing data in ESRI "shp" file format for use in ArcView or ArcGIS software. Note that some of the "dbf" files associated with the "shp" files are very large with several thousand variables, and cannot be used in MS-Excel.

We will update this page on an as needed basis, and will inform the user community via the Bay Area Census listserv (see the ABAG Bay Area Census page for more information).


Documentation

Be sure and download and read the CTPP documentation. It will be impossible to understand the data without having the documentation. Especially useful are the SAS programs, Appendix E (Table Titles), Appendix F (Category Labels) and the spreadsheets CTPP1_AllVariables.xls, CTPP2_AllVariables.xls and CTPP3_AllVariables.xls.

MTC's SAS programs (CTPP2000_SASjobs_AUG0103.zip) (The SAS programs are text files, with labels for variables. SAS job scripts can be viewed with typical text editing programs such as Notepad, Word, Wordpad or TextPad. These text-based SAS programs are critical for interpreting these databases.)

MTC's SAS programs for CTPP, Part 2 (CTPP2000P2_SASJobs_JAN3004.zip) (The SAS programs are text files, with labels for variables. SAS job scripts can be viewed with typical text editing programs such as Notepad, Word, Wordpad or TextPad. These text-based SAS programs are critical for interpreting these databases.)  Added 1/30/04.

CTPP1_AllVariables.xls (1.5 MB) or zipped version of EXCEL file: CTPP1_AllVariables.zip (253 KB).  This EXCEL file lists all 11,444 variables and their labels. Produced at MTC using SAS PROC CONTENTS. Added: 8/5/03.

CTPP2_AllVariables.xls (941 KB) or zipped version of EXCEL file: CTPP2_AllVariables.zip (167 KB).  This EXCEL file lists all 7,660 variables and their labels. Produced at MTC using SAS PROC CONTENTS. Added 1/20/04.

CTPP3_AllVariables.xls ( 71 KB). This EXCEL File lists the 210 variables and their labels. Produced at MTC using the SAS PROC CONTENTS. Added 5/6/04.

CTPP_techdocs.zip  (zipped version of CTPP documentation containing all of the following PDF files. 5.2 MB)
Technical Documentation.pdf
Appendix A - Accuracy of the data.pdf
Appendix B - Collection and Processing Procedures.pdf  (strange error in PDF file, so use the file from zipped archive)
Appendix C -- MPO Codes and Names.pdf
Appendix D - Summary Levels.pdf
Appendix E - Table Titles.pdf
Appendix F - Category Labels.pdf
Appendix G - Glossary of Terms.pdf
Appendix H - Variables by Table.pdf
Appendix I - MPO Region Definitions.pdf
Appendix J - Census 2000 Occupational Categories.pdf
Appendix K - Census 2000 Industry Categories.pdf
Appendix L - Questionnaire.pdf


California and Bay Area CTPP "Commuter Flow" Data New: May 6, 2004

The Census Transportation Planning Package (CTPP) "Part 3" data files include the journey-to-work "flow" data. These "commuter matrices" show the characteristics of commuters from area of residence-to-area of work. Geographic levels currently available include: county-to-county, place-to-place, and tract- to-tract. MTC has also produced commuter flow tabulations by the MTC 34 "superdistrict" system. (More detailed commute data at the block group and census zone level are expected late May, 2004). These data files are provided in either "CSV" (comma-separated value) or "XLS" (MS-Excel workbook) formats, in "zipped" archive files to make for faster downloads. Data is provided for intra-California records, only.

The data user should download the CTPP3_AllVariables.xls and Appendices E and F to gain a better understanding of the CTPP Part 3 database.

CAUTION: Five of the fourteen data tables included in CTPP Part 3 are subject to a minimum sample size threshold to protect the confidentiality of respondents. These are Tables 3-3 through 3-7. This means that when there are only one or two sample respondents for that area-to-area commuter flow, then the values for these five tables are "zeroed out" and no data is shown. These represent insignificant data losses at the larger geographic summary levels such as county and place-level, but are serious data losses at smaller geographic summary levels (e.g., tracts, block groups, zones) as well as geographic levels based on these levels (e.g., MTC's superdistricts). For example, there is a 34 percent loss in the number of total Bay Area commuters when comparing the intra-regional tract-to-tract database (2,154,754 commuters) to the intra-regional county-to-county database (3,258,465 commuters); and a 1.1 percent loss when examining the intra-Bay Area place-to-place database (3,221,359). These data losses suggest that Tables 3-3 through 3-7 should not be used for tract-to-tract, block group-to-block group, or zone-to-zone analyses (with the exception of the "work at home workers" included in Table 3-6).

MORE CAUTION: These Excel workbooks contain very large databases which may not be suitable for printing. Some of these Excel worksheets will contain thousands of pages of data, so be careful when trying to print these spreadsheets. All of these "csv" files can be opened in Excel with the exception of the Bay Area tract-to-tract database.

MORE WORDS OF ENCOURAGEMENT: Please read the README files. These README files are contained in separate Excel workbooks, and spreadsheets within the XLS workbooks. These files will include descriptions of all of the variables used in these XLS and CSV databases.

Data File Description File Size (zipped)
CTPP2000_California_CountyFlow_AllVars.zip California county-to-county CTPP Part 3, All Variables 1,180 KB
CTPP2000_California_CountyFlow_SelVars.zip California county-to-county CTPP Part 3, Selected Variables 118 KB
CTPP2000_California_PlaceFlow_AllVars.zip California place-to-place CTPP Part 3, All Variables 5,380 KB
CTPP2000_California_PlaceFlow_SelVars.zip California place-to-place CTPP Part 3, Selected Variables 4,362 KB
CTPP2000_BayArea_IntraRegion_CountyFlow_SelVars.zip Bay Area, county-to-county, CTPP Part 3, Selected Variables 13 KB
CTPP2000_BayArea_PlaceFlow_SelVars.zip Bay Area, place-to-place, CTPP Part 3, Selected Variables 917 KB
CTPP2000_BayArea_IntraRegion_TractFlow_AllVars.zip Bay Area, tract-to-tract, CTPP Part 3, All Variables 6,640 KB
CTPP1990_2000_California_PlaceFlow_SelVars.zip California, place-to-place, 1990-2000, Selected Variables 3,963 KB
Compare_BayArea_county2county_commuters_1960_2000.zip Bay Area, county-to-county, 1960-2000 46 KB
Compare_IntraBayArea_place2place_utpp80_ctpp90.zip Bay Area, place-to-place, 1980-1990 (not 2000). Use the Calif. place-to-place for 1990-2000 Bay Area places. 636 KB
Compare_BayArea_Superdistrict_Flows_1970_2000.zip Bay Area, superdistrict-to-superdistrict, 1970-2000 436 KB
Compare_BayArea_Interregional_county2county_commuters_1980_2000.zip Bay Area, interregional county-to-county commute, 1980-2000 29 KB
CTPP3_AllVariables.xls Data Dictionary for All Variables in CTPP, Part 3 71 KB
MTC 34 Superdistrict Maps (PDF Format) Map showing MTC's 34 superdistricts (PDF) 195 KB

GIS Data: San Francisco Bay Area CTPP Data Files in ESRI SHP file format

Note that these are very large SHP files, with 1,000 to 2,500 variables in each file. These data sets do not have simple, mnemonic variable names such as TOTPOP or HHPOP, but instead have the Census Bureau-provided variable names such as tab1x1 (Table 1, cell 1) and tab120x154 (Table 120, cell 154).  The data user should use CTPP1_AllVariables.xls and Appendices E and F to interpret these variable names. Since there are 11,444 variables in the CTPP Part 1, MTC staff will not be creating mnemonic variable names and will be relying on the SAS labels for further analyses.

All of the GIS files are projected in NAD-1983, UTM, Zone 10N, meters.


CTPP, Part 1, Bay Area Census Tracts (n=1,405)

Tables included in SHP file:
Typical Data Universe
Data File
File Size
Part 1, Tables 1 - 17
All Workers
bayarea_tab001_017_tract_shp_ctpp1.zip
3.5 MB
Part 1, Tables 18 - 29
All Workers
bayarea_tab018_029_tract_shp_ctpp1.zip
3.4 MB
Part 1, Tables 30 - 46
Workers in Households
bayarea_tab030_046_tract_shp_ctpp1.zip
3.8 MB
Part 1, Tables 47 - 73
Persons, Households
bayarea_tab047_073_tract_shp_ctpp1.zip
3.0 MB
Part 1, Tables 74 - 87
Households
bayarea_tab074_087_tract_shp_ctpp1.zip
3.9 MB
Part 1, Tables 88 - 120
Households, Workers
bayarea_tab088_120_tract_shp_ctpp1.zip
3.2 MB


CTPP, Part 1, Bay Area Places (n=183. Note that data is available only for Bay Area places of 2,500+ population)

Tables included in SHP file:
Typical Data Universe
Data File
File Size
Part 1, Tables 1 - 17
All Workers
bayarea_tab001_017_places_shp_ctpp1.zip
1.0 MB
Part 1, Tables 18 - 29
All Workers
bayarea_tab018_029_places_shp_ctpp1.zip
1.0 MB
Part 1, Tables 30 - 46
Workers in Households
bayarea_tab030_046_places_shp_ctpp1.zip
1.1 MB
Part 1, Tables 47 - 73
Persons, Households
bayarea_tab047_073_places_shp_ctpp1.zip
0.9 MB
Part 1, Tables 74 - 87
Households
bayarea_tab074_087_places_shp_ctpp1.zip
1.0 MB
Part 1, Tables 88 - 120
Households, Workers
bayarea_tab088_120_places_shp_ctpp1.zip
0.9 MB


CTPP, Part 1, Bay Area Block Groups (n=4,422)

Tables included in SHP file:
Typical Data Universe
Data File
File Size
Part 1, Tables 1 - 17
All Workers
bayarea_tab001_017_blkgrp_shp_ctpp1.zip
7.5 MB
Part 1, Tables 18 - 29
All Workers
bayarea_tab018_029_blkgrp_shp_ctpp1.zip
6.9 MB
Part 1, Tables 30 - 46
Workers in Households
bayarea_tab030_046_blkgrp_shp_ctpp1.zip
7.8 MB
Part 1, Tables 47 - 73
Persons, Households
bayarea_tab047_073_blkgrp_shp_ctpp1.zip
6.4 MB
Part 1, Tables 74 - 87
Households
bayarea_tab074_087_blkgrp_shp_ctpp1.zip
8.2 MB
Part 1, Tables 88 - 120
Households, Workers
bayarea_tab088_120_blkgrp_shp_ctpp1.zip
6.8 MB


CTPP, Part 2, GIS Files for "Selected Variables" (added 1/30/04)
All of the GIS files are projected in NAD-1983, UTM, Zone 10N, meters.

Geographic Level
Data File
File Size
California Counties (n=58)
CTPP2_CalifCounties_shp_selvars.zip
2.1 MB
California Places (n=748 with data; n=1,081 total places)
CTPP2_CalifPlaces_shp_selvars.zip
4.2 MB
Bay Area Census Tracts (n=1,405)
CTPP2_BayTract_shp_selvars.zip
1.9 MB
Bay Area Block Groups (n=4,422)
CTPP2_BayBlkGrp_shp_selvars.zip
3.6 MB
Bay Area Travel Analysis Zones (n=4,069)
CTPP2_BayTAZ_shp_selvars.zip
3.3 MB

Note that the CTPP data is only available for places greater than 2,500 total population. In California, 748 places out of 1,081 places meeting this population size threshold.


San Francisco Bay Area CTPP Data Files in CSV (comma-separated value) file format

Typical spreadsheet applications such as EXCEL can only handle up to 256 columns of data. This represents a major challenge since the CTPP Part 1 contains over 11,000 data cells (columns of data). The files included in the following table are derived from the Part 1 CTPP data, and are constructed to contain no more than 256 columns. These files, in comma-separated value format, can be opened and saved in EXCEL and other spreadsheet applications. There are a total of 117 tables in CTPP Part 1. The following twelve CTPP "mega-tables" (tables with greater than 256 cells) are not included in these CSV extracts: Tables 9, 15, 16, 23, 34, 44, 45, 46, 75, 76, 79 and 82.

Each of the following five file archives contain 34 separate CSV files. The file naming should be self-explanatory.

Geographic Summary Level
Data File
File Size (zipped)
California Counties (sumlev=50)
CalifCounty_csv_ctpp1.zip
0.6 MB
California Places (sumlev=160)
CalifPlace_csv_ctpp1.zip
5.2 MB
Bay Area Census Tracts (sumlev=140)
BayTracts_csv_ctpp1.zip
7.4 MB
Bay Area Block Groups (sumlev=150)
BayBlkGrp_csv_ctpp1.zip
16.6 MB
Bay Area Census Travel Analysis Zones (sumlev=940)
BayTAZ_csv_ctpp1.zip
14.6 MB


The CTPP Part 2 data are the "tables by area-of-work" datasets. Tables provide detailed information on the characteristics of workers by place-of-work, county of work, TAZ-of-work, census tract-of-work, and block group-of-work. Again, these files are limited to no more than 256 columns so that they can be conveniently loaded into EXCEL and other spreadsheet applications. There are a total of 65 tables in CTPP Part 2. There are eight CTPP Part 2 "mega-tables" (tables with greater than 256 cells) which are not included in these CSV data extracts: Tables 2-9, 2-15, 2-16, 2-23, 2-34, 2-44, 2-45, and 2-46. (Table 2-29 was deleted by the Census Review Board.)Added: 1/20/04.

Each of the following five CTPP Part 2 file archives contain 22 separate CSV files. Again, the file naming should be self-explanatory.
Added: 1/20/04.

Geographic Summary Level
Data File
File Size (zipped)
California Counties (sumlev=50)
CalifCounty_csv_CTPP2.zip
0.4 MB
California Places (sumlev=160)
CalifPlace_csv_CTPP2.zip
3.1 MB
Bay Area Census Tracts (sumlev=140)
BayTracts_csv_CTPP2.zip
4.1 MB
Bay Area Block Groups (sumlev=150)
BayBlkGrp_csv_CTPP2.zip
8.7 MB
Bay Area Census Travel Analysis Zones (sumlev=940)
BayTAZ_csv_CTPP2.zip
8.4 MB

For More Information....

For more information on the Census Transportation Planning Package, visit the TRB Census Data Subcommittee web page at:  http://www.trbcensus.com/ or visit the Federal Highway Administration CTPP page at: http://www.fhwa.dot.gov/ctpp/

For more information on Bay Area Census data, visit the ABAG Census data site at:
http://www.bayareacensus.ca.gov/ or the MTC Census DataMart at: http://www.mtc.ca.gov/maps_and_data/datamart/census/ .

Quick link to MTC's Census File Transfer Protocol (FTP) site: ftp://ftp.abag.ca.gov/pub/mtc/census2000/CTPP/data/.

For more information on census data available from MTC, please contact David Ory of MTC at 510-817-5755, or Mr. Shimon Israel of MTC at 510-817-5839.


Created: August 1, 2003. Last Updated: May 9, 2005.
http://www.mtc.ca.gov/maps_and_data/datamart/census/ctpp2000/