About this Dataset

Muni Stops

A. SUMMARY All transit stops in SFMTA system. B. METHODOLOGY To provide location and feature data of all transit stops. C. UPDATE FREQUENCY Stop data is exported from the Trapeze scheduling system and represents the most up to date location of transit stops. D. OTHER CRITICAL INFO Updated by “Sign-up”, when transit system changes are put into effect. Updates range from every 3-6 months.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:38.557636
Tags: bus-stop, cable-car-stops, lrv-stops, rail-stops, shelter, stop-attributes, stop-features, stop-location, stops

Tables

Table 1

@usgov.city_of_san_francisco_muni_stops.table_1

316.72 kB
3,291 rows
26 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "stopname" VARCHAR,
  "trapezestopabbr" VARCHAR,
  "rucusstopabbr" VARCHAR,
  "stopid" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "accessibilitymask" DOUBLE,
  "atstreet" VARCHAR,
  "onstreet" VARCHAR,
  "position" VARCHAR,
  "orientation" VARCHAR,
  "serviceplanningstoptype" VARCHAR,
  "shelter" BIGINT,
  "insert_timestamp" BIGINT,
  "sde_id" BIGINT,
  "signupid" BIGINT,
  "supervisor_district" DOUBLE,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE
);