Census Transportation Planning Products (CTPP) Program Overview

1. Census Transportation Planning Products (CTPP)Program Overview March 11, 2010

2. Overview of the CTPP Program • CTPP is an AASHTO sponsored data program funded by member state transportation agencies • CTPP operates with support from FHWA, RITA, FTA, Census Bureau, MPOs and TRB • The CTPP program includes: • Data products • Training and technical assistance • Research • Designed for the transportation community

3. Applications of CTPP • Performance measurement • Modal share analysis • Environmental justice • FTA New Starts/Small Starts • Travel Demand Modeling • Livability analysis • Corridor planning • Air quality modeling • Trend analysis • Descriptive statistics • Travel forecasting

4. CTPP Data Sources • CTPP uses data from the US Census Bureau American Community Survey (ACS). • The ACS replaced the decennial census “long form” and requires accumulation of data over multiple years for small area tabulation • 1 Year of data for places with 60,000+ people • 3 Years of data for places with 20,000 + people • 5 Years of data for smaller geographic areas, e.g. TAZs

5. Key CTPP Variables • Data on Households • Size, income, vehicles per household • Data on Workers • Age and gender, occupations, earnings • Data on Journey to Work • Usual mode to work, commuting time, work departure time • Data on Workplaces • Work locations, times of arrival at work

6. Key CTPP Products • Transportation Profiles for state, county and place • CTPP 3-Year Data Products • Data access and visualization tools • CTPP 5-year Data Products • TAZ development • Data access and visualization tools • National Data Products

7. Additional CTPP Products • Training and technical support • On-call user support • Training classes and web seminars • Research • Integration of data sources • Disclosure avoidance • Sharing of best practices, successes, challenges and constraints

8. CTPP Program Activities and Costs 5-Year Program: 2007-2012

9. CTPP Oversight Board17 Voting Members – 9 States, 8 MPOs 10 Ex-Officio Members • Jennifer Finch – Chair, CO • Jonette Kreideweis, Vice Chair, MN • Laine Heltebridle, PA • Nathan Erlbaum, NY • Hui Wei Shen, FL • Paul Agnello, VA • Phillip Mescher, IA • Ahmad Jaber, UT • AyalewAdamu, CA • Kuo-Ann Chiao, NYMTC • Steven Gayle, BMTS • Mell Henderson, MARC • ArashMirzaei, NCTCOG • Guy Rousseau, ARC • Clara Reschovsky,MWCOG • Pete Swensson, TRPC • Vacancy • Penelope Weinberger, AASHTO, CTPP Program Manager

10. CTPP Oversight BoardEx-Officio Members • Ed Christopher, FHWA • Melissa Chiu, Census Bureau • Alison Fields, Census Bureau • Rich Denbow, AMPO • Elaine Murakami, FHWA • Robert Padgette, APTA • Alan Pisarski, Consultant • Steven Polzin, USF. CUTR • Nanda Srinivasan, TRB • Elaine Murakami, FHWA • John Sprowls, FTA AASHTO Census Data Work Group With 30+ Members CTPP Federal Technical Advisory Group TRB Subcommittees– List Serve (830 Members) & Quarterly Newsletters

11. CTPP Accomplisments To Date • State, Local and County Profiles for 2005-2007 are completed and posted at the AASHTO website • http://ctpp.transportation.org/profiles_2005-2007/ctpp_profiles.html • 3-Year CTPP list has been finalized and approved by the Census Bureau • Data access software development contract is in place • Plans for a TRB Census Conference in 2011 are underway

12. CTPP Key Contacts • Penelope WeinbergerAASHTO CTPP Program Manager202-624-3556pweinberger@aashto.org • Melissa ChiuCTPP Program CoordinatorCensus Bureau301-763-2421Extension 2454melissa.c.chiu@census.gov http://ctpp.transportation.org

13. An Early CTPP Data Product ACS Data Profiles Ed Christopher Resource CenterPlanning Team Federal Highway Administration 4749 Lincoln Mall Dr. Rm 600 Matteson, IL 60443 708-283-3534 edc@EdtheFed.com

14. Why do them? What good are they? Foundation Building Snapshot of Area Quickly compare Between Areas Begin to Understand Changes Good introduction to the data Easy to do!

15. What are they? 2000 Profiles(1990 and 2000 data) 2005 Profiles(1990, 2000 and 2005 ACS) 2005, 2006 and 2007(2000 and 3-year ACS) • Data Summaries • Focus on Transportation Variables • Resident and Workplace data • Includes Significance Tests • And MOEs for 2000 Data • Various Geographies

16. Residence Workplace What do the Profiles Include? 2000 Long Form Data States and all counties 2005 ACS(65K+ people) States, Large Cities, MSAs and CSAs 2005, 2006, 2007 ACS (20K+ people) States, Counties and Places Includes

17. Note: 3-year ACS data is only available for areas with 20,000 or more residents

18. Where do you find the Profiles? http://ctpp.transportation.org

19. Finding CTPP Profiles http://download.ctpp.transportation.org/profiles_2005-2007/ctpp_profiles.html

20. Read the Notes and Cautions 3-Year Data Profiles

