hasadna / hasadna/open-bus-stride-api

API returns total_actual_rides: 0 for all operators on 2025-09-17 !

Open
#49 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
8
Forks
18
PR merge metrics
No merged PRs in 30d

Description

## Bug Description
The `/gtfs_rides_agg/group_by` endpoint returns `total_actual_rides: 0` for ALL operators when querying data for 2025-09-17.

## API Call

## Expected Behavior
Should return realistic numbers for `total_actual_rides` based on SIRI real-time data.

## Actual Behavior
All operators return `total_actual_rides: 0`, while `total_planned_rides` shows normal values.

## Sample Response
[{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":2,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":1230,"total_planned_rides":1230,"total_actual_rides":0},{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":3,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":20057,"total_planned_rides":46608,"total_actual_rides":0},{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":4,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":3242,"total_planned_rides":4410,"total_actual_rides":0},{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":5,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":6328,"total_planned_rides":24385,"total_actual_rides":0},{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":6,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":1892,"total_planned_rides":4442,"total_actual_rides":0},{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":7,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":2285,"total_planned_rides":3271,"total_actual_rides":0},{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":8,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":744,"total_planned_rides":908,"total_actual_rides":0},{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":10,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":98,"total_planned_rides":98,"total_actual_rides":0},{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":14,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":7354,"total_planned_rides":12105,"total_actual_rides":0},{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":15,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":12618,"total_planned_rides":25872,"total_actual_rides":0},{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":16,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":8559,"total_planned_rides":21014,"total_actual_rides":0},{"gtfs_route_date":null,"gtfs_route_hour":null,"operator_ref":18,"day_of_week":null,"line_ref":null,"route_short_name":null,"route_long_name":null,"total_routes":14100,"total_planned_rides":26736,"total_actual_rides":0} ..

## Impact
This causes the Open Bus Map Search application to display 0% completion rate for all operators.

## Environment
- Date: 2025-09-18
- Query Date Range: 2025-09-17 to 2025-09-18
- All operators affected (2, 3, 4, 5, etc.)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.