HHTBS 2016 Dataset AT Intercept Survey

Active Transportation Bicycle Intercept Survey

SQL Table: [hhtbs2016].[intercept]

Dataset Fields

Field	Description
household_id	unique identifier of household
survey_status	survey completion status
survey_start	survey start time (PST)
survey_end	survey end time (PST)
survey_date	survey_date (PST)
pilot_study	survey administered during pilot study
origin_purpose	primary purpose at trip origin
employment_status	employment status
student_status	student status
origin_address	trip origin address
origin_latitude	trip origin latitude
origin_longitude	trip origin longitude
origin_shape	trip origin shape attribute (EPSG: 2230)
origin_mgra_13	trip origin Series 13 MGRA
destination_purpose	primary purpose at trip destination
destination_address	trip destination address
destination_latitude	trip destination latitude
destination_longitude	trip destination longitude
destination_shape	trip destination shape attribute (EPSG: 2230)
destination_mgra_13	trip destination Series 13 MGRA
distance_beeline	o-d beeline distance (miles)
distance_beeline_bin	o-d beeline distance category
visit_work	employed or volunteer/intern; if trip o/d is not work, will visit work before returning home
visit_school	student; if trip o/d is not school, will visit school before returning home
number_household_vehicles	number of household vehicles
number_children_0_15	number of children age <=15 in household
number_children_16_17	number of children age 16-17 in household
number_adults	number of adults 18+ in household
age	respondent age
smartphone	smartphone ownership
resident	resident of San Diego County
bike_party	number of members in bike party (not including self)
bike_share	respondent or members of bike party using bike share
gender	respondent gender
intercept_site	intercept site/location
intercept_direction	direction participant was traveling when intercepted
language	language in which survey was conducted
rmove_qualify	respondent qualified to participate in part two (rMove diary)
opt_out	opted to not participate in part two (rMove diary)
rmove_participate	respondent qualified and agreed to participate in part two (rMove diary)
rmove_complete	respondent completed part two (rMove diary), 90% of trip surveys complete and 5+ daily surveys complete
recruit_complete	respondent completed the recruit survey
survey_time_peak	survey was completed during peak hours
expansion_site	site/location used to determine expansion factor
expansion_factor	final expansion factor

Missings Report

Field	Valid Count	Missing Count	Pct. Missing
household_id	902	0	0
survey_status	902	0	0
survey_start	902	0	0
survey_end	902	0	0
survey_date	902	0	0
pilot_study	902	0	0
origin_purpose	902	0	0
employment_status	902	0	0
student_status	902	0	0
origin_address	902	0	0
origin_latitude	902	0	0
origin_longitude	902	0	0
origin_shape	902	0	0
origin_mgra_13	895	7	0.8
destination_purpose	900	2	0.2
destination_address	902	0	0
destination_latitude	902	0	0
destination_longitude	902	0	0
destination_shape	902	0	0
destination_mgra_13	891	11	1.2
distance_beeline	902	0	0
distance_beeline_bin	902	0	0
visit_work	902	0	0
visit_school	902	0	0
number_household_vehicles	902	0	0
number_children_0_15	902	0	0
number_children_16_17	902	0	0
number_adults	902	0	0
age	902	0	0
smartphone	902	0	0
resident	902	0	0
bike_party	902	0	0
bike_share	902	0	0
gender	902	0	0
intercept_site	902	0	0
intercept_direction	846	56	6.2
language	902	0	0
rmove_qualify	902	0	0
opt_out	728	174	19.3
rmove_participate	902	0	0
rmove_complete	506	396	43.9
recruit_complete	113	789	87.5
survey_time_peak	902	0	0
expansion_site	902	0	0
expansion_factor	901	1	0.1

Categorical Variables Values Report

