Travel Decision Survey 2021
City of San Francisco
@usgov.city_of_san_francisco_travel_decision_survey_2021
City of San Francisco
@usgov.city_of_san_francisco_travel_decision_survey_2021
CREATE TABLE table_1 (
"n__respnum" BIGINT,
"q2" BIGINT,
"q3" DOUBLE,
"trips" BIGINT,
"q4tot" DOUBLE,
"q5tot" DOUBLE,
"q4ap" DOUBLE,
"q4bp" DOUBLE,
"q4cp" DOUBLE,
"q4dp" DOUBLE,
"q4ep" DOUBLE,
"q4fp" DOUBLE,
"q4gp" DOUBLE,
"q4hp" DOUBLE,
"q4ip" DOUBLE,
"q4jp" DOUBLE,
"q5ap" DOUBLE,
"q5bp" DOUBLE,
"q5cp" DOUBLE,
"q5dp" DOUBLE,
"q5ep" DOUBLE,
"q5fp" DOUBLE,
"q5gp" DOUBLE,
"q5hp" DOUBLE,
"q5ip" DOUBLE,
"q5jp" DOUBLE,
"work" BIGINT,
"sch" BIGINT,
"shop" BIGINT,
"soc" BIGINT,
"home" BIGINT,
"oth_p_sf" BIGINT,
"dk_p_sf" BIGINT,
"rel" BIGINT,
"q4am_1" DOUBLE,
"q4am_2" DOUBLE,
"q4am_3" VARCHAR,
"q4bm_1" DOUBLE,
"q4bm_2" DOUBLE,
"q4bm_3" VARCHAR,
"q4cm_1" DOUBLE,
"q4cm_2" DOUBLE,
"q4cm_3" VARCHAR,
"q4dm_1" DOUBLE,
"q4dm_2" DOUBLE,
"q4dm_3" VARCHAR,
"q4em_1" DOUBLE,
"q4em_2" VARCHAR,
"q4em_3" VARCHAR,
"q4fm_1" DOUBLE,
"q4fm_2" VARCHAR,
"q4fm_3" VARCHAR,
"q4gm_1" DOUBLE,
"q4gm_2" VARCHAR,
"q4gm_3" VARCHAR,
"q4hm_1" DOUBLE,
"q4hm_2" DOUBLE,
"q4hm_3" VARCHAR,
"q4im_1" DOUBLE,
"q4im_2" VARCHAR,
"q4im_3" VARCHAR,
"q4jm_1" DOUBLE,
"q4jm_2" VARCHAR,
"q4jm_3" VARCHAR,
"q5am_1" DOUBLE,
"q5am_2" DOUBLE,
"q5am_3" VARCHAR,
"q5bm_1" DOUBLE,
"q5bm_2" VARCHAR,
"q5bm_3" VARCHAR,
"q5cm_1" DOUBLE,
"q5cm_2" VARCHAR,
"q5cm_3" VARCHAR,
"q5dm_1" DOUBLE,
"q5dm_2" DOUBLE,
"q5dm_3" VARCHAR,
"q5em_1" DOUBLE,
"q5em_2" VARCHAR,
"q5em_3" VARCHAR,
"q5fm_1" DOUBLE,
"q5fm_2" DOUBLE,
"q5fm_3" VARCHAR,
"q5gm_1" DOUBLE,
"q5gm_2" VARCHAR,
"q5gm_3" VARCHAR,
"q5hm_1" DOUBLE,
"q5hm_2" VARCHAR,
"q5hm_3" VARCHAR,
"q5im_1" DOUBLE,
"q5im_2" VARCHAR,
"q5im_3" VARCHAR,
"q5jm_1" DOUBLE,
"q5jm_2" VARCHAR,
"q5jm_3" VARCHAR,
"da" BIGINT,
"do" BIGINT,
"crshre" BIGINT,
"tnc" BIGINT,
"taxi" BIGINT,
"trans" BIGINT
);
Anyone who has the link will be able to view this.