Automate access to high-level data points for TPWstat

[Charlie-Henry]

@michael-santulli has been collecting a list of data he and OPM pulls manually for monthly TPWstat meetings. We should identify which of these are easiest ETLify and/or the most painful for OPM to collect and prioritize that way.

Sources of data

• Maximo
• SMD Knack
• AMD Data tracker (knack)
• Moped

View all of the created Socrata views for TPWstat

Breakdown by data source

CSRs

• [x] Automate access to high-level CSR datapoints for TPW Stat #15504
• CSRs for signals on flash
• Transportation Engineering Division: number of CSRs
• Transportation Engineering Division: CAFs and CSRs by Council District

VZ viewer

• [x] #15505
• Fatalities and serious injuries YTD + serious injuries by mode

SMD Knack + Power BI dashboard

• [ ] #15507
• Signals retimed
• Intersections with detection installed
• Percent of unstriped streets striped within 30 days
• Signs in Fair or Better condition
• HIN Markings in Fair or Better condition

Moped (?)

• [ ] #15506
• Miles of bike lanes built
• Projects under design by ATSD by group
• Medium and Full Build Quality bikeway progress
• Active Projects by group (i.e. VZ, Transit Enhancement, Speed Management, Other)
• Miles of sidewalk built per year

Maximo

• [ ] #15508
• 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

Bond Spending (microstategy)

• [x] #15766
• 2016 Bond Spending by Category
• 2018 Bond Spending by Category
• 2020 Bond Spending by Category
• Community Services bond spending
• Sidewalks bond spending (2016, 2018, 2020)
• Urban Trails bond spending (2016, 2018, 2020)

Not sure:

• Locations staffed with crossing guards
• NPP project pipeline

[amenity]

Today's discussion in Data Science Refinement

• Possibly provide Michael with a query
• We have a lot of these data points already