search

cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services
17 stars 2 forks source link

OPM and Admin request for data integration, analysis and reporting for TPW 3-1-1 data, for ACM Robert G. #15179

Closed atdservicebot closed 8 months ago

atdservicebot commented 9 months ago

This project came about when ACM Goode approached our executive team and staff and asked for an analysis. He requested an analysis to discover

Background

The 311 management staff provide monthly reporting to Mayor & Council.

  1. report that shows overall top 20 service requests and dispositions.
  2. report that shows the top 20 service requests by districts.
  3. report that shows SR Types department definitions.
  4. report that shows the comparable SR Type Report by Council District.

These reports are what spun the questions from ACM Goode.

Scope & Deliverables

We are assisting the Office of Performance Management (OPM) Division on answering these questions.

Deliverables: 311 SR Data and Visualizations (monthly - fiscal year)

Desired Outcomes

We are hoping that providing this information the executive team and ACM Goode that will shed light on potentially why we get certain 311 requests by the community.

Timebox

The initial ask estimated a time line of end of the week (this was requested on 12/11/23). Due to holidays, I believe OPM had requested to get this completed by the end of January.

References

Request details

image

This Github issue represents a project of Transportation Public Work's Data & Technology Services team. Project status is documented regularly in the comments below.

Charlie-Henry commented 9 months ago

email to Carrie/Hichame at 311 regarding the data we are pulling from them and trying to calculate a backlog.

Hey Hichame & Carrie,

Appreciate you making us those CSR reports we pull daily for TPW. I noticed today that the closed date in those reports appears to be the same as the created date. Is that expected? We had a question from our department execs about the CSR backlog over time and I was trying to calculate the number of SRs we had open for a given date. We also have a Status Change Date or last updated date, maybe those would be the correct field(s) to use to know when a given CSR has been closed out?

maccallump commented 9 months ago

@dianamartin can you create a project index for this?

dianamartin commented 9 months ago

1/11/24

Original Request Details

What application are you using?

Other / Not sure

Describe the problem.

Hello! We are requesting help with data analysis and regular reporting for 3-1-1 data, resulting from a request from ACM Robert G.

As part of this request, we would appreciate support with the data and visualizations for an initial report and a longer term dashboard. Here are the short term action items we discussed:

Data - Diana a. Ask what data they can provide for 3-1-1 data b. Ask how many CSR types (primary and secondary) we have for TPW

Visualizations (monthly - fiscal year) - Charlie a. Update visualization for count over time - 2 year average compared to current year b. Create visualization for backlog c. Update visualization for timeliness (adjust for fiscal year ?)

Here is the link to the

How soon do you need this?

Soon — Within a week

Is there anything else we should know?

The target completion date for the initial analysis is 1/31/2024.

Requested By Paige W.

Request ID: DTS24-111855

Charlie-Henry commented 8 months ago

I think we're good to close this one out? Unless y'all have heard otherwise from the exec team @maccallump, @dianamartin?

dianamartin commented 8 months ago

@Charlie-Henry I haven't heard anything. Should we ask Paige there is no follow up action needed?