Mobile Speed Camera Visits and Stays

Details of mobile camera visits, length of visit, location, number of vehicles checked, and highest and average speed for vehicles that were fined.

Latitude and longitude of the camera locations can be found at https://www.data.act.gov.au/Transport/Traffic-speed-camera-locations/426s-vdu4

Highest and Average Speed from 18.05.2018 will not be displayed.

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 \"data-act-gov-au/mobile-speed-camera-visits-and-stays-d56a-2nhi\".\"mobile_speed_camera_visits_and_stays\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.