About this Dataset

National Transit Map Routes

The National Transit Map - Routes dataset was compiled on June 02, 2025 from the Bureau of Transportation Statistics (BTS) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The National Transit Map (NTM) is a nationwide catalog of fixed-guideway and fixed-route transit service in America. It is compiled using General Transit Feed Specification (GTFS) Schedule data. The NTM Routes dataset shows transit routes, which is a group of trips that are displayed to riders as a single service. To display the route alignment and trips for each route, this dataset combines the following GTFS files: routes.txt, trips.txt, and shapes.txt. The GTFS Schedule documentation is available at, https://gtfs.org/schedule/. To improve the spatial accuracy of the NTM Routes, the Bureau of Transportation Statistics (BTS) adjusts transit routes using context from the submitted GTFS source data and/or from other publicly available information about the transit service. A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1529048
Organization: Federal Geographic Data Committee
Last updated: 2025-06-30T16:05:17.327522
Tags: ngda-fgdc-gda-transportation

Tables

Table 1

@usgov.fgdc_gov_national_transit_map_routes_b405a.table_1

3.24 MB
68,994 rows
18 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ntd_id" VARCHAR,
  "feed_id" VARCHAR,
  "shape_id" VARCHAR,
  "route_id" VARCHAR,
  "agency_id" VARCHAR,
  "route_short_name" VARCHAR,
  "route_long_name" VARCHAR,
  "route_desc" VARCHAR,
  "route_type" DOUBLE,
  "route_type_text" VARCHAR,
  "route_url" VARCHAR,
  "route_color" VARCHAR,
  "route_color_formatted" VARCHAR,
  "route_text_color" VARCHAR,
  "route_text_color_formatted" VARCHAR,
  "download_date" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);