CMWSSB Complaint Analytics

Street	Depot	Complaints	People
Srinivasaperumal Sannathi II Street	DEP 118	69	19
Muthiah Street	DEP 118	61	26
Pirasanna Vinayagar Koil 1St Street	DEP 118	58	19
Avvai Shanmugam Salai	DEP 118	57	24
Thomaiappan Street	DEP 118	41	18
Govarthan Street	DEP 118	39	13
Ponnusamy Street	DEP 118	39	20
Varatharajapuram Main Road	DEP 118	34	20
Pudupet Garden Street	DEP 118	33	23
Anna Salai From Teynampet Signal To Kamarajar Arangam	DEP 118	32	19
Pillaiyar Koil Street	DEP 118	32	18
Nattu Muthu Street	DEP 118	30	19

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

CSV PDF

Street	Depot	Sewer	People
Srinivasaperumal Sannathi II Street	118	50	17
Muthiah Street	118	49	21
Pirasanna Vinayagar Koil 1St Street	118	38	13
Govarthan Street	118	37	11
Ponnusamy Street	118	34	20
Avvai Shanmugam Salai	118	33	15
Pillaiyar Koil Street	118	30	17
Nattu Muthu Street	118	27	16
Varatharajapuram Main Road	118	26	16
Parthasarathy Pettai	118	24	13

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

CSV PDF

Street	Depot	Water	People
Avvai Shanmugam Salai	118	20	10
Pirasanna Vinayagar Koil 1St Street	118	15	7
Pudupet Garden Street	118	13	10
Anna Salai From Teynampet Signal To Kamarajar Arangam	118	10	4
Thomaiappan Street	118	9	5
Kanakasree Nagar	118	8	4
Ganapathy Street	118	7	5
J.j Road	118	7	6
Poes Garden	118	7	5
Rajakrishnarao Road	118	7	5

💧 Water Pollution (pollution complaints)

CSV PDF

Street	Depot	Pollut.	People
Thomaiappan Street	118	13	2
Srinivasaperumal Sannathi II Street	118	12	5
Sriman Srinivasan Road	118	10	7
Mariyappan Street	118	8	5
Shanmugam Street	118	8	3
Muthiah Street	118	7	3
Varatharajapuram Main Road	118	7	4
Ganapathy Street	118	6	2
Venkatarathinam Salai	118	5	2
Besant Road	118	4	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
Sewer Main Block	Srinivasaperumal Sannathi II Street	118	45	530	12	2.55
Sewer Main Block	Govarthan Street	118	32	492	15.9	1.95
Sewer Main Block	Muthiah Street	118	30	554	19.1	1.63
Sewer Main Block	Ponnusamy Street	118	30	528	18.2	1.7
Sewer Main Block	Pillaiyar Koil Street	118	28	517	19.2	1.62
Sewer Main Block	Avvai Shanmugam Salai	118	26	536	21.4	1.46
Sewer Main Block	Pirasanna Vinayagar Koil 1St Street	118	26	498	19.9	1.57
Sewer Main Block	Nattu Muthu Street	118	24	482	21	1.49
Sewer Main Block	Parthasarathy Pettai	118	22	499	23.8	1.32
Sewer Main Block	Varatharajapuram Main Road	118	22	563	26.8	1.17
Sewer Main Block	Anna Salai From Teynampet Signal To Kamarajar Arangam	118	20	477	25.1	1.26
No Water Supply	Avvai Shanmugam Salai	118	20	541	28.5	1.11

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
Sewer Main Block vital	823	57.3%	57.3%
No Water Supply vital	227	15.8%	73.1%
Sewer - House Block vital	143	10%	83.1%
Water Pollution	115	8%	91.1%
Others	51	3.6%	94.6%
Sewer Machine Hole Open (or) Broken	25	1.7%	96.4%
Water Leakage in Service Line / Main Line	16	1.1%	97.5%
Water Short Supply	13	0.9%	98.4%
Booking Issues	7	0.5%	98.9%
New Water Connection Renewal	6	0.4%	99.3%
New Sewer Connection Renewal	5	0.3%	99.7%
Hand Pump Repair	3	0.2%	99.9%
Street Tank Supply Not Made	1	0.1%	99.9%
Rain Water Stagnation	1	0.1%	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	2	130	91	25	248
Tue	6	111	69	36	222
Wed	2	102	84	28	216
Thu	1	107	82	25	215
Fri	1	118	79	27	225
Sat	2	80	85	20	187
Sun		56	40	27	123
Total	14	704	530	188	1,436

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
No Water Supply	Sewer Main Block	57
Sewer - House Block	Sewer Main Block	47
No Water Supply	Sewer - House Block	38
Others	Sewer Main Block	37
No Water Supply	Others	30
Sewer Main Block	Water Pollution	30
Others	Sewer - House Block	28
No Water Supply	Water Pollution	25
Others	Water Pollution	22
Sewer - House Block	Water Pollution	20
Sewer Machine Hole Open (or) Broken	Sewer Main Block	15
Others	Sewer Machine Hole Open (or) Broken	13