2016 Household Travel Behavior Survey

The 2016 Household Travel Behavior Survey project contains the delivered raw datasets, a Python project providing cleaned datasets, and SQL objects facilitating loading into SANDAGs SQL Server environment. For documentation on the survey process and/or raw results processed outside of this project please see SANDAG and RSG's Technical Report and Appendix.

The Python project also includes a utility to load the cleaned household travel behavior survey datasets into SANDAGs SQL Server environment. To run the project

• Pull the hhts repository from GitHub into your local environment making sure to select the release branch corresponding to the household travel behavior survey of interest
• Update the main.py file located in the python folder to point at the correct SQL Server instance and database containing the SQL objects created by the hhtbs2016Objects.sql file in the sql folder
• Use the environment.yml file located in the python folder to create the hhtbs2016 Python virtual environment and set as the project interpreter. For more information see Managing environments.
• Run python\main.py directly from the python folder

Note that the Python project can be easily altered to output cleaned datasets to flat-file destinations instead of SANDAGs SQL environment.

Python

File	Description
environment.yml	conda environment used to run python files
main.py	orchestrator file used to load cleaned datasets to SANDAGs SQL environment
hhtbs2016Data.py	class for all information and utilities to output cleaned 2016 Household Travel Behavior Survey datasets

SQL Tables and Views

Name	Description
[hhtbs2016].[border_trips]	household cross border trip list
[hhtbs2016].[day]	person day-level trip diary data-set
[hhtbs2016].[households]	household list
[hhtbs2016].[intercept]	active transportation intercept survey
[hhtbs2016].[location_lines]	trip paths built from ordered trip location point data
[hhtbs2016].[location_points]	ordered trip location point data
[hhtbs2016].[persons]	persons list
[hhtbs2016].[trips]	person trip list
[hhtbs2016].[vehicles]	household vehicle list

Go To Top