Which ghats need attention before Durga visarjan?

Seven Bhopal immersion ghats ranked by past dissolved-oxygen readings against the CPCB bathing standard. Every rank links to the readings behind it. Missing readings are shown as missing, never as passing.

What this view covers

Backend output· load.py, criteria.py

Data: MPPCB visarjan reports 2023–2025 · Ganesh and Durga · before, during and one week after immersion
Ghats: 7 Bhopal ghats
Standard: CPCB Class B (outdoor bathing): Dissolved oxygen (DO) 5 mg/l or more · BOD 3 mg/l or less · pH 6.5 to 8.5Dissolved oxygen (DO), CPCB Class D: 4 mg/l or more (used only as a severity line)
Not assessable: Total coliform (Class B: 500 MPN/100 ml or less) is not in the data, so no ghat can be shown as meeting Class B in full.
Page references: From the data file; only a partial manual spot check against the PDFs

Ghat ranking

Rank order by the PRD v2 §6.4 rules: tier, then share of DO readings below 5, then below 4, then BOD. Sorting a column changes display order only; the # column keeps the tool's rank.

Backend output· ranking.py

Showing 7 of 7 ghats

								Readings available	Flags
1	Bairagarh (Sant Hirdaram) kund Upper Lake	Tier 1High risk	11/13Dissolved oxygen was below 5 mg/l in 11 of 13 readings.	6	0	13/13BOD above 3: 13 of 13	0/13pH outside 6.5–8.5: 0 of 13	DO13/18DO: 13 numeric of 18 expected; 5 missing (not sampled or no table in report)BOD13/18BOD: 13 numeric of 18 expected; 5 missing (not sampled or no table in report)pH13/18pH: 13 numeric of 18 expected; 5 missing (not sampled or no table in report)	DO below 4DO 0DO often below 5BOD often above 3Data gap
2	Malikhedi kund Kund	Tier 1High risk	9/13Dissolved oxygen was below 5 mg/l in 9 of 13 readings.	3	0.6	11/13BOD above 3: 11 of 13	0/13pH outside 6.5–8.5: 0 of 13	DO13/18DO: 13 numeric of 18 expected; 5 missing (not sampled or no table in report)BOD13/18BOD: 13 numeric of 18 expected; 5 missing (not sampled or no table in report)pH13/18pH: 13 numeric of 18 expected; 5 missing (not sampled or no table in report)	DO below 4DO often below 5BOD often above 3Data gap
3	Khatlapura ghat Lower Lake	Tier 2	8/18Dissolved oxygen was below 5 mg/l in 8 of 18 readings.	0	4	15/17BOD above 3: 15 of 17	1/18pH outside 6.5–8.5: 1 of 18	DO18/18DO: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)BOD17/18BOD: 17 numeric of 18 expected; 1 missing (not sampled or no table in report)pH18/18pH: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)	BOD often above 3pH outside rangeData gap
4	Rani Kamlapati ghat / Kamla Park kund Lower Lake (as printed in Durga tables) Site identity uncertain	Tier 2High risk	6/18Dissolved oxygen was below 5 mg/l in 6 of 18 readings.	4	2.4	18/18BOD above 3: 18 of 18	0/18pH outside 6.5–8.5: 0 of 18	DO18/18DO: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)BOD18/18BOD: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)pH18/18pH: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)	DO below 4BOD often above 3Identity uncertain
5	Shahpura lake ghat Shahpura Lake	Tier 2High risk	5/18Dissolved oxygen was below 5 mg/l in 5 of 18 readings.	3	2.5	18/18BOD above 3: 18 of 18	0/18pH outside 6.5–8.5: 0 of 18	DO18/18DO: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)BOD18/18BOD: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)pH18/18pH: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)	DO below 4BOD often above 3
6	Prempura ghat Upper Lake	Tier 2High risk	3/18Dissolved oxygen was below 5 mg/l in 3 of 18 readings.	1	3.9	9/15BOD above 3: 9 of 15	2/17pH outside 6.5–8.5: 2 of 17	DO18/18DO: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)BOD15/18BOD: 15 numeric of 18 expected; 3 missing (not sampled or no table in report)pH17/18pH: 17 numeric of 18 expected; 1 missing (not sampled or no table in report)	DO below 4BOD often above 3pH outside rangeData gap
7	Hathaikheda dam / kund Hathaikheda dam	Tier 3	0/18Dissolved oxygen was below 5 mg/l in 0 of 18 readings.	0	5.1	16/18BOD above 3: 16 of 18	3/18pH outside 6.5–8.5: 3 of 18	DO18/18DO: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)BOD18/18BOD: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)pH18/18pH: 18 numeric of 18 expected; 0 missing (not sampled or no table in report)	BOD often above 3pH outside range

Critical dissolved-oxygen flags

Ghats with any DO reading below 4 mg/l, in rank order.

#1Bairagarh (Sant Hirdaram) kundTier 1
Dissolved oxygen fell below 4 mg/l in 6 of 13 readings (lowest 0 mg/l). Dissolved oxygen was below 5 mg/l in 11 of 13 readings.
- Backend output2023 report, p.26· matched in partial PDF spot check2023 report, p.60· matched in partial PDF spot check2024 report, p.25· page not yet checked2025 report, p.28· matched in partial PDF spot check
- Dissolved oxygen read 0 mg/l 4 times (2023 Ganesh after, p.26; 2023 Durga pre, p.60; 2023 Durga during, p.60; 2025 Ganesh during, p.28).
  Backend output2023 report, p.26· matched in partial PDF spot check2023 report, p.60· matched in partial PDF spot check2025 report, p.28· matched in partial PDF spot check
