NYC Water Project Health Dashboard
Narrowed a 56,525-record public dataset into 37 records worth closer review.
2026
Why I built this
I wanted to see if a large city dataset could be narrowed down to the projects that might deserve a closer look. Water infrastructure felt meaningful because it affects something people depend on every day.
Tools I used
Python · Pandas · Next.js · React · TypeScript
What I did
- Narrowed 56,525 city records to 211 water projects by keeping the latest reporting period (May 2026), projects in active phases such as design or construction, and projects managed by the NYC Department of Environmental Protection (DEP), the agency relevant to this review.
- Flagged 37 of those projects for review when the Current Phase Start date was missing, the Forecast Completion date was before May 1, 2026, or both.
- Checked repeated project IDs so I would not accidentally count the same project twice.
What this shows
I can turn thousands of records into a smaller, focused list that makes possible problems easier to find.
56,525 records → 37 flagged for review
The numbers
56,525
All city records
5,801
Latest report
May 2026
3,162
In a standard phase
Pre-Design to Close-out
211
Managed by DEP
NYC Department of Environmental Protection
37
Worth reviewing
Dates missing or passed
Review signals
A project is flagged when its Current Phase Start date is missing, its Forecast Completion date is before May 1, 2026, or both.
29
no start date
22
passed finish date
14
both
- 15 no start date only
- 14 both
- 8 passed finish date only
The two signals overlap. 14 projects have both, so the groups don’t simply add up: 29 + 22 − 14 = 37 projects.
Explore project health by borough
Choose a view, then select a borough.
View
Click a borough here or in the list. Shading compares boroughs within the selected view.
Borough
Other project scope
“Citywide” means the source lists the project as citywide rather than assigning it to one borough.
Result
Total
211 projects · 37 worth reviewing
137 in the five boroughs + 73 Citywide + 1 with no borough listed = 211 projects.
Counts use the borough listed for each project. The data has no project locations, so none are plotted.
Examples flagged
- Conversion of Kensico Lab to EOH Operations HQ — finish date had passed
- City Water Tunnel 3 — Stage 2 connection — no start date listed
- Delaware–Rondout Aqueduct — Parallel Tunnel — both issues
9 funding IDs repeat, so I didn’t sum budgets into one total.
What I learned
I learned how to reduce a very large project dataset into a focused review list by filtering for current DEP projects and using schedule issues to identify the 37 projects that needed closer attention.
What I will do next
I will turn this into a live monitoring tool that updates automatically and shows which projects may need another look as new information comes in.