Phase 6: Safety Tab Notebooks (3 notebooks) #74

Closed
opened 2026-01-17 16:55:40 +00:00 by lmiranda · 0 comments
Owner

Overview

Create Jupyter notebooks documenting the Safety tab visualizations.

Notebooks to Create

Notebook Visualization Figure Factory
notebooks/safety/crime_rate_choropleth.ipynb Crime rate per 100K map choropleth.py
notebooks/safety/crime_breakdown_bar.ipynb Crime by type stacked bar New or existing
notebooks/safety/crime_trend_line.ipynb 5-year crime trend line time_series.py

Acceptance Criteria

  • Each notebook follows the standard template (Data Reference + Visualization)
  • SQL queries documented with sample output
  • Transformation steps explained
  • Figure factory imports work and render correctly
  • Notebooks execute without errors

Technical Notes

Safety tab metrics from mart_neighbourhood_safety:

  • Crime rates per 100K population
  • Year-over-year change
  • Crime type breakdown (MCI categories)

Labels: Type/Feature, Priority/Medium, Complexity/Medium, Efforts/S, Component/Docs, Tech/Python

## Overview Create Jupyter notebooks documenting the Safety tab visualizations. ## Notebooks to Create | Notebook | Visualization | Figure Factory | |----------|---------------|----------------| | `notebooks/safety/crime_rate_choropleth.ipynb` | Crime rate per 100K map | `choropleth.py` | | `notebooks/safety/crime_breakdown_bar.ipynb` | Crime by type stacked bar | New or existing | | `notebooks/safety/crime_trend_line.ipynb` | 5-year crime trend line | `time_series.py` | ## Acceptance Criteria - [ ] Each notebook follows the standard template (Data Reference + Visualization) - [ ] SQL queries documented with sample output - [ ] Transformation steps explained - [ ] Figure factory imports work and render correctly - [ ] Notebooks execute without errors ## Technical Notes Safety tab metrics from `mart_neighbourhood_safety`: - Crime rates per 100K population - Year-over-year change - Crime type breakdown (MCI categories) **Labels:** Type/Feature, Priority/Medium, Complexity/Medium, Efforts/S, Component/Docs, Tech/Python
Sign in to join this conversation.