About this Dataset

2016 SFO Customer Survey

SFO conducts a yearly comprehensive survey of our guests to gauge satisfaction with our facilities, services, and amenities. SFO compares results to previous surveys to look for areas of improvement and discover elements of the guest experience that are not satisfactory.

** The 2017 survey and Data Dictionary will be published late Summer, 2017.**
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:54.845479
Tags: airport, customer, sfo, survey

Tables

Table 1

@usgov.city_of_san_francisco_2016_sfo_customer_survey.table_1

233.62 kB
3,087 rows
97 columns

CREATE TABLE table_1 (
  "n__respnum" BIGINT  -- *RESPNUM,
  "ccgid" BIGINT,
  "runid" BIGINT,
  "intdate" VARCHAR,
  "egyptair" BIGINT,
  "day" BIGINT,
  "gate" BIGINT,
  "barea" VARCHAR,
  "strata" BIGINT,
  "peak" BIGINT,
  "method" BIGINT,
  "saq" BIGINT,
  "airline" VARCHAR,
  "destination" VARCHAR,
  "flight" BIGINT,
  "airline_code" BIGINT,
  "dest_code" BIGINT,
  "destgeo" BIGINT,
  "destmark" BIGINT,
  "arrtime" VARCHAR,
  "deptime" VARCHAR,
  "q2purp1" BIGINT,
  "q2purp2" DOUBLE,
  "q2purp3" DOUBLE,
  "q3getto1" BIGINT,
  "q3getto2" DOUBLE,
  "q3getto3" VARCHAR,
  "q3park" DOUBLE,
  "q4bags" BIGINT,
  "q4store" BIGINT,
  "q4food" BIGINT,
  "q4wifi" BIGINT,
  "q5timesflown" BIGINT,
  "q5firsttime" BIGINT,
  "q6longuse" BIGINT,
  "q7art" BIGINT,
  "q7food" BIGINT,
  "q7store" BIGINT,
  "q7sign" BIGINT,
  "q7walkways" BIGINT,
  "q7screens" BIGINT,
  "q7infodown" BIGINT,
  "q7infoup" BIGINT,
  "q7wifi" BIGINT,
  "q7roads" BIGINT,
  "q7park" BIGINT,
  "q7airtrain" BIGINT,
  "q7ltparking" BIGINT,
  "q7rental" BIGINT,
  "q7all" BIGINT,
  "q8com" BIGINT,
  "q8com2" DOUBLE,
  "q8com3" DOUBLE,
  "q8com4" DOUBLE,
  "q8com5" DOUBLE,
  "q9boarding" BIGINT,
  "q9airtrain" BIGINT,
  "q9rental" BIGINT,
  "q9food" BIGINT,
  "q9restroom" BIGINT,
  "q9all" BIGINT,
  "q9com" BIGINT,
  "q9com2" DOUBLE,
  "q9com3" DOUBLE,
  "q10safe" BIGINT,
  "q10com1" BIGINT,
  "q10com2" DOUBLE,
  "q10com3" DOUBLE,
  "q11tsapre" BIGINT,
  "q12precheckrate" DOUBLE,
  "q12precom1" DOUBLE,
  "q12precom2" DOUBLE,
  "q12precom3" DOUBLE,
  "q13_county" BIGINT,
  "q13getrate" BIGINT,
  "q14find" BIGINT,
  "q14passthru" BIGINT,
  "q15problem" BIGINT,
  "q15com1" DOUBLE,
  "q15com2" DOUBLE,
  "q15com3" DOUBLE,
  "q16live" BIGINT,
  "q17zip" DOUBLE,
  "q17country" VARCHAR,
  "home" BIGINT,
  "q18pet" BIGINT,
  "q19age" VARCHAR,
  "q20gender" VARCHAR,
  "q21incme" BIGINT,
  "q22fly" BIGINT,
  "q23sjc" DOUBLE,
  "q23oak" DOUBLE,
  "lang" BIGINT,
  "weight" DOUBLE,
  "howlong" DOUBLE,
  "q17city" VARCHAR,
  "q17state" VARCHAR
);