gavincabbage/gtfs-timeseries

Playing with GTFS-realtime data in time series databases

gtfs-timeseries

Playing with GTFS-realtime data in timeseries database. Uploading and querying data to InfluxDB Cloud using the new IOx storage engine and TimeseriesDB Cloud.

Contents

• telegraf/
  • A Telegraf execd plugin written in Go that polls GTFS-realtime data
• export/
  • Python code to query GTFS-realtime data in InfluxDB IOx via FlightSQL and TimescaleDB via PostgreSQL and convert it to GeoJSON
• config.toml
  • Telegraf configuration using the GTFS-realtime plugin in this repo to write to InfluxDB and TimescaleDB
• keplergl.ipynb
  • Juypter Notebook using KeplerGL to visualize data exported with the Python code in this repo

Resource

Links I used while putting this together:

• Visualizing Bus Trajectories in Denver
• Visualizing Istanbul Bus Traffic With Python and KeplerGL
• Using KeplerGL in JupyterLab