yesid@transit:gold> LIVE
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
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;
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
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 2880 51.7 24121 18.4 2251 44.9 19165 27.6 17
5 rows · 0.023s · updated 30s ago
Refreshes metrics + query results from the live pipeline
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.