gtfs-indices.sql

-- create indices to speed up queries

-- TRIPS
create index trips_trip_id on trips (trip_id);
create index trips_service_id on trips (service_id);

-- STOP_TIMES
create index stop_times_trips on stop_times (trip_id);
create index stop_times_stop_id on stop_times (stop_id);

-- SHAPES
create index shapes_shape_id on shapes (shape_id);

-- STOPS
create index stops_stop_id on stops (stop_id);

-- CALENDAR
create index calendar_service_id on calendar (service_id);