Loading...
Loading...
Available on 1 platform
Sign in to view source links and access this dataset
811 Chicago dig ticket notifications alert utility companies to planned excavations. Records include columns for location (LATITUDE, LONGITUDE, STNAME), timing (REQUESTDATE, DIGDATE), and involved parties (PRIMARYCONTACTFIRST, PRIMARYCONTACTLAST). The Chicago Department of Transportation maintains this dataset, which was last updated in April 2026.
Multiple notifications per unique dig ticket (DIG_TICKET#) mean the dataset cannot be used for unique excavation counts without deduplication.
| # | Column Name |
|---|---|
| 1 | DIRECTION |
| 2 | STNAME |
| 3 | PLACEMENT |
| 4 | STNOFROM |
| 5 | LONGITUDE |
| 6 | PRIMARYCONTACTFIRST |
| 7 | Notice History (Created) |
| 8 | Community Areas |
| 9 | EMERGENCY |
| 10 | Boundaries - ZIP Codes |
| 11 | Notice History (Status) |
| 12 | PRIMARYCONTACTLAST |
| 13 | REQUESTDATE |
| 14 | Notice History (Site ID) |
| 15 | STNOTO |
| 16 | LASTSTATUSTIME |
| 17 | DIGDATE |
| 18 | Notice History (Type) |
| 19 | Notice History (Utility Name) |
| 20 | Wards |
| 21 | PERMIT# |
| 22 | LATITUDE |
| 23 | Census Tracts |
| 24 | Zip Codes |
| 25 | LOCATION |
| 26 | Last Member Transmission Flag |
| 27 | UNIQUEKEY |
| 28 | SUFFIX |
| 29 | EXPIRATIONDATE |
| 30 | DIG_TICKET# |