Research Request - migrate gtfs_utils to v2

[tiffanychu90]

Complete the below when receiving a research request, and continue to add to this issue as you receive additional details and produce deliverables. Be sure to also add the appropriate project-level label to this issue (eg gtfs-rt, DLA).

Research Question

Single sentence description: Move gtfs_utils queries that pulls from v1 in warehouse to v2

Detailed description: Test this on Sept and Oct dates we already have downloaded for HQTA to make sure feed -> operators is done correctly for summing up service hours statewide

How will this research be used?

What will be achieved or informed? What is the intended impact?

Stakeholders & End-Users

Who is asking the question, and who is the audience?

Metrics

• any specific calculations
• you think will be needed

Data sources

• Cal-ITP data sources:

• External data sources:

• Remaining data source questions:

Deliverables:

Notebook, dashboard, narrative, presentation details.

Timeline of deliverables:

Estimated completion date

[tiffanychu90]

• Patch needed here for v1 to fully work with existing analyses add v1 geog functions to gtfs_utils for v1 speedmap compatibility #628

[tiffanychu90]

• Adding more to portfolio_utils for v2 in Jan open data #626