Streetlight repair status data from the City of Seattle, classified by urgency levels of Green, Yellow, and Red. The dataset tracks trouble tickets and their escalation to specialized repair teams with defined response goals of 10, 45, and 120 calendar days. It is refreshed daily and was last updated on March 22, 2026.
Use Cases
- Predict repair completion times based on the escalation status (Green, Yellow, Red) and associated calendar-day goals.
- Analyze the distribution of repair complexity based on the proportion of tickets escalated to Yellow and Red teams.
- Monitor municipal service performance against the stated response goals for new trouble tickets.
- Model resource allocation for streetlight maintenance based on the escalation categories requiring different teams and timelines.
Strengths
- Defined service level goals for each status category (10, 45, and 120 calendar days).
- Data is refreshed daily, suggesting operational relevance.
- Multiple file formats are available, including CSV, JSON, and geospatial formats like GeoPackage.
Limitations
- Column-level documentation is absent; field semantics must be inferred after download.
- Row count is unknown, which may limit suitability assessment.
- Description metadata is limited; actual data quality requires manual inspection after download.
Provenance
- Source
- City of Seattle
- Collection Method
- Likely sourced from municipal work order and asset management systems.
- Time Range
- null
- Freshness
- Refreshed daily; last updated 2026-03-22.
- Geography
- Seattle, Washington, USA