GTFS Guidelines: Presence of wheelchair data for stops and trips

[evansiroky]

Question

What percent of wheelchair_* fields for each row in stops.txt and trips.txt are set to a "not unknown" value?

See also: cal-itp/data-analyses#165

Metrics

• Percent of rows in the stops table that have a "not unknown" value (not empty and not set to 0) defined for the wheelchair_boarding field
• Percent of rows in the trips table that have a "not unknown" value (not empty and not set to 0) defined for the wheelchair_accessible field

Data sources

• stops table
• trips table

(Data Servicess Team to Copy and Fill Out Below)

The QuVR MD template below will be filled out by a member of the data services team. This allows us to describe the request, in a way that is easy to hand-off for analysis. After the research phase, we will sync with the asker to figure out if the metric and dashboard pieces are needed.

Before starting research:

• Question: Question written as a single sentence.
• View: E.g. views.gtfs_schedule_fact_daily_feed_files.
• Research:
  • How should the results be presented?
  • When are they needed by?

After reviewing research with the asker:

• Metric: what specific calculations are needed?
• Dashboard: where should we put the result?

[evansiroky]

The latest assessment instructions say to check the GTFS Guidelines dashboard on metabase, so closing as complete for this iteration.