-
Notifications
You must be signed in to change notification settings - Fork 1
HHTBS 2016 Dataset Trip List
Gregor Schroeder edited this page Apr 29, 2021
·
3 revisions
Trip list
SQL Table: [hhtbs2016].[trips]
Field | Description |
---|---|
trip_id |
unique identifier of trip |
trip_id_linked |
linked trip identifier |
trip_id_location |
trip identifier for joining to location table |
person_id |
unique identifier of person |
household_id |
unique identifier of household |
travel_date |
date of travel |
travel_day_number |
travel day number for person (1-7) |
travel_day_of_week |
travel day of week |
data_source |
trip was recorded by rMove or online |
completed_trip_survey |
trip survey is complete |
completed_date |
rMove trip; date and time survey was completed |
completed_household_survey |
all household surveys completed on travel date of trip |
completed_person_survey |
all surveys completed by person on travel date of trip |
number_household_survey_weekdays |
number of complete weekdays for household |
revised_at |
rMove trip; Date and time survey was last revised |
revised_count |
rMove trip; Number of revisions to survey |
error |
rMove trip; user reported error on trip |
flag_teleport |
rMove trip; >=250m gap occurs after trip |
copied_trip |
trip copied from another household member |
analyst_merged_trip |
rMove trip; trip is result of 2 or more trips merged by analyst |
analyst_split_trip |
rMove trip; trip is result of trip split by analyst |
user_merged_trip |
rMove trip; trip is result of 2 or more trips merged by user |
user_split_trip |
rMove trip; trip is result of trip split by user |
added_trip |
rMove trip; trip was added by user |
nonproxy_derived_trip |
rMove trip; trip was derived from a non-proxy record for a non-participant |
proxy_added_trip |
rMove trip; trip was added by proxy respondent |
unlinked_transit_trip |
trip is part of an unlinked transit trip |
origin_name |
online trip; origin name |
origin_address |
online trip; origin address |
origin_latitude |
origin latitude |
origin_longitude |
origin longitude |
origin_shape |
origin point geometry (EPSG: 2230) |
origin_mgra_13 |
origin Series 13 MGRA |
destination_name |
online trip; destination name |
destination_address |
online trip; destination address |
destination_latitude |
destination latitude |
destination_longitude |
destination longitude |
destination_shape |
destination point geometry (EPSG:2230) |
destination_mgra_13 |
destination Series 13 MGRA |
origin_purpose |
derived origin purpose |
origin_purpose_other_specify |
derived other origin purpose |
origin_purpose_inferred |
inferred origin purpose based on home, work, and school locations |
destination_purpose |
derived destination purpose |
destination_purpose_other_specify |
derived other destination purpose |
destination_purpose_inferred |
inferred destination purpose based on home, work, and school locations |
departure_time |
departure time |
arrival_time |
arrival time |
travelers |
derived number of people on trip, including self |
travelers_household |
derived number of household members on trip, including self |
travelers_non_household |
number of non-household members on trip |
mode_1 |
travel mode (up to four allowed on a trip) |
mode_2 |
travel mode (up to four allowed on a trip) |
mode_3 |
travel mode (up to four allowed on a trip) |
mode_4 |
travel mode (up to four allowed on a trip) |
mode_transit_access |
online trip, bus or rail; access mode |
mode_transit_egress |
online trip, bus or rail; egress mode |
google_mode |
unlinked transit trip; google-suggested mode category for trip leg |
driver |
auto trip, non-taxi; Driver or passenger on trip |
toll_road |
online trip, auto trip; used toll road |
toll_road_express |
online trip, auto trip; used toll road with express lane |
parking_location |
auto trip, non-taxi; parking location |
parking_pay_type |
parked on street/lot; how paid for parking |
parking_cost |
paid for parking; cost of parking ($) |
parking_cost_dk |
paid for parking; does not know cost of parking |
parking_egress_duration |
rMove, parked on street/lot; walking duration from parking spot to destination (minutes) |
taxi_pay_type |
taxi trip; how paid for taxi |
taxi_cost |
taxi trip, paid or was reimbursed; cost of taxi fare ($) |
taxi_cost_dk |
taxi trip, paid or was reimbursed; does not know cost of taxi fare |
airplane_pay_type |
airplane trip; how paid for airfare |
airplane_cost |
airplane trip, paid; cost of airfare ($) |
airplane_cost_dk |
airplane trip, paid; does not know cost of airfare |
bus_pay_type |
bus trip; how paid for fare |
bus_cost |
bus trip, paid; cost of fare ($) |
bus_cost_dk |
bus trip, paid; does not know cost of fare |
rail_pay_type |
rail trip; how paid for fare |
rail_cost |
rail trip, paid; cost of fare ($) |
rail_cost_dk |
rail trip, paid; does not know cost of fare |
ferry_pay_type |
ferry trip; how paid for fare |
ferry_cost |
ferry trip, paid; cost of fare ($) |
ferry_cost_dk |
ferry trip, paid; does not know cost of fare |
parkride_lot |
online trip, parked in Park& Ride lot; which lot |
parkride_city |
online trip, parked in Park & Ride lot; city where lot is located |
distance |
derived trip path distance (miles) |
duration |
derived trip duration (minutes) |
duration_reported |
online trip: reported trip duration (minutes) |
speed |
rMove trip: derived trip speed (mph) |
weight_trip |
weight to use for non-weighted survey trip based metrics |
weight_person_trip |
weight to use for non-weighted survey person trip based metrics |
weight_household_multiday_factor |
household multi-day weight factor |
weight_person_multiday_456x |
factored person-day weight |
Field | Valid Count | Missing Count | Pct. Missing |
---|---|---|---|
trip_id | 293587 | 0 | 0 |
trip_id_linked | 293587 | 0 | 0 |
trip_id_location | 293587 | 0 | 0 |
person_id | 293587 | 0 | 0 |
household_id | 293587 | 0 | 0 |
travel_date | 293587 | 0 | 0 |
travel_day_number | 293310 | 277 | 0.1 |
travel_day_of_week | 293587 | 0 | 0 |
data_source | 293587 | 0 | 0 |
completed_trip_survey | 293587 | 0 | 0 |
completed_date | 262506 | 31081 | 10.6 |
completed_household_survey | 285552 | 8035 | 2.7 |
completed_person_survey | 282145 | 11442 | 3.9 |
number_household_survey_weekdays | 282145 | 11442 | 3.9 |
revised_at | 10779 | 282808 | 96.3 |
revised_count | 293587 | 0 | 0 |
error | 259530 | 34057 | 11.6 |
flag_teleport | 273289 | 20298 | 6.9 |
copied_trip | 278155 | 15432 | 5.3 |
analyst_merged_trip | 273289 | 20298 | 6.9 |
analyst_split_trip | 273289 | 20298 | 6.9 |
user_merged_trip | 278155 | 15432 | 5.3 |
user_split_trip | 278155 | 15432 | 5.3 |
added_trip | 278155 | 15432 | 5.3 |
nonproxy_derived_trip | 34503 | 259084 | 88.2 |
proxy_added_trip | 34366 | 259221 | 88.3 |
unlinked_transit_trip | 293587 | 0 | 0 |
origin_name | 293587 | 0 | 0 |
origin_address | 293587 | 0 | 0 |
origin_latitude | 293587 | 0 | 0 |
origin_longitude | 293587 | 0 | 0 |
origin_shape | 293587 | 0 | 0 |
origin_mgra_13 | 293587 | 0 | 0 |
destination_name | 293587 | 0 | 0 |
destination_address | 293587 | 0 | 0 |
destination_latitude | 293585 | 2 | 0 |
destination_longitude | 293585 | 2 | 0 |
destination_shape | 293585 | 2 | 0 |
destination_mgra_13 | 293585 | 2 | 0 |
origin_purpose | 271002 | 22585 | 7.7 |
origin_purpose_other_specify | 293587 | 0 | 0 |
origin_purpose_inferred | 274969 | 18618 | 6.3 |
destination_purpose | 278577 | 15010 | 5.1 |
destination_purpose_other_specify | 293587 | 0 | 0 |
destination_purpose_inferred | 274969 | 18618 | 6.3 |
departure_time | 293587 | 0 | 0 |
arrival_time | 293587 | 0 | 0 |
travelers | 293587 | 0 | 0 |
travelers_household | 293587 | 0 | 0 |
travelers_non_household | 293587 | 0 | 0 |
mode_1 | 278560 | 15027 | 5.1 |
mode_2 | 4051 | 289536 | 98.6 |
mode_3 | 502 | 293085 | 99.8 |
mode_4 | 76 | 293511 | 100 |
mode_transit_access | 857 | 292730 | 99.7 |
mode_transit_egress | 857 | 292730 | 99.7 |
google_mode | 14887 | 278700 | 94.9 |
driver | 118256 | 175331 | 59.7 |
toll_road | 10332 | 283255 | 96.5 |
toll_road_express | 10332 | 283255 | 96.5 |
parking_location | 224299 | 69288 | 23.6 |
parking_pay_type | 144465 | 149122 | 50.8 |
parking_cost | 2507 | 291080 | 99.1 |
parking_cost_dk | 3129 | 290458 | 98.9 |
parking_egress_duration | 115279 | 178308 | 60.7 |
taxi_pay_type | 2043 | 291544 | 99.3 |
taxi_cost | 1258 | 292329 | 99.6 |
taxi_cost_dk | 1547 | 292040 | 99.5 |
airplane_pay_type | 579 | 293008 | 99.8 |
airplane_cost | 306 | 293281 | 99.9 |
airplane_cost_dk | 0 | 293587 | 100 |
bus_pay_type | 5959 | 287628 | 98 |
bus_cost | 453 | 293134 | 99.8 |
bus_cost_dk | 498 | 293089 | 99.8 |
rail_pay_type | 275 | 293312 | 99.9 |
rail_cost | 502 | 293085 | 99.8 |
rail_cost_dk | 6 | 293581 | 100 |
ferry_pay_type | 158 | 293429 | 99.9 |
ferry_cost | 52 | 293535 | 100 |
ferry_cost_dk | 69 | 293518 | 100 |
parkride_lot | 2 | 293585 | 100 |
parkride_city | 2 | 293585 | 100 |
distance | 293571 | 16 | 0 |
duration | 293571 | 16 | 0 |
duration_reported | 15432 | 278155 | 94.7 |
speed | 293571 | 16 | 0 |
weight_trip | 277176 | 16411 | 5.6 |
weight_person_trip | 277176 | 16411 | 5.6 |
weight_household_multiday_factor | 282145 | 11442 | 3.9 |
weight_person_multiday_456x | 282145 | 11442 | 3.9 |
Field | Count | Pct. |
---|---|---|
travel_day_of_week |
||
Monday | 37083 | 12.6 |
Tuesday | 43660 | 14.9 |
Wednesday | 46465 | 15.8 |
Thursday | 46832 | 16.0 |
Friday | 43596 | 14.8 |
Saturday | 41667 | 14.2 |
Sunday | 34284 | 11.7 |
Missing | 0 | 0.0 |
Not Applicable | 0 | 0.0 |
data_source |
||
rMove | 278155 | 94.7 |
Online | 15432 | 5.3 |
Missing | 0 | 0.0 |
Not Applicable | 0 | 0.0 |
completed_trip_survey |
||
No | 15134 | 5.2 |
Yes | 278453 | 94.8 |
Missing | 0 | 0.0 |
Not Applicable | 0 | 0.0 |
completed_household_survey |
||
No | 88554 | 30.2 |
Yes | 196998 | 67.1 |
Not Applicable | 6433 | 2.2 |
Missing | 1602 | 0.5 |
completed_person_survey |
||
No | 47898 | 16.3 |
Yes | 234247 | 79.8 |
Not Applicable | 6433 | 2.2 |
Missing | 5009 | 1.7 |
error |
||
No error | 248985 | 84.8 |
Not moving | 4391 | 1.5 |
Still traveling | 170 | 0.1 |
Made other stops | 114 | 0.0 |
Other error | 5870 | 2.0 |
Missing | 18625 | 6.3 |
Not Applicable | 15432 | 5.3 |
flag_teleport |
||
No | 262857 | 89.5 |
Yes | 10432 | 3.6 |
Missing | 4866 | 1.7 |
Not Applicable | 15432 | 5.3 |
copied_trip |
||
No | 254244 | 86.6 |
Yes | 23911 | 8.1 |
Missing | 0 | 0.0 |
Not Applicable | 15432 | 5.3 |
analyst_merged_trip |
||
No | 272921 | 93.0 |
Yes | 368 | 0.1 |
Missing | 4866 | 1.7 |
Not Applicable | 15432 | 5.3 |
analyst_split_trip |
||
No | 241670 | 82.3 |
Yes | 31619 | 10.8 |
Missing | 4866 | 1.7 |
Not Applicable | 15432 | 5.3 |
user_merged_trip |
||
No | 270264 | 92.1 |
Yes | 7891 | 2.7 |
Missing | 0 | 0.0 |
Not Applicable | 15432 | 5.3 |
user_split_trip |
||
No | 268736 | 91.5 |
Yes | 9419 | 3.2 |
Missing | 0 | 0.0 |
Not Applicable | 15432 | 5.3 |
added_trip |
||
No | 265311 | 90.4 |
Yes | 12844 | 4.4 |
Missing | 0 | 0.0 |
Not Applicable | 15432 | 5.3 |
nonproxy_derived_trip |
||
No | 25859 | 8.8 |
Yes | 8644 | 2.9 |
Not Applicable | 21865 | 7.4 |
Missing | 237219 | 80.8 |
proxy_added_trip |
||
No | 32555 | 11.1 |
Yes | 1811 | 0.6 |
Not Applicable | 21865 | 7.4 |
Missing | 237356 | 80.8 |
unlinked_transit_trip |
||
No | 278764 | 95.0 |
Yes | 14823 | 5.0 |
Missing | 0 | 0.0 |
Not Applicable | 0 | 0.0 |
origin_purpose |
||
Home | 70721 | 24.1 |
School/Class | 482 | 0.2 |
Drop off, pick up, accompany person (Online diary only) | 767 | 0.3 |
Social/leisure/vacation activity (Online diary only) | 690 | 0.2 |
Primary workplace | 23508 | 8.0 |
Work-related | 10058 | 3.4 |
Traveling for work (e.g., going to airport) | 533 | 0.2 |
Volunteer work | 132 | 0.0 |
Other work | 1156 | 0.4 |
K-12 School | 1301 | 0.4 |
College/University | 1824 | 0.6 |
Other education-related (e.g., field trip) | 586 | 0.2 |
Vocational education | 149 | 0.1 |
Grocery | 13607 | 4.6 |
Gas | 3329 | 1.1 |
Routine shopping | 12552 | 4.3 |
Errands without appointment | 6871 | 2.3 |
Medical | 3843 | 1.3 |
Shopping for a major item | 1061 | 0.4 |
Errands with appointment | 2877 | 1.0 |
Pick someone up (rMove only) | 9338 | 3.2 |
Drop someone off (rMove only) | 12878 | 4.4 |
Accompany someone (rMove only) | 1064 | 0.4 |
Multiple: pickup, dropoff, accompany (rMove only) | 1096 | 0.4 |
Restaurant | 26489 | 9.0 |
Exercise | 15533 | 5.3 |
Social (rMove only) | 8414 | 2.9 |
Leisure/entertainment (rMove only) | 5776 | 2.0 |
Religious/civic (rMove only) | 1871 | 0.6 |
Vacation/travel (rMove only) | 2749 | 0.9 |
Family activity (rMove only) | 2609 | 0.9 |
Change travel mode | 12191 | 4.2 |
Other errand | 2808 | 1.0 |
Other leisure (rMove only) | 1186 | 0.4 |
Other purpose | 9616 | 3.3 |
Other | 1337 | 0.5 |
Technical error | 0 | 0.0 |
Participant non-response | 14573 | 5.0 |
Missing | 8012 | 2.7 |
Not Applicable | 0 | 0.0 |
origin_purpose_inferred |
||
Home | 68019 | 23.2 |
School/Class | 0 | 0.0 |
Drop off, pick up, accompany person (Online diary only) | 0 | 0.0 |
Social/leisure/vacation activity (Online diary only) | 0 | 0.0 |
Primary workplace | 14509 | 4.9 |
Work-related | 0 | 0.0 |
Traveling for work (e.g., going to airport) | 0 | 0.0 |
Volunteer work | 0 | 0.0 |
Other work | 0 | 0.0 |
K-12 School | 2093 | 0.7 |
College/University | 476 | 0.2 |
Other education-related (e.g., field trip) | 560 | 0.2 |
Vocational education | 52 | 0.0 |
Grocery | 0 | 0.0 |
Gas | 0 | 0.0 |
Routine shopping | 0 | 0.0 |
Errands without appointment | 0 | 0.0 |
Medical | 0 | 0.0 |
Shopping for a major item | 0 | 0.0 |
Errands with appointment | 0 | 0.0 |
Pick someone up (rMove only) | 0 | 0.0 |
Drop someone off (rMove only) | 0 | 0.0 |
Accompany someone (rMove only) | 0 | 0.0 |
Multiple: pickup, dropoff, accompany (rMove only) | 0 | 0.0 |
Restaurant | 0 | 0.0 |
Exercise | 0 | 0.0 |
Social (rMove only) | 0 | 0.0 |
Leisure/entertainment (rMove only) | 0 | 0.0 |
Religious/civic (rMove only) | 0 | 0.0 |
Vacation/travel (rMove only) | 0 | 0.0 |
Family activity (rMove only) | 0 | 0.0 |
Change travel mode | 0 | 0.0 |
Other errand | 0 | 0.0 |
Other leisure (rMove only) | 0 | 0.0 |
Other purpose | 189260 | 64.5 |
Other | 0 | 0.0 |
Technical error | 0 | 0.0 |
Participant non-response | 0 | 0.0 |
Missing | 3186 | 1.1 |
Not Applicable | 15432 | 5.3 |
destination_purpose |
||
Home | 76843 | 26.2 |
School/Class | 494 | 0.2 |
Drop off, pick up, accompany person (Online diary only) | 779 | 0.3 |
Social/leisure/vacation activity (Online diary only) | 719 | 0.2 |
Primary workplace | 23564 | 8.0 |
Work-related | 10085 | 3.4 |
Traveling for work (e.g., going to airport) | 538 | 0.2 |
Volunteer work | 131 | 0.0 |
Other work | 1161 | 0.4 |
K-12 School | 1321 | 0.4 |
College/University | 1829 | 0.6 |
Other education-related (e.g., field trip) | 590 | 0.2 |
Vocational education | 149 | 0.1 |
Grocery | 13687 | 4.7 |
Gas | 3342 | 1.1 |
Routine shopping | 12585 | 4.3 |
Errands without appointment | 6904 | 2.4 |
Medical | 3857 | 1.3 |
Shopping for a major item | 1063 | 0.4 |
Errands with appointment | 2885 | 1.0 |
Pick someone up (rMove only) | 9435 | 3.2 |
Drop someone off (rMove only) | 13046 | 4.4 |
Accompany someone (rMove only) | 1069 | 0.4 |
Multiple: pickup, dropoff, accompany (rMove only) | 1108 | 0.4 |
Restaurant | 26604 | 9.1 |
Exercise | 15826 | 5.4 |
Social (rMove only) | 8486 | 2.9 |
Leisure/entertainment (rMove only) | 5791 | 2.0 |
Religious/civic (rMove only) | 1875 | 0.6 |
Vacation/travel (rMove only) | 2789 | 0.9 |
Family activity (rMove only) | 2619 | 0.9 |
Change travel mode | 12417 | 4.2 |
Other errand | 2815 | 1.0 |
Other leisure (rMove only) | 1192 | 0.4 |
Other purpose | 10979 | 3.7 |
Other | 0 | 0.0 |
Technical error | 0 | 0.0 |
Participant non-response | 15010 | 5.1 |
Missing | 0 | 0.0 |
Not Applicable | 0 | 0.0 |
destination_purpose_inferred |
||
Home | 70921 | 24.2 |
School/Class | 0 | 0.0 |
Drop off, pick up, accompany person (Online diary only) | 0 | 0.0 |
Social/leisure/vacation activity (Online diary only) | 0 | 0.0 |
Primary workplace | 16677 | 5.7 |
Work-related | 0 | 0.0 |
Traveling for work (e.g., going to airport) | 0 | 0.0 |
Volunteer work | 0 | 0.0 |
Other work | 0 | 0.0 |
K-12 School | 3056 | 1.0 |
College/University | 746 | 0.3 |
Other education-related (e.g., field trip) | 742 | 0.3 |
Vocational education | 60 | 0.0 |
Grocery | 0 | 0.0 |
Gas | 0 | 0.0 |
Routine shopping | 0 | 0.0 |
Errands without appointment | 0 | 0.0 |
Medical | 0 | 0.0 |
Shopping for a major item | 0 | 0.0 |
Errands with appointment | 0 | 0.0 |
Pick someone up (rMove only) | 0 | 0.0 |
Drop someone off (rMove only) | 0 | 0.0 |
Accompany someone (rMove only) | 0 | 0.0 |
Multiple: pickup, dropoff, accompany (rMove only) | 0 | 0.0 |
Restaurant | 0 | 0.0 |
Exercise | 0 | 0.0 |
Social (rMove only) | 0 | 0.0 |
Leisure/entertainment (rMove only) | 0 | 0.0 |
Religious/civic (rMove only) | 0 | 0.0 |
Vacation/travel (rMove only) | 0 | 0.0 |
Family activity (rMove only) | 0 | 0.0 |
Change travel mode | 0 | 0.0 |
Other errand | 0 | 0.0 |
Other leisure (rMove only) | 0 | 0.0 |
Other purpose | 182051 | 62.0 |
Other | 716 | 0.2 |
Technical error | 0 | 0.0 |
Participant non-response | 0 | 0.0 |
Missing | 3186 | 1.1 |
Not Applicable | 15432 | 5.3 |
travelers |
||
1 | 144171 | 49.1 |
2 | 76386 | 26.0 |
3 | 30866 | 10.5 |
4 | 16056 | 5.5 |
5 | 6007 | 2.0 |
6 | 3612 | 1.2 |
7 | 966 | 0.3 |
8 | 209 | 0.1 |
9 | 173 | 0.1 |
10 | 136 | 0.0 |
Participant Non-response | 15005 | 5.1 |
Technical error | 0 | 0.0 |
Missing | 0 | 0.0 |
Not Applicable | 0 | 0.0 |
travelers_household |
||
1 | 177005 | 60.3 |
2 | 67059 | 22.8 |
3 | 22685 | 7.7 |
4 | 11249 | 3.8 |
5 | 3208 | 1.1 |
6 | 751 | 0.3 |
7 | 40 | 0.0 |
8 | 32 | 0.0 |
9 | 52 | 0.0 |
10 | 0 | 0.0 |
Participant Non-response | 11506 | 3.9 |
Technical error | 0 | 0.0 |
Missing | 0 | 0.0 |
Not Applicable | 0 | 0.0 |
travelers_non_household |
||
0 | 233394 | 79.5 |
1 | 29292 | 10.0 |
2 | 8908 | 3.0 |
3 | 3092 | 1.1 |
4 | 1218 | 0.4 |
5+ | 2678 | 0.9 |
Participant Non-response | 15005 | 5.1 |
Technical error | 0 | 0.0 |
Missing | 0 | 0.0 |
Not Applicable | 0 | 0.0 |
mode_1 |
||
Walk/jog/wheelchair | 30402 | 10.4 |
Personal bicycle | 3692 | 1.3 |
Borrowed bicycle | 39 | 0.0 |
Rental bicycle | 41 | 0.0 |
Household vehicle 1 | 129905 | 44.2 |
Household vehicle 2 | 62189 | 21.2 |
Household vehicle 3 | 8935 | 3.0 |
Household vehicle 4 | 1837 | 0.6 |
Household vehicle 5 | 294 | 0.1 |
Household vehicle 6 | 34 | 0.0 |
Household vehicle 7 | 7 | 0.0 |
Other household vehicle | 5041 | 1.7 |
Rental car | 2420 | 0.8 |
Carshare | 81 | 0.0 |
Vanpool | 185 | 0.1 |
Other auto | 1189 | 0.4 |
Bus | 7218 | 2.5 |
School bus | 311 | 0.1 |
Intercity bus | 13 | 0.0 |
Shuttle bus | 978 | 0.3 |
Paratransit | 37 | 0.0 |
Other bus | 206 | 0.1 |
Subway | 178 | 0.1 |
Airplane | 573 | 0.2 |
Ferry or water taxi | 154 | 0.1 |
Work car | 4860 | 1.7 |
Friends car | 7516 | 2.6 |
Taxi - Regular | 262 | 0.1 |
Taxi - Rideshare | 1755 | 0.6 |
University bus or shuttle | 363 | 0.1 |
Rail - Light | 3870 | 1.3 |
Rail - Intercity | 384 | 0.1 |
Rail - Other | 152 | 0.1 |
Skateboard | 54 | 0.0 |
Golf cart | 195 | 0.1 |
ATV | 15 | 0.0 |
Other household motorcycle | 193 | 0.1 |
Express bus/Rapid | 969 | 0.3 |
Other mode | 1603 | 0.5 |
San Diego Coaster Line | 410 | 0.1 |
Technical error | 0 | 0.0 |
Participant non-response | 15027 | 5.1 |
Not Applicable | 0 | 0.0 |
mode_2 |
||
Walk/jog/wheelchair | 1164 | 0.4 |
Personal bicycle | 115 | 0.0 |
Borrowed bicycle | 5 | 0.0 |
Rental bicycle | 9 | 0.0 |
Household vehicle 1 | 703 | 0.2 |
Household vehicle 2 | 261 | 0.1 |
Household vehicle 3 | 74 | 0.0 |
Household vehicle 4 | 4 | 0.0 |
Household vehicle 5 | 2 | 0.0 |
Household vehicle 6 | 1 | 0.0 |
Household vehicle 7 | 0 | 0.0 |
Other household vehicle | 106 | 0.0 |
Rental car | 16 | 0.0 |
Carshare | 1 | 0.0 |
Vanpool | 7 | 0.0 |
Other auto | 56 | 0.0 |
Bus | 514 | 0.2 |
School bus | 12 | 0.0 |
Intercity bus | 8 | 0.0 |
Shuttle bus | 31 | 0.0 |
Paratransit | 2 | 0.0 |
Other bus | 1 | 0.0 |
Subway | 22 | 0.0 |
Airplane | 6 | 0.0 |
Ferry or water taxi | 5 | 0.0 |
Work car | 27 | 0.0 |
Friends car | 95 | 0.0 |
Taxi - Regular | 1 | 0.0 |
Taxi - Rideshare | 28 | 0.0 |
University bus or shuttle | 9 | 0.0 |
Rail - Light | 123 | 0.0 |
Rail - Intercity | 29 | 0.0 |
Rail - Other | 9 | 0.0 |
Skateboard | 9 | 0.0 |
Golf cart | 9 | 0.0 |
ATV | 2 | 0.0 |
Other household motorcycle | 59 | 0.0 |
Express bus/Rapid | 287 | 0.1 |
Other mode | 208 | 0.1 |
San Diego Coaster Line | 31 | 0.0 |
Technical error | 0 | 0.0 |
Participant non-response | 0 | 0.0 |
Not Applicable | 289536 | 98.6 |
mode_3 |
||
Walk/jog/wheelchair | 83 | 0.0 |
Personal bicycle | 1 | 0.0 |
Borrowed bicycle | 0 | 0.0 |
Rental bicycle | 0 | 0.0 |
Household vehicle 1 | 47 | 0.0 |
Household vehicle 2 | 32 | 0.0 |
Household vehicle 3 | 1 | 0.0 |
Household vehicle 4 | 1 | 0.0 |
Household vehicle 5 | 0 | 0.0 |
Household vehicle 6 | 0 | 0.0 |
Household vehicle 7 | 0 | 0.0 |
Other household vehicle | 11 | 0.0 |
Rental car | 1 | 0.0 |
Carshare | 0 | 0.0 |
Vanpool | 0 | 0.0 |
Other auto | 4 | 0.0 |
Bus | 102 | 0.0 |
School bus | 0 | 0.0 |
Intercity bus | 0 | 0.0 |
Shuttle bus | 7 | 0.0 |
Paratransit | 0 | 0.0 |
Other bus | 0 | 0.0 |
Subway | 0 | 0.0 |
Airplane | 0 | 0.0 |
Ferry or water taxi | 0 | 0.0 |
Work car | 1 | 0.0 |
Friends car | 8 | 0.0 |
Taxi - Regular | 0 | 0.0 |
Taxi - Rideshare | 10 | 0.0 |
University bus or shuttle | 3 | 0.0 |
Rail - Light | 81 | 0.0 |
Rail - Intercity | 0 | 0.0 |
Rail - Other | 0 | 0.0 |
Skateboard | 0 | 0.0 |
Golf cart | 0 | 0.0 |
ATV | 0 | 0.0 |
Other household motorcycle | 3 | 0.0 |
Express bus/Rapid | 81 | 0.0 |
Other mode | 5 | 0.0 |
San Diego Coaster Line | 20 | 0.0 |
Technical error | 0 | 0.0 |
Participant non-response | 0 | 0.0 |
Not Applicable | 293085 | 99.8 |
mode_4 |
||
Walk/jog/wheelchair | 7 | 0.0 |
Personal bicycle | 8 | 0.0 |
Borrowed bicycle | 0 | 0.0 |
Rental bicycle | 0 | 0.0 |
Household vehicle 1 | 0 | 0.0 |
Household vehicle 2 | 11 | 0.0 |
Household vehicle 3 | 0 | 0.0 |
Household vehicle 4 | 0 | 0.0 |
Household vehicle 5 | 0 | 0.0 |
Household vehicle 6 | 0 | 0.0 |
Household vehicle 7 | 0 | 0.0 |
Other household vehicle | 0 | 0.0 |
Rental car | 0 | 0.0 |
Carshare | 0 | 0.0 |
Vanpool | 0 | 0.0 |
Other auto | 0 | 0.0 |
Bus | 9 | 0.0 |
School bus | 0 | 0.0 |
Intercity bus | 6 | 0.0 |
Shuttle bus | 3 | 0.0 |
Paratransit | 0 | 0.0 |
Other bus | 0 | 0.0 |
Subway | 0 | 0.0 |
Airplane | 0 | 0.0 |
Ferry or water taxi | 0 | 0.0 |
Work car | 0 | 0.0 |
Friends car | 0 | 0.0 |
Taxi - Regular | 0 | 0.0 |
Taxi - Rideshare | 9 | 0.0 |
University bus or shuttle | 0 | 0.0 |
Rail - Light | 10 | 0.0 |
Rail - Intercity | 0 | 0.0 |
Rail - Other | 0 | 0.0 |
Skateboard | 0 | 0.0 |
Golf cart | 0 | 0.0 |
ATV | 0 | 0.0 |
Other household motorcycle | 1 | 0.0 |
Express bus/Rapid | 9 | 0.0 |
Other mode | 0 | 0.0 |
San Diego Coaster Line | 3 | 0.0 |
Technical error | 0 | 0.0 |
Participant non-response | 0 | 0.0 |
Not Applicable | 293511 | 100.0 |
mode_transit_access |
||
Walked or jogged | 534 | 0.2 |
Rode a bike | 16 | 0.0 |
Drove and parked a car | 15 | 0.0 |
Got dropped off | 25 | 0.0 |
Took a taxi | 0 | 0.0 |
Transferred from other transit | 114 | 0.0 |
Was already at the stop | 95 | 0.0 |
Other | 58 | 0.0 |
Not Applicable | 292730 | 99.7 |
Missing | 0 | 0.0 |
mode_transit_egress |
||
Walked or jogged | 540 | 0.2 |
Rode a bike | 25 | 0.0 |
Drove and parked a car | 20 | 0.0 |
Got dropped off | 43 | 0.0 |
Took a taxi | 2 | 0.0 |
Transferred from other transit | 97 | 0.0 |
Was already at the stop | 79 | 0.0 |
Other | 51 | 0.0 |
Not Applicable | 292730 | 99.7 |
Missing | 0 | 0.0 |
google_mode |
||
DRIVE | 344 | 0.1 |
TRANSIT | 6112 | 2.1 |
WALK/BIKE | 8431 | 2.9 |
Not Applicable | 278700 | 94.9 |
driver |
||
Driver | 57705 | 19.7 |
Passenger | 60016 | 20.4 |
Both (switched drivers during trip) | 535 | 0.2 |
Missing | 107117 | 36.5 |
Not Applicable | 68214 | 23.2 |
toll_road |
||
No | 10209 | 3.5 |
Yes | 123 | 0.0 |
Not Applicable | 283201 | 96.5 |
Missing | 54 | 0.0 |
toll_road_express |
||
No | 10255 | 3.5 |
Yes | 77 | 0.0 |
Not Applicable | 283201 | 96.5 |
Missing | 54 | 0.0 |
parking_location |
||
My own driveway/garage | 53530 | 18.2 |
Someone elses driveway | 10047 | 3.4 |
Parking lot/garage | 107329 | 36.6 |
On street parking | 32060 | 10.9 |
Park & Ride lot | 516 | 0.2 |
Did not park (e.g., waited, drop-off, drive-thru) | 19024 | 6.5 |
Other | 1793 | 0.6 |
Technical error | 0 | 0.0 |
Participant non-response | 14 | 0.0 |
Missing | 1060 | 0.4 |
Not Applicable | 68214 | 23.2 |
parking_pay_type |
||
Free parking (no cost) | 133986 | 45.6 |
Used a parking pass (any type) | 6647 | 2.3 |
Paid via cash, credit card, or ticket(s) | 2924 | 1.0 |
Reserved parking service (e.g., ParkingPanda) | 207 | 0.1 |
Another person paid | 37 | 0.0 |
Other | 664 | 0.2 |
Technical error | 0 | 0.0 |
Participant non-response | 19 | 0.0 |
Missing | 5468 | 1.9 |
Not Applicable | 143635 | 48.9 |
parking_cost_dk |
||
No | 2531 | 0.9 |
Yes | 598 | 0.2 |
Missing | 39 | 0.0 |
Not Applicable | 290419 | 98.9 |
taxi_pay_type |
||
I paid the fare myself (no reimbursement) | 1220 | 0.4 |
Employer paid (I am reimbursed) | 220 | 0.1 |
Split/shared fare with other(s) | 107 | 0.0 |
Someone else paid 100% (all of taxi fare) | 418 | 0.1 |
Other | 78 | 0.0 |
Technical error | 0 | 0.0 |
Participant non-response | 0 | 0.0 |
Missing | 20 | 0.0 |
Not Applicable | 291524 | 99.3 |
taxi_cost_dk |
||
No | 1287 | 0.4 |
Yes | 260 | 0.1 |
Missing | 0 | 0.0 |
Not Applicable | 292040 | 99.5 |
airplane_pay_type |
||
Personally paid the airfare cost | 245 | 0.1 |
Employer paid 100% | 197 | 0.1 |
Used miles/points to purchase flight | 42 | 0.0 |
Someone else paid 100% (all of airfare cost) | 47 | 0.0 |
Other | 48 | 0.0 |
Technical error | 0 | 0.0 |
Participant non-response | 0 | 0.0 |
Missing | 0 | 0.0 |
Not Applicable | 293008 | 99.8 |
airplane_cost_dk |
||
No | 0 | 0.0 |
Yes | 0 | 0.0 |
Missing | 0 | 0.0 |
Not Applicable | 293587 | 100.0 |
bus_pay_type |
||
Technical error | 0 | 0.0 |
Participant non-response | 2 | 0.0 |
Free (no cost) | 334 | 0.1 |
Used pass (any type) | 5095 | 1.7 |
Cash, credit card, or ticket(s) | 498 | 0.2 |
Other | 27 | 0.0 |
Do not know | 5 | 0.0 |
Missing | 2992 | 1.0 |
Not Applicable | 284634 | 97.0 |
bus_cost_dk |
||
No | 460 | 0.2 |
Yes | 38 | 0.0 |
Missing | 0 | 0.0 |
Not Applicable | 293089 | 99.8 |
rail_pay_type |
||
Free (no cost) | 19 | 0.0 |
Used pass (any type) | 250 | 0.1 |
Cash, credit card, or ticket(s) | 6 | 0.0 |
Other | 0 | 0.0 |
Do not know | 0 | 0.0 |
Technical error | 0 | 0.0 |
Participant non-response | 0 | 0.0 |
Missing | 8678 | 3.0 |
Not Applicable | 284634 | 97.0 |
rail_cost_dk |
||
No | 5 | 0.0 |
Yes | 1 | 0.0 |
Missing | 0 | 0.0 |
Not Applicable | 293581 | 100.0 |
ferry_pay_type |
||
Free (no cost) | 64 | 0.0 |
Used pass (any type) | 5 | 0.0 |
Cash, credit card, or ticket(s) | 69 | 0.0 |
Other | 15 | 0.0 |
Do not know | 5 | 0.0 |
Missing | 1 | 0.0 |
Not Applicable | 293428 | 99.9 |
ferry_cost_dk |
||
No | 52 | 0.0 |
Yes | 17 | 0.0 |
Missing | 0 | 0.0 |
Not Applicable | 293518 | 100.0 |
parkride_lot |
||
Lot #16 Poway Rd at Sabre Springs Pkwy | 0 | 0.0 |
Lot #17 I-8 at Taylor St | 0 | 0.0 |
Lot #20 I-805 at Governor Dr | 0 | 0.0 |
Lot #24 I-805 at Mira Mesa Blvd & Vista Sorrento Pkwy | 0 | 0.0 |
Lot #26 Carmel Mountain Rd at Rancho Carmel Dr | 0 | 0.0 |
Lot #31 SR 56 at Rancho Carmel Dr | 0 | 0.0 |
Lot #4 Carmel Mountain Rd at Freeport Rd | 0 | 0.0 |
Lot #43 I-5 at Gilman Dr | 0 | 0.0 |
Lot #51 I-15 at Rancho Penasquitos Blvd | 0 | 0.0 |
Lot #53 Carmel Mountain Rd at Paseo Cardiel | 0 | 0.0 |
Lot #57 Carmel Mountain Rd at Stoney Creek Rd | 0 | 0.0 |
Lot #6 I-15 at Mira Mesa Blvd | 0 | 0.0 |
Lot #65 I-15 at Rancho Bernardo Rd | 0 | 0.0 |
Lot #7 I-5 at Carmel Valley Rd & Sorrento Valley Rd | 0 | 0.0 |
Lot #76 I-15 at Scripps Poway Pkwy | 0 | 0.0 |
Lot #78 I-805 at Childrens Way | 0 | 0.0 |
Lot #80 Caliente Ave | 0 | 0.0 |
Lot #1 SR 94 at Sweetwater Springs Blvd | 0 | 0.0 |
Lot #28 SR 94 at Potrero Post Office | 0 | 0.0 |
Lot #33 I-15 at Deer Springs Rd | 0 | 0.0 |
Lot #34 I-15 at Mountain Meadow Rd | 0 | 0.0 |
Lot #35 I-15 at Gopher Canyon Rd | 0 | 0.0 |
Lot #37 SR 94 at Avocado Blvd | 0 | 0.0 |
Lot #40 SR 54 at Jamacha Blvd | 0 | 0.0 |
Lot #71 Sweetwater Springs Blvd at Austin Dr | 0 | 0.0 |
Lot #11 SR 78 at Broadway | 0 | 0.0 |
Lot #3 Felicita Ave at Escondido Blvd | 0 | 0.0 |
Lot #30 I-15 at El Norte Pkwy | 0 | 0.0 |
Lot #38 7 Oakes Rd at El Norte Pkwy | 0 | 0.0 |
Lot #81 Westfield North County | 0 | 0.0 |
Lot #22 I-8 at Murray Dr | 0 | 0.0 |
Lot #59 Bancroft Dr at Grossmont Blvd | 0 | 0.0 |
Lot #60 Severin Dr at Bancroft Dr | 0 | 0.0 |
Lot #61 Severin Dr at Murray Dr | 0 | 0.0 |
Lot #8 Lemon Grove Ave at High St | 0 | 0.0 |
Lot #39 SR 78 at College Blvd (South) | 0 | 0.0 |
Lot #44 I-5 at SR 78 & Moreno St | 0 | 0.0 |
Lot #45 SR 78 at College Blvd (North) | 0 | 0.0 |
Lot #5 Maxson St at Barnes St | 0 | 0.0 |
Lot #73 Mission Ave at Frontier Dr | 0 | 0.0 |
Lot #32 I-5 at La Costa Ave | 0 | 0.0 |
Lot #47 I-5 at Birmingham Dr | 0 | 0.0 |
Lot #62 Encinitas Blvd at Calle Magdelena | 0 | 0.0 |
Lot #10 SR 67 at Mapleview St | 0 | 0.0 |
Lot #2 SR 67 at Riverford Rd & Woodside Ave | 0 | 0.0 |
Lot #42 I-8 at Lake Jennings Park Rd | 2 | 0.0 |
Lot #48 Twin Peaks Rd at Budwin Ln | 0 | 0.0 |
Lot #77 SR 67 at Poway Rd | 0 | 0.0 |
Lot #25 SR 54 at Washington Ave | 0 | 0.0 |
Lot #41 I-8 at Los Coches Rd | 0 | 0.0 |
Lot #63 SR 67 at Day St | 0 | 0.0 |
Lot #75 SR 67 at Dye Rd | 0 | 0.0 |
Lot #70 Mission Gorge Rd at Big Rock Dr | 0 | 0.0 |
Lot #72 North Magnolia Ave at Alexander Way | 0 | 0.0 |
Lot #50 Telegraph Canyon Rd at Paseo Del Ray | 0 | 0.0 |
Lot #56 East H St at Buena Vista Way | 0 | 0.0 |
Lot #46 SR 76 at Sweetgrass Ln | 0 | 0.0 |
Lot #29 I-8 at Japatul Valley Rd | 0 | 0.0 |
Lot #69 SR 78 at Barham Dr | 0 | 0.0 |
Lot #19 I-15 at SR 76 | 0 | 0.0 |
Lot #21 SR 78 at Sunset Dr & Seaview Pl | 0 | 0.0 |
Lot #12 Lemon Grove Ave at Lincoln St | 0 | 0.0 |
Lot #9 I-805 at Sweetwater Rd | 0 | 0.0 |
Not Applicable | 293585 | 100.0 |
parkride_city |
||
Bonsall | 0 | 0.0 |
Chula Vista | 0 | 0.0 |
Descanso | 0 | 0.0 |
El Cajon | 0 | 0.0 |
Encinitas | 0 | 0.0 |
Escondido | 0 | 0.0 |
La Mesa | 0 | 0.0 |
Lakeside | 2 | 0.0 |
Lemon Grove | 0 | 0.0 |
National City | 0 | 0.0 |
Oceanside | 0 | 0.0 |
Pala | 0 | 0.0 |
Poway | 0 | 0.0 |
Ramona | 0 | 0.0 |
San Diego | 0 | 0.0 |
San Diego County | 0 | 0.0 |
San Marcos | 0 | 0.0 |
Santee | 0 | 0.0 |
Vista | 0 | 0.0 |
Not Applicable | 293585 | 100.0 |