Transcript Document

Ed Christopher
Resource Center near Chicago
Federal Highway Administration
19900 Governors Drive
Olympia Fields, IL 60461
708-283-3534
[email protected]
In this Module
Overview Census 2000 with
a Transportation Focus
Census 2000
Short Form and Long Form
Short form
Long form
Census 2000
Short Form Questionnaire
7 Questions
Name
Sex
Age
Relationship
Hispanic Origin
Race
Owner/Renter Status
Census 2000
Long Form Sampling Pattern

For the U.S. as a whole, about one
in six households received the
long-form questionnaire.
Transportation Related Questions
Long Form
Place of Work
Means of Transportation to Work
Carpool Occupancy to Work

Departure Time for Work
Travel Time to Work
B
Vehicles Available
B

What Data is Available?
100% data or SHORT-FORM data
•Redistricting Summary File (PL Data)
•Summary File 1 (SF1)
•Summary File 2
Sample or LONG-FORM data
•Summary File 3 (SF3)
•Summary File 4
Public Use Microdata Sample
(PUMS)
Unaggregated responses to Census 2000
with all identifying information removed
– 1-Percent National Characteristics File
– 5-Percent State Files
• 100,000 population threshold for
geography
• 10,000 population threshold for
characteristics
California PUMAs (5%) and
Super-PUMAs (1%)
233
PUMAs
5-Percent
62
superPUMA
1-Percent
Bay Area PUMAs (5%) and
Super-PUMAs (1%)
12 superPUMAs
54 PUMAs
Typical Products We Use
PL171 100% Pop, Age, Race (Blocks)
Summary File 1 (SF1) 100% Pop, Age,
Race, Household size, owner/renter
More Geography than PL171
(Blocks)
Summary File 3 (SF3) 17% All
Variables, (Block Group)
Public Use Micro Series (PUMS) 5%
of SF3 Individual Records (Big Zones)
Media
 Internet
 CD-ROM /DVD
 Paper
http://www.census.gov
Now for a Slight
Gear Change
The Transportation Data
Census Transportation
Planning Package
What is CTPP 2000?
The Census Transportation
Planning Package 2000 is a set of
special tabulations from the long
form of the decennial census
designed by transportation
planners for transportation planners
It summarizes the data
Flows between
Home and Work
At Workplace
At Residence
Who developed it?
CTPP 2000 was a product of the
states and MPOs funded
through an AASHTO Pooled
Fund Project
It was guided by a Working Group
USDOT (FHWA, BTS, FTA and OST)
Census Bureau (Migration and Geography Divisions)
AASHTO
States and MPOs
TRB Subcommittee on Census Data
www.TRBcensus.com
Who paid for it?
1960
1970
1980
1990
2000
Buyers/Users
Direct Cost
Tables
OMB
112
152
???
$0.6 M
$2.0 M
$2.5 M
$3.0 M
???
43
82
120
203
All States
and MPOs
What are the CTPP 2000
Products?
Main CTPP 2000 Products
Tabulations
at Residence
Tabulations
at Workplace
Flows between
Home and Work
Collateral Products
 State and County Profiles
 County Flow Data
