Annual Average Daily Traffic (AADT): Beginning 1977

Annual Average Daily Traffic (AADT) is an estimate of the average daily traffic along a defined segment of roadway. This value is calculated from short term counts taken along the same section which are then factored to produce the estimate of AADT. Because of this process, the most recent AADT for any given roadway will always be for the previous year. Data is available for all New York State Routes and roads that are part of the Federal Aid 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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ny-gov/annual-average-daily-traffic-aadt-beginning-1977-6amx-2pbv\".\"annual_average_daily_traffic_aadt_beginning_1977\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.