Research Request - Agency-Grain Census Data Summary Table

[KatrinaMKaiser]

Research Question

Single sentence description: How can we characterize the "service population" of a transit agency?

Detailed description: @indexing is looking for an agency-level table counting and describing populations served by Cal-ITP-client agencies.

How will this research be used?

This will be used to create talking points for communicating the success or potential success of Cal-ITP services (Benefits, open-loop). For example, a regression analysis of benefits enrollment on population/agency characteristics and benefits enrollment for existing agencies could be used to identify the predicted enrollment for additional agencies.

A less-summarized version of this table (stop-level) could be used for #1128 and the agency-level table could be used for #1542 as well. This research could inform a future warehouse table.

Stakeholders & End-Users

@indexing is asking the question, along with other Compiler staff. The most obvious audience is legislators/the GO, but this table has other use cases as identified above.

Metrics

• County-level metrics
  • total population
  • total veteran population
  • total senior population
  • total low-income population
• Area-around-a-stop-level metrics
  • same as above, using census tracts intersecting a 1/4 mi buffer around a stop for now

Data sources

• Cal-ITP data sources: organizations

• External data sources:

  • https://docs.google.com/spreadsheets/d/15NV66cnCuS_hYZavNSlv2ZIDhWGGZPMAg-Q81zIKOVU/edit?gid=1557638523#gid=1557638523

• Remaining data source questions:
  What does "low income" mean? For the purpose of Benefits, it means people enrolled in SNAP/CalFresh. This data needs to come from elsewhere and will be addressed in a future issue.

Deliverables

• stop-level table
• agency-level table
• Metabase summary for easy access by Cal-ITP staff
  • later we'll add more variables to this from NTD

Timeline of deliverables

Not urgent but of interest