2015-2017 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 the following years to determine if there were significant changes to the amount of graffiti found. This data set is result of 2015 through to 2017 Graffiti Vandalism Audits. You can see the 2017 report at: http://www.edmonton.ca/programs_services/documents/GraffitiVandalismAuditReport-WebVersion.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/20152017-graffiti-audit-2gxp-ymsd\".\"20152017_graffiti_audit\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.