CMWSSB Complaint Analytics

Street	Depot	Complaints	People
Bajanai Koil Street (East)	DEP 109	6	5
Sriramaburam 1St Street	DEP 109	5	4
Thiruvengadapuram 2Nd Street	DEP 109	5	3
Atherayapuram Main Road	DEP 109	4	3
Vada Agaram 1St Street	DEP 109	4	2
Thiruvallivarpuram 2Nd Street	DEP 109	3	3
Abdullah Street	DEP 109	2	2
Bajanai Koil 5H Street	DEP 109	2	2
Basha Street	DEP 109	2	2
Nelson Manickam Road	DEP 109	2	2
Rajaveethi	DEP 109	2	2
Sakthi Nagar 3Rd Street	DEP 109	2	2

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

CSV PDF

Street	Depot	Sewer	People
Bajanai Koil Street (North)	109	99	12
Venkateswara Lane	109	51	11
Bajanai Koil Street (South)	109	40	7
Nelson Manickam Road	109	40	21
Periyar Pathai	109	36	17
Bajanai Koil Street Lane	109	35	8
Vannier 2Nd Street	109	31	12
Vada Agaram 1St Street	109	29	14
Kalyanapuram	109	28	7
Basha Street	109	27	17

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

CSV PDF

Street	Depot	Water	People
Khan Street	109	24	4
Vannier Street	109	18	14
Thiruvallivarpuram 1 St Street	109	13	8
Vannier 1St Street	109	12	6
Vannier 2Nd Street	109	12	4
Thiruvallivarpuram 2Nd Street	109	11	8
Bajanai Koil Street (East)	109	10	9
Thiruvengadapuram 1St Street	109	9	6
Krishnapuram	109	8	7
Vada Agaram 1St Street	109	8	6

💧 Water Pollution (pollution complaints)

CSV PDF

Street	Depot	Pollut.	People
Basha Street	109	11	9
Venkateswara Lane	109	8	4
Periyar Pathai	109	7	6
Thiruvallivarpuram 1 St Street	109	7	5
Abdullah Street	109	6	4
South Gangai Amman Koil 2Nd Street	109	5	5
Sriramaburam 2Nd Street	109	5	2
Thiruvallivarpuram 2Nd Street	109	5	1
Vannier 2Nd Lane	109	5	2
Bajanai Koil Street (East)	109	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	Bajanai Koil Street (East)	109	6	432	86.4	0.42
Others	Sriramaburam 1St Street	109	5	189	47.1	0.8
Others	Thiruvengadapuram 2Nd Street	109	5	373	93.3	0.4
Others	Atherayapuram Main Road	109	4	60	19.9	2.01
Others	Vada Agaram 1St Street	109	4	141	47.1	0.85

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	68	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	2	2	10
Tue		9	1	2	12
Wed		4	5	1	10
Thu		3	3	2	8
Fri		5	3	2	10
Sat		1	6	3	10
Sun		1	4	3	8
Total	0	29	24	15	68

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.