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.
This dataset has the following 20 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| ID | id | text | CitySourced unique identifier. | 1000444 1000446 1000449 1000482 1000484 view top 100 |
| Date Reported | date_reported | calendar_date | Date that graffiti record was generated. | 2017-01-10T00:00:00.000 2019-11-14T00:00:00.000 2020-06-22T00:00:00.000 2020-02-05T00:00:00.000 2019-06-17T00:00:00.000 view top 100 |
| Calculated Received Date | calculated_received_date | calendar_date | Calculated workday request was received by the city staff. Normal workday is generally defined as M-Th excluding holidays. | 2019-11-18T00:00:00.000 2020-06-22T00:00:00.000 2018-01-02T00:00:00.000 2019-06-17T00:00:00.000 2017-12-18T00:00:00.000 view top 100 |
| Date Abated | date_abated | calendar_date | Date that graffiti was abated. | 2017-01-10T00:00:00.000 2016-09-21T00:00:00.000 2019-11-14T00:00:00.000 2020-06-22T00:00:00.000 2022-04-26T00:00:00.000 view top 100 |
| Nearest Address | nearest_address | text | Recorded address of graffiti. | Sun Cir Trail, Mesa, AZ 85203 AZ-202-LOOP W, Mesa, AZ, 85201 Tempe Canal Service Rd, Mesa, AZ 85201 Moorings at Mesa Cove, Mesa, AZ, 85203 Mesa, AZ, 85212 view top 100 |
| Square Feet Abated | sq_foot_abated | number | Square feet abated. | 1 2 4 6 3 view top 100 |
| Days to Abatement | days_to_abatement | number | Count of days between calculated received date and date abated based on next normal workday. Normal workday is generally defined as M-Th excluding holidays. | 0 0.1 0.2 0.3 0.4 view top 100 |
| Reporting Source | reporting_source | text | The mode used to report graffiti. | Self Reported (City Staff) Mobile App (Public) Phone/Email (Public) Website (Public) Error view top 100 |
| Year Reported | year_reported | text | Year the graffiti record was generated. | 2018 2019 2020 2021 2017 view top 100 |
| Month Reported | month_reported | text | Month the graffiti record was generated. | May Oct Jan Aug Jun view top 100 |
| Day Reported | day_reported | text | Day of the month the graffiti record was generated. | 19 12 14 10 22 view top 100 |
| Calculated Received Year | calculated_received_year | text | The year the calculated workday request was received by the city staff. | 2018 2019 2020 2021 2017 view top 100 |
| Calculated Received Month | calculated_received_month | text | The month the calculated workday request was received by the city staff. | May Jan Oct Aug Jun view top 100 |
| Calculated Received Day | calculated_received_day | text | The day of the month the calculated workday request was received by the city staff. | 13 26 12 10 16 view top 100 |
| Year Abated | year_abated | text | Year the graffiti was abated | 2018 2019 2020 2021 2017 view top 100 |
| Month Abated | month_abated | text | Month the graffiti was abated | May Jan Oct Aug Jun view top 100 |
| Day Abated | day_abated | text | Day of the month the graffiti was abated | 12 19 14 10 22 view top 100 |
| Location | location | point | Combined Lat/Lon location | {"coordinates":[-111.816,33.4372],"type":"Point"} {"coordinates":[-111.816,33.4371],"type":"Point"} {"coordinates":[-111.825,33.4224],"type":"Point"} {"coordinates":[-111.801,33.4319],"type":"Point"} {"coordinates":[-111.814,33.437],"type":"Point"} view top 100 |
| Latitude | lat | number | Latitudinal location of graffiti. | 33.436935 33.436966 33.436981 33.437012 33.436996 view top 100 |
| Longitude | lon | number | Longitudinal location of graffiti. | -111.8265684 -111.81411 -111.788063 -111.81414 -111.814774 view top 100 |