sfgov/travel-decision-survey-2019-qmdj-wtj2

  • bicycling
  • driving
  • mode share
  • municipal transportation agency
  • survey
  • + 4

Travel Decision Survey 2019

Travel Decision Survey 2019

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%

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
DA1da1da1NumberTotal of all Drove Alone (1) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
Q20q20q20NumberIf you did not mode of travel on your first trip, what would you have done otherwise? (about half of respondents)
AGECOagecoagecoNumberAge code (used for weighting)
Q4bMq4bmq4bmNumber(SF Residents) How did you make that trip?
OTH2-Poth2_poth2_pNumberTotal of all Other (6) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
CRSHREcrshrecrshreNumberTotal of all Drove Car Share (3) entries for Q4aM to Q5hM
TripstripstripsNumberTotal trips taken- SF residents: Sum of Q4Tot+Q5Tot, Bay Area Residents: Sum of Work1 to Rel2 Columns
WORKworkworkNumberTotal of all Work (1) entries for Q4aP to Q5hP
Q26B_2q26b_2q26b_2TextIF YES What is your disability, would you say (Read list. Include all that apply) (MULTIPLE RESPONSES ALLOWED)
DAdadaNumberTotal of all Drove Alone (1) entries for Q4aM to Q5hM
Q4TOTq4totq4totNumber(SF Residents) How many trips did you take yesterday?
Q11dMq11dmq11dmNumber(Outside SF Residents) How did you make that trip?
Q16P-Adjq16p_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)
REL2rel2rel2NumberTotal of all Rel/Vol/Pol (8) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
Q25A-SFq25a_sfq25a_sfNumber(San Francisco Residents) What is your home ZIP Code?
Q4ePq4epq4epNumber(SF Residents) Where did you go next?
LASTMODElastmodelastmodeNumberLast mode used for Q20_Last
Q22B_2q22b_2q22b_2NumberWhat modes do you combine most often? (Select two or more) (MULTIPLE ANSWERS ALLOWED)
Q7Mq7mq7mNumber(Outside SF Residents) How did you make that trip?
Q18cPq18cpq18cpNumber(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
Q9Mq9mq9mNumber(Outside SF Residents) How did you make that trip?
Q30q30q30NumberIs your annual household income...(Read List)
Q18aPq18apq18apNumber(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
Q18ePq18epq18epText(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
Q4gMq4gmq4gmNumber(SF Residents) How did you make that trip?
Q18bMq18bmq18bmNumber(Outside SF Residents) How did you make that trip?
SCH2sch2sch2NumberTotal of all School (2) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
Q4fMq4fmq4fmNumber(SF Residents) How did you make that trip?
DO2do2do2NumberTotal of all Drove With Others (2) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
Q6q6q6Number(Outside SF Residents) Over the past 30 days, about how many total days have you gone into San Francisco
Q11dPq11dpq11dpNumber(Outside SF Residents) Where did you go next?
DO1do1do1NumberTotal of all Drove With Others (2) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
SHOP1shop1shop1NumberTotal of all Shopping/Errand (3) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
Q28q28q28NumberAge
TNCtnctncNumberTotal of all TNC (4) entries for Q4aM to Q5hM
HOME1home1home1NumberTotal of all Home (5) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
Q11aMq11amq11amNumber(Outside SF Residents) How did you make that trip?
Q4dPq4dpq4dpNumber(SF Residents) Where did you go next?
Q19q19q19Number"(Outside SF Residents) Over the past 30 days, how many days have you made that same kind of trip into San Francisco? "
Q9M-Adjq9m_adjq9m_adjNumberAdded field. Integrates responses from Q7 for those who said yes on Q8. (Q7 unless Q8 = 2 or 3, then Q9M)
Q4dMq4dmq4dmNumber(SF Residents) How did you make that trip?
Q21Aq21aq21aNumberHave you tried any of these new travel options? If yes, how often do you use them? a. Lyft or Uber
CYCLE1cycle1cycle1NumberTotal of all Motorcycle (10) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
Q25Bq25bq25bNumberWhat is your workplace zipcode?
Q23q23q23NumberDo you own a car or have regular access to a car through family or friends?
Q11cPq11cpq11cpNumber(Outside SF Residents) Where did you go next?
WORK2work2work2NumberTotal of all Work (1) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
Interview_Dateinterview_dateinterview_dateCalendar dateDate of the interview
Q5fMq5fmq5fmNumber(SF Residents) How did you make that trip?
TRANS1trans1trans1NumberTotal of all Public Transit (6) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
DRVRFLAGdrvrflagdrvrflagNumberIndicates respondent drove alone or with others on any trip
Q20_LASTq20_lastq20_lastNumberIf you did not mode of travel on your last trip, what would you have done otherwise? (about half of respondents)
Q12q12q12Number"(Outside SF Residents) Over the past 30 days, how many days have you made that same kind of trip into San Francisco? "
SOC1soc1soc1NumberTotal of all Social/Rec (4) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
OTH2-Moth2_moth2_mNumberTotal of all Other (12) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
*RESPNUMrespnumrespnumNumberRespondent Number – automatically generated during data entry
DOdodoNumberTotal of all Drove With Others (2) entries for Q4aM to Q5hM
FIRSTMODEfirstmodefirstmodeNumberFirst mode used for Q20
Q5dMq5dmq5dmNumber(SF Residents) How did you make that trip?
WALK1walk1walk1NumberTotal of all Walk (9) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
Q26Aq26aq26aNumberDo you have a disability or health condition that affects the travel choices you make in San Francisco?
Q22Aq22aq22aNumberHow often do you use more than one mode?
ZONEzonezoneNumber(San Francisco Residents) San Francisco Zone (Based on Zip code)
TRANS2trans2trans2NumberTotal of all Public Transit (6) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
Q5dPq5dpq5dpNumber(SF Residents) Where did you go next?
Q5gPq5gpq5gpNumber(SF Residents) Where did you go next?
SOC2soc2soc2NumberTotal of all Social/Rec (4) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
Q25A-NSFq25a_nsfq25a_nsfNumber(Outside San Francisco Residents) What is your home ZIP code
Q4bPq4bpq4bpNumber(SF Residents) Where did you go next?
Q11bPq11bpq11bpNumber(Outside SF Residents) Where did you go next?
Q22q22q22Number(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.
CRSHRE2crshre2crshre2NumberTotal of all Drove Car Share (3) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
WORK1work1work1NumberTotal of all Work (1) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
DK2-Mdk2_mdk2_mNumberTotal of all Don't Know/Don't remember (13) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
Q7Pq7pq7pNumber(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…
WEIGHTweightweightNumberWeighting factor applied to record
LANGlanglangNumberInterview Language
Q31q31q31NumberWhat gender do you identify with?
Q29_3q29_3q29_3NumberWhat is your race or ethnic identification. Are you... (MULTIPLE ANSWERS ALLOWED)
Q29_2q29_2q29_2NumberWhat is your race or ethnic identification. Are you... (MULTIPLE ANSWERS ALLOWED)
Q29_1q29_1q29_1NumberWhat is your race or ethnic identification. Are you... (MULTIPLE ANSWERS ALLOWED)
Q27q27q27NumberAre you responsible for the transportation of anyone else in your household?
Q26B_4q26b_4q26b_4TextIF YES What is your disability, would you say (Read list. Include all that apply) (MULTIPLE RESPONSES ALLOWED)
Q22B_3q22b_3q22b_3NumberWhat modes do you combine most often? (Select two or more) (MULTIPLE ANSWERS ALLOWED)
Q22B_1q22b_1q22b_1NumberWhat modes do you combine most often? (Select two or more) (MULTIPLE ANSWERS ALLOWED)
Q21Cq21cq21cNumberAnd how often do you use traditional taxis?
BIKE2bike2bike2NumberTotal of all Bicycle (8) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
TAXI2taxi2taxi2NumberTotal of all Taxi (5) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
DA2da2da2NumberTotal of all Drove Alone (1) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
SHTTLE1shttle1shttle1NumberTotal of all Private Bus/Van (7) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
TNC1tnc1tnc1NumberTotal of all TNC (4) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
CRSHRE1crshre1crshre1NumberTotal of all Drove Car Share (3) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
Q18dMq18dmq18dmNumber(Outside SF Residents) How did you make that trip?
Q14Mq14mq14mNumber(Outside SF Residents) How did you make that trip?
Q11fMq11fmq11fmNumber(Outside SF Residents) How did you make that trip?
DK2-Pdk2_pdk2_pNumberTotal of all Don't know/Don't remember (7) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
HOME2home2home2NumberTotal of all Home (5) entries for Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
OTH1-Poth1_poth1_pNumberTotal of all Other (6) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
Q18dPq18dpq18dpNumber(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
Q18bPq18bpq18bpNumber(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
Q14Pq14pq14pNumber(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:
Q18Totalq18totalq18totalNumber(Outside SF Residents) How many additional destinations within San Francisco did you go to on that day?
Q13q13q13Number(Outside SF Residents) Have you taken any DIFFERENT TYPE OF TRIPS into San Francisco in the past 30 days?
Q8q8q8Number(Outside SF Residents) Did you leave San Francisco using the same mode of transportation (E.G. car, taxi, etc)
CYCLEcyclecycleNumberTotal of all Motorcycle (10) entries for Q4aM to Q5hM
TAXItaxitaxiNumberTotal of all Taxi (5) entries for Q4aM to Q5hM
Q5eMq5emq5emNumber(SF Residents) How did you make that trip?
Q5cMq5cmq5cmNumber(SF Residents) How did you make that trip?
Q5bMq5bmq5bmNumber(SF Residents) How did you make that trip?
Q5aMq5amq5amNumber(SF Residents) How did you make that trip?
Q4cMq4cmq4cmNumber(SF Residents) How did you make that trip?
RELrelrelNumberTotal of all Rel/Vol/Pol (8) entries for Q4aP to Q5hP
DK-P-SFdk_p_sfdk_p_sfNumberTotal of all Don't know/Don't remember (7) entries for Q4aP to Q5hP
SHOPshopshopNumberTotal of all Shopping/Errand (3) entries for Q4aP to Q5hP
Q5hPq5hpq5hpNumber(SF Residents) Where did you go next?
Q5fPq5fpq5fpNumber(SF Residents) Where did you go next?
Q5ePq5epq5epNumber(SF Residents) Where did you go next?
Q5cPq5cpq5cpNumber(SF Residents) Where did you go next?
Q5bPq5bpq5bpNumber(SF Residents) Where did you go next?
Q4fPq4fpq4fpNumber(SF Residents) Where did you go next?
Q4cPq4cpq4cpNumber(SF Residents) Where did you go next?
Q4aPq4apq4apNumber(SF Residents) What was the purpose your first trip?
Q5TOTq5totq5totNumber(SF Residents) How many trips did you take (outside of your home) TWO DAYS AGO.
Q2q2q2NumberIn which Bay Area county do you live?
Q11aPq11apq11apNumber(Outside SF Residents) What was the purpose your first trip?
Q21Bq21bq21bNumberHave you tried any of these new travel options? If yes, how often do you use them? b. Bikeshare or Standup e-Scooter
Q11eMq11emq11emNumber(Outside SF Residents) How did you make that trip?
BIKEbikebikeNumberTotal of all Bicycle (8) entries for Q4aM to Q5hM
Q24Aq24aq24aNumberAre you aware of the expansion of bicycle lanes and other improvements in bicycle access throughout San Francisco in the past few years?
SCH1sch1sch1NumberTotal of all School (2) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
TRANStranstransNumberTotal of all Public Transit (6) entries for Q4aM to Q5hM
Q29_4q29_4q29_4TextWhat is your race or ethnic identification. Are you... (MULTIPLE ANSWERS ALLOWED)
Q26B_1q26b_1q26b_1NumberIF YES What is your disability, would you say (Read list. Include all that apply) (MULTIPLE RESPONSES ALLOWED)
OTH1-Moth1_moth1_mNumberTotal of all Other (12) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
Q4hPq4hpq4hpNumber(SF Residents) Where did you go next?
Q4eMq4emq4emNumber(SF Residents) How did you make that trip?
OTH-M-SFoth_m_sfoth_m_sfNumberTotal of all Other (12) entries for Q4aM to Q5hM
Q4gPq4gpq4gpNumber(SF Residents) Where did you go next?
Q11ePq11epq11epNumber(Outside SF Residents) Where did you go next?
Q5hMq5hmq5hmNumber(SF Residents) How did you make that trip?
SHOP2shop2shop2NumberTotal of all Shopping/Errand (3) entriesfor Day 2 (Q14P, Q16P-Adj, Q18aP to Q18fP) multiplied by Q19
Q26B_3q26b_3q26b_3TextIF YES What is your disability, would you say (Read list. Include all that apply) (MULTIPLE RESPONSES ALLOWED)
WALKwalkwalkNumberTotal of all Walk (9) entries for Q4aM to Q5hM
SCHschschNumberTotal of all School (2) entries for Q4aP to Q5hP
Q11fPq11fpq11fpNumber(Outside SF Residents) Where did you go next?
OTH-P-SFoth_p_sfoth_p_sfNumberTotal of all Other (6) entries for Q4aP to Q5hP
Q11Totalq11totalq11totalNumber(Outside SF Residents) How many additional destinations within San Francisco did you go to on that day?
SHTTLE2shttle2shttle2NumberTotal of all Private Bus/Van (7) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
Q22B_4q22b_4q22b_4NumberWhat modes do you combine most often? (Select two or more) (MULTIPLE ANSWERS ALLOWED)
SOCsocsocNumberTotal of all Social/Rec (4) entries for Q4aP to Q5hP
Q5gMq5gmq5gmNumber(SF Residents) How did you make that trip?
TNC2tnc2tnc2NumberTotal of all TNC (4) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
Q16M-Adjq16m_adjq16m_adjNumberAdded field. Integrates responses from Q14 for those who said yes on Q15.
DK-M-SFdk_m_sfdk_m_sfNumberTotal of all Don't Know/Don't remember (13) entries for Q4aM to Q5hM
Q4hMq4hmq4hmNumber(SF Residents) How did you make that trip?
Interview_Dayinterview_dayinterview_dayNumberDay of the week on which the interview was conducted
Q4aMq4amq4amNumber(SF Residents) How did you make that trip?
SCOOTscootscootNumberTotal of all E-Scooter (11) entries for Q4aM to Q5hM
SCOOT1scoot1scoot1NumberTotal of all E-scooter (11) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
DK1-Pdk1_pdk1_pNumberTotal of all Don't know/Don't remember (7) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
TAXI1taxi1taxi1NumberTotal of all Taxi (5) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
Q16Mq16mq16mNumber(Outside SF Residents) How did you leave San Francisco?
DK1-Mdk1_mdk1_mNumberTotal of all Don't Know/Don't remember (13) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12
SFINTMODEsfintmodesfintmodeNumber(SF Residents) How did you make that trip? (combination of initial modes from Q4am and Q5aM-Q4am unless Q4am is blank)
Q17q17q17Number(Outside SF Residents) Did you go to any other destinations in the City that day?
Q5aPq5apq5apNumber(SF Residents) What was the purpose your first trip on (DAY)?
Q18fMq18fmq18fmText(Outside SF Residents) How did you make that trip?
Q3q3q3NumberHave you gone into San Francisco within the past month (30 days)?
Q11bMq11bmq11bmNumber(Outside SF Residents) How did you make that trip?
Q18aMq18amq18amNumber(Outside SF Residents) How did you make that trip?
SCOOT2scoot2scoot2NumberTotal of all E-Scooter (11) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
Q9P-ADJq9p_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)
Q18fPq18fpq18fpText(Outside SF Residents) For each additional destination, what was the purpose and how did you make the trip?
Q10q10q10Number(Outside SF Residents) Did you go to any other destinations in the City that day?
WALK2walk2walk2NumberTotal of all Walk (9) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
Q18cMq18cmq18cmNumber(Outside SF Residents) How did you make that trip?
Q11cMq11cmq11cmNumber(Outside SF Residents) How did you make that trip?
CYCLE2cycle2cycle2NumberTotal of all Motorcycle (10) entries for Day 2 (Q14M, Q16M-Adj, Q18aM to Q18fM) multiplied by Q19
SHTTLEshttleshttleNumberTotal of all Private Bus/Van (7) entries for Q4aM to Q5hM
Q15q15q15Number(Outside SF Residents) Did you leave San Francisco using the same mode (E.G. car, taxi, etc.)?
Q18eMq18emq18emText(Outside SF Residents) How did you make that trip?
REL1rel1rel1NumberTotal of all Rel/Vol/Pol (8) entries for Day 1 (Q7P, Q9P-Adj, Q11aP to Q11fP) multiplied by Q12
HOMEhomehomeNumberTotal of all Social/Rec (4) entries for Q4aP to Q5hP
BIKE1bike1bike1NumberTotal of all Bicycle (8) entries for Day 1 (Q7M, Q9M-Adj, Q11aM to Q11fM) multiplied by Q12

Upstream Metadata