Visualize 3-1-1 Service Request "Activities" data

[katelunceford]

Goals

• Visualize SR Activities data to record current state of
  • Response timeliness
  • Public communication - if a detailed update was communicated to the citizen
• Understand data quality around
  • SR response "Activities"
  • What is pushed to the public

To do

• [x] Scope #18200
• [x] Spike to calculate stats for a group we're familiar with (SMD) #18206
• [x] Review output, edit/update before applying it to the rest of the work groups
• [x] Coordinate with 311 to configure 311 Activities Report #18594
• [x] Load 311 activities report into Socrata #18595
• [x] Design mockup of 3-1-1 Service Request Activities dashboard #18748
• [x] Build 3-1-1 Service Request Activities dashboard #18631
• [x] Get feedback from OPM & Jim D. #18993

[katelunceford]

• Activities are all the data people are putting on a 311 ticket, but not everything goes automatically back to the public
• "Review Required" = activity for 311 feedback
• DTS is working with Patrick at 311 to update the outcome codes so that there's not duplicate activities for "Closed Service Request - Resolved" (one from Knack + an automatically applied one from 311)
• Match up the fields - this activity description is connected to this field that we see on the activities report - include additional fields the public is not seeing and highlight to Jim: this is everything being inputted into 311, and this is what makes its way to the public
• [x] Check dataset from 311 against the public website to make sure they match

[katelunceford]

In the future, we might need to extend this beyond 30 days, but Jim hasn't specifically requested that yet.

• Could add a search page to the dashboard
• Could add a date filter similar to the License Agreements dashboard and set it to start at Last 30 Days