Census Transportation Planning Products (CTPP) Data Products

1. Census Transportation Planning Products (CTPP)Data Products June 18, 2010

2. Key CTPP Products • Transportation Profiles for state, county and place • CTPP based on 3-Year ACS Data Products • Data access and visualization tools • CTPP based on 5-year ACS Data Products • TAZ development • Data access and visualization tools • National Data Products – Commuting in America

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

4. Ready to Rock Profiles Transportation Profiles for state, county and place 2000 – States, Counties (towns) cf. 1990 2005 – Single year ACS – States cf. 2000 2005 – 2007 – 3-yr ACS >20,000 cf. 2000

5. CTPP Profiles 2005 - 2007 Part 1 Profile 1 has the following tables: Total Persons, Persons in Households, Total Households, Average Household Size, Average Vehicles per Households, Persons in Group Quarters, Total Workers and Workers at Work, Mode to Work (including collapsed version), Travel Time to Work, Departure Time to Work and Mean Travel Time by Mode to Work. Part 1 Profile 2 has the following tables: Vehicles available in Household, Mode to Work by Poverty Status, Mode to Work by Vehicles available, Household size by Vehicles available, Vehicles available by Workers in Household, Persons in Household by Workers in Household, Household Income in Household. Part 1 Profile 3 has two tables: Mode to Work by Travel Time and Mode to Work by Time Leaving Home. Part 2 Profile 1 has the following tables: Total Workers, Total Workers Excluding Home-based Workers, Mean Travel Time to work, Average Vehicle Occupancy, Average Carpool size and Workers in Group Quarters, Total Workers by Sex, Mode to Work, Total Workers by Industry, Travel Time to Work and Arrival Time to Work. Part 2 Profile 2 has one table: Mode to Work by Industry.

6. Where do you find the Profiles? http://ctpp.transportation.org/Pages/default.aspx

7. http://download.ctpp.transportation.org/profiles_2005-2007/ctpp_profiles.htmlhttp://download.ctpp.transportation.org/profiles_2005-2007/ctpp_profiles.html

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

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

10. 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

11. 3-Year Data Profiles for large areas

12. Key CTPP Products • Transportation Profiles for state, county and place • CTPP based on 3-Year ACS Data Products • Data access and visualization tools • CTPP based on 5-year ACS Data Products • TAZ development • Data access and visualization tools • National Data Products – Commuting in America

13. When do we get CTPP based on 2006 – 2008 ACS • June 2010 CTPP based on 2006-2008 ACS released in text (.CSV) format • Sept 2010 CTPP based on 2006-2008 ACS 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)

14. CTPP based on 2006-2008 ACS Table Summary CTPP_custom_tabulations_based_on_3yracs2006_2008

15. Content

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

17. Collapsed Variables • A “collapsed” version of a variable combines categories on that variable • Use of collapses is necessary because … • Due to disclosure protections, there is a minimum requirement of 3 unweighted records per cell for calculations of • Averages (e.g. mean travel time) • Aggregates (e.g. number of vehicles used) • Or the table is suppressed!

18. Means of Transportation (MOT) Collapses • A CTPP subcommittee defined MOT collapses for the CTPP based on 3-year ACS • 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

19. Means of Transportation (MOT)- Collapsed Versions

20. Means of Transportation (MOT)- Collapsed Versions

21. Content- Means of Transportation • MOT (18) is used in univariate tables • Only 5 characteristics are allowed to cross with MOT, which made the threshold go away • The CTPP subcommittee 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

22. 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

24. Geography Levels • Workplace and Residence data is available at the following levels for areas with population 20,000 or greater: • Nation • State • County • County Subdivision • Place • PUMA (Public Use Microdata Area) – place of work PUMAs are slightly different from residence ones • Metropolitan Statistical Area (MSA) • MSA Principal City

25. Geography Levels • Flow data is available at the following levels (residence-to-workplace): • State to state • County to county • County-subdivision to county-subdivision • Place to place • PUMA to PUMA • Principal-city to principal-city • County to place • County-subdivision to place • PUMA to place

26. Accessing the 3-year data • All available on a single easy-to-use free website • Free to use, but you do need to register • Online help and tutorials help users along the way • Create “sessions”, which are groups of tables with a common geography selection • Select geography using a map and/or drill down through the geographic hierarchy • Search for tables by dimension name or any relevant word • Either within one of the parts or across all parts

27. Viewing the data • Open any table, either in your “session” or from the public view. • From there, you can customize your view of the data: • Rearrange dimensions • Make selections on any dimension • View charts • View the data on a thematic map • Aggregate items using standard functions or provide a formula (margin of error will be recalculated for you for simpler formulas) • Save your report for future use • Save your selections and aggregations for use in other tables

28. Exporting the Data • Once you have set up the table you want to see, you can export it: • Export the data in CSV, XLS or Beyond 20/20 (IVT) format for use in your own analysis tools • Export SHP files for viewing maps in your own GIS engine • Entire “sessions” can be exported in a single operation.

29. Key CTPP Products • Transportation Profiles for state, county and place • CTPP based on 3-Year ACS Data Products • Data access and visualization tools • CTPP based on 5-year ACS Data Products • TAZ development • Data access and visualization tools • National Data Products – Commuting in America

30. CTPP and ACS Schedule • Dec 2010 ACS 2005-2009 standard products released (tracts, block groups) • Spring 2011 TAZ 2010 Delineation • Dec 2011 ACS 2006-2010 standard products released (tracts, block groups) • Summer 2012 CTPP based on 2006-2010 ACS (tentative)

31. A few notes about CTPP based on 5 year ACS (2006 – 2010) • Includes all size geography • Down to TAD, Tract, Block Group or TAZ • Two “sets” of tables dependant upon population • Large area 20,000 and above • Small area below 20,000 • More collapsed/collapsing variables • To get better quality data • NCHRP 8-79 - Producing Transportation Data Products from the American Community Survey that Comply with Disclosure Rules

32. Key CTPP Products • Transportation Profiles for state, county and place • CTPP based on 3-Year ACS Data Products • Data access and visualization tools • CTPP based on 5-year ACS Data Products • TAZ development • Data access and visualization tools • National Data Products – Commuting in America

33. A few notes about National Data Products • A new incarnation of Commuting in America • May be a series of reports • Likely based on Public Use Micro Sample data (PUMS)