Exploring UI ideas for ETL processes. Can we make complex data transformations as easy to build+troubleshoot as spreadshets? What if we had tools to quickly diagnose+fix common issues in data pipelines? I built an interactive mockup that parses JS formulas as they’re edited.
This started out small, as a tiny C# and WPF urban planning tool to help me visualize the impact of setback and lot size requirements on individual properties. Eventually I rewrote it as a web app using the HTML5 Canvas element, and after that I realized that I might as well scale it to entire neighbourhoods…
Abundant Housing Vancouver Letter System
This has two parts:
- An Angular front-end that generates personalized letters in support of housing projects
- A Serverless Framework back-end that uses various AWS pieces (Lambda, SES, S3, Athena) to review+approve+send+analyze emails
I built an interactive map of every property in Vancouver using Mapbox, Eric Fischer’s remarkable Tippecanoe, and a Heroku app to serve the map tiles.
Be warned, there is a bug in Tippecanoe that makes the map look a little wonky at certain zoom levels.
Vancouver Rezoning Scraper (GitHub)
This little thing scrapes the City of Vancouver’s rezoning application page then notifies of any changes via Slack.
It’s an .NET Core Azure Function written in C# using Azure Table+Blob storage.