CMWSSB Complaint Analytics

Street	Depot	Complaints	People
Mufthi Amirullah Shahib Street	DEP 114	16	1
Fakkir Sahib Street	DEP 114	13	9
Kithbath Khan Street	DEP 114	8	4
John Mohammed Street	DEP 114	7	4
Parthasarathy Naidu Street	DEP 114	6	2
Subathral Street	DEP 114	6	3
Thiruvatteeswaran Sanadhi Street	DEP 114	6	3
Mohamed Abdulla 1St Street	DEP 114	4	2
Pachaiyappan Street	DEP 114	4	2
Arumugappa Street	DEP 114	3	2
Asudeenkhan Street	DEP 114	3	3
Bangaru Street	DEP 114	3	3

🛠 Sewer Complaints (main block · house block · overflow)

CSV PDF

Street	Depot	Sewer	People
Quaide Millath Road	114	54	29
Bells Road	114	39	12
Bangaru Street	114	36	20
C.n.krishnasamy Lane	114	32	7
Lalmohamed Cross Street	114	28	11
Mayor Chitti Babu Street	114	28	9
Dowlath Khan Street	114	27	9
Fakkir Sahib Street	114	27	15
John Mohammed Street	114	26	9
Mohamed Abdulla 1St Street	114	26	8

🚰 Water Complaints (no supply · short supply · leaks)

CSV PDF

Street	Depot	Water	People
Habibullah Shahib Cross Street	114	19	4
Buchi Babu Street	114	18	6
Asudeenkhan Street	114	12	6
Azizudeen Khan Street	114	8	4
Mohamed Abdulla 1St Street	114	7	4
Bharathi Salai (Pycrafs Road)	114	6	5
Mufthi Amirullah Shahib Street	114	5	2
Quaide Millath Road	114	5	4
Akbar Sahib Street	114	4	2
Kithbath Khan Street	114	3	3

💧 Water Pollution (pollution complaints)

CSV PDF

Street	Depot	Pollut.	People
Mufthi Amirullah Shahib Street	114	16	1
Fakkir Sahib Street	114	13	9
Kithbath Khan Street	114	8	4
John Mohammed Street	114	7	4
Parthasarathy Naidu Street	114	6	2
Subathral Street	114	6	3
Thiruvatteeswaran Sanadhi Street	114	6	3
Mohamed Abdulla 1St Street	114	4	2
Pachaiyappan Street	114	4	2
Arumugappa Street	114	3	2

🔁 Recurrence — how often the same issue comes back (same category · same street)

PDF

Category	Street	Depot	Times	Span (days)	Avg gap (days)	Per month
Water Pollution	Mufthi Amirullah Shahib Street	114	16	495	33	0.97
Water Pollution	Fakkir Sahib Street	114	13	313	26	1.25
Water Pollution	Kithbath Khan Street	114	8	218	31.2	1.1
Water Pollution	John Mohammed Street	114	7	344	57.3	0.61
Water Pollution	Parthasarathy Naidu Street	114	6	263	52.6	0.68
Water Pollution	Subathral Street	114	6	364	72.8	0.49
Water Pollution	Thiruvatteeswaran Sanadhi Street	114	6	131	26.2	1.38
Water Pollution	Mohamed Abdulla 1St Street	114	4	458	152.7	0.26
Water Pollution	Pachaiyappan Street	114	4	308	102.7	0.39

Avg gap = average days between consecutive complaints of that type on that street. Lower gap / higher “per month” = a faster-recurring, unresolved problem.

🔬 Advanced Analysis

Pareto — the vital few (which categories drive most complaints)

Categories ordered by volume with their cumulative share. The highlighted rows are the smallest set that together account for ~80% of all complaints — fix these first.

Category	Count	Share	Cumulative
Water Pollution vital	124	100%	100%

When complaints arrive (weekday × time of day)

Load pattern across the week — darker cells are busier six-hour windows. Useful for staffing and planning proactive checks before the peak.

	Night	Morning	Afternoon	Evening	Total
Mon	1	10	7	3	21
Tue	2	13	9	3	27
Wed	1	8	7	1	17
Thu		3	11	1	15
Fri		9	5	3	17
Sat	2	8	7	1	18
Sun		6	2	1	9
Total	6	57	48	13	124

Linked problems (category pairs that hit the same streets)

Pairs of issue types that recur together on the same street, ranked by the number of streets where both appear. Strong pairs point to a shared root cause worth fixing in one visit.

Problem A	Problem B	Shared streets
Not enough overlapping complaints in this scope.