About this Dataset

Street Vending Permits

A. SUMMARY This dataset contains all Street Vendor Permits issued by the Department of Public Works whose status is active or approved including the approximate location of the vendor. B. HOW THE DATASET IS CREATED The dataset pulls permit information from the Department of Public Works system of record. C. UPDATE PROCESS This dataset will refresh once a week, though the underlying data can be updated at any time. D. HOW TO USE THIS DATASET Use this dataset to understand the location, goods sold, and type of permit issued for street vendors. Please note that "roaming" vendors will not have a latitude or longitude. Learn more about the program here. E. RELATED DATASETS

Mobile Food Facility Permit
Registered Businesses
Organization: City of San Francisco
Last updated: 2025-03-29T16:44:43.915714

Tables

Table 1

@usgov.city_of_san_francisco_street_vending_permits.table_1

35.49 kB
169 rows
20 columns

CREATE TABLE table_1 (
  "id" VARCHAR,
  "dbaname" VARCHAR,
  "permit_number" VARCHAR,
  "expiration_date" VARCHAR,
  "whatwillyoubeselling" VARCHAR,
  "describewhatyouwillsell" VARCHAR,
  "hoursofoperation" VARCHAR,
  "typeofvendor" VARCHAR,
  "vendinglocationstreet" VARCHAR,
  "vendinglocationcrossstreet" VARCHAR,
  "sideofthestreet" VARCHAR,
  "distancefromcrossstreet" VARCHAR,
  "beinfrontof" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "point" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);