 |
Census Transportation Planning Package (CTPP2000)
|
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/
info@mtc.ca.gov • Report Web site comments • Accessibility Information • Site Help
Metropolitan Transportation Commission • 101 Eighth Street, Oakland, California 94607
Phone:
(510) 817-5700, Fax: (510) 817-5848
This page was last modified Friday November 09, 2012
© 2013 MTC