Baselight

Transit Rail Signals Maintainted By MTA

City of San Francisco

@usgov.city_of_san_francisco_mta_signals_rail_data

Loading...
Loading...

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
  • 79.54 KB
  • 108 rows
  • 18 columns
Loading...

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
);

Share link

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