AmandaWilsonKC
commented
6 years ago I met with the abatement team today and made some updates to this list. My notes to developers are in brackets. Let me know if you have questions. Thank you!!!
We are currently planning on focusing on the Priority Zone from 12th to 39th Streets along Prospect and four blocks east and west of Prospect. This tool will serve a few functions:
- Pre-abatement inspections and area survey
- Track abatement work and locations of graffiti
- Post-abatement inspection
- Track time spent on activities
- If time allows, an externally facing app where people can report graffiti
Data fields for #2. Track abatement work and locations of graffiti [can we save data with the ability to enter more data or edit data at a later date?] Date (can this be automatically populated?) Number of Tags in Picture 1 Number of Tags in Picture 2 Number of Tags in Picture 3 Tag Text (Use * for each letter that cannot be read) Small Tag Text / Initials Inside Larger Tag (Tag Crew) Racial or Hate Tone? [checkbox] Gang-Related [checkbox] Crossed Out Tag [checkbox] Surface [Bare Brick, Bare Concrete, Glass, Painted, Bare Stone, Bare Wood, Other] Need Other Code Enforcement? – Weeds, Building Disrepair, Illegal Dumping, Trash, Other Square Footage Covered Type of Property [Commercial, Residential, Public] Vacant Property [checkbox] Land Bank Property [can we pre-load this data into the app so people in the field can automatically tell if it’s a land bank property? This can be pulled from Open Data or the Neighborhood Dashboard app]
Date of Contact with Owner [date field]
Owner Name [Can all of this owner information be pre-populated from the City’s Parcel Viewer database and the Rental Registration list? That would be awesome!!]
Owner Phone
Owner Email
Tenant Name Tenant Contact Phone or Email
Owner Waiver Completed [Can we have the owner sign the waiver in the app? That would be awesome!!]
Follow up with Owner Needed? CPTED Recommendations: Lighting, Fencing, Brush Removal, Camera Installation, Other
Number of Nearby Businesses Inform about Abatement? [number field] Number of Nearby Residents Inform about Abatement? [number field] Follow-up Needed to Nearby Businesses and Residents: [checkbox and text field]
Data fields for #3. Post-Abatement Inspections Date of Inspection [automatically populate?] Graffiti Present? [yes or no] [Take picture, ability to choose from list of addresses where graffiti already abated] Square Footage of New Graffiti [allow user to fill in same graffiti data as above]
Data fields for #4. Track time spent on activities [two ways to enter data: time per property or time spent for a batch of properties] Time Spent on Each Activity • Survey / Inspection • Site Prep • Set Up • Abatement • Break Down and Clean-Up • Outreach
Time Spent for Survey / Inspection for Multiple Properties • Time • Properties [checkbox multiple properties]
Processes Survey and look for graffiti Look for recurrence Internally record occurrences Residents record occurrences
Reporting Record graffiti occurrences and recurrences before and after Tie in with 311 data
Goals Did this allow new business to move in? Abate and beautify, make area more aesthetically pleasing - blend in, not blend Reduce graffiti and vandalism and the reoccurrence Reduce amount businesses and residents have to spend on abatement
JakeLaCombe
(Will need to be able to enter multiple pictures for each location with each picture having it’s own set of data)
Date (can this be automatically populated?) Number of Tags Wall 1 Number of Tags Wall 2 Number of Tags Wall 3 Tag Text (Use * for each letter that cannot be read) Tag Crew (initials inside the tag) Racial or Hate Tone? Square Footage Type of Property: Commercial, Residential, Public Vacant? Surface: Painted, Unpainted Wood, Brick, Concrete, Glass, Other Need Other Code Enforcement? – Weeds, Building Disrepair, Illegal Dumping, Trash, Other
Initial Contact with Owner Date Owner Name Owner Contact phone number Owner Contact Email Tenant Name and Contact Owner Completed Waiver? Time Required to Abate Follow up with Owner Needed? CPTED Recommendations: Lighting, Fencing, Brush Removal, Camera Installation, Other
Number of Nearby Businesses Inform about Abatement? Number of Nearby Residents Inform about Abatement? Follow-up Needed to Nearby Businesses and Residents:
Date of Recurrence Square Footage of New Graffiti
Processes / Will Use Data For… Survey and look for graffiti Look for recurrences in locations (hotspots) and taggers Internally record occurrences People external to the abatement team can record occurrences Identify how soon after graffiti is abated that it returns Share information with the City and with KCPD Eventually would like to overlay graffiti data with crime, vacancy, and new business license data