About this Dataset

Street-Use Permits

Note 1/17/2025: This dataset has been backfilled to include additional permit status and historical permit data. Please see Active Street-Use Permits if you are only interested in currently active permits. A. SUMMARY All street space permits received by SF Public Works. This includes permits in all statuses of review by Public Works, including those approved and issued as well as those pending review, closed or withdrawn. The dataset includes permits received since 1996. A street space permit grants permission to temporarily occupy a portion of a public roadway or sidewalk for building construction and other construction related work. Find out more about street space permits here. B. HOW THE DATASET IS CREATED The dataset is extracted by SF Public Works from its source system and transmitted directly to the Open Data Portal via an automated pipeline. C. UPDATE PROCESS The dataset is updated daily at 12am with a one day lag. D. HOW TO USE THIS DATASET This dataset can be used to identify the status of any street space permits received by SF Public Works since 1996. Some of the data fields are from early versions of Public Works current system and may not have been validated when first entered. Some fields such as the DBI Building Permit Application (“bpa” field) are entered by Public Works staff and are not validated against Building Permit Applications in DBI’s Permit Tracking System (PTS). A single permit may be repeated on multiple rows if it covers more than one street or location. You can use the permit_number field to identify the unique number of permits. The data_as_of field represents when the row was updated, and can be used for incremental loading of the data in conjunction with the unique_id. E. RELATED DATASETS

Active street permits
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:21.847922
Tags: banner, chairs, display, excavation, food, mobile, mounted, occupancy, permits, row, surface, tables, temporary, truck

Tables

Table 1

@usgov.city_of_san_francisco_street_use_permits.table_1

108.94 MB
1173687 rows
30 columns


CREATE TABLE table_1 (
  "permit_number" VARCHAR,
  "unique_identifier" VARCHAR,
  "cnn" BIGINT,
  "streetname" VARCHAR,
  "cross_street_1" VARCHAR,
  "cross_street_2" VARCHAR,
  "permit_type" VARCHAR,
  "agent" VARCHAR,
  "agentphone" VARCHAR,
  "permit_purpose" VARCHAR,
  "approved_date" TIMESTAMP,
  "status" VARCHAR,
  "bpa" VARCHAR,
  "permit_zipcode" VARCHAR,
  "permit_start_date" TIMESTAMP,
  "permit_end_date" TIMESTAMP,
  "permit_address" VARCHAR,
  "n_24_7_contact" VARCHAR,
  "inspector" VARCHAR,
  "curbrampwork" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR,
  "the_geom" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);