CMWSSB Complaint Analytics

Street	Depot	Complaints	People
Sriram Colony	DEP 123	13	4
Periyar Salai	DEP 123	8	6
Luz Church Road	DEP 123	4	3
Raja Annamalaipuram 2Nd Main Road	DEP 123	3	3
Dr. Ranga Salai	DEP 123	2	1
East Abiramapuram 1St Street	DEP 123	2	2
Eldams Road	DEP 123	2	2
Raja Annamalaipuram 1St Main Road	DEP 123	2	2
Raja Annamalaipuram 3Rd Main Road	DEP 123	2	2
St. Marys Road	DEP 123	2	2
Abiramapuram 4Th Street	DEP 123	1	1
Appadurai Street	DEP 123	1	1

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

CSV PDF

Street	Depot	Sewer	People
Sriram Colony	123	57	11
Eldams Road	123	43	27
St. Marys Road	123	35	21
Madanagopal Street	123	34	8
Periyar Salai	123	34	15
Raja Annamalaipuram 7Th Main Road	123	33	10
Narasimhapuram	123	29	16
Raja Annamalaipuram 1St Main Road	123	26	13
Abiramapuram 1St Street	123	24	7
Canal Bank Road	123	22	12

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

CSV PDF

Street	Depot	Water	People
Luz Avenue	123	14	8
St. Marys Road	123	13	11
Natesan Colony	123	11	6
Prithivi Avenue	123	11	2
Raja Annamalaipuram 1St Main Road	123	10	7
Dr C.v.raman Road	123	7	5
East Abiramapuram 3Rd Street	123	7	7
Desilva Salai	123	6	4
Kennady 2Nd Street	123	6	3
Raja Annamalaipuram 2Nd Main Road	123	6	6

💧 Water Pollution (pollution complaints)

CSV PDF

Street	Depot	Pollut.	People
Kamaraj Street	123	12	6
Raja Annamalaipuram 4Th Main Road	123	12	10
Raja Annamalaipuram 5Th Main Road	123	8	5
Luz Church Road 2Nd Street	123	7	5
Luz Church Road 1St Street	123	6	4
Raja Annamalaipuram 1St Cross Street	123	6	6
Raja Annamalaipuram 2Nd Main Road	123	5	5
Seethammal Colony I Cross Street	123	5	4
Seethammal Road	123	5	5
East Abiramapuram 1St Street	123	4	3

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

PDF

Category	Street	Depot	Times	Span (days)	Avg gap (days)	Per month
Others	Sriram Colony	123	13	474	39.5	0.82
Others	Periyar Salai	123	8	439	62.7	0.55
Others	Luz Church Road	123	4	385	128.3	0.31

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
Others vital	61	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			6	3	9
Tue		3	10	2	15
Wed		1	4	1	6
Thu		3	3	2	8
Fri	1	1	4	5	11
Sat		1	9	1	11
Sun			1		1
Total	1	9	37	14	61

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.