cameras

Dataset provides data from the Iowa Department of Transportation's Intelligent Transportation System (ITS) CCTV Cameras. Data includes location of cameras, static image URL, and motion video URL where available.

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 \"mydata-iowa-gov/cameras-4bfg-n52x\".\"cameras\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.