opendata-maryland-gov/icc-vehicle-volume-data-8d75-q6az
Icon for Socrata external plugin
 
Readme
Updated over 2 years ago
Indexed 6 hours ago

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 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • icc_vehicle_volume_data
     
Upstream Metadata