Exploration of Worcester Data

WPI 2019 Data Science REU

Explore data visualizations about service requests from data provided by the Worcester Department of Public Works and Department of Inspectional Services.



Sources

  • WorcesterMA.gov
  • WorcesterMA.gov
  • Wikipedia User Terageorge | CC BY-SA 3.0
  • Boston Magazine | Shutterstock

The Department of Inspectional Services (DIS) and the Department of Public Works (DPW) provided information in hopes of making it more accessible to the public.


DIS deals with the following:

  • Building and Zoning
  • Housing and Health Inspections
  • Permits and Licensing

DPW deals with the following:

  • Residential Drop-Off Center
  • Online Customer Service
  • Pothole Reports
  • Clean Worcester Water

The tabs at the top show statistical information about the departments' services. Click through them to see what's going on in Worcester.



Sources

  • WorcesterMA.gov
  • WorcesterMA.gov
  • Wikipedia User Terageorge | CC BY-SA 3.0
  • Boston Magazine | Shutterstock

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.

Tickets by Department

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.


November 2010

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.


The Project

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.


This project is a part of the 2019 WPI REU in Data Science funded by the National Science Foundation.

The Team

Jack J Amend

  • School: Elon University
  • Major: Computer Science and Applied Mathematics
  • Minor: Statistics
  • Year: Senior

Elizabeth Hennen

  • School: Roger Williams University
  • Major: Biomedical Engineering
  • Minor: Mathematics, Biology, and Chemistry
  • Year: Junior

Megan Resurreccion

  • School: University of Illinois at Urbana-Champaign
  • Major: Creative Writing
  • Minor: Informatics and Statistics
  • Year: Senior
  • Personal Website

Mentor: Dr. Yanhua Li

  • School: Worcester Polytechnic Institute
  • Department: Computer Science
  • Website


If you would like to give some feedback regarding the effectiveness of this website, please feel free to take this survey: Survey Link.