DataMar 2023 – Apr 2023
Tracking Airplane Carbon Emission
A web app to track carbon emission of airplanes
- React
- RedwoodJS
- PySpark
- Dataproc
- Prisma
- GraphQL
- PostgreSQL
Architecture (simplified)
Data flows: Flight data to Batch jobs; Batch jobs to PostgreSQL; Population data to Emissions model; Emissions model to PostgreSQL; PostgreSQL to GraphQL API; GraphQL API to Web app.
About the project
TACE answers a simple question: how much carbon does the flight I'm about to take actually put out? Pick a route, and the app shows the emissions for it.
It was a team project at CU Boulder, and I built the full-stack side: the RedwoodJS app people use, the GraphQL API behind it, and the Prisma models over PostgreSQL. The team processed the flight and aircraft data with PySpark batch jobs on Dataproc, and a small model estimates the emissions a new airport would add based on the population around it. My job was turning all of that into something you can click through and understand.