ICC Vehicle Volume Data
This dataset shows the number of vehicles that have passed under a gantry on that particular day. This dataset does not show trips, it only shows segments. Segments are compiled to make trips. There are 10 gantries on the InterCounty Connector (ICC) and 5 interchanges.
The eastbound gantries are 101, 105, 107, 109, 113, and the
westbound gantries are 102, 106, 108, 110, 114.
The dataset has a column for each gantry going east and west, then a total for each gantry.
The ICC is an all electronic tolling road which opened February 2011. The first opening was a partial opening, with only the first interchange being available for use.There was a free period from February 23, 2011 through March 6, 2011. The rest of the ICC opened in November 2011, and there was another free period from November 22, 2011 through December 4, 2011.
There are a few days where a low number of traffic passed under gantries (rows 196,198, 269,271...), these were either testing periods or construction vehicles.
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 \"opendata-maryland-gov/icc-vehicle-volume-data-8d75-q6az\".\"icc_vehicle_volume_data\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
