Transit: understanding transit data
Public transit, with the data and its limitations in view.
Services
Tech Stack
2 Transit networks: Montréal and Ottawa
FR / EN Interface languages
yesid@transit:gold> DEMO
SELECT d.route_short_name,
round(avg(f.delay_seconds)::numeric, 1) AS avg_delay_s,
count(DISTINCT f.vehicle_id) AS vehicles
FROM gold.latest_trip_delay_snapshot f
INNER JOIN gold.dim_route d USING (provider_id, route_id)
WHERE f.delay_seconds IS NOT NULL
GROUP BY d.route_short_name
ORDER BY vehicles DESC
LIMIT 5;
round(avg(f.delay_seconds)::numeric, 1) AS avg_delay_s,
count(DISTINCT f.vehicle_id) AS vehicles
FROM gold.latest_trip_delay_snapshot f
INNER JOIN gold.dim_route d USING (provider_id, route_id)
WHERE f.delay_seconds IS NOT NULL
GROUP BY d.route_short_name
ORDER BY vehicles DESC
LIMIT 5;
| route | avg_delay_s | vehicles |
|---|---|---|
| 24 | 32.1 | 28 |
| 80 | 51.7 | 24 |
| 121 | 18.4 | 22 |
| 51 | 44.9 | 19 |
| 165 | 27.6 | 17 |
5 rows · 0.023s · demo data
Regenerates the metrics + query results. Simulated STM-style pipeline data, not a live feed.
CONNECTED LIGNE ORANGE yesid.dev v2.0 SCROLL ↓
LAT 45.5017°N LNG 73.5673°W SRC Sherbrooke, QC VIA Lennoxville, QC DST Montréal, QC NODE berri-uqam STATUS active
SEC-02 MANIFESTO MTL-QC
0
80
160
240
320
400
480
PROCHAIN / NEXT 02:47
QUAI / PLATFORM 2
DIRECTION: CENTRE-VILLE
yesid@mtl :~$ cat manifesto.md
I BUILD THE
INFRASTRUCTURE
YOUR OPERATIONS RUN ON.
Services.
Services.
About.
About.
Projects.
01 / 04
View all projects →Projects.
Let's build somethingthat moves.
Database, pipeline, dashboard, website: wherever it's stuck, that's where we start.