Travel Decision Survey 2019

data.sfgov.org | Last Updated 31 Jan 2020

**Please refer to the downloadable XLSX attachment (http://bit.ly/SFMTATravelSurvey2019) for the complete dataset, metadata, and instructions for use.** This workbook provides data and data dictionaries for the SFMTA 2019 Travel Decision Survey. On behalf of San Francisco Municipal Transportation Agency (SFMTA), Corey, Canapary & Galanis (CC&G) undertook a Mode Share Survey within the City and County of San Francisco as well as the eight surrounding Bay Area counties of Alameda, Contra Costa, San Mateo, Marin, Santa Clara, Napa, Sonoma and Solano. The primary goals of this study were to: • Assess percent mode share for travel in San Francisco for evaluation of the SFMTA Strategic Objective 2.2: Mode Share target of 80% sustainable travel by 2030. • Evaluate the above statement based on the following parameters: number of trips to, from, and within San Francisco by Bay Area residents. Trips by visitors to the Bay Area and for commercial purposes are not included. • Provide additional trip details, including trip purpose for each trip in the mode share question series. • Collect demographic data on the population of Bay Area residents who travel to, from, and within San Francisco. • Collect data on travel behavior and opinions that support other SFMTA strategy and project evaluation needs. The survey was conducted as a telephone study among 801 Bay Area residents aged 18 and older. Interviewing was conducted in English, Spanish, Mandarin, Cantonese, and Tagalog. Surveying was conducted via random digit dial (RDD) and cell phone sample. All survey datasets incorporate respondent weighting based on age and home location; utilize the “weight” field when appropriate in your analysis. The survey period for this survey is as follows: 2019: May - August 2019 The margin of error is related to sample size (n). For the total sample, the margin of error is 3.3% for a confidence level of 95%. When looking at subsets of the data, such as just the SF population, just the female population, or just the population of people who bicycle, the sample size decreases and the margin of error increases. Below is a guide of the margin of error for different samples sizes. Be cautious in making conclusions based off of small sample sizes. At the 95% confidence level is: • n = 801(Total Sample). Margin of error = +/- 3.3% • n = 400. Margin of error = +/- 4.85% • n = 100. Margin of error = +/- 9.80%

Tags: municipal transportation agency, transportation, mode share, survey, driving, transit, bicycling, walking, tnc

This dataset has the following 184 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
*RESPNUMrespnumnumberRespondent Number – automatically generated during data entry
Q2q2numberIn which Bay Area county do you live?
Q3q3numberHave you gone into San Francisco within the past month (30 days)?
TripstripsnumberTotal trips taken- SF residents: Sum of Q4Tot+Q5Tot, Bay Area Residents: Sum of Work1 to Rel2 Columns
Q4TOTq4totnumber(SF Residents) How many trips did you take yesterday?
Q5TOTq5totnumber(SF Residents) How many trips did you take (outside of your home) TWO DAYS AGO.
Q4aPq4apnumber(SF Residents) What was the purpose your first trip?
Q4bPq4bpnumber(SF Residents) Where did you go next?
Q4cPq4cpnumber(SF Residents) Where did you go next?
Q4dPq4dpnumber(SF Residents) Where did you go next?
Q4ePq4epnumber(SF Residents) Where did you go next?
Q4fPq4fpnumber(SF Residents) Where did you go next?
Q4gPq4gpnumber(SF Residents) Where did you go next?
Q4hPq4hpnumber(SF Residents) Where did you go next?
Q5aPq5apnumber(SF Residents) What was the purpose your first trip on (DAY)?
Q5bPq5bpnumber(SF Residents) Where did you go next?
Q5cPq5cpnumber(SF Residents) Where did you go next?
Q5dPq5dpnumber(SF Residents) Where did you go next?
Q5ePq5epnumber(SF Residents) Where did you go next?
Q5fPq5fpnumber(SF Residents) Where did you go next?
Q5gPq5gpnumber(SF Residents) Where did you go next?
Q5hPq5hpnumber(SF Residents) Where did you go next?
WORKworknumberTotal of all Work (1) entries for Q4aP to Q5hP
SCHschnumberTotal of all School (2) entries for Q4aP to Q5hP
SHOPshopnumberTotal of all Shopping/Errand (3) entries for Q4aP to Q5hP
SOCsocnumberTotal of all Social/Rec (4) entries for Q4aP to Q5hP
HOMEhomenumberTotal of all Social/Rec (4) entries for Q4aP to Q5hP
OTH-P-SFoth_p_sfnumberTotal of all Other (6) entries for Q4aP to Q5hP
DK-P-SFdk_p_sfnumberTotal of all Don't know/Don't remember (7) entries for Q4aP to Q5hP
RELrelnumberTotal of all Rel/Vol/Pol (8) entries for Q4aP to Q5hP
SFINTMODEsfintmodenumber(SF Residents) How did you make that trip? (combination of initial modes from Q4am and Q5aM-Q4am unless Q4am is blank)
Q4aMq4amnumber(SF Residents) How did you make that trip?
Q4bMq4bmnumber(SF Residents) How did you make that trip?
Q4cMq4cmnumber(SF Residents) How did you make that trip?
Q4dMq4dmnumber(SF Residents) How did you make that trip?
Q4eMq4emnumber(SF Residents) How did you make that trip?
Q4fMq4fmnumber(SF Residents) How did you make that trip?
Q4gMq4gmnumber(SF Residents) How did you make that trip?
Q4hMq4hmnumber(SF Residents) How did you make that trip?
Q5aMq5amnumber(SF Residents) How did you make that trip?
Q5bMq5bmnumber(SF Residents) How did you make that trip?
Q5cMq5cmnumber(SF Residents) How did you make that trip?
Q5dMq5dmnumber(SF Residents) How did you make that trip?
Q5eMq5emnumber(SF Residents) How did you make that trip?
Q5fMq5fmnumber(SF Residents) How did you make that trip?
Q5gMq5gmnumber(SF Residents) How did you make that trip?
Q5hMq5hmnumber(SF Residents) How did you make that trip?
DAdanumberTotal of all Drove Alone (1) entries for Q4aM to Q5hM
DOdonumberTotal of all Drove With Others (2) entries for Q4aM to Q5hM
CRSHREcrshrenumberTotal of all Drove Car Share (3) entries for Q4aM to Q5hM
TNCtncnumberTotal of all TNC (4) entries for Q4aM to Q5hM
TAXItaxinumberTotal of all Taxi (5) entries for Q4aM to Q5hM
TRANStransnumberTotal of all Public Transit (6) entries for Q4aM to Q5hM
SHTTLEshttlenumberTotal of all Private Bus/Van (7) entries for Q4aM to Q5hM
BIKEbikenumberTotal of all Bicycle (8) entries for Q4aM to Q5hM
WALKwalknumberTotal of all Walk (9) entries for Q4aM to Q5hM
CYCLEcyclenumberTotal of all Motorcycle (10) entries for Q4aM to Q5hM
SCOOTscootnumberTotal of all E-Scooter (11) entries for Q4aM to Q5hM
OTH-M-SFoth_m_sfnumberTotal of all Other (12) entries for Q4aM to Q5hM
DK-M-SFdk_m_sfnumberTotal of all Don't Know/Don't remember (13) entries for Q4aM to Q5hM
Q6q6number(Outside SF Residents) Over the past 30 days, about how many total days have you gone into San Francisco
Q8q8number(Outside SF Residents) Did you leave San Francisco using the same mode of transportation (E.G. car, taxi, etc)
Q10q10number(Outside SF Residents) Did you go to any other destinations in the City that day?
Q11Totalq11totalnumber(Outside SF Residents) How many additional destinations within San Francisco did you go to on that day?
Q12q12number"(Outside SF Residents) Over the past 30 days, how many days have you made that same kind of trip into San Francisco? "
Q19q19number"(Outside SF Residents) Over the past 30 days, how many days have you made that same kind of trip into San Francisco? "
Q13q13number(Outside SF Residents) Have you taken any DIFFERENT TYPE OF TRIPS into San Francisco in the past 30 days?
Q15q15number(Outside SF Residents) Did you leave San Francisco using the same mode (E.G. car, taxi, etc.)?
Q16Mq16mnumber(Outside SF Residents) How did you leave San Francisco?
Q17q17number(Outside SF Residents) Did you go to any other destinations in the City that day?
Q18Totalq18totalnumber(Outside SF Residents) How many additional destinations within San Francisco did you go to on that day?
Q9Mq9mnumber(Outside SF Residents) How did you make that trip?
Q7Pq7pnumber(Outside SF Residents) Thinking about your most recent trip into San Francisco, can you please describe the purpose of your first stop (for example: work, shopping, entertainment) and how you got there…
Q9P-ADJq9p_adjnumber(Outside SF Residents) Added field to reflect the trip out of San Francisco. Adds a “5” to reflect a trip home unless Q11aP-Q11fP includes a 5, then this is set to a “7” (don’t know)
Q11aPq11apnumber(Outside SF Residents) What was the purpose your first trip?
Q11bPq11bpnumber(Outside SF Residents) Where did you go next?
Q11cPq11cpnumber(Outside SF Residents) Where did you go next?
Q11dPq11dpnumber(Outside SF Residents) Where did you go next?
Q11ePq11epnumber(Outside SF Residents) Where did you go next?
Q11fPq11fpnumber(Outside SF Residents) Where did you go next?
Q14Pq14pnumber(Outside SF residents) Describe your first stop in the City and how you got there for this "different type of trip" that you took most recently:
Q16P-Adjq16p_adjnumber(Outside SF Residents) Added field to reflect the trip out of San Francisco. Adds a “5” to reflect a trip home unless Q18aP-Q18fP includes a 5, then this is set to a “7” (don’t know)
Q18aPq18apnumber(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
Q18bPq18bpnumber(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
Q18cPq18cpnumber(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
Q18dPq18dpnumber(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
Q18ePq18eptext(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
Q18fPq18fptext(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
WORK1work1numberTotal of all Work (1) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
SCH1sch1numberTotal of all School (2) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
SHOP1shop1numberTotal of all Shopping/Errand (3) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
SOC1soc1numberTotal of all Social/Rec (4) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
HOME1home1numberTotal of all Home (5) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
OTH1-Poth1_pnumberTotal of all Other (6) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
DK1-Pdk1_pnumberTotal of all Don't know/Don't remember (7) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
REL1rel1numberTotal of all Rel/Vol/Pol (8) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
WORK2work2numberTotal of all Work (1) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
SCH2sch2numberTotal of all School (2) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
SHOP2shop2numberTotal of all Shopping/Errand (3) entriesfor Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
SOC2soc2numberTotal of all Social/Rec (4) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
HOME2home2numberTotal of all Home (5) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
OTH2-Poth2_pnumberTotal of all Other (6) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
DK2-Pdk2_pnumberTotal of all Don't know/Don't remember (7) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
REL2rel2numberTotal of all Rel/Vol/Pol (8) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
Q7Mq7mnumber(Outside SF Residents) How did you make that trip?
Q9M-Adjq9m_adjnumberAdded field. Integrates responses from Q7 for those who said yes on Q8. (Q7 unless Q8 = 2 or 3, then Q9M)
Q11aMq11amnumber(Outside SF Residents) How did you make that trip?
Q11bMq11bmnumber(Outside SF Residents) How did you make that trip?
Q11cMq11cmnumber(Outside SF Residents) How did you make that trip?
Q11dMq11dmnumber(Outside SF Residents) How did you make that trip?
Q11eMq11emnumber(Outside SF Residents) How did you make that trip?
Q11fMq11fmnumber(Outside SF Residents) How did you make that trip?
Q14Mq14mnumber(Outside SF Residents) How did you make that trip?
Q16M-Adjq16m_adjnumberAdded field. Integrates responses from Q14 for those who said yes on Q15.
Q18aMq18amnumber(Outside SF Residents) How did you make that trip?
Q18bMq18bmnumber(Outside SF Residents) How did you make that trip?
Q18cMq18cmnumber(Outside SF Residents) How did you make that trip?
Q18dMq18dmnumber(Outside SF Residents) How did you make that trip?
Q18eMq18emtext(Outside SF Residents) How did you make that trip?
Q18fMq18fmtext(Outside SF Residents) How did you make that trip?
DA1da1numberTotal of all Drove Alone (1) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
DO1do1numberTotal of all Drove With Others (2) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
CRSHRE1crshre1numberTotal of all Drove Car Share (3) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
TNC1tnc1numberTotal of all TNC (4) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
TAXI1taxi1numberTotal of all Taxi (5) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
TRANS1trans1numberTotal of all Public Transit (6) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
SHTTLE1shttle1numberTotal of all Private Bus/Van (7) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
BIKE1bike1numberTotal of all Bicycle (8) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
WALK1walk1numberTotal of all Walk (9) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
CYCLE1cycle1numberTotal of all Motorcycle (10) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
SCOOT1scoot1numberTotal of all E-scooter (11) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
OTH1-Moth1_mnumberTotal of all Other (12) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
DK1-Mdk1_mnumberTotal of all Don't Know/Don't remember (13) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
DA2da2numberTotal of all Drove Alone (1) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
DO2do2numberTotal of all Drove With Others (2) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
CRSHRE2crshre2numberTotal of all Drove Car Share (3) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
TNC2tnc2numberTotal of all TNC (4) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
TAXI2taxi2numberTotal of all Taxi (5) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
TRANS2trans2numberTotal of all Public Transit (6) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
SHTTLE2shttle2numberTotal of all Private Bus/Van (7) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
BIKE2bike2numberTotal of all Bicycle (8) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
WALK2walk2numberTotal of all Walk (9) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
CYCLE2cycle2numberTotal of all Motorcycle (10) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
SCOOT2scoot2numberTotal of all E-Scooter (11) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
OTH2-Moth2_mnumberTotal of all Other (12) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
DK2-Mdk2_mnumberTotal of all Don't Know/Don't remember (13) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
Q20q20numberIf you did not [mode of travel] on your first trip, what would you have done otherwise? (about half of respondents)
Q20_LASTq20_lastnumberIf you did not [mode of travel] on your last trip, what would you have done otherwise? (about half of respondents)
Q21Aq21anumberHave you tried any of these new travel options? If yes, how often do you use them? a. Lyft or Uber
Q21Bq21bnumberHave you tried any of these new travel options? If yes, how often do you use them? b. Bikeshare or Standup e-Scooter
Q21Cq21cnumberAnd how often do you use traditional taxis?
Q22q22number(SF RESIDENTS) In the past 30 days have you used more than one mode of transportation to get somewhere in San Francisco? For example, you begin dropped off, then take Muni to your destination. (OUTSIDE SF RESIDENTS) In the past 30 days have you used more than one mode of transportation in San Francisco to get to your destination? For example, using Muni to get to BART.
Q22Aq22anumberHow often do you use more than one mode?
Q22B_1q22b_1numberWhat modes do you combine most often? (Select two or more) (MULTIPLE ANSWERS ALLOWED)
Q22B_2q22b_2numberWhat modes do you combine most often? (Select two or more) (MULTIPLE ANSWERS ALLOWED)
Q22B_3q22b_3numberWhat modes do you combine most often? (Select two or more) (MULTIPLE ANSWERS ALLOWED)
Q22B_4q22b_4numberWhat modes do you combine most often? (Select two or more) (MULTIPLE ANSWERS ALLOWED)
Q23q23numberDo you own a car or have regular access to a car through family or friends?
Q24Aq24anumberAre you aware of the expansion of bicycle lanes and other improvements in bicycle access throughout San Francisco in the past few years?
Q25A-SFq25a_sfnumber(San Francisco Residents) What is your home ZIP Code?
Q25A-NSFq25a_nsfnumber(Outside San Francisco Residents) What is your home ZIP code
Q25Bq25bnumberWhat is your workplace zipcode?
Q26Aq26anumberDo you have a disability or health condition that affects the travel choices you make in San Francisco?
Q26B_1q26b_1number[IF YES] What is your disability, would you say (Read list. Include all that apply) (MULTIPLE RESPONSES ALLOWED)
Q26B_2q26b_2text[IF YES] What is your disability, would you say (Read list. Include all that apply) (MULTIPLE RESPONSES ALLOWED)
Q26B_3q26b_3text[IF YES] What is your disability, would you say (Read list. Include all that apply) (MULTIPLE RESPONSES ALLOWED)
Q26B_4q26b_4text[IF YES] What is your disability, would you say (Read list. Include all that apply) (MULTIPLE RESPONSES ALLOWED)
Q27q27numberAre you responsible for the transportation of anyone else in your household?
Q28q28numberAge
Q29_1q29_1numberWhat is your race or ethnic identification. Are you... (MULTIPLE ANSWERS ALLOWED)
Q29_2q29_2numberWhat is your race or ethnic identification. Are you... (MULTIPLE ANSWERS ALLOWED)
Q29_3q29_3numberWhat is your race or ethnic identification. Are you... (MULTIPLE ANSWERS ALLOWED)
Q29_4q29_4textWhat is your race or ethnic identification. Are you... (MULTIPLE ANSWERS ALLOWED)
Q30q30numberIs your annual household income...(Read List)
Q31q31numberWhat gender do you identify with?
LANGlangnumberInterview Language
ZONEzonenumber(San Francisco Residents) San Francisco Zone (Based on Zip code)
Interview_Dateinterview_datecalendar_dateDate of the interview
Interview_Dayinterview_daynumberDay of the week on which the interview was conducted
DRVRFLAGdrvrflagnumberIndicates respondent drove alone or with others on any trip
AGECOageconumberAge code (used for weighting)
FIRSTMODEfirstmodenumberFirst mode used for Q20
LASTMODElastmodenumberLast mode used for Q20_Last
WEIGHTweightnumberWeighting factor applied to record