When a complaint or request comes into the department, a ticket is formed. The graphs below show the general statistics regarding the tickets.
If you press play, you can see how the proportion of open tickets versus closed tickets changes with time.
The above plot represents how many tickets were open on a given day. Hover your mouse to see the number of tickets open on a given day.
This plot displays the number of tickets submitted versus the number completed. Hover your mouse to see the number of tickets open during a given month.
This tab breaks up the ticket information by its intake or close year. You can use the drop-down bar to select what year you're interested in.
This plot shows the number of tickets taken in and completed by DIS and DPW through the months by year. To hide a specific category, click on it in the legend.
This plot shows the number of tickets with either DIS or DPW or both by Division. To select an option, fill in the bubble below.
Within each department is a division. The drop-down will allow you to choose the division your interested in.
This plot shows the number of tickets throughout years or months by department. To select year or month, click the bubble above.
These are the number of tickets by department are plotted over time. To hide a division, click on its name in the legend. To look at a different status, received, opened, or closed, select the bubble next to its name above.
This plot shows the number of tickets for each streets. Adjust how many streets are displayed using the slider below.
Each department uses priority statuses to distinguish between how urgent a complaint or request is. Emergency depicts a ticket which needs immediate assistance. Standard deals with tickets that do not need immediate attention. ADA/Spec Needs stands for American Disability Act Special Needs.
This pie chart shows the percentage of tickets that are Standard, Emergency, and ADA/Spec Needs.
Here, you can look at the activity of each day of the week. The drop-down bar can be used to look at different days of the week.
These pie charts show the percentage of tickets that are open and closed for each day of the week.
This plot shows the number of tickets that are taken in and the number of tickets that are closed during the hours of the day by each day of the week. Use the drop-down below to change the day you're looking at.
This boxplot shows the number of days to complete a ticket for each day of the week.
Above is a breakdown of where the outliers are coming from.
In November of 2010, over 8,000 tickets were closed. The average number of tickets closed per month is about 3430 tickets. That means in November, ---percent more were closed than usual.
As shown above, 4278 tickets were closed on Monday, Novemeber 15th. The average number of tickets closed per day is 123. If we can assume it was a normal 8 hour work day, that means about 535 tickets had to be closed every hour.
We are looking into data from the Worcester City Government. We are analyzing tickets from the Department of Public Works and the Department of Inspectional Services. We are exploring the data for trends and correlations while also looking into anomalies in the duration a ticket takes to be completed.
If you would like to give some feedback regarding the effectiveness of this website, please feel free to take this survey: Survey Link.