Skip to content

Travel Diary Survey Tool Inventory

Suzanne Childress edited this page Mar 20, 2024 · 14 revisions

Travel Survey Data and Tools

Public Data Location

PSRC

https://household-travel-survey-psregcncl.hub.arcgis.com/

SFCTA

MTC

Our public webpage is here: https://mtc.ca.gov/tools-resources/survey-program but the data isn’t posted.

We have a dashboard of freeway-users details here: Bay Area Travel Study 2019 - Freeway Facility User Summary

Met Council https://gisdata.mn.gov/dataset/us-mn-state-metc-society-tbi-home-interview2021

https://gisdata.mn.gov/dataset/us-mn-state-metc-society-tbi-home-interview2019

R library for working with survey that also includes the data https://github.com/Metropolitan-Council/metc.tbi.helper

Agency Landing Page about Travel Survey

PSRC https://www.psrc.org/our-work/household-travel-survey-program MTC: Our public webpage is here: https://mtc.ca.gov/tools-resources/survey-program Met Council: https://metrocouncil.org/Transportation/Performance/Travel-Behavior-Inventory/Household-Travel-Survey.aspx Survey Program Recent and Future Plan Implementation PSRC 2014, 2017, 2019, 2021, 2023, (planned)2025, 2027, 2029 Sample sizes ranging from 3000-7000 households SFCTA MTC Met Council

Internal Data Format

PSRC SQL Server

SFCTA MTC - We’re old school, mostly just text-based.

Met Council

Scripting Languages and Most Popular Tools

PSRC Python, SQL,R, ArcGIS product family, MS Access still

SFCTA

MTC: Python, R

Met Council

Data Cleaning

PSRC https://github.com/psrc/travel-survey-QC-Clean/blob/main/survey_data_cleaning/Rulesy.sql

SFCTA

MTC

Met Council

Data Imputation

PSRC Joint Trip Imputation work (improvements to children’s travel) to be completed shortly

SFCTA

MTC

  • Facility Matching with Smartphone telemetry

Met Council

Modeling Preparation

PSRC For DaySim and ActivitySim https://github.com/psrc/survey-conversion

SFCTA https://github.com/sfcta/survey_scripts_tnc2019

MTC

Met Council

Summarization and Visualization

PSRC

https://github.com/psrc/travel-studies - Where we store code across languages to summarize travel survey data

https://rsginc.github.io/travelSurveyTools/

R Shiny app that we want to update shortly: https://psrcwa.shinyapps.io/travel-study-stories/

Typically each survey year we create a series of presentations for our planning committees and data vignettes about planning topics Examples: https://www.psrc.org/media/7630 (home deliveries), https://www.psrc.org/media/7296 (transportation demand management)

SFTCA

MTC Met Council

Other PSRC Use an MS Access database with forms to make manual edits sending update queries to our SQL Server database, enables cleaning by interns

We have found the best way to get more users is to have intensive internal weekly training on working with the data. Efforts to include other jurisdictions/data analysts that have include 1-2 time trainings have not been successful.

Met Council

Upcoming plans and priorities

Clone this wiki locally