Research Request - RT trip diagnostics: thresholds for usable trips

[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: Exploratory work to find which RT trips have enough usable vehicle positions.

• Time coverage: total minutes of RT data available per trip
• Geographic coverage: its vehicle positions are attached to x% of segments for that route
• Epic - Daskify RT segment speeds #592
• Build on work in Research Request - Trip-level diagnostics #595 / Segment speeds, fix sjoin, add trip diagnostics #600

Detailed description:

(1) For each operator, what's the % of RT trip_ids that would remain after those thresholds are used? Make a chart function that takes a single operator. Produce charts for all operators. Is the time or geographic coverage that's driving this excluding of trips? What is the distribution by route? What is a recommended threshold to use?
(2) Using GTFS schedule data, by route_id-shape_id, calculate how many the route_length of each shape_id as a proportion of the longest shape_id. For short trips, do they tend to be 50% of the longest route length? 40% 30%? What is the distribution? Have this handy to inform question 1.

How will this research be used?

Stakeholders & End-Users

Metrics

Data sources

• Cal-ITP data sources: GCS
  analysis_date = '2023-01-18' --> shared_utils.rt_dates["jan2023"]

• rt_segment_speeds/longest_shape_segment_{analysis_date}.parquet

• rt_segment_speeds/segments_route_direction_crosswalk_{analysis_date}.parquet

• rt_delay/compiled_cached_views/routelines_{analysis_date}.parquet or rt_delay/compiled_cached_views/trips_{analysis_date}.parquet

• rt_segment_speeds/trip_diagnostics_{analysis_date}.parquet

• External data sources:

• Remaining data source questions:

Deliverables:

Notebook(s) with charts/tables to support recommendations

Timeline of deliverables: