Automate access to high-level Maximo data points for TPWstat

[amenity]

• [ ] Pending Utility Excavation Repairs (UER backlog)
• [ ] Sidewalk feet constructed per month
• [ ] Curb/gutter feet constructed per month
• [ ] In-house bridge projects completed FYTD
• [ ] Seal Coat lane miles completed
• [ ] Overlay (in-house) lane miles completed
• [ ] Crack Seal lane miles completed
• [ ] Fog Seal lane miles completed
• [ ] Miles of sidewalk inspected
• [ ] Potholes repaired on time
• [ ] District maintenance 311 Requests addressed
• [ ] Urban forestry: ROW obstructions cleared within 72 hours

[katelunceford]

Notes from Data Science Backlog Refinement 4/24/24

• Maximo data warehouse is an Oracle Database
• We're hiring a new person who knows Maximo reporting! They start Monday 4/29 😀
  • They're familiar with pulling data out of Maximo
  • Definitely need their help on this issue
• Other Maximo issues

  • 16311 Get access to Maximo Primary DB (needs scoping)

  • 16656 Set up PBI dataflow for TPW Work Orders (in progress)

  • 12670 Obtain data pipeline for Maximo data into PBI (icebox)

[katelunceford]

Notes from OPM Sprint Review on 4/30/24

@michael-santulli will you review this list of requested data points and let us know if anything's changed?

[katelunceford]

Notes from Data Science Sprint Planning on 5/1/24

It’d be cool to look at the queries behind Maximo reports to see if we could translate them for the data warehouse, where we’re running the ETL