About this Dataset

Street Signs

A. SUMMARY Inventory of signs on public streets and sidewalks owned and maintained by MTA. Includes street signs such as stop signs, traffic lights, directional signs, parking signs, transit lanes, etc. B. HOW THE DATASET IS CREATED The dataset is derived from MTA's Sign Shop asset inventory. This inventory may not contain all signs in the roadway and is continually being updated and enhanced to provide the most up to date information on MTA-owned signs. C. UPDATE PROCESS The source data is maintained by the MTA Sign Shop and updated as needed in MTA's internal spatial data store. D. HOW TO USE THIS DATASET Many of the signs have been assigned to the nearest intersection or midblock point and may not indicate the exact location of a sign. The dataset has not been fully validated and should be used with caution. E. RELATED DATASETS Stop Signs Traffic Signals
Organization: City of San Francisco
Last updated: 2025-03-29T17:04:21.543599

Tables

Table 1

@usgov.city_of_san_francisco_street_signs_4a06c.table_1

14.5 MB
144,333 rows
46 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "asset_id" VARCHAR,
  "gisobjid" DOUBLE,
  "sign_code" VARCHAR,
  "legend" VARCHAR,
  "sign_size" VARCHAR,
  "street_address_range" VARCHAR,
  "loc_spec" VARCHAR,
  "sign_support" VARCHAR,
  "streetname" VARCHAR,
  "from_st" VARCHAR,
  "to_st" VARCHAR,
  "intersection" VARCHAR,
  "corner_side_facing" VARCHAR,
  "arrow_dir" VARCHAR,
  "num_of_assets" DOUBLE,
  "condition" VARCHAR,
  "orig_install_date" VARCHAR,
  "replacement_date" VARCHAR,
  "retirement_date" VARCHAR,
  "sign_supervisor" VARCHAR,
  "sf_sup_district" VARCHAR,
  "sheeting" VARCHAR,
  "status_code" VARCHAR,
  "new_sign_code" VARCHAR,
  "new_sign_legend" VARCHAR,
  "new_sign_size" VARCHAR,
  "sign_category" VARCHAR,
  "sign_class" VARCHAR,
  "last_edited_date" VARCHAR,
  "cnn" DOUBLE,
  "asset_name" VARCHAR,
  "status_date" VARCHAR,
  "street_block" VARCHAR,
  "accepted" DOUBLE,
  "active" DOUBLE,
  "addrange" VARCHAR,
  "point_x" DOUBLE,
  "point_y" DOUBLE,
  "asset_name_1" VARCHAR,
  "created_date" VARCHAR,
  "shape" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);