edmonton-ca/20122014-graffiti-audit-2q9r-ang2
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated almost 3 years ago
Indexed 1 month ago

2012-2014 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 2012, 2013 and 2014 Graffiti Vandalism Audits. You can see the 2014 report at: http://www.edmonton.ca/programs_services/documents/2014GraffitiVandalismAuditReport.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/20122014-graffiti-audit-2q9r-ang2\".\"20122014_graffiti_audit\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • 20122014_graffiti_audit
     
     
     
     
     
Upstream Metadata