// 01
Geo Data Engineering
$81.6M UNMET DEMAND
NYC Taxi Supply-Demand Gap Analysis
Seven-component GCP pipeline over 35M+ validated trips and 185 zones; PostGIS spatial validation showed that dispatch, not road access, was the bottleneck behind $81.6M in unmet demand.
// IMPACT
- trips
- 35M+
- zones
- 185
- ADRs
- 56

- GCS
- Dataproc
- PySpark
- BigQuery
- dbt
- PostGIS
- H3
- Kestra
- Terraform
- Streamlit
