1 / 57

Federal Data for Modelers

Join us for a workshop session on federal data for modelers. Learn about the Census Transportation Planning Products program, the American Community Survey, Longitudinal Employment Household Dynamics, and the National Household Travel Survey. Discover how these resources can enhance your modeling efforts.

coreymercado
Download Presentation

Federal Data for Modelers

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Federal Data for Modelers Ed Christopher Resource CenterPlanning Team Federal Highway Administration 19900 Governors Drive Olympia Fields, IL 60461 708-283-3534 edc@EdTheFed.com

  2. Workshop/Session S1  Federal Data for Modelers: Are you prepared for the future? 2:00 pm - 4:00 pm Census Transportation Planning Products (CTPP) ProgramEd Christopher, FHWA Resource Center American Community Survey (ACS)Melissa Chiu, US Census Bureau Elaine Murakami, FHWA-Planning Longitudinal Employment Household Dynamics (LEHD) Matthew Graham, US Census Bureau National Household Travel Survey (NHTS) Heather Contrino, FHWA

  3. National Household Travel Survey

  4. Obtains trips from one address to another by all modes…

  5. NHTS Core Data Content • Household • Income, composition, location • Person • Age, sex, race, ethnicity, worker and student status, citizenship, education • Geography • High level geography – urban, rural, suburban, state and national analyses • Vehicles • Make, model, year, mileage, alternative fuels, commercially licensed • Trips • Mode, time of day, purpose, vehicle occupancy, distance, trip length

  6. NHTS – Two Components • National Study • Serves USDOT, Congress, and White House • Resource for State, metro areas (MPOs), etc. • 40 years of trend data on U.S. travel behavior • Sample size: 25,000 households • Add-On Program • Service to States and MPOs since 1990 • Allows States and MPOs to purchase additional samples • 2008 sample size: 125,000 (a doubling from 2001)

  7. Vermont DOT Wisconsin DOT South Dakota DOT New York State DOT Cedar Rapids, IA Iowa DOT Indiana DOT Omaha, Nebraska California DOT Virginia DOT North Carolina DOT Tennessee DOT Piedmont Region Maricopa, AZ South Carolina DOT Pima, AZ Georgia DOT Texas DOT Florida DOT NHTS – Add On 125,000 Add-On Samples

  8. Survey Design - New for 2008 • Allows for valid statewide data--minimum sample (n=250) • Cell Phone only sample • Customizable content for Add-On participants • New data items for national study

  9. New 2008 NHTS Content • Congestion • Interstate use and tolling • Telecommuting – opportunity and frequency • Work arrival time and flexibility • Safety • Safe Travel to School • Travel impacts of disability • Energy and Environment • Shopping by Internet and deliveries to the household • Hybrid/Alternative fuel vehicles • Fuel costs by vehicle type and travel behavior • Vehicle age, odometer reading, and annual mileage • Alternative Modes • Access (to transit) travel party size • Frequency of walk and bike • Motorcycle ownership and use

  10. 2008 NHTS Schedule • April 2009 - Data collection completed • June 2009 - Final unweighted data for QA • August 2009 - Add-On GIS files • August 2009 – Draft final weighted file for QA • October 2009 – Final weighted data and documentation • Add-Ons receive final data • January 2009 – Public use data set • On-line analysis tool available for 2008 • March 2009 – Final full documentation and users guide

  11. NHTS Products • Policy Briefs: http://ornl.gov/publications.shtml#issueBriefs • Trends Database: To be posted soon • Transferable data for trip generation • http://fmip.ornl.gov/nhts/ • Risk Assessment Tool: • http://www.aaafoundation.org/trafficSTATS/ • On-line Analysis Tool: http://nhts.ornl.gov • SAS Data Set: http://nhts.ornl.gov/download.shtml http://nhts.ornl.gov

  12. NHTS Contact Heather Contrino Heather.Contrino@dot.gov Project Manager

  13. Local Employment Dynamics (LED) Local Employment Household Dynamics (LEHD) http://lehd.did.census.gov On The Map http://lehdmap3.did.census.gov/themap3/

  14. Local Employment Dynamics (LED) Federal-State Partnership Based on Administrative Records State UI Wage Records Quarterly Census of Employment and Wages Database Updated Quarterly Ongoing QA/QC and Data Improvement What is LED?

  15. The LED Partnership StatePartners UI Wage Records & QCEW U.S. Census Bureau Censuses & Surveys Local Employment Dynamics (LED) Online24/7 Free! QWI Online OnTheMap

  16. A Dataset… Origin-Destination Data Census’ first partially synthetic dataset Public-use data at the Census block level Worker characteristic data: Age, Earnings, Industry What is OnTheMap?

  17. and a Tool. Online, free, 24/7, interactive Mapping complex data for those without GIS knowledge or resources Allows sophisticated queries based upon standard Census geography……Or from arbitrary block-based areas. What is OnTheMap?

  18. Start with LED data infrastructure Employment information based upon Quarterly Workforce Indicators (QWI) Residential information and origin-destination relationships synthesized From PCF, 2000 Decennial Census, ACS, and StARS as well as SIPP and CPS CTPP informs the prior How is the Data Constructed?

  19. QWI and OnTheMap workplace data protected by dynamically consistent noise infusion applied at the establishment level Ramp distribution with a hole in the middle OnTheMap residence, origin/destination, and QWI-suppressed workplace employment are protected by synthetic data Multinomial/Dirichlet PPD Add noise and protections

  20. OnTheMap Application Download from VirtualRDC Hosted by Cornell University Same data as in the application Block based Multiple labor segments How to Access the Data?

  21. LED Partnership 21

  22. LED Products 22 22

  23. LED Partnership/LEHD Program Jeremy Wu, LEHD Program Manager jeremy.s.wu@census.gov http://lehd.did.census.gov ces.local.employment.dynamics@census.gov QWI Online http://lehd.did.census.gov/led/datatools/qwiapp.html OnTheMap http://lehdmap3.did.census.gov/themap3/ Links/Contacts

  24. What is the American Community Survey Replacement of the Long Form Continuous Survey Methodology Conducted Monthly Produces characteristics, notpopulationcounts http://www.census.gov/acs/www/

  25. ACS Facts 250,000 Households sampled per month About 1 in 40 Households sampled per year Same transportation questions as 2000 Long Form Decennial Long Form is History Kaput, Nada, Defunct, Gone!

  26. How does the ACS work? Three Methods of Data Collection 1. MailSelf-administered mail-out/mail-back 2. TelephoneComputer Assisted Telephone Interviewing (CATI) 3. Personal VisitsComputer Assisted Personal Interviewing (CAPI) 1:3

  27. Some of what the ACS provides ACS Standard Tables Standard Tabs include some “New” tables previously only in CTPP, eg place of work - Mode to work by travel time - Mode to work by time leaving home - Household size by # of vehicles - Household size by # of workers http://factfinder.census.gov/

  28. Data Type Population Size of Area Data for the Previous Year Released in: 2006 2007 2008 2009 2010 2011 2012+ Annual 65,000+ 3-year Period 20,000+ 5-year Period Tract and Block Group ACS Data Release Timeline

  29. Is it 1 or 3 or 5? What does this mean? Users will have to choose which data to use • Population < 20,000 • 5-year estimates only • Population >= 20,000 and < 65,000 • 3-year estimates • 5-year estimates • Population >= 65,000 • 1-year estimates • 3-year estimates • 5-year estimates

  30. Geography simplified

  31. Percent of Population 5 Years and Older who Speak Spanish at Home - Lake County, IL ReliabilityvsCurrency

  32. There are RESOURCES AVAILABLE A Compass for Understanding And Using ACS Data l Set of user-specific handbooks l Train-the trainer materials l E-learning ACS Tutorial http://www.census.gov/acs/www/UseData/Compass/compass_series.html

  33. Training and Technical Assistance Report 588 A Guidebook for Using ACS Data for Transportation Planning ACS for Transportation Trend Analysis How to recalculate Margins of Error (MOEs) 275 pages http://onlinepubs.trb.org/onlinepubs/nchrp/nchrp_rpt_588.pdf

  34. Flows between Home and Work At Workplace At Residence Census Transportation Planning Products 1960 OMB Journey-to-Work Tables 1970 and 1980 Urban Transportation Planning Package (UTPP) 1990 and 2000 Census Transportation Planning Package (CTPP)

  35. Past Journey to Work data All States and MPOs

  36. 2000 BTS Product Distribution Center 1990 and 2000 BTS TranStats 1980 Try the MPO 1970 Try the MPO 1960 Good Luck http://www.transtats.bts.gov/ Call a Friend Where do you get the data https://www.bts.gov/pdc/

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

  38. The NEW CTPP program lAll States + DC lAASHTO Led lOversight Board lFive Year period ~ 2011 Federal Technical Advisory Group TRB Subcommittee -- List Serve (700 strong) Quarterly Newsletter -- Outreach Several Websites

  39. Staff Additions Penelope Weinberger CTPP Program Manager, AASHTO 444 North Capitol Street NE Suite 249 Washington, DC 20001 202-624-3556 pweinberger@aashto.org http://ctpp.transportation.org Melissa Chiu CTPP Program Manager Census Bureau 301-763-2421 or (2454) melissa.c.chiu@census.gov

  40. Census Data Tabulations April 1, ‘09 New 3-year Table Request Submitted

  41. 2000 Geography Product Structure 3-Parts Part 1-Place of Residence Part 2-Place of Work Part 3-Flows between Home and Work (Extraction Software) Nation (US Total) State State-County State-County-MCD State-Place State-PUMA State-POW PUMA Metropolitan Statistical Area MSA – EACH Principal City The 3-year Product Design

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

  43. Collapsing Schema

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

  45. 5-year Data Product

  46. 5-year Data Product 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_Proposal_Oct2008.pdf

  47. But why the Change? Will there be Traffic Analysis Zones? • 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

  48. TRB Census Subcommittee www.TRBcensus.com

  49. USDOT (FHWA) Website http://www.dot.gov/ctpp

  50. AASHTO Website http://ctpp.transportation.org

More Related