About this Dataset

Transit Rail Signals Maintainted By MTA

A. Summary Current inventory of transit rail signals maintained by Muni MOW. B. METHODOLOGY Manual edits to Access database export. C. UPDATE FREQUENCY Updated as changes are made through SRC and Rail CCB. D. OTHER CRITICAL INFO n/a E. ATTRIBUTES CNN: The intersection associated with the signal; STREET_1, _2, _3, _4: The cross streets nearest to the signal; LOC: Whether the signal is at an intersection or at a midblock location; LAT: Latitude in WGS-84; LON: Longitude in WGS-84; SIGNAL_TYPE: The type of signal (i.e. whether it shows ROW or a switch position); SIGNAL_ID: The ID of the signal per Muni records; LINE: Which lines use the signal, or if the signal is on a non-revenue track segment; DIRECTION: If used for a line, whether it is the inbound or outbound track; NO_ASPECTS: The number of aspects that comprise the signal; ASPECT_1, _2, _3, _4, _5: A description of the aspects from top to bottom; SIGNAL_HEAD_SIZE: The diameter of the signal head; SRC_NO: The number for the latest SRC Work Order that concerns this signal; DATE_SUBMITTED: The date that the SRC Work Order was submitted to the shop; DATE_COMPLETED: The latest date that work was completed on this signal;Date_Last: Date of last edit
Organization: City of San Francisco
Last updated: 2023-12-02T06:06:02.018187

Tables

Table 1

@usgov.city_of_san_francisco_mta_signals_rail_data.table_1

81.45 kB
108 rows
18 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "created_user" VARCHAR,
  "created_date" VARCHAR,
  "last_edited_user" VARCHAR,
  "last_edited_date" VARCHAR,
  "supdist" BIGINT,
  "gd_for_map" VARCHAR,
  "label_nam" VARCHAR,
  "shape_len" DOUBLE,
  "streetname" VARCHAR,
  "public" VARCHAR,
  "shape_area" DOUBLE,
  "grade" VARCHAR,
  "the_geom" VARCHAR,
  "former_nam" VARCHAR,
  "fullschnam" VARCHAR
);