About this Dataset

Muni Simple Routes

A. SUMMARY Current Muni routes for simple cartographic and spatial analyses. B. METHODOLOGY Route data is exported from the Trapeze scheduling system and filtered only for full length patterns. C. UPDATE FREQUENCY Updated by “Sign-up”, when transit system changes are put into effect. Updates range from every 3-6 months. D. OTHER CRITICAL INFO Inbound and Outbound route lines are included and represented with separate polylines for each route. Route numbers 59, 60, 61 are all Cable Car routes.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:18.155827
Tags: bus, cable-car, lrv, metro, public-lines, rail, routes, transit-lines, transit-network

Tables

Table 1

@usgov.city_of_san_francisco_muni_simple_routes.table_1

179.11 kB
135 rows
14 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "pattern" VARCHAR,
  "patternid" BIGINT,
  "route_name" VARCHAR,
  "direction" VARCHAR,
  "pattern_type" VARCHAR,
  "sub_type" BIGINT,
  "pattern_version" BIGINT,
  "lineabbr" VARCHAR,
  "signid" BIGINT,
  "service_ca" VARCHAR,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);