DC Streetcar Routes by US Government | Transportation and Logistics

About this Dataset

DC Streetcar Routes

The District Department of Transportation (DDOT) launched DC Streetcar in February 2016 after more than 50 years. The rebirth of the streetcar emerged out of a mid-2000s planning effort to shape the future of transit in the city. The comprehensive District of Columbia Transit Improvements Alternatives Analysis studied gaps in transit and identified ways to better meet the needs of residents. From there, DDOT focused on expanding transit service with the DC Circulator, express Metrobus routes, bus rapid transit, Capital Bike Share, and DC Streetcar. The streetcar offers an array of benefits. A fully envisioned streetcar system makes it easier for residents to move between neighborhoods and spurs economic development. Unlike buses, fixed rail lines attract long-term community investments in housing, retail, and commercial properties.
Organization: District of Columbia
Last updated: 2024-04-30T19:13:05.548708
Tags: dc, ddot, district-of-columbia, rail, streetcar, transit, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_dc_streetcar_routes.table_1

26.17 KB
2 rows
40 columns


CREATE TABLE table_1 (
  "line" VARCHAR,
  "gis_id" VARCHAR,
  "web_url" VARCHAR,
  "color" VARCHAR,
  "lineid" VARCHAR,
  "servicedaydescription_a" VARCHAR,
  "servicedaystart_a" BIGINT,
  "servicedayend_a" BIGINT,
  "servicehourstart_a" BIGINT,
  "servicehourend_b" BIGINT,
  "servicedaydescription_b" VARCHAR,
  "servicedaystart_b" BIGINT,
  "servicedayend_b" BIGINT,
  "servicehourstart_b" BIGINT,
  "servicedaydescription_c" VARCHAR,
  "servicedaystart_c" BIGINT,
  "servicedayend_c" BIGINT,
  "servicehourstart_c" BIGINT,
  "servicehourend_c" BIGINT,
  "servicedaydescription_d" VARCHAR,
  "servicedaystart_d" VARCHAR,
  "servicedayend_d" VARCHAR,
  "servicehourstart_d" VARCHAR,
  "servicehourend_d" VARCHAR,
  "servicehourend_a" BIGINT,
  "line_alt" VARCHAR,
  "line_status" VARCHAR,
  "direction" VARCHAR,
  "comments" VARCHAR,
  "created_user" VARCHAR,
  "created_date" VARCHAR,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "objectid" BIGINT,
  "shapelen" BIGINT
);