CTPP 2000 Main Products
Tabulations
at Residence
Tabulations
at Workplace
Flows between
Home and Work
Part 1
Part 2
Part 3
When was it released?
CTPP 2000 cames out in 3- waves
Residence, Workplace and Worker Flows
Residence Based Tables
Oct 2002 Mar. 03 April
June July-August 2003
Workplace Spring / Summer
Summer 2003 Fall 2003
Worker Flow Tables
2004
-------- 2003-2005
-----Winter
Summer
Why all the delay?
Disclosure Review Board Negotiations
(Sept 2001 to Jan 2002)--- 5 months
People Living in Group Quarters Issues
(Jan to May 2003)--- 5 months
Part 3 Software Issues
(Sept ‘04 to ???)--- 9+months
Inexcusable delays caused by CB on whether or not 13
tables in CTPP 2000 Part 1 could be released. Finally, CB
allow all but 3 Tables originally identified… Dave Clawson,
AASHTO
Why the 2003 Delay?
Group Quarters Issue
Fear by Census Bureau that one could
identify the “characteristics” of workers
who live in group quarters by subtraction
SF3--Workers
who live in
Households and
Group Quarters
Modes Used
-
CTPP 2000-Workers who
live in
Households
Modes Used
=
Workers who
live in Group
Quarters
Modes Used
How is it packaged?
CTPP Access Tool
The CAT
ASCII Too
What was the
Distribution Process?
CDs with Extraction Software
To MPOs and States First
(ASCII also available)
30 Day review period
Corrections made
Quantities prepared and redistributed
BTS (and others) distribution program(s)
MPO - State Note
Feel free to copy and distribute the
data to your member agencies and
others
The are no copyright or licensing
provisions
Is there be Training?
Yes! Sort of
Provides all basics on understanding, using
and working with the CTPP data in a
transportation planning context
What is it?
l Self-Paced, Individualized Training
l CD-Rom Based
l Loaded with Animations
l Fun yet Informative
l Less than 5-Hours to Complete
l Chock Full of Information
MPO-State Note
Feel free to copy and distribute the
data to your member agencies and
others
The are no copyright or licensing
provisions
Where do I get the CTPP
2000 Data?
http://www.transtats.bts.gov/
Where do I get the CTPP
2000 Data?
https://www.bts.gov/pdc/
What are we Getting?
Let’s Look at the Details
So how does this thing work?
Tables—Lots of Tables
121 Tables of Residents’ Based Data
68 Tables of Work Place Data
14 Tables of Flow Data
Variables--Lots of Variables
Person
Worker Status
Age, Sex, Race, Hispanic
Origin, Disability
Household
Income
Nos. Vehicles Available
Size and Nos. Workers
Workers
Journey-to-Work
Work Location and Mode
Departure and Travel Time
Arrival Time (Calculated)
What is a “Universe”?
CTPP 2000 Table Structure
Part 1: At Residence (121 Tables)
Group 1: All Workers
Tables 1-29
Group 2: Workers in Housholds
Tables 30-48
Group 3: Persons
Tables 49-61
Group 4: Households
Tables 62-83
Group 5: Housing Units
Group 6: Computed Tables
Tables 84 to 88
Tables 89-121
Part 2: At Workplace (68 Tables)
Group 1: All Workers
Tables 1-29
Group 2: Workers in Households
Tables 30-48
Group 3: Computed Tables
Tables 49-68
Part 3: Worker Flows (14 Tables)
Group 1: Small Geography
Tables 1-8
Group 2: Sm Geo Computed
Tables 9-14
Sample Table List
Comparing SF3 to CTPP 2000
SF3
CTPP 2000
Travel time to Work (4)
by Means of
Transportation (2)
Travel time to Work (15)
by Means of
Transportation (10)
Tenure (2) by Vehicles
Available (6)
Vehicles Avail (5) by Hhld
Income (25)
Vehicles Avail (5) by Nos.
of workers in hhld (5)
AND MORE
Sample CTPP Cross Tabulations
One-Way
Household income in 1999 (11)
Two-Way
Sex (3) by Age (12)
Household size (5) by Vehicles
Three-Way available (6) by Household income
(11)
Vehicles available (3) by Hispanic
Four-Way origin (3) by Race of person (5) by
Means of transportation to work (8)
http://www.dot.gov/ctpp/
Means of Transportation to Work
Total
Drove Alone
2 Person Carpool
3 Person Carpool
4 Person Carpool
5-6 Person Carpool
7+ Person Carpool
Bus/Trolley Bus
Streetcar/Trolley
Subway/Elevated
Railroad
Ferryboat
Bicycle
Walked
Taxicab
Motorcycle
Other Means
Worked at Home
18 Modes
Total
Drove Alone
2 Person Carpool
3 Person Carpool
4+ Person Carpool
Total
Drove Alone
2 Person Carpool
3+ Person Carpool
Bus/Trolley Bus
Streetcar/Trolley/
Subway/Elevated
Bus or Trolley Bus
Bicycle/Walked
Bicycle/Walked/
Taxicab/
Motorcycle/other
Means
Total
Drove Alone
2+ Person Carpool
Bus/Trolley Bus/
Streetcar/Trolley/ Streetcar/Trolley/
Subway/Elevated/ Subway/Elevated/
Railroad/ Ferryboat Railroad/ Ferryboat Railroad/ Ferryboat
Taxicab/
Motorcycle/other
Means
Worked at Home
11 Modes
Worked at Home
8 Modes
Bicycle/ Walked/
Taxicab/
Motorcycle/other
Means/ Worked at
Home
5 Modes
Sample
Variable List
NOTE: Age has 3
levels, clusters or
elements
Disclosure Review Board
CTPP 2000 Post DRB
Part 1: at Residence (121 Tables)
All Tables Rounded
Zero = 0
1 through 7 = 4
8 though  = Nearest Multiple of “5”
Part 2: at Workplace (68 Tables)
All Tables Rounded
Part 3: Worker Flows (14 Tables)
All Tables Rounded
Some Tables with Thresholds
Example of Rounding
Mode to
Work
Circa 1990
For 2000
(ROUNDED)
Total
Drive Alone
Carpool
Transit
Walk
Bike
352
212
46
59
33
2
350 (not 355!)
210
45
60
35
4
True Total 354
Part 3: Worker Flow Tables
Table
Content
1
Total Workers (1)
2
Vehicles Available (3--zero,one or two+) by Means of Transportation (7 modes)
3
Poverty Status (3 categories)
4
Minority Status (2--white non-hispanic and all others)
5
Household Income (8 classifications)
6
Means of Transportation (17 modes)
7
Household Income (4 classifications) by Means of Transportation (4 modes)
8
9
No record
threshold
Must have 3
unweighted
records
Mean Travel Time by Means of Transportation to Work (7 modes) and Time
Leaving Home for Work (2--AM peak and all other times)
Median Travel Time by Means of Transportation to Work (7 modes) and Time
Leaving Home for Work (2 groupings)
10
Aggregate Number of Vehicles by Time Leaving Home for Work (2, see table 8)
11
Number of Workers per Vehicle by Time Leaving Home for Work (2, see table 8)
12
Aggregate Number of Carpools by Time Leaving Home for Work (2, see table 8)
13
Number of Workers per Carpool by Time Leaving Home for Work (2, see table 8)
14
Aggregate Travel Time by Means of transportation to work (7 modes) and Time
Leaving Home for Work (2, see table 8)
Stay Connected
http://www.dot.gov/ctpp
http://www.TRBcensus.com
202-366-5000
Are You on the CTPP-News Listserve?
Have You Seen our Newsletter (the Status Report)?
When Mining Your Census Data
Keep us in Mind
Want to…
Show Off Your Work?
Gain National Exposure?
Meet Other Data Users?
Tour Washington DC?
Sound Exciting?
Let Us Know What You Have Done
We Are Always Interested
TRB Urban Data and Information Systems Committee
Ed Christopher-Chair (708-283-3534)