How foyin/exploring-the-link-between-walkability-and-crime-etl-project works
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 Analysis charts · crime_data_with_walkscores_resumed_49501.csv Toronto crime records · crime_data_with_walkscores_resumed_2022_49501_cleaned_42000_records.csv Processed crime data · README.md Statistical findings
Components 9
Data inputs
- Toronto crime records
crime_data_with_walkscores_resumed_49501.csv
Data pipeline
- Walk-score calculation
- AWS Glue cleaning
- Processed crime data
crime_data_with_walkscores_resumed_2022_49501_cleaned_42000_records.csv - AWS S3 storage
- AWS Athena queries
Analysis outputs
- QuickSight visualizations
- Analysis charts
Charts - Statistical findings
README.md
Connections 8
- Toronto crime records → Walk-score calculation: scores locations
README.md - Walk-score calculation → AWS Glue cleaning: provides scored data
README.md - AWS Glue cleaning → Processed crime data: cleans and structures
README.md - AWS Glue cleaning → AWS S3 storage: stores results
README.md - AWS S3 storage → AWS Athena queries: queries data
README.md - AWS Athena queries → QuickSight visualizations: visualizes findings
README.md - QuickSight visualizations → Analysis charts: produces charts
README.md - Analysis charts → Statistical findings: illustrates results
README.md