data-infra
data-infra copied to clipboard
Cal-ITP data infrastructure
## User story / feature request During the implementation of Littlepay deduplication changes, we considered the idea that (unlike other tables from Littlepay) [it may be correct to treat the...
## User story / feature request As a warehouse developer, I would like to test synching to metabase locally, So that I can verify my local fixes will work in...
As highlighted during a call with the CCJPA team, it would be helpful to have a table view of journeys associated with a weekly fare cap, both: - The journeys...
Name: Members of https://github.com/orgs/cal-itp/teams/ntd-slalom Role: Contractor team from Slalom working on NTD Modernization Reports to: @hunterowens Google Workspace Email Address: GCS/BQ not needed yet GitHub Usernames: above Slack Username: n/a...
Sentry Issue: [CAL-ITP-DATA-INFRA-24J2](https://sentry.calitp.org/organizations/sentry/issues/70478/?referrer=github_integration) ``` CalledProcessError: Command '['java', '-jar', '/gtfs-realtime-validator.jar', '-gtfs', '/tmp/tmpojtth514/google_transit.zip', '-gtfsRealtimePath', '/tmp/tmpojtth514/rt_44a2869ad642dfa9a626ddd7995e0393/', '-sort', 'name']' returned non-zero exit status 1. File "gtfs_rt_parser.py", line 634, in parse_and_validate return validate_and_upload( File "gtfs_rt_parser.py",...
## User stories As a GTFS producer, if I include `feed_start_date` and `feed_end_date` in `feed_info.txt`, I expect those to be respected when consumers interpret service dates in `calendar.txt` and `calendar_dates.txt`....
Sentry Issue: [CAL-ITP-DATA-INFRA-24D4](https://sentry.calitp.org/organizations/sentry/issues/70320/?referrer=github_integration) ``` CalledProcessError: Command '['java', '-jar', '/gtfs-realtime-validator.jar', '-gtfs', '/tmp/tmpwd5haiit/google_transit.zip', '-gtfsRealtimePath', '/tmp/tmpwd5haiit/rt_ac6acf70d5c9ebf9164e3e789b678196/', '-sort', 'name']' returned non-zero exit status 1. File "gtfs_rt_parser.py", line 634, in parse_and_validate return validate_and_upload( File "gtfs_rt_parser.py",...
Sentry Issue: [CAL-ITP-DATA-INFRA-25HW](https://sentry.calitp.org/organizations/sentry/issues/71514/?referrer=github_integration) ``` DbtTestFail: test.calitp_warehouse.dbt_utils_expression_is_true_int_gtfs_schedule__stop_times_grouped__num_gtfs_flex_stop_times_0_is_gtfs_flex_trip.73b2c7213d - Got 14 results, configured to fail if != 0 ```
A key issue we want to help transit providers resolve is GTFS-RT availability. Availability describes, for systems that produce any GTFS-RT, what percent of the time will a rider who...
To go over with @chriscardillo next week, to sanity check the views we are creating. Below is a list of many questions which have been asked of GTFS RT data....