A full-stack geospatial platform that finds location and scheduling overlaps across infrastructure projects from three utility providers.
What it achieved
- Analyzed 272 projects from public filings
- Flagged 61 potential overlaps within 25 miles
- Matched all 6 organizer-confirmed overlaps
How I built it
- Data-processing pipeline in Python to parse and normalize public utility filings
- PostgreSQL location-based queries to compare projects by distance and schedule
- Interactive map of projects and overlapping construction schedules with Leaflet and Next.js