Road Weather Demonstration Data

The Belle Isle data was collected between May 1st, 2014 and September 16th, 2014 on the Belle Isle Park in Michigan. However, within the data file provided as part of this data environment, only data during the World Congress demonstration period from September 5, 2014 to September 11, 2014 is included. Several vehicles equipped with multiple sensors drove around the island collecting 572,030 readings of multiple variables. The uploaded data file lists all those observations and the pertaining details about the sensor equipment, the sensor platform and the status of quality checking performed for each observation.

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/road-weather-demonstration-data-jc5e-psbx\".\"road_weather_demonstration_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.