Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Epic: add mart_gtfs tables based on data-analyses/gtfs_funnel work #3645

Open
1 task
tiffanychu90 opened this issue Jan 14, 2025 · 0 comments
Open
1 task
Assignees
Labels
project-gtfs-rt warehouse-poc Staging proof-of-concept tables related to analytics-driven warehouse models

Comments

@tiffanychu90
Copy link
Member

User story / feature request

The data-analyses GTFS analytics pipeline has reached a point where the majority of GTFS data products are using the same upstream scripts to query, transform several mart_gtfs tables. Identify some tables to add into the warehouse, especially some of the scripts related to GTFS RT (vehicle positions).

Acceptance Criteria

  • mart_gtfs.fct_vehicle_positions_dwell - gtfs_funnel/vp_dwell_time script
    • incorporate "dwell time" as a concept of how many vp are we counting at that same position, and use columns location_timestamp and moving_timestamp to identify when the bus first arrives at the location, when the bus starts moving again, and how many vehicle positions can be rolled up into 1 row. Based on work in data-analyses, a single day might be reduced from 15M rows to 12M rows.
    • MBTA repo

Add more tables as it comes up.

@tiffanychu90 tiffanychu90 added project-gtfs-rt warehouse-poc Staging proof-of-concept tables related to analytics-driven warehouse models labels Jan 14, 2025
@tiffanychu90 tiffanychu90 self-assigned this Jan 14, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
project-gtfs-rt warehouse-poc Staging proof-of-concept tables related to analytics-driven warehouse models
Projects
None yet
Development

No branches or pull requests

1 participant