search

cal-itp / data-infra

Cal-ITP data infrastructure
https://docs.calitp.org/data-infra
GNU Affero General Public License v3.0
47 stars 12 forks source link

Bug: Missing GTFS data from at least two operators (LA Metro, Santa Monica BBB) in tbl.gtfs_schedule #845

Closed edasmalchi closed 2 years ago

edasmalchi commented 2 years ago

Describe the bug I'm no longer able to find any data for LA Metro (itp_id 182) or Santa Monica Big Blue Bus (itp_id 300) in the tbl.gtfs_schedule/ GTFS Schedule Feeds Latest views using siuba or metabase

To Reproduce Look for GTFS data for either operator in tbl.gtfs_schedule/ GTFS Schedule Feeds Latest, for example with:

tbl.gtfs_schedule.trips() >> filter(_.calitp_itp_id == 182)

Expected behavior Being able to get GTFS data from the tbl.gtfs_schedule/ GTFS Schedule Feeds Latest views in the warehouse for these operators.

Additional context I've only noticed these two missing so far, but it would probably be worth checking more broadly in case more data isn't making it into these views

Related issue specifically for rail routes, but it now seems it's more of a widespread problem?

edasmalchi commented 2 years ago

Fixed by PR 872