Dig Ticket Notifications - Last Member Transmissions
data.cityofchicago.org | Last Updated 21 Jul 2022In order to help contractors and private residents avoid existing utility lines (including gas, electrical, and water lines) when digging, the Chicago Department of Transportation maintains 811 Chicago, a free, 24-hour service to private contractors and homeowners in Chicago. Anyone planning to dig within Chicago must obtain a “dig ticket” from 811 Chicago. 811 Chicago notifies all utilities of the impending excavations. The utility owners then send out staff to mark the location of the underground facilities within 48 hours (excluding emergencies), not counting Saturdays, Sundays, and holidays. The dataset on which this filtered view is based shows these utility notifications. Since it is common for the same dig ticket to produce multiple notifications, the same dig ticket will appear multiple times and the dataset cannot be used without further refinement to count, map, or analyze unique excavations in Chicago. This filtered view shows only the most recent notification for each utility. It, therefore, removes some of the duplication in the dataset but still will produce multiple records per dig ticket if multiple utilities have been notified. See https://ipi.cityofchicago.org/Digger for more information on the dig ticket system.
This dataset has the following 25 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| DIG_TICKET# | dig_ticket_ | number | Dig ticket number which can be reviewed through the 811 user portal. | 600439088 600433879 600450173 600450170 600439434 view top 100 |
| PERMIT# | permit_ | text | The permit associated with the dig ticket if one exists. | DOT980385 DOT961511 DOT984447 DOT910668 DOT1001301 view top 100 |
| REQUESTDATE | requestdate | calendar_date | The date and time on which the dig request was made. | 2019-11-12T09:32:24.000 2019-03-27T11:56:36.000 2019-11-12T08:12:08.000 2019-01-29T15:18:44.000 2018-04-09T07:26:31.000 view top 100 |
| EMERGENCY | emergency | checkbox | Indicates whether dig ticket was an emergency request. | false true view top 100 |
| STNOFROM | stnofrom | number | The start of the street address where the excavation will occur. The 811 system creates separate dig tickets for address ranges by breaking them into even and odd blocks. | 10000 301 1601 201 2 view top 100 |
| STNOTO | stnoto | number | The end of the street address where the excavation will occur. The 811 system creates separate dig tickets for address ranges by breaking them into even and odd blocks. | 10000 301 201 2358 1601 view top 100 |
| DIRECTION | direction | text | The direction component of the street where the excavation will occur. | W S N E view top 100 |
| STNAME | stname | text | The name of the street where the excavation will occur. | WESTERN PULASKI ASHLAND CLARK HALSTED view top 100 |
| SUFFIX | suffix | text | The suffix of the street where the excavation will occur. | AVE ST RD PL BLVD view top 100 |
| PLACEMENT | placement | text | The location within the public right of way where the excavation will occur. Excavations on private property do not have placement data associated with them.” | CURBLANE,PARKWAY,SIDEWALK,TRAFFIC PARKWAY SIDEWALK,PARKWAY CURBLANE,PARKWAY,SIDEWALK,TRAFFIC,INTERSECT CURBLANE,TRAFFIC view top 100 |
| DIGDATE | digdate | calendar_date | The date and time before which the excavator is not permitted to break ground. | 2021-05-26T08:00:00.000 2021-04-12T08:00:00.000 2019-04-01T08:00:00.000 2021-05-24T08:00:00.000 2018-09-20T08:00:00.000 view top 100 |
| EXPIRATIONDATE | expirationdate | calendar_date | The date and time at which the dig ticket expires. | 2020-12-31T00:00:00.000 2021-12-31T00:00:00.000 2019-12-31T00:00:00.000 2018-12-31T00:00:00.000 2020-04-30T00:00:00.000 view top 100 |
| PRIMARYCONTACTFIRST | primarycontactfirst | text | The first name of the individual or company requesting the dig ticket. | OSCEOLA FENCE FENCE RUSTIC WOOD FENCING & US HOMEOWNER view top 100 |
| PRIMARYCONTACTLAST | primarycontactlast | text | The last name of the individual or company requesting the dig ticket. | DWM Peoples Gas SEVEN-D CONSTRUCTION CO MEADE ELECTRIC CO., INC. NPL CONSTRUCTION view top 100 |
| Notice History (Utility Name) | notice_history_utility_name | text | The name of the utility company notified. Each dig ticket is sent to one or more utility owners. Thus, the dig ticket number as well as most of the data associated with the dig ticket will be repeated for each utility owner that was notified under that ticket. | Peoples Gas City of Chicago (CoC) AT&T (SBC IL) Comcast Cable (29) ComED South view top 100 |
| Notice History (Site ID) | notice_history_site_id | number | The unique site number associated with each utility owner. The 811 system identifies utility owners by their site number. | 22 136 70 29 5 view top 100 |
| Notice History (Type) | notice_history_type | text | The type of ticket issued including: a. “Initial ticket” - the first ticket issued. Utility owners have 48 hours (recorded as the “DIGDATE”) to mark the location of their facilities at the address on the ticket. b. “No-show” - a follow-up request associated with an initial ticket that notifies specific utilities that their facility was not marked by the dig date. c.“Remark request” - a follow-up request associated with an initial ticket that notifies specific utilities that they need to put new location marks at the site. d. “Cancellation Notice” - a notice to the utility owners that the dig ticket has been cancelled. e. “Notification of renewal” - a notice to the utility owners that the dig ticket expiration date has been extended. f. “Update ticket” - a notice to the utility owners that information on the dig ticket has been updated. | Initial ticket Notification of renewal Remark request Cancellation notice Update ticket view top 100 |
| Notice History (Status) | notice_history_status | text | Utility owners respond to the ticket via the 811 system using the following statuses. All utilities should at a minimum respond "acknowledged." The use of the other status codes is a company by company decision. a. “Acknowledged” - a notification from the utility owner that they received the dig ticket through their web service. This is the most common status and often is not updated. b. “Marked” - a notification from the utility owner that they marked the location of their facility at the address on the dig ticket. c. “In Route” - a notification from the utility owner that their locator is on the way to the address on the dig ticket. d. “Positive Response / Clear” - a notification from the utility owner that they do not have facilities near the address on the dig ticket. e. “Unacknowledged” - a notification from the system that the utility owner has not acknowledged receiving the dig ticket. | Acknowledged Positive Response/Clear Marked Unacknowledged In Route view top 100 |
| Notice History (Created) | notice_history_created | calendar_date | The date and time when the notice was sent to the utility. | 2018-03-23T07:47:17.000 2018-04-02T13:05:50.000 2018-03-27T10:03:21.000 2018-05-17T07:34:56.000 2018-08-08T20:50:09.000 view top 100 |
| LASTSTATUSTIME | laststatustime | calendar_date | The last time the ticket was updated. This can be either an update from the City of Chicago to a utility or a response from the utility. | 2018-05-17T07:39:27.000 2018-05-15T11:12:31.000 2018-05-15T08:46:11.000 2018-05-15T13:37:16.000 2018-05-17T07:39:18.000 view top 100 |
| UNIQUEKEY | uniquekey | number | A unique number that differentiates each record in the data set. | 4070453 4070454 4070455 4070456 4070457 view top 100 |
| Last Member Transmission Flag | last_member_transmission_flag | checkbox | The most recent record for each utility associated with a unique ticket. The most recent record for each utility on a dig ticket will be marked True and all others will be marked False. | true view top 100 |
| LATITUDE | latitude | number | The latitude of the midpoint of the address range. | 41.976201139 41.979728797 41.651658699 41.651752169 41.852756782 view top 100 |
| LONGITUDE | longitude | number | The longitude of the midpoint of the address range. | -87.905309125 -87.902322358 -87.52740033 -87.527636932 -87.631052672 view top 100 |
| LOCATION | location | point | The location of the midpoint of the address range in a format that allows for creation of maps and other geographic operations on this data portal. | {"coordinates":[-87.905309125103,41.976201139024],"type":"Point"} {"coordinates":[-87.902322358222,41.979728797337],"type":"Point"} {"coordinates":[-87.527400329927,41.651658699345],"type":"Point"} {"coordinates":[-87.527636931873,41.65175216895],"type":"Point"} {"coordinates":[-87.631052671948,41.852756782361],"type":"Point"} view top 100 |