Icon for Socrata external plugin
Open repository in Console
Updated 12 hours ago
Indexed 4 hours ago

Dig Ticket Notifications

In 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.

This dataset 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 this dataset cannot be used without further refinement to count, map, or analyze unique excavations in Chicago.

See for more information on the dig ticket system.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofchicago/dig-ticket-notifications-cygx-ui4j\".\"dig_ticket_notifications\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • dig_ticket_notifications
Upstream Metadata