#2Malikhedi kundTier 1
Dissolved oxygen fell below 4 mg/l in 3 of 13 readings (lowest 0.6 mg/l). Dissolved oxygen was below 5 mg/l in 9 of 13 readings.
- Backend output2023 report, p.27· page not yet checked2024 report, p.71· page not yet checked2025 report, p.29· matched in partial PDF spot check
#4Rani Kamlapati ghat / Kamla Park kundTier 2
Dissolved oxygen fell below 4 mg/l in 4 of 18 readings (lowest 2.4 mg/l).
- Backend output2024 report, p.70· page not yet checked2025 report, p.64· matched in partial PDF spot check
#5Shahpura lake ghatTier 2
Dissolved oxygen fell below 4 mg/l in 3 of 18 readings (lowest 2.5 mg/l).
- Backend output2024 report, p.26· page not yet checked2025 report, p.65· page not yet checked
#6Prempura ghatTier 2
Dissolved oxygen fell below 4 mg/l in 1 of 18 readings (lowest 3.9 mg/l).
- Backend output2024 report, p.70· matched in partial PDF spot check

Data gaps and site identity

Missing readings and uncertain site names. A gap never lowers a ghat's tier.

Expected grid

Backend output· load.py

1,638 expected cells (7 ghats × 6 seasons × 3 phases × 13 parameters); 1,524 rows in the file; 114 cells have no row at all.

114 expected cells have no table in the reports: no Durga 2025 table for Bairagarh (Sant Hirdaram) kund; no Durga 2025 table for Malikhedi kund; no suspended solids rows in Durga 2023 (7 ghats); no suspended solids rows in Durga 2025 (5 ghats). These cells are missing, not passing.

#1Bairagarh (Sant Hirdaram) kundData gap
- No reading for Dissolved oxygen, BOD, pH in 2025 Ganesh (pre, after); Dissolved oxygen, BOD, pH in 2025 Durga (pre, during, after). Missing data is not counted as passing.
  Backend output2025 report, p.28· page not yet checked
#2Malikhedi kundData gap
- No reading for Dissolved oxygen, BOD, pH in 2025 Ganesh (pre, after); Dissolved oxygen, BOD, pH in 2025 Durga (pre, during, after). Missing data is not counted as passing.
  Backend output2025 report, p.29· page not yet checked
#3Khatlapura ghatData gap
- No reading for BOD in 2023 Durga (during). Missing data is not counted as passing.
  Backend output2023 report, p.59· page not yet checked
#4Rani Kamlapati ghat / Kamla Park kundIdentity uncertain
- Report tables may describe two different places under this name.
  Backend output
#6Prempura ghatData gap
- No reading for BOD in 2023 Durga (pre, after); BOD, pH in 2023 Durga (during). Missing data is not counted as passing.
  Backend output2023 report, p.60· page not yet checked

Historical findings, 2023–2025

Counts are over numeric readings only. Missing readings are not counted as passing.

Dissolved oxygen below 5 mg/l (Class B)
Backend output· criteria.py
42 of 116
numeric DO readings, all 7 ghats
Dissolved oxygen below 4 mg/l (Class D line)
Backend output· criteria.py
17 of 116
numeric DO readings
Dissolved oxygen read 0 mg/l
Backend output· ranking.py
4
readings, all at Bairagarh (Sant Hirdaram) kund
2023 report, p.26· matched in partial PDF spot check2023 report, p.60· matched in partial PDF spot check2025 report, p.28· matched in partial PDF spot check
BOD above 3 mg/l (Class B)
Backend output· criteria.py
100 of 112
numeric BOD readings, all 7 ghats
pH outside 6.5–8.5 (Class B)
Backend output· criteria.py
6 of 115
numeric pH readings
Durga readings only: DO below 5 / BOD above 3
Backend output· criteria.py
25 of 57
DO readings below 5; BOD was above 3 in 50 of 53 Durga readings
Ghats flagged high risk
Backend output· ranking.py
5 of 7
high risk = any DO below 4, or DO below 5 in more than half of readings
BOD already above 3 before immersion
Backend output· criteria.py
32 of 37
pre-immersion readings. BOD was already above the limit in most readings taken before immersion, so these readings cannot show what immersion itself changed.

How to read this page

Tiers (PRD v2 §6.4)

Tier 1DO below 5 in more than half of readings
Tier 2Some DO readings below 5
Tier 3DO met in every reading taken; BOD or pH outside limits
Tier 4No reading outside limits among those taken. This is not a clearance.

Flags (PRD v2 §6.3)

DO below 4Any dissolved-oxygen reading below 4 mg/l (Class D line).
DO 0Dissolved oxygen read 0 mg/l.
DO often below 5Dissolved oxygen below 5 mg/l in more than half of readings.
BOD often above 3BOD above 3 mg/l in more than half of readings.
pH outside rangeAny pH reading outside 6.5–8.5.
Data gapAt least one DO, BOD or pH reading is missing. Missing is not treated as passing.
Identity uncertainReport tables may describe two different places under this name.

Where each figure comes from

Backend outputComputed by the Visarjan Ghat Watch Python backend from the supplied track CSV and CPCB criteria file; covered by its test suite.
PRD v2 ruleA rule or plan-window description from the team's PRD v2 (text, not data).
Not assignedIntentionally empty until an officer fills it in.