Parking Contravention (Citations)

Monthly Parking Contravention starting in 2010. This dataset includes geolocation where this information is available, and includes a reference to the bylaw that was violated.

The fine amounts in the data set identify both the full fine and early payment discount (fine owing if paid early) at the time the violation was issued.

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 \"winnipeg-ca/parking-contravention-citations-bhrt-29rb\".\"parking_contravention_citations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.