Overview — Gig Dashboard

140

Total Gigs

457

PRG Issues

Gigs Over 30 Days ↗

Marked Critical ↗

28.3

Avg Age (days)

Project Rankings

Project	Total ↓	Open	Over 30d	Δ Total	Δ Over 30d	Avg Age	Oldest	Top Type
Denver (05/11)	58	58	25	-5	-10	31.3	156	Structure_Grounding (41)
Logan (02/11)	27	27	24	0	0	45.3	100	Conduit_Sealed (11)
Arizona (02/11)	20	20	2	-25	-5	19.9	45	Restoration_Trench (15)
Oklahoma (02/11)	19	19	1	-5	-1	14.1	32	Structure_Other (9)
Oregon (02/11)	16	16	2	-14	-10	16.4	51	Unspecified (9)

PRG Issues

Project	Total	Resolved	Vendor Resolved	Over 30d	Top Issue Type	This Week
Denver	447	5107	30	263	Site Cleanup (176)	▲189 / ▼209
Logan	10	483	0	0	Sealant (6)	▲0 / ▼4

Resolution History

Denver

Week Of	New	Resolved
2026-10-26	+125	−226
2026-10-19	+93	−184
2026-10-12	+130	−203
2026-10-05	+561	−445
2026-09-28	+149	−335
2026-09-21	+209	−340
2026-09-14	+370	−303
2026-09-07	+212	−148
2026-08-31	+245	−310
2026-08-24	+288	−124
2026-08-17	+198	−283
2026-08-10	+176	−243
2026-08-03	+463	−39
2026-07-27	+19	−122
2026-07-20	+246	−151
2026-07-13	+184	−130

Logan

Week Of	New	Resolved
2026-10-26	+0	−1
2026-10-19	+0	−0
2026-10-12	+20	−9
2026-10-05	+15	−13

Top Gig Types — Overall

Gig Type	Count	Share
Structure_Grounding	43
Restoration_Trench	16
Unspecified	13
Conduit_Sealed	11
Structure_Other	9
Markerpost	7
Structure_Gravel	6
Locate_Isolation_Switch	5
Structure_Grade_Level	4
Conduit_Other	4
Restoration_Other	4
Conduit_Length	4

Gigs by Crew / Contractor

Crew	Count	Share
Unassigned	47
DTOB	37
GTO	18
U Lineman	14
Alpha One	7
Redline Utilities	5
Paramount Underground	5
ECC	4
Solid Rock	2
Foxfiber	1

Gig Types by Project

Arizona

Restoration_Trench	15
Unspecified	4
Structure_Grade_Level	1

Denver

Structure_Grounding	41
Structure_Gravel	6
Structure_Grade_Level	3
Conduit_Other	2
Restoration_Other	2
Restoration_Core_Hole	1
Other	3

Logan

Conduit_Sealed	11
Locate_Isolation_Switch	5
Structure_Tracer_Wire	3
Conduit_Length	3
Conduit_Entry	2
Restoration_Core_Hole	2
Other	1

Oklahoma

Structure_Other	9
Markerpost	7
Structure_Grounding	2
Conduit_Length	1

Oregon

Unspecified	9
Conduit_Other	2
Structure_Gradelevel	1
Other	1
Fiber_Other	1
Restoration_Hardscape_Asphalt	1
Other (misc.)	1

Aging — Days Open, by Project

Project	0-7 days	8-14 days	15-30 days	31-60 days	61-90 days	90+ days	Avg Age
Arizona	0	1	17	2	0	0	19.9
Denver	10	0	23	22	2	1	31.3
Logan	0	0	3	17	5	2	45.3
Oklahoma	0	12	6	1	0	0	14.1
Oregon	5	4	5	2	0	0	16.4
All Projects	15	17	54	44	7	3

Trends — Gig Count Over Time

Oldest Open Gigs

Project	Type	Status	Supervisor	Age (days)	Created
Denver	Structure_Grounding	OPEN	874324	156	2026-06-03
Logan	Conduit_Entry	OPEN	879390	100	2026-07-29
Logan	Locate_Isolation_Switch	OPEN	879390	95	2026-08-03
Denver	Structure_Grounding	OPEN	878884	88	2026-08-10
Denver	Structure_Grounding	OPEN	874324	72	2026-08-26
Logan	Restoration_Core_Hole	OPEN	884186	72	2026-08-26
Logan	Conduit_Sealed	OPEN	884186	65	2026-09-02
Logan	Conduit_Sealed	OPEN	884186	65	2026-09-02
Logan	Conduit_Sealed	OPEN	884186	65	2026-09-02
Logan	Structure_Tracer_Wire	OPEN	884186	65	2026-09-02
Logan	Conduit_Sealed	OPEN	884186	58	2026-09-09
Oregon	Structure_Gradelevel	OPEN	Unassigned	51	2026-09-16
Denver	Structure_Grade_Level	OPEN	874324	49	2026-09-18
Denver	Structure_Gravel	OPEN	878884	46	2026-09-21
Arizona	Restoration_Trench	OPEN	ECC	45	2026-09-22
Denver	Structure_Grounding	OPEN	874324	45	2026-09-22
Denver	Structure_Grounding	OPEN	874324	45	2026-09-22
Denver	Structure_Grounding	OPEN	874324	44	2026-09-23
Denver	Structure_Grounding	OPEN	874324	44	2026-09-23
Denver	Structure_Grounding	OPEN	874324	44	2026-09-23

Source Files Loaded

Arizona__Google_ECC_AZ_Mesa_AddMarkup_1329089832157154050.csv Arizona__Google_ECC_AZ_Mesa_AddMarkup_5576560358170334095.csv Arizona__Open_Gigs_List.csv Arizona__Open_Gigs_List_(1).csv Denver__CO_Google_Denver_ADDmarkup_5044138285409705530_(1).csv Logan__Google_ECC_UT_Logan_AddMarkup_4199960884263504364.csv Oklahoma__Open_Gig_List.csv Oregon__Gig_List.csv