Baselight

Temporary Street Closures

City of San Francisco

@usgov.city_of_san_francisco_temporary_street_closures

Loading...
Loading...

About this Dataset

Temporary Street Closures

A. SUMMARY This dataset stores upcoming and current street closures occurring as a result of the Shared Spaces program, certain special events, and some construction work. This dataset only includes street closures permitted by the San Francisco Municipal Transportation Agency (SFMTA). It doesn’t include street closures managed by other City departments such as Public Works or the Police Department. B. HOW THE DATASET IS CREATED The data is exported from the Street Closure Salesforce database which is maintained by the SFMTA ISCOTT unit and converted to the geometry of streets and intersections based on closed street extent descriptions. C. UPDATE PROCESS Database is updated constantly. This report is issued daily. D. HOW TO USE THIS DATASET Please be aware that this dataset only contains temporary street closure events that are permitted “status = permitted” This dataset contains various types of street closures. If you are looking for a particular type please use the type field to select the appropriate closure type (Ex. type = Shared Space). E. RELATED DATASETS

Tables

Table 1

@usgov.city_of_san_francisco_temporary_street_closures.table_1
  • 251.36 KB
  • 4109 rows
  • 26 columns
Loading...

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "case_num" BIGINT,
  "case_name" VARCHAR,
  "type" VARCHAR,
  "status" VARCHAR,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "start_dt" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "end_dt" VARCHAR,
  "loc_desc" VARCHAR,
  "cnn" BIGINT,
  "street" VARCHAR,
  "from_st" VARCHAR,
  "to_st" VARCHAR,
  "direction" VARCHAR,
  "veh_imp" VARCHAR,
  "info" VARCHAR,
  "start_utc" VARCHAR,
  "end_utc" VARCHAR,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "created_date" VARCHAR,
  "last_edited_date" VARCHAR
);

Share link

Anyone who has the link will be able to view this.