About this Dataset

Streetlight Repair Status

Classifies data by Green, Yellow, and Red dot. Green is a new report. A "Trouble Ticket" has been issued to Green Team repair crew. Our goal is to respond to all new Trouble Tickets within 10 business days (14 calendar days). Yellow is a trouble ticket that has been escalated to the Yellow Team because the light at this location requires additional material and/or crew resources in order to be repaired. The goal is to acquire the additional resources and complete repairs within 45 calendar days of the escalation date. Red indicates a replacement of major street light components is required before the light will function properly. The Red Team will produce a Capitol Improvement Project (CIP) work order, acquire necessary permits, schedule crews and then complete the work within 120 calendar days of the escalation date.

Refreshed daily.
Organization: City of Seattle
Last updated: 2025-02-28T23:44:36.723163
Tags: repair, scl, seattle-gis-open-data, streetlight

Tables

Table 1

@usgov.city_of_seattle_streetlight_repair_status.table_1

120.5 kB
1,134 rows
17 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "trouble_ticket_no" BIGINT,
  "street_address" VARCHAR,
  "pole_address" VARCHAR,
  "pole_direction" VARCHAR,
  "pole_northing" DOUBLE,
  "pole_easting" DOUBLE,
  "poleqtrsect" VARCHAR,
  "trouble_ticket_color" VARCHAR,
  "pole_id" BIGINT,
  "task_required_date" VARCHAR,
  "percent_complete" DOUBLE,
  "task_status" VARCHAR,
  "task_phase" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);