Research Task - fct_monthly_operator_summary

[amandaha8]

Research Task

fct_monthly_operator_summary had many operators missing because the analysis_name column was added early on in the dataset creation. Now Tiffany has updated with the code and I need to join fct_monthly_operator_summary with the bridge table.

• Question or Goal: overarching goal of this issue

• Make sure the number of operators show up make sense after joining the two tables together. fct_monthly_operator_summary's column schedule_name matches schedule_gtfs_dataset_name in the bridge_gtfs_analysis_name_x_ntd table.

• Data Required:

• cal-itp-data-infra.mart_gtfs_rollup.fct_monthly_operator_summary

• cal-itp-data-infra.mart_transit_database.bridge_gtfs_analysis_name_x_ntd

• Expected Outputs / Findings: what do you hope to have created when this is complete?

• More operators to be available.

• Tiffany notes: try it to see how it works, it should be at least 80% good, if not more. mountain view is something I need to look into, i'm pretty sure it's because we use different names, like Bay Area 511 Mountain View and Mountain View, so the merge doesn't work, so let me know what's not joining up that you think you want!