Name: MTA Bus Routes
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

MTA Bus Routes

This dataset contains polyline geometries and metadata for distinct bus route shapes by route and direction across schedule bundles.
Organization: State of New York
Last updated: 2025-11-01T20:30:07.239412
Tags: bus, bus-routes, coordinates, express-bus, locations, mta-bus, mtabc, new-york-city-transit, nyct, routes, schedules

Tables

Table 1

@usgov.state_of_new_york_mta_bus_routes.table_1

438.93 MB
189,454 rows
20 columns

CREATE TABLE table_1 (
  "valid_from" TIMESTAMP,
  "valid_to" TIMESTAMP,
  "route_id" VARCHAR,
  "route_short_name" VARCHAR,
  "route_long_name" VARCHAR,
  "route_description" VARCHAR,
  "trip_type" BIGINT,
  "route_type" VARCHAR,
  "bundle" VARCHAR,
  "route_color" VARCHAR,
  "direction_id" BIGINT,
  "direction" VARCHAR,
  "shape_id" VARCHAR,
  "vertices" BIGINT,
  "shape_length" DOUBLE,
  "min_longitude" DOUBLE,
  "min_latitude" DOUBLE,
  "max_longitude" DOUBLE,
  "max_latitude" DOUBLE,
  "geometry" VARCHAR
);