About this Dataset

Active And Upcoming Street Surface Permits

A. SUMMARY This table includes all active and upcoming "street use" permits issued by the Department of Public Works for activities on the street surface (not underground). It lists permits that are currently active or have a start date within the next 14 days. B. HOW THE DATASET IS CREATED This dataset is the union of two other permit tables on the open data portal:

Street Use Permits
Street Vending Permits Only the following permits types are included from street use permits: 'Display', 'Parklet', 'FoodFac', 'minorenc', 'Referral', 'NightNoise', 'StrtImprov', 'MajorEnc', 'Excavation', 'AddlStSpac', 'StreetSpace', 'StorCont', 'MinorEnc', 'ExcStreet', 'TableChair', 'TempOccup', 'FreeSample' C. UPDATE PROCESS This dataset refreshes daily. The underlying data updates when a new permit is issued. D. HOW TO USE THIS DATASET This dataset will be used to create a map of active and upcoming street surface permits. E. RELATED DATASETS
Street Use Permits
Street Vending Permits
Organization: City of San Francisco
Last updated: 2025-03-29T16:53:48.791086

Tables

Table 1

@usgov.city_of_san_francisco_active_and_upcoming_street_surfa_8ef380df.table_1

365.66 kB
5,316 rows
17 columns

CREATE TABLE table_1 (
  "permit_number" VARCHAR,
  "dba_name" VARCHAR,
  "street_name" VARCHAR,
  "cross_street" VARCHAR,
  "permit_type" VARCHAR,
  "permit_description" VARCHAR,
  "status" VARCHAR,
  "approved_date" VARCHAR,
  "permit_start_date" VARCHAR,
  "permit_end_date" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "point" VARCHAR,
  "supervisor_district" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);