ApartmentIssues.com
Problem: NYC renters can't understand building history from scattered city datasets.
Solution: One URL shows 311, DOB, HPD complaints, trends, and patterns. Turns open data into a decision tool for renters.
- ▹ETL pipeline processing millions of records
- ▹SQLite with index optimization for millisecond queries
- ▹Address → BBL mapping with caching
- ▹Clean React UX with grouped complaints