Average Daily Traffic Counts

Average Daily Traffic (ADT) counts are analogous to a census count of vehicles on city streets. These counts provide a close approximation to the actual number of vehicles passing through a given location on an average weekday. Since it is not possible to count every vehicle on every city street, sample counts are taken along larger streets to get an estimate of traffic on half-mile or one-mile street segments. ADT counts are used by city planners, transportation engineers, real-estate developers, marketers and many others for myriad planning and operational purposes.

Data Owner: Transportation.

Time Period: 2006.

Frequency: A citywide count is taken approximately every 10 years. A limited number of traffic counts will be taken and added to the list periodically.

Related Applications: Traffic Information Interactive Map (http://webapps.cityofchicago.org/traffic/).

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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofchicago/average-daily-traffic-counts-pfsx-4n4m\".\"average_daily_traffic_counts\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.