Red Light Camera Locations

This dataset shows the location, first operational date, and approaches of the red light cameras in the City of Chicago. The approach describes the originating direction of travel which is monitored by a red light camera.

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 \"cityofchicago/red-light-camera-locations-thvf-6diy\".\"red_light_camera_locations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.