Dataset: SF Open Data Transportation

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

150.41 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

306.9 KB
3312 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
);