----------------------------------------------------------- ------------------------------------------------- - Monthly, Quarterly and Yearly Cases Previous Year - - Top 25 Monthly, Quarterly and Yearly Cases - ----------------------------------------------------------- ------------------------------------------------- - Local date-time is [2023-12-02 06:00:01.460] - - Local date-time is [2023-12-02 06:00:30.773] - ----------------------------------------------------------- ------------------------------------------------- Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: An existing connection was forcibly closed by the remote host. Case Type |Past 4 Weeks . ------------------------------------|------------ Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Communication link failure. Water Leak | 2942 Missed Garbage Pickup | 2154 Water Service | 1788 Sewer Wastewater | 1476 Nuisance On Property | 1001 Traffic Signal Maintenance | 966 Parking Violation | 962 Missed Recycling Pickup | 836 Street Condition | 779 Container Replacement | 674 Street Hazard | 666 Dead Animal Collection | 633 Traffic Signs | 604 Container Repair | 590 Heavy Trash Violation | 534 New Resident Container | 451 Recycling Participation NEW | 414 Missed Heavy Trash Pickup | 414 Trash Dumping or Illegal Dumpsite | 404 SWM Escalation | 400 Drainage | 388 Pothole | 380 Fire Hydrant | 374 Building Code Violation | 293 Water/Sewer/Drainage Billing | 292 Case Type |Past 12 Weeks ------------------------------------|------------- Water Leak | 13395 Missed Garbage Pickup | 7142 Water Service | 7097 Sewer Wastewater | 4763 Traffic Signal Maintenance | 4222 Nuisance On Property | 3814 Parking Violation | 3503 Missed Recycling Pickup | 3311 Street Condition | 2883 Street Hazard | 2749 Container Replacement | 2236 Traffic Signs | 2137 Dead Animal Collection | 2030 Container Repair | 1954 Heavy Trash Violation | 1906 Missed Heavy Trash Pickup | 1860 SWM Escalation | 1584 Trash Dumping or Illegal Dumpsite | 1517 New Resident Container | 1460 Fire Hydrant | 1449 Recycling Participation NEW | 1429 Drainage | 1398 Pothole | 1182 Building Code Violation | 1106 MYR Correspondence | 1059 Case Type |Past 12 Months ------------------------------------|-------------- Water Leak | 41292 Missed Garbage Pickup | 27157 Water Service | 21228 Sewer Wastewater | 19938 Missed Recycling Pickup | 18099 Traffic Signal Maintenance | 16511 Nuisance On Property | 14961 Parking Violation | 13647 Street Condition | 10913 Street Hazard | 10742 SWM Escalation | 9723 Container Replacement | 9516 Traffic Signs | 8614 Container Repair | 8329 Dead Animal Collection | 7968 Missed Heavy Trash Pickup | 7945 Heavy Trash Violation | 7083 Drainage | 6740 New Resident Container | 6355 Trash Dumping or Illegal Dumpsite | 6207 Recycling Participation NEW | 5848 Water Main Valve | 4751 Missed Yard Waste Pickup | 4737 MYR Correspondence | 4590 Add a Can | 4588