2011 Graffiti Audit

In 2010, Capital City Clean Up initiated a Graffiti Vandalism Audit to assess the amount of graffiti vandalism found in the neighbourhoods in Edmonton with the highest reported incidences of graffiti. A follow-up audit was completed in 2011 to determine if there were significant changes to the amount of graffiti found. This data set is result of the 2011 Graffiti Vandalism Audit. You can view the report at: http://www.edmonton.ca/environmental/documents/GraffitiVandalismAudit.pdf

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/2011-graffiti-audit-4adt-tbf8\".\"2011_graffiti_audit\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.