Todays Slides

1
Census Transportation Planning Products (CTPP)
Ed Christopher Resource Center Planning
Team Federal Highway Administration 19900
Governors Drive Olympia Fields, IL
60461 708-283-3534 edc_at_EdTheFed.com
Todays Slides http//edthefed.com/
2
Whats Covered

• The NEW CTPP
• Consolidated Purchase
• AASHTO Oversight Board
• Work Program - Data Products
• Resources
• General
• Data

3
Long Form to ACS
1960 OMB Journey-to-Work Tables 1970 and
1980 Urban Transportation Planning Package
(UTPP) 1990 and 2000 Census Transportation
Planning Package (CTPP)
4
Past Journey to Work data
All States and MPOs
5
Why packages were so special
6
Where do you get the data
https//www.bts.gov/pdc/
7
Enter the ACS era
Census Transportation Planning Products
The CTPP embodies a collection of Census Data
used for Transportation Planning. With changing
data needs and the ACS, there will be a variety
of different products useful for transportation
planning emanating from Census Data. There will
be Special Tabulations, Standard Tables and even
Value Added-products. The CTPP captures all of
these.
Think of CTPP as a place to look for Census Data
products to help with your Transportation needs
8
How did we get where we are?
AASHTO Standing Committee on Planning (SCOP) gets
involved
May 11-13, 2005, TRB Census Data for
Transportation Planning Conference ftp//ftp.camsy
s.com/clientsupport/CTPPdata/Conference/index.html
2005 SCOP Census Data Working Group April
10-11, 2006, SCOP Workshop on Priority Census
Data Uses and Needs For Transportation http//trbc
ensus.com/SCOP/docs/workshop_report.pdf May
10-11th 2007, SCOP ACS Capacity Building Peer
Exchange http//trbcensus.com/SCOP/docs/acs_peer_e
xchange_may2007.pdf
http//trbcensus.com/SCOP/
9
Results of 2006 Workshop
l All States DC l AASHTO Led l Oversight
Board l Five Year period 2011
Federal Technical Advisory Group TRB Subcommittee
-- List Serve (700 strong) Quarterly Newsletter
-- Outreach Several Websites
10
Who paid what
11
AASHTO CTPP Oversight Board (ACOB)
MPOs Kuo-Ann Chiao, NYMTC Jerry Duke, RTC Vegas
Steven Gayle, BMTS Mell Henderson MARC Arash
Mirzaei, NCTCOG Guy Rousseau, ARC Vacant Vacant
Chair Mary Lynn Tischer, VA (Region II)Vice
Chair Jonette Kreideweis, MN (Region III) AASHTO
Liaison Penelope Weinberger
17 voting members 9 states and 8 MPOs
Consensus Decision Making
Ex Officio Members Ed Christopher, FHWA Melissa
Chiu, Census Bureau Alison Fields, Census
Bureau DeLania Hardy, AMPO Elaine Murakami,
FHWA Robert Padgette, APTA Alan Pisarski,
Consultant Steven Polzin, USF. CUTR Nanda
Srinivasan, TRB John Sprowls, FTA
States Vacant, (Region I) Nathan Erlbaum, NY
(Region I) Hui Wei Shen, FL (Region II) Mike
Thomas, GA (Region II) Phillip Mescher, IA
(Region III) Ahmad Jaber, UT (Region IV) Ayalew
Adamu, CA (Region IV
12
ACOB First Meeting August 5-6, 2008
Approved Work Program Program Management --
Staff up Census Data Tabulations 3- and 5-year
data products TAZ creation Training and
Technical Assistance Research Approved FHWA-CB
IAA for 1.19 million
13
Staff Additions
Penelope Weinberger CTPP Program Manager,
AASHTO 444 North Capitol Street NE Suite
249 Washington, DC 20001 202-624-3556 pweinberger_at_
aashto.org http//ctpp.transportation.org
Melissa Chiu CTPP Contractor Censu
Bureau 301-763-2421 or (2454) melissa.c.chiu_at_censu
s.gov
14
Data Tabulations (a year ago)
Feb 6, 2008 3-year Table Request Submitted
15
3-year Product Hits Snag
Disclosure Review Board
All Tables rounded like 2000 No thresholds on
Univariate Mode tables Cell thresholds on all
Mode by X tables Tables with failing cells
will be suppressed Includes all Resident and
Workplace tables Worker flows by Total Workers
and Flows by Mode 8 no thresholds
16
The CORE Issue
CTPP Tables link to PUMS Records
1. Find unique traveler and build pseudo
microdata record with all the crosstabs 18
variables 20K population area
2. Add additional variables to pseudo microdata
record 150 variables 100K pop. zone

3. Take new 20,000 Pop area Frankenstein
record 4. Match it to files on Internet 5.
Produce a persons name, address and vitals
100 Main St, Fairfax VA
17
AASHTO appealed, and lost
Feb 5, 2008 Submitted 3-year CTTP Data
request Feb. 14 Staff email suggests new DBR
rules Mar. 12 New DRB rules received March-April
Discussed with community May 2 Sent response
to DRB May 12 Met with full DRB June 2 AASHTO
files appeal August 5 FHWA sends support
letter August-Sept FTA, COPAFS, others? support
August 28 Appeal heard Sept 19 Appeal formally
rejected Oct 18 Discussions at AASHTO SCOP,
ACOB April 1, 2009 New Table request submitted
http//trbcensus.com/drb
18
Census Data Tabulations
April 1, 09 New 3-year Table Request Submitted
19
The 3-year Product Design
20
3-year Product Detail
Submittal Letter http//trbcensus.com/aashto/docs/
CTPP_3-year_table_request.pdf Table
Detail http//trbcensus.com/aashto/docs/CTPPtables
-09apr01-1.xls

• Collapsed Mode to Work
• Reduced Mode to Work Crosstabs to 5 variables
• Increased Flows by Mode from 8 to 11 modes

http//www.dot.gov/ctpp
Also at
21
Collapsing Schema
22
Modal Crosstabs
Too many cross-tabulations byMeans of
Transportation (Mode)

• Age
• Sex
• Class of Worker
• Disability status
• Earnings
• Household Income
• Poverty status
• Industry
• Occupation

• Length of U.S. residence
• Minority Status (Y/N)
• Time Leaving Home
• Time Arriving (Part 2)
• Travel Time
• Vehicle Availability
• Workers in Household
• Age of Youngest Child

makes for micro data record
23
The 3-year Product Summary
24
5-year Data Product
25
5-year Data Product
Key product to the whole CTPP effort Likely to be
all synthetic Hinges on some key research
NCHRP Project 8-79 (500K) Identifying Credible
Alternatives for Producing 5-year CTPP Data
Products from the ACS
http//trbcensus.com/notes/NCHRP_CTPP_Data_Proposa
l_Oct2008.pdf
26
TAZs (Traffic Analysis Zones)
What we were planning a year ago
27
Where we are at today?

• Developed in late 2008 and early 2009 Summer
  2011
• All zones would nest within each larger zones and
  Counties
• GIS approach similar to (PSAP) equivalency
  process
• Funded under Consolidated Purchase

http//trbcensus.com/notes/ACSTAZs.pdf
28
Resources to Consider
29
TRB Census Subcommittee
www.TRBcensus.com
30
USDOT (FHWA) Website
http//www.dot.gov/ctpp
31
AASHTO Website
http//ctpp.transportation.org
32
CTPP List Serve
http//trbcensus.com
33
Status Report
http//www.fhwa.dot.gov/ctpp/status.htm
http//www.trbcensus.com/newsletters.html
34
The 3-year Product
http//www.trbcensus.com/aashto/index.html
35
New Profiles
Coming Soon
Trend Data 2000 and 3-year ACS Includes
MOEs and significance tests Keys on
Transportation Variables
Summer 2009
36
Research Efforts
Report 588 Using ACS for Transportation Planning
(9/06) 08-36(63) Making NAICS Work for
Transportation (March 2007) 08-36(71)
Disclosure Avoidance Techniques to Improve ACS
Data Availability (5/09) 8-36(81) Enhancing the
ACS as a Source for Home-to-Work Flows (10/09)
www.trb.org/CRP/NCHRP/NCHRPProjects.asp?AreaID8
37
Research Efforts
NCHRP Project 8-79 (500K) Identifying Credible
Alternatives for Producing 5-year CTPP Data
Products from the ACS
Workplace Allocation-- Research and
Implementation (250K) Imputation of Vehicle
Ownership and Means of Transportation (Done)
38
http//www.dot.gov/ctpp http//www.TRBcensus.com 2
02-366-5000
Ed Christopher 708-283-3534 edc_at_EdTheFed.com
Todays Slides http//edthefed.com/