# tobeyfung/780-transit architecture

> Architecture diagram of the GitHub repository tobeyfung/780-transit, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-22). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/tobeyfung/780-transit
- Repository: https://github.com/tobeyfung/780-transit

## Overview

This repository is a city-level transportation convenience analysis, not a reusable software service. Its main workflow combines population, transit funding, ridership, and walkability data into a city-year panel, calculates an equally weighted 0–100 score, and compares cities by size, growth, components, and region. The notebook is the analysis runtime; the README documents the findings and intended uses. Relationships below follow the README because no source excerpts were provided, so implementation details beyond that documentation are omitted.

Main entry points: [`A03-Transportation-Convenience-Across-US cities.ipynb`](https://github.com/tobeyfung/780-transit/blob/main/A03-Transportation-Convenience-Across-US%20cities.ipynb) (Clean and join data), [`data/population_2020.xlsx`](https://github.com/tobeyfung/780-transit/blob/main/data/population_2020.xlsx) (Population estimates), [`data/2024 TS1.1 Total Funding Time Series.xlsx`](https://github.com/tobeyfung/780-transit/blob/main/data/2024%20TS1.1%20Total%20Funding%20Time%20Series.xlsx) (Transit funding), [`data/ridership.xlsx`](https://github.com/tobeyfung/780-transit/blob/main/data/ridership.xlsx) (Transit ridership)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_inputs["Data inputs"]
  node_population["Population estimates"]
  node_funding["Transit funding"]
  node_ridership["Transit ridership<br/>[ridership.xlsx]"]
  node_walkability["Walkability index"]
  node_boundaries["Geographic sources"]
end

subgraph group_analysis["Analysis workflow"]
  node_panel["Clean and join data"]
  node_score["Convenience score"]
  node_comparisons["City comparisons"]
end

subgraph group_findings["Results and use"]
  node_findings["Findings and charts"]
end

node_readers(("Movers and analysts"))

node_panel -->|"joins population"| node_population
node_panel -->|"joins funding"| node_funding
node_panel -->|"joins ridership"| node_ridership
node_panel -->|"joins walkability"| node_walkability
node_panel -->|"spatially joins"| node_boundaries
node_panel -->|"produces panel for"| node_score
node_score -->|"scores cities for"| node_comparisons
node_comparisons -->|"summarizes results"| node_findings
node_findings -->|"informs decisions"| node_readers

click node_population "https://github.com/tobeyfung/780-transit/blob/main/data/population_2020.xlsx"
click node_funding "https://github.com/tobeyfung/780-transit/blob/main/data/2024%20TS1.1%20Total%20Funding%20Time%20Series.xlsx"
click node_ridership "https://github.com/tobeyfung/780-transit/blob/main/data/ridership.xlsx"
click node_walkability "https://github.com/tobeyfung/780-transit/blob/main/data/2017_2023_walkability_index.csv.zip"
click node_panel "https://github.com/tobeyfung/780-transit/blob/main/A03-Transportation-Convenience-Across-US%20cities.ipynb"
click node_score "https://github.com/tobeyfung/780-transit/blob/main/A03-Transportation-Convenience-Across-US%20cities.ipynb"
click node_comparisons "https://github.com/tobeyfung/780-transit/blob/main/A03-Transportation-Convenience-Across-US%20cities.ipynb"
click node_findings "https://github.com/tobeyfung/780-transit/blob/main/A03-Transportation-Convenience-Across-US%20cities.ipynb"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_population,node_funding,node_ridership,node_walkability,node_boundaries toneBlue
class node_panel,node_score,node_comparisons toneAmber
class node_findings toneMint
class node_readers toneIndigo
```

## Components

### Data inputs

- [Population estimates](https://github.com/tobeyfung/780-transit/blob/main/data/population_2020.xlsx): `data/population_2020.xlsx`
- [Transit funding](https://github.com/tobeyfung/780-transit/blob/main/data/2024%20TS1.1%20Total%20Funding%20Time%20Series.xlsx): `data/2024 TS1.1 Total Funding Time Series.xlsx`
- [Transit ridership](https://github.com/tobeyfung/780-transit/blob/main/data/ridership.xlsx): `data/ridership.xlsx`
- [Walkability index](https://github.com/tobeyfung/780-transit/blob/main/data/2017_2023_walkability_index.csv.zip): `data/2017_2023_walkability_index.csv.zip`
- **Geographic sources**

### Analysis workflow

- [Clean and join data](https://github.com/tobeyfung/780-transit/blob/main/A03-Transportation-Convenience-Across-US%20cities.ipynb): `A03-Transportation-Convenience-Across-US cities.ipynb`
- [Convenience score](https://github.com/tobeyfung/780-transit/blob/main/A03-Transportation-Convenience-Across-US%20cities.ipynb): `A03-Transportation-Convenience-Across-US cities.ipynb`
- [City comparisons](https://github.com/tobeyfung/780-transit/blob/main/A03-Transportation-Convenience-Across-US%20cities.ipynb): `A03-Transportation-Convenience-Across-US cities.ipynb`

### Results and use

- [Findings and charts](https://github.com/tobeyfung/780-transit/blob/main/A03-Transportation-Convenience-Across-US%20cities.ipynb): `A03-Transportation-Convenience-Across-US cities.ipynb`

### Other components

- **Movers and analysts**

## Connections

- Clean and join data → Population estimates: joins population (evidence: `README.md`)
- Clean and join data → Transit funding: joins funding (evidence: `README.md`)
- Clean and join data → Transit ridership: joins ridership (evidence: `README.md`)
- Clean and join data → Walkability index: joins walkability (evidence: `README.md`)
- Clean and join data → Geographic sources: spatially joins (evidence: `README.md`)
- Clean and join data → Convenience score: produces panel for (evidence: `README.md`)
- Convenience score → City comparisons: scores cities for (evidence: `README.md`)
- City comparisons → Findings and charts: summarizes results (evidence: `README.md`)
- Findings and charts → Movers and analysts: informs decisions (evidence: `README.md`)
