Context

Public health agencies in Maine needed a way to put community-level health estimates directly in front of the people making resource-allocation decisions — without funneling every question through an analyst. County-level dashboards existed; sub-county, subpopulation-aware tooling did not.

Challenge

Build a production platform that lets non-technical partners at MaineHealth and Portland Public Health explore Apriqot's estimates interactively — choosing datasets, geographic levels (census tract, township, ZIP), and subpopulation filters — then save, view, and export the resulting maps. The system had to handle authenticated multi-user state, render statewide choropleths fluidly, and stay legible under real partner workflows, not demo conditions.

Approach

Built the frontend in Next.js (App Router) with TypeScript, Tailwind, and shadcn/ui, with Leaflet driving the interactive map layer over OpenStreetMap tiles. Designed and implemented the data selection UI — dataset, geography, and subpopulation pickers — plus the saved-map persistence flow and tabular export. On the backend, wired authentication through Auth.js and modeled per-account map state in Postgres. Wrote unit and end-to-end test coverage in Jest across the estimate-retrieval and saved-map flows to keep the partner-facing surface stable across iterations.

Outcome

WHAM! is in active use by partner organizations in Maine, including MaineHealth and Portland Public Health, where it backs decisions on mobile food pantry placement and subpopulation-targeted outreach. The platform now serves as the delivery surface for Apriqot's full estimate catalog — extending past food insecurity into other community-health domains.