VelospatialRoads
Sample data
Urgent Priority Programmed Monitor
SeverityRoad and locationType TrendLast seenPasses

The model proposes, a person disposes: nothing here has raised a work order. Rows rank what is worth a look, worst and worsening first. Severity must be mapped to your Road Management Plan intervention levels before this list drives anything.