Mobile Automated Traffic Enforcement Tickets Issued (by Month)
This dataset contains the location (the approximate latitude/longitude of the enforcement zone's mid point), the number of tickets issues at the various speed ranges in excess of the enforce speed limit and the number of enforcement hours (Deployment Hours) by month of enforcement.
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 \"edmonton-ca/mobile-automated-traffic-enforcement-tickets-r53s-3xgt\".\"mobile_automated_traffic_enforcement_tickets\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
