Intelligent Network Flow Optimization Prototype Infrastructure Traffic Sensor System Data Aggregator

Data is from the small-scale demonstration of the Intelligent Network Flow Optimization (INFLO) Prototype System and applications in Seattle, Washington. Connected vehicle systems were deployed in 21 vehicles in a scripted driving scenario circuiting this I-5 corridor northbound and southbound during morning rush hour. This data set contains real-time volume, speed and loop occupancy data that were collected from WSDOT’s simulated roadway sensors every 20 seconds and aggregated according to user defined procedures and threshold by the Infrastructure Traffic Sensor System (TSS) Data Aggregator software.

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 \"datahub-transportation-gov/intelligent-network-flow-optimization-prototype-e5bn-vf7s\".\"intelligent_network_flow_optimization_prototype\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.