Catch Basin Status
Refresh Data
Pretend Today is:
Days Until Expiring:
Site Filter:
All Sites
Expiring Only
Expiring + Expired
Time Period:
Yearly
Weekly
Chart Type:
Stacked Bar
Grouped Bar
Line Chart
Area Chart
Display Metric:
Total Treatments
Unique CB Treated
Display Metric:
Active Treatments
Year Range:
Refresh Historical
Color Theme:
MMCD
IBM
Wong
Tol
Viridis
ColorBrewer
Zone Display:
P1 Only
P2 Only
P1 and P2 Separate
Combined P1+P2
Facility:
FOS Area:
Group By:
Facility
FOS
Section
All MMCD
Group By:
Facility
FOS
All MMCD
Show/Hide Help
How to Use This Dashboard
Facility:
Filter data by specific facility or view all facilities combined.
FOS:
Filter by Field Operations Supervisor area.
Zone Display:
View zones separately, combined, or filter to a single priority zone.
Group By:
View data aggregated across all MMCD or broken down by facility, FOS, or section.
Pretend Today is:
Set a custom analysis date to view historical treatment status.
Days Until Expiring:
Adjust the threshold for identifying catch basins nearing treatment expiration.
Site Filter:
Filter to show all sites, only expiring sites, or expiring plus expired sites.
Status Overview:
View summary statistics and visual charts of catch basin treatment status.
Detailed View:
Browse detailed data table with all catch basin counts and percentages.
Historical Analysis:
Analyze catch basin treatment trends over time.
Key Metrics
Total Wet Catch Basins:
Count of all catch basins currently classified as wet (status_udw='W').
Wet CB with Active Treatment:
Count of wet catch basins with current active or expiring treatment.
Treatment Coverage:
Percentage of wet catch basins that have active treatment.
Calculation: (Active Treatment Count / Total Wet CB Count) × 100
Expiring:
Catch basins with treatments nearing expiration (within specified days threshold).
Expired:
Catch basins with treatments that have passed their effective treatment period.
Never Treated:
Wet catch basins that have never received any treatment this year.
Historical Metrics Explained
Yearly - Total Treatments:
Counts every treatment applied. Since catch basins are treated multiple times per year, a single catch basin treated 3 times will contribute 3 to this count. Use this to track treatment workload.
Yearly - Unique Wet CB Treated:
Counts each catch basin only once, regardless of how many times it was treated. Use this to track coverage of the wet catch basin inventory.
Weekly - Active Treatments:
For each week, counts how many treatments were still active (not expired) on Friday of that week. Shows treatment effectiveness over time.
Status Overview
Detailed View
Historical Analysis
Summary Statistics
Catch Basin Status by Group
Catch Basin Details
Download CSV
Download filtered data as CSV file
Historical Data
Download CSV