21. Let’s get the data

22. Selecting a Profile Make Your Selections and Click Submit

23. Where is Part 2 Profile 2? Just Choose Your Profile and Click on It

24. What you get (Part 1, Profile 1) What is going on here?

25. What you get (Part 1, Profile 1) Mode To Work Mode to Work Collapsed Travel time to Work Departure time for Work Mean Travel time to Work Vehicles available in HH Mode to Work by Poverty status Mode to Work by Vehicles available HH size by Vehicles available

26. 3-Year Data Profiles

27. Wrapping up Check out the Profiles for your area http://ctpp.transportation.org Need to Brush up on significance testing http://www.edthefed.com/presentations/significance%20testing.ppt

28. Census Transportation Planning Products (CTPP) Mar 11, 2010 CTPP Snapshot Webinar Journey to Work and Migration Statistics Branch Housing and Household Economic Statistics Division U.S. Census Bureau

29. CTPP and ACS Schedule • June 2010 CTPP 2006-2008 released in text (.CSV) format • Sept 2010 CTPP 2006-2008 data access software completed • Dec 2010 ACS 2005-2009 standard products released (tracts, block groups) • Spring 2011 TAZ 2010 Delineation • Summer 2012 CTPP 2006-2010 (tentative)

30. CTPP 2006-2008 Table Summary

31. Collapsed Versions of Variables • A “collapsed” version of a variable combines categories on that variable • Use of collapses is advantageous because … • Due to disclosure protections, there is a minimum of 3 unweighted records per cell for calculations of • Averages (e.g. mean travel time) • Aggregates (e.g. number of vehicles used) • Standard errors calculated by Census Bureau • ACS replicate weight SEs difficult to calculate • Standard errors are more accurate than when combining categories and recalculating from published numbers

32. Means of Transportation (MOT) Collapses • An AASHTO task force defined MOT collapses for the CTPP • Collapses are designed to • Adapt to disclosure protection needs • Accommodate a variety of planning needs in different types of geographic areas • Versions do not all fully nest • MOT (7) provides more detail on non-private vehicle modes • MOT (6) provides more detail on carpools

33. Means of Transportation (MOT)- Full Version MOT (18)

34. Means of Transportation (MOT)- Collapsed Versions

35. Means of Transportation (MOT)- Collapsed Versions

36. Content- Means of Transportation • MOT (18) is used in univariate tables • Only 5 characteristics are allowed to cross with MOT, due to disclosure protections • An AASHTO tables task force selected: • Travel time • Departure time from home / arrival time at workplace • Vehicles available in household • Age • Household income • All 4 collapsed MOT versions are crossed by these 5 variables in all 3 Parts of the CTPP

37. Content- Journey-to-Work • Besides means of transportation, other commuting tables are included: • Travel time (minutes) • Departure time from home / arrival time at workplace • Vehicles available in household • Number of vehicles and carpools used • Workers per carpool, vehicle ridership • For details, go to: www.fhwa.dot.gov/ctpp/acsdataprod.htm

38. Content- Other Information

40. CTPP 3-year Geography (only areas population size 20,000+) * Nation and state also tabulated at geographic components.

41. CTPP 3-year Geographic Components* (only areas population size 20,000+) * Geographic components only tabulated for nation and state.

42. CTPP 3-year Flow Geography (only areas population size 20,000+)

43. CTPP Resources • Federal Highway Administration (FHWA) www.fhwa.dot.gov/ctpp/ Upcoming CTPP data products 2000, 1990 CTPP data products • AASHTO ctpp.transportation.org/ Transportation profiles, training materials • Transportation Research Board trbcensus.com • Bureau of Transportation Statistics (BTS) www.transtats.bts.gov CTPP 2000, CTPP 1990 data download

44. www.census.gov/acs/ Subscribe to the ACS Alert Information about the American Community Survey

45. Web Site Improvements Training • New and revised content on ACS web site ACS Compass Series: Understanding the the ACS (UTACS) Handbooks Tutorials and Powerpoint slides www.census.gov/acs/www/UseData/Compass/compass_series.html • Train the Trainer workshops at SDCs, regional offices, etc.

46. General Users Businesses High School Teachers Media Congressional Staff State & Local Governments Federal Agencies Researchers Rural Areas PUMS Users American Indians / Alaska Natives PRCS (in Spanish) Data User Education: Target Audiences for ACS Compass and Other Materials

47. U. S. Census Bureau • Melissa Chiu, CTPP Coordinator • Journey-to-Work & Migration Statistics Branch • Housing and Household Economic Statistics Division • 301-763-2421 • melissa.c.chiu@census.gov • www.census.gov/population/www/socdemo/journey.html

48. Getting Your CTPP 3-year data On line (Web Based) Table Extractor Similar to CTPP 2000 Easy to Use Downloadable ~ stand alone use Mapping component “Free” with registration

49. Additional Software Highlights User saved sessions Graphic and charting features Variable grouping MOE recalculation Exportable data (xls, cvs, txt, dbf) Training Tutorials Much, much more

50. CTPP 5-year Tabulation TAZ Delineation CTPP Community Liang Long March 11, 2010