Baselight

Temp Street Closure Intersections

City of San Francisco

@usgov.city_of_san_francisco_temp_street_closure_intersections

Loading...
Loading...

About this Dataset

Temp Street Closure Intersections

A. SUMMARY This dataset contains a list of intersections impacted by 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_temp_street_closure_intersections.table_1
  • 335.93 KB
  • 6755 rows
  • 31 columns
Loading...

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "case_num" BIGINT,
  "case_name" VARCHAR,
  "type" VARCHAR,
  "status" VARCHAR,
  "start_date" VARCHAR,
  "start_time" VARCHAR,
  "start_dt" VARCHAR,
  "end_date" VARCHAR,
  "end_time" VARCHAR,
  "end_dt" VARCHAR,
  "loc_desc" VARCHAR,
  "cnn" BIGINT,
  "street" VARCHAR,
  "x_street" VARCHAR,
  "is_open" VARCHAR,
  "direction" VARCHAR,
  "veh_imp" VARCHAR,
  "info" VARCHAR,
  "start_utc" VARCHAR,
  "end_utc" VARCHAR,
  "shape" VARCHAR,
  "created_date" VARCHAR,
  "last_edited_date" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" BIGINT,
  "analysis_neighborhoods" DOUBLE,
  "neighborhoods" DOUBLE
);

Share link

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