Traffic Signals by US Government | Transportation and Logistics

About this Dataset

Traffic Signals

A. SUMMARY
An inventory of traffic signals, flashing beacons, and related equipment located throughout San Francisco.

B. METHODOLOGY
Imported from the Signals Access database which is maintained by the SFMTA signal shop.

C. UPDATE FREQUENCY
Signals Access database updated regularly (quarterly) based on SRC work orders returned to date. GIS file updated quarterly.
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:06.532699

Tables

Table 1

@usgov.city_of_san_francisco_traffic_signals.table_1

142.87 KB
1507 rows
55 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "cnn" BIGINT,
  "street1" VARCHAR,
  "street2" VARCHAR,
  "detection" VARCHAR,
  "street3" VARCHAR,
  "sup_dist" DOUBLE,
  "street4" VARCHAR,
  "sig_num" BIGINT,
  "type" VARCHAR,
  "ic_make" VARCHAR,
  "model" VARCHAR,
  "cabinet_si" VARCHAR,
  "system_num" VARCHAR,
  "master" VARCHAR,
  "bbs" VARCHAR,
  "veh_actuat" VARCHAR,
  "ped_signal" VARCHAR,
  "ped_actuat" VARCHAR,
  "tbc" VARCHAR,
  "interconne" VARCHAR,
  "preempt_pr" VARCHAR,
  "d_ate2070" DOUBLE,
  "project_ne" VARCHAR,
  "project_ol" VARCHAR,
  "upgraded" VARCHAR,
  "yr_of_cont" VARCHAR,
  "last_upgra" VARCHAR,
  "new_signal" VARCHAR,
  "mod_projec" VARCHAR,
  "full_upgra" VARCHAR,
  "beacon_fla" VARCHAR,
  "funding" VARCHAR,
  "rlcam" VARCHAR,
  "startyear" BIGINT,
  "caltrans_r" VARCHAR,
  "caltrans" VARCHAR,
  "percent_c" BIGINT,
  "sf" VARCHAR,
  "percent_sf" BIGINT,
  "percent_po" BIGINT,
  "lamp_assgn" VARCHAR,
  "lamp_sort" VARCHAR,
  "sort_me" VARCHAR,
  "aps" VARCHAR,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE
);