Leo Miranda

lmiranda closed issue personal-projects/personal-portfolio#57

2026-01-16 16:03:26 +00:00

Create neighbourhood and census loaders

lmiranda commented on issue personal-projects/personal-portfolio#57

2026-01-16 16:03:20 +00:00

Create neighbourhood and census loaders

Implementation complete:

Created loaders/census.py with load_census_data() function
Uses upsert by (neighbourhood_id, census_year) key
Import test passed

Note: Neighbourhood loader…

lmiranda commented on issue personal-projects/personal-portfolio#57

2026-01-16 16:01:18 +00:00

Create neighbourhood and census loaders

Starting implementation of neighbourhood and census loaders.

lmiranda closed issue personal-projects/personal-portfolio#55

2026-01-16 16:01:00 +00:00

Create Toronto Police crime data parser

lmiranda commented on issue personal-projects/personal-portfolio#55

2026-01-16 16:00:57 +00:00

Create Toronto Police crime data parser

Implementation complete:

Created parsers/toronto_police.py with TorontoPoliceParser
Methods: get_crime_rates(), get_major_crime_indicators()
Hood_ID to neighbourhood_id mapping…

lmiranda closed issue personal-projects/personal-portfolio#54

2026-01-16 16:00:55 +00:00

Create Toronto Open Data CKAN parser

lmiranda commented on issue personal-projects/personal-portfolio#54

2026-01-16 16:00:53 +00:00

Create Toronto Open Data CKAN parser

Implementation complete:

Created parsers/toronto_open_data.py with TorontoOpenDataParser
Methods: get_neighbourhoods(), get_census_profiles(), get_parks(), get_schools(),…

lmiranda commented on issue personal-projects/personal-portfolio#55

2026-01-16 16:00:03 +00:00

Create Toronto Police crime data parser

Starting implementation of TorontoPoliceParser for crime data via CKAN API.

lmiranda commented on issue personal-projects/personal-portfolio#54

2026-01-16 15:58:50 +00:00

Create Toronto Open Data CKAN parser

Starting implementation of TorontoOpenDataParser for CKAN API.

lmiranda closed issue personal-projects/personal-portfolio#56

2026-01-16 15:57:59 +00:00

Add new fact and bridge SQLAlchemy models

lmiranda commented on issue personal-projects/personal-portfolio#56

2026-01-16 15:57:57 +00:00

Add new fact and bridge SQLAlchemy models

Implementation complete:

Added BridgeCMHCNeighbourhood - CMHC zone to neighbourhood mapping with weights
Added FactCensus - Census statistics by neighbourhood/year
Added FactCrime -…

lmiranda commented on issue personal-projects/personal-portfolio#56

2026-01-16 15:56:48 +00:00

Add new fact and bridge SQLAlchemy models

Starting implementation of SQLAlchemy models for FactCensus, FactCrime, FactAmenities, and BridgeCMHCNeighbourhood.

lmiranda closed issue personal-projects/personal-portfolio#53

2026-01-16 15:56:35 +00:00

Create neighbourhood and amenities Pydantic schemas

lmiranda commented on issue personal-projects/personal-portfolio#53

2026-01-16 15:56:33 +00:00

Create neighbourhood and amenities Pydantic schemas

Implementation complete:

Created schemas/neighbourhood.py with NeighbourhoodRecord, CensusRecord, CrimeRecord, CrimeType
Created schemas/amenities.py with AmenityType, `AmenityRec…

lmiranda commented on issue personal-projects/personal-portfolio#53

2026-01-16 15:54:58 +00:00

Create neighbourhood and amenities Pydantic schemas

Starting implementation of Pydantic schemas for neighbourhood, census, crime, and amenities data.

lmiranda opened issue personal-projects/personal-portfolio#59

2026-01-16 15:49:56 +00:00

Create CMHC-neighbourhood crosswalk loader

lmiranda opened issue personal-projects/personal-portfolio#58

2026-01-16 15:49:54 +00:00

Create crime and amenities loaders

lmiranda opened issue personal-projects/personal-portfolio#57

2026-01-16 15:49:51 +00:00

Create neighbourhood and census loaders

lmiranda opened issue personal-projects/personal-portfolio#56

2026-01-16 15:49:48 +00:00

Add new fact and bridge SQLAlchemy models

lmiranda opened issue personal-projects/personal-portfolio#55

2026-01-16 15:49:46 +00:00

Create Toronto Police crime data parser