citydata-mesaaz-gov/transportation-graffiti-9spb-749m
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

Transportation Graffiti

Graffiti abated with location, date of abatement and square footage abated.Data is from October 2015 to present. Days to abatement information is calculated based on receipt during normal workday. See attachment for how "normal workday" information is calculated. Calculated workday request was received by the city staff. Normal workday is generally defined as M-Th excluding holidays.

Go to https://citylink.mesaaz.gov/Create to report graffiti or find the link to download an app for your mobile device that you can use to report graffiti.

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 \"citydata-mesaaz-gov/transportation-graffiti-9spb-749m\".\"transportation_graffiti\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • transportation_graffiti
     
     
     
     
     
Upstream Metadata