About this Dataset

DDOT Bus Routes 2017

Most current available data on bus routes in the city of Detroit, MI. Data reflects service as of April 22, 2017 and is subject to change as DDOT continues to improve service. All stops included in this dataset are operated by DDOT staff, including SE Michigan RTA's Reflex 498 Woodward.

Metadata are available here.
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T06:59:42.162721
Tags: bus, ddot, public, route, transit, transportation

Tables

Table 1

@usgov.city_of_ferndale_michigan_ddot_bus_routes_2017_07cd1.table_1

22.07 kB
112 rows
21 columns

CREATE TABLE table_1 (
  "objectid_1" BIGINT,
  "direction" VARCHAR,
  "pattern_de" VARCHAR,
  "routenum" BIGINT,
  "shape_leng" DOUBLE,
  "name" VARCHAR,
  "orientatio" VARCHAR,
  "rundays" VARCHAR,
  "runspan" VARCHAR,
  "wkpeak_fre" BIGINT,
  "wkbase_fre" BIGINT,
  "wknight_fr" BIGINT,
  "satbase_fr" BIGINT,
  "satnight_f" BIGINT,
  "sunbase_fr" BIGINT,
  "sunnight_f" BIGINT,
  "spantime_w" VARCHAR,
  "spantime_s" VARCHAR,
  "spantime_1" VARCHAR,
  "runpick" TIMESTAMP,
  "shape_length" DOUBLE  -- Shape, Length
);