I wanted to explore UI ideas for ETL processes. Can we make complex data transformations as easy to build+troubleshoot as spreadsheets? What if we had tools to quickly diagnose+fix common issues in data pipelines?
To answer those questions, I built an interactive prototype in React that parses JS formulas as they’re edited.
This Website (GitHub)
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 lower zoom levels and the free Heroku tier takes ~10s to serve map data.
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 Slack and multiple AWS services (Lambda, SES, S3, Athena) to review+approve+send+analyze emails
Vancouver Rezoning Scraper (GitHub)
Drop by GitHub to see what else I’ve been up to lately.