Field	Count	Pct.
survey_status
Incomplete	0	0.0
Complete	902	100.0
Missing	0	0.0
pilot_study
No	846	93.8
Yes	56	6.2
Missing	0	0.0
origin_purpose
My home	537	59.5
My work or a work-related place	141	15.6
My school	45	5.0
Someone elses home	18	2.0
A business (e.g., shopping, errand, banking, doctor, etc.)	30	3.3
A restaurant	6	0.7
A leisure activity (e.g., museum, gym, sporting event, etc.)	74	8.2
Pickup or drop-off child at daycare, school, etc.	7	0.8
Other	44	4.9
Missing	0	0.0
employment_status
Employed full-time (paid) 35+ hours/week	450	49.9
Employed part-time (paid) up to 35 hours/week	135	15.0
Unpaid volunteer or intern	16	1.8
Not currently employed	301	33.4
Missing	0	0.0
student_status
Not a student	742	82.3
Enrolled in higher education	141	15.6
Enrolled in high school (grades 9-12)	12	1.3
Enrolled in grade school or middle school (grades K-8)	7	0.8
Missing	0	0.0
destination_purpose
My home	463	51.3
My work or a work-related place	87	9.6
My school	39	4.3
Someone elses home	16	1.8
A business (e.g., shopping, errand, banking, doctor, etc.)	59	6.5
A restaurant	35	3.9
A leisure activity (e.g., museum, gym, sporting event, etc.)	140	15.5
Pickup or drop-off child at daycare, school, etc.	11	1.2
Other	50	5.5
Missing	2	0.2
distance_beeline_bin
0-2 miles	554	61.4
2-4 miles	137	15.2
4-6 miles	49	5.4
6-8 miles	30	3.3
8-10 miles	24	2.7
10-12 miles	17	1.9
12-14 miles	27	3.0
14-16 miles	13	1.4
16-18 miles	7	0.8
18-20 miles	6	0.7
20 miles or more	38	4.2
Missing	0	0.0
number_household_vehicles
0	131	14.5
1	266	29.5
2	309	34.3
3	117	13.0
4	44	4.9
5	20	2.2
6	10	1.1
7+	5	0.6
Missing	0	0.0
age
16-17 years	16	1.8
18-24 years	90	10.0
25-34 years	186	20.6
35-44 years	132	14.6
45-49 years	76	8.4
50-54 years	85	9.4
55-59 years	94	10.4
60-64 years	84	9.3
65 years or older	139	15.4
Missing	0	0.0
smartphone
Yes, an Android smartphone	326	36.1
Yes, an Apple smartphone	450	49.9
Yes, another type of smartphone	12	1.3
No, I do not own a smartphone	114	12.6
Missing	0	0.0
resident
Yes	848	94.0
No	54	6.0
Missing	0	0.0
bike_party
0	652	72.3
1	203	22.5
2	29	3.2
3	14	1.6
4	3	0.3
5+	1	0.1
Missing	0	0.0
bike_share
Yes	5	0.6
No	897	99.4
Missing	0	0.0
gender
Male	687	76.2
Female	215	23.8
Do not know	0	0.0
Missing	0	0.0
intercept_site
1 - (Oceanside) - S. Pacific Street and Tyson St	36	4.0
2 - (Oceanside) - Rail Trail and Elm Street	18	2.0
3 - (Oceanside) - N Coast Highway and Topeka St (8/16/16 - 2/05/17)	4	0.4
4 - (San Marcos) - Valpreda Rd and Mission Rd	28	3.1
5 - (San Marcos) - Campus Way and Campus View Dr	7	0.8
6 - (Escondido) - Rock Springs Rd and W Mission Ave	14	1.6
7 - (Escondido) - Centre City Pkwy and W Valley Pkwy	8	0.9
8 - (Solana Beach) - Coast Highway and Lomas Santa Fe/Plaza St	151	16.7
9 - (Chula Vista) - Broadway, Between E Street and Flower St	30	3.3
10 - (San Diego - La Jolla) - N Torrey Pines Rd and La Jolla Shores Dr	61	6.8
11 - (San Diego - La Jolla) - Gilman Dr between Osler Ln and La Jolla Village Dr	36	4.0
12 - (San Diego - Pacific Beach) - Fanuel St and Crown Point Bike Path	123	13.6
13 - (San Diego - Pacific Beach) - Ingraham St and Hornblend St	35	3.9
14 - (San Diego - Downtown) - Union St and Ash St	11	1.2
15 - (San Diego - Downtown) - 4th Ave and C St	23	2.5
16 - (San Diego - Downtown) - 5th Ave and Broadway (8/16/16 - 02/05/17)	42	4.7
17 - (San Diego - Downtown) - 10th Ave and Market St	20	2.2
18 - (San Diego - North Park) - Park Blvd and Myrtle St	95	10.5
19 - (San Diego - North Park) - 30th St and University Ave	28	3.1
20 - (San Diego - North Park) - Oregon St and El Cajon Blvd	29	3.2
21 - (San Diego - North Park) - Utah St and Meade Ave	21	2.3
22 - (San Diego - College Area) - Collwood Blvd and Montezuma Rd	24	2.7
23 - (San Diego - College Area) - E Campus Dr and Montezuma Rd	32	3.5
24 - (El Cajon) - Orlando St and Main St	18	2.0
25 - (El Cajon) - Jamacha Road and E. Washington Ave	7	0.8
26 - Other	1	0.1
3 - (Oceanside) - N Coast Highway and Mission Ave (2/06/17 - 2/16/17)	0	0.0
16 - (San Diego - Downtown) - 5th Ave, between Elm St and Fir St (2/06/17 - 2/16/17)	0	0.0
Missing	0	0.0
intercept_direction
North	246	27.3
East	182	20.2
South	260	28.8
West	158	17.5
Missing	56	6.2
language
English	901	99.9
Spanish	1	0.1
Other	0	0.0
Missing	0	0.0
rmove_qualify
No	174	19.3
Yes	728	80.7
Missing	0	0.0
opt_out
No	539	59.8
Yes	189	21.0
Not Applicable	174	19.3
rmove_participate
No	363	40.2
Yes	539	59.8
Missing	0	0.0
rmove_complete
No	397	44.0
Yes	109	12.1
Not Applicable	396	43.9
recruit_complete
No (dropped out)	12	1.3
Yes	101	11.2
Not Applicable	789	87.5
survey_time_peak
No	520	57.6
Yes	382	42.4
Missing	0	0.0
expansion_site
1 - (Oceanside) - S. Pacific Street and Tyson St	36	4.0
2 - (Oceanside) - Rail Trail and Elm Street	18	2.0
3 - (Oceanside) - N Coast Highway and Topeka St (8/16/16 - 2/05/17)	4	0.4
4 - (San Marcos) - Valpreda Rd and Mission Rd	28	3.1
5 - (San Marcos) - Campus Way and Campus View Dr	7	0.8
6 - (Escondido) - Rock Springs Rd and W Mission Ave	14	1.6
7 - (Escondido) - Centre City Pkwy and W Valley Pkwy	8	0.9
8 - (Solana Beach) - Coast Highway and Lomas Santa Fe/Plaza St	151	16.7
9 - (Chula Vista) - Broadway, Between E Street and Flower St	30	3.3
10 - (San Diego - La Jolla) - N Torrey Pines Rd and La Jolla Shores Dr	61	6.8
11 - (San Diego - La Jolla) - Gilman Dr between Osler Ln and La Jolla Village Dr	36	4.0
12 - (San Diego - Pacific Beach) - Fanuel St and Crown Point Bike Path	123	13.6
13 - (San Diego - Pacific Beach) - Ingraham St and Hornblend St	35	3.9
14 - (San Diego - Downtown) - Union St and Ash St	11	1.2
15 - (San Diego - Downtown) - 4th Ave and C St	48	5.3
16 - (San Diego - Downtown) - 5th Ave and Broadway (8/16/16 - 02/05/17)	17	1.9
17 - (San Diego - Downtown) - 10th Ave and Market St	20	2.2
18 - (San Diego - North Park) - Park Blvd and Myrtle St	95	10.5
19 - (San Diego - North Park) - 30th St and University Ave	28	3.1
20 - (San Diego - North Park) - Oregon St and El Cajon Blvd	29	3.2
21 - (San Diego - North Park) - Utah St and Meade Ave	21	2.3
22 - (San Diego - College Area) - Collwood Blvd and Montezuma Rd	24	2.7
23 - (San Diego - College Area) - E Campus Dr and Montezuma Rd	32	3.5
24 - (El Cajon) - Orlando St and Main St	18	2.0
25 - (El Cajon) - Jamacha Road and E. Washington Ave	7	0.8
26 - Other	1	0.1
3 - (Oceanside) - N Coast Highway and Mission Ave (2/06/17 - 2/16/17)	0	0.0
16 - (San Diego - Downtown) - 5th Ave, between Elm St and Fir St (2/06/17 - 2/16/17)	0	0.0
Missing	0	0.0

Go To Top