personal-projects/personal-portfolio
Template
1
1
Fork 0
Code Issues 3 Pull Requests Actions Packages Projects 1 Releases Wiki Activity

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

New Issue
Closed
opened 2026-01-17 16:55:40 +00:00 by lmiranda · 0 comments
lmiranda commented 2026-01-17 16:55:40 +00:00
Owner
Copy Link

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.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Complexity/Complex
High uncertainty or many dependencies
 Complexity/Medium
Some unknowns or dependencies
 Complexity/Simple
Straightforward, well-understood
 Effort/L
3-5 days
 Effort/M
1-2 days
 Effort/S
2-4 hours
 Effort/XL
> 1 week
 Effort/XS
< 2 hours
 Priority/Critical
Immediate attention required
 Priority/High
Important, needs attention soon
 Priority/Low
Nice to have, can wait
 Priority/Medium
Normal priority
 Type/Bug
Something isn't working
 Type/Chore
Maintenance tasks
 Type/Documentation
Documentation improvements
 Type/Feature
New feature or request
 Type/Refactor
Code refactoring without changing behavior
 Type/Test
Testing related
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
lmiranda
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: personal-projects/personal-portfolio#74
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?