About this Dataset

MTA.Muni Simpleroutes Data

| A. PURPOSE | Current Muni routes for simple cartographic and spatial analyses. For more complete and nuanced data, see MTA.Muni_pattern.
| B. METHODOLOGY | Route data is imported from the Trapeze scheduling system and filtered only for full length patterns from this table: TRAPEZEDEVELOPMENT.SIMPLEROUTE
| 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.
| E. ATTRIBUTES | PATTERN: Pattern designation. A pattern represents one of the variations of a route. For example, the 38-Geary outbound may terminate at Fort Miley, 48thAve, or 32ndAve. PATTERNID: Pattern unique ID;ROUTE_NAME: Public-facing route number;DIRECTION: “I” = Inbound, “O” = Outbound;PATTERN_TYPE: See pattern code document;SUB_TYPE: See pattern code document;PATTERN_VERSION: See pattern code document;LINEABBR: Line code in Trapeze;SIGNID: Signup unique ID;SERVICE_CA: As part of Muni Forward, SFMTA proposed a new framework that reorganizes Muni service into transit categories.
Organization: City of San Francisco
Last updated: 2023-12-02T06:12:00.458316

Tables

Table 1

@usgov.city_of_san_francisco_mta_muni_simpleroutes_data.table_1

349.82 KB
8 rows
16 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "created_user" VARCHAR,
  "created_date" VARCHAR,
  "last_edited_user" VARCHAR,
  "last_edited_date" VARCHAR,
  "shape_len" DOUBLE,
  "zero_veh_h" BIGINT,
  "com_carpoo" BIGINT,
  "objectid_1" BIGINT,
  "com_transi" BIGINT,
  "veh_capita" DOUBLE,
  "com_da" BIGINT,
  "shape_area" DOUBLE,
  "the_geom" VARCHAR,
  "neighborho" VARCHAR,
  "mta_equitystrategy_nhoods_area" DOUBLE
);