Name: SF Open Data Transportation
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

SF Open Data Transportation

This dataset collection contains data available on SF open data regarding Public Transportation in the city.

Currently, there are two datasets- The first contains the list of routes taken by the SF Muni Public Transit and the second contains the list of SF Muni Public Transit stops.

1.SF Muni Routes, Source: https://data.sfgov.org/Transportation/Muni-Simple-Routes/9exe-acju. Contains Current Muni routes for simple cartographic and spatial analyses as of July 10, 2023

2.SF Muni Stops, Source: https://data.sfgov.org/Transportation/Muni-Stops/i28k-bkz6. Contains Current Muni stops for geospatial analysis as of July 10, 2023

Tables

Muni Simple Routes

@kaggle.adyg1234_sf_open_data_transportation.muni_simple_routes

154.02 kB
130 rows
11 columns

CREATE TABLE muni_simple_routes (
  "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
);

Muni Stops

@kaggle.adyg1234_sf_open_data_transportation.muni_stops

314.27 kB
3,312 rows
24 columns

CREATE TABLE muni_stops (
  "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" DOUBLE,
  "insert_timestamp" BIGINT,
  "sde_id" BIGINT,
  "signupid" BIGINT,
  "supervisor_district" VARCHAR,
  "shape" VARCHAR,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE
);