# foyin/exploring-the-link-between-walkability-and-crime-etl-project architecture

> Architecture diagram of the GitHub repository foyin/exploring-the-link-between-walkability-and-crime-etl-project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-02). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project
- Repository: https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project

## Overview

This repository documents a Toronto 2022 crime-and-walkability analysis, not an executable application: it contains CSV datasets, charts, and a README describing the workflow. The documented path runs from public crime records through walk-score calculation and AWS cleaning/storage/querying to QuickSight visualizations and statistical findings. The tree has no implementation source excerpts, so the score-calculation and AWS stages are documented components with no asserted code paths; edges reflect README statements only.

Main entry points: [`Charts`](https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/tree/main/Charts) (Analysis charts), [`crime_data_with_walkscores_resumed_49501.csv`](https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/blob/main/crime_data_with_walkscores_resumed_49501.csv) (Toronto crime records), [`crime_data_with_walkscores_resumed_2022_49501_cleaned_42000_records.csv`](https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/blob/main/crime_data_with_walkscores_resumed_2022_49501_cleaned_42000_records.csv) (Processed crime data), [`README.md`](https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/blob/main/README.md) (Statistical findings)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_inputs["Data inputs"]
  node_toronto_data["Toronto crime records"]
end

subgraph group_pipeline["Data pipeline"]
  node_walkscore["Walk-score calculation"]
  node_cleaning["AWS Glue cleaning"]
  node_processed_data["Processed crime data"]
  node_s3[("AWS S3 storage")]
  node_athena["AWS Athena queries"]
end

subgraph group_analysis["Analysis outputs"]
  node_quicksight["QuickSight visualizations"]
  node_charts["Analysis charts"]
  node_findings["Statistical findings<br/>[README.md]"]
end

node_toronto_data -->|"scores locations"| node_walkscore
node_walkscore -->|"provides scored data"| node_cleaning
node_cleaning -->|"cleans and structures"| node_processed_data
node_cleaning -->|"stores results"| node_s3
node_s3 -->|"queries data"| node_athena
node_athena -->|"visualizes findings"| node_quicksight
node_quicksight -->|"produces charts"| node_charts
node_charts -->|"illustrates results"| node_findings

click node_toronto_data "https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/blob/main/crime_data_with_walkscores_resumed_49501.csv"
click node_processed_data "https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/blob/main/crime_data_with_walkscores_resumed_2022_49501_cleaned_42000_records.csv"
click node_charts "https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/tree/main/Charts"
click node_findings "https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/blob/main/README.md"

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_toronto_data toneBlue
class node_walkscore,node_cleaning,node_processed_data,node_s3,node_athena toneAmber
class node_quicksight,node_charts,node_findings toneMint
```

## Components

### Data inputs

- [Toronto crime records](https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/blob/main/crime_data_with_walkscores_resumed_49501.csv): `crime_data_with_walkscores_resumed_49501.csv`

### Data pipeline

- **Walk-score calculation**
- **AWS Glue cleaning**
- [Processed crime data](https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/blob/main/crime_data_with_walkscores_resumed_2022_49501_cleaned_42000_records.csv): `crime_data_with_walkscores_resumed_2022_49501_cleaned_42000_records.csv`
- **AWS S3 storage**
- **AWS Athena queries**

### Analysis outputs

- **QuickSight visualizations**
- [Analysis charts](https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/tree/main/Charts): `Charts`
- [Statistical findings](https://github.com/foyin/exploring-the-link-between-walkability-and-crime-etl-project/blob/main/README.md): `README.md`

## Connections

- Toronto crime records → Walk-score calculation: scores locations (evidence: `README.md`)
- Walk-score calculation → AWS Glue cleaning: provides scored data (evidence: `README.md`)
- AWS Glue cleaning → Processed crime data: cleans and structures (evidence: `README.md`)
- AWS Glue cleaning → AWS S3 storage: stores results (evidence: `README.md`)
- AWS S3 storage → AWS Athena queries: queries data (evidence: `README.md`)
- AWS Athena queries → QuickSight visualizations: visualizes findings (evidence: `README.md`)
- QuickSight visualizations → Analysis charts: produces charts (evidence: `README.md`)
- Analysis charts → Statistical findings: illustrates results (evidence: `README.md`)
