Loading Events

« All Events

Virtual Event
  • This event has passed.

Querying Big Bus Data off of the Open Data Portal

March 24 @ 11:00 am - 12:00 pm
Virtual Event
Free
Open Data Week 2026 March 22-29, 2026 (and more!)

In this training, data scientists on the Metropolitan Transportation Authority’s (MTA) Data & Analytics team will teach attendees how to query big bus data off of the Socrata-powered open data portals using Socrata Query Language (SoQL). The first half of the session will be done entirely using in-browser tools, no special software required!

For the second half of the session, we’ll dive deeper into how to join bus route segment speed data to geospatial shapes in order to create map-based visuals. Python experience recommended to those who want to follow along, though all are welcome to listen in and learn! A URL to a GitHub repository will be added to this event page at a later date.

Details

Other

Pre-requisites
The first half of the session is beginning friendly and will only make use of in-browser tools on the open data portal. The second half of this session is more advanced and recommended to those with Python programming experience for full participation, though all are welcome to stay on to listen and learn!
Public Dataset(s)
MTA Bus Routes, MTA Bus Route Segment Speeds: Beginning 2025