I know this has been discussed before (eg, here:
http://lists.open311.org/groups/discuss/messages/topic/tTrrQO2z6VTEylY2iLIQC/0
) but I've started to do some work on it.
As Louisville's Chief Data Officer, I've been talking to other CDOs (San Diego,
Kansas City, others) to add standard categories to our 311 data so we can cross
compare. Andrew Nicklin has been involved as well.
It's been challenging. Louisville has over 250.
https://data.louisvilleky.gov/dataset/311-service-requests
Kansas City has about 125.
https://data.kcmo.org/311/311-Call-Center-Service-Requests/7at3-sxhp
San Diego has over 500.
https://data.sandiego.gov/datasets/get-it-done-311/
I worked on Louisville's and got it down to 22 high level categories. One
thing that I think is key though is to have standardized sub-categories under
each of these to ensure your data has the appropriate level of granularity. So
we created 69 sub-categories.
I wanted to share these here and get feedback. Not perfect yet at all. KC and
SD are working on aligning their current 311 data with these categories and
identifying gaps.
But these work well for Louisville and I've used them on some internal maps and
data analysis, finding they work much better than our bloated categorizations.
I haven't added them to our open data yet, but will. Even when I do, I will
likely keep the original group and sub-groups in the data because these can now
be used as a kind of description.
Category
Air Quality Concerns
Animal Issue
Building/construction Issue
Business Legal Needs
Emergency
Garbage/recycle/junk/yard Waste Issue
Graffiti
Health Issue
Illegal Dumping
Litter Concerns
Miscellaneous
Open Burning / Fire Concern
Other Concerns/opinions
Park/bike/pedestrian Issue
Pests
Police Issue
Sidewalk/curb/guardrail Issue
Traffic/roadway Issue
Tree/grass/plant Issue
Utility Concerns
Vehicle/parking Issue
Weather Issue
Sub Category
Abandoned Vehicle
Accessible Parking Zone
Adult Entertainment
Air Quality Concerns
Alcohol Beverage Control
Animal Cruelty
Animal Nuisance
Bedbugs
Bike Pedestrian
Building Construction
Building Violation
Charitable Solicitation
Codes And Regulations
Community Issue
Compliment
Dangerous Animal
Dead Animal
Emergency
Garbage/recycle/junk/yard Waste Concerns
Garbage/recycle/junk/yard Waste Missed
Garbage/recycle/junk/yard Waste Questions
Garbage/recycle/junk/yard Waste Violation
Get Garbage/recycle Cart/bin
Graffiti
Health Concerns
High Grass Weeds
Illegal Dumping
Illegal Parking
Lane Marking
Litter Concerns
Louisville Loop
Maintenance Of Metro Property
Miscellaneous
Mosquitos
Noise Concerns
Open Burning / Fire Concern
Other Concerns/opinions
Park Maintenance
Parking Meters
Pavement Repair/replace
Permit Questions
Pests
Police
Pothole
Request To Tow Vehicle From Private Property
Restaurant Complaint
Right Of Way Obstruction
Road Construction
Sidewalk/curb/guardrail New
Sidewalk/curb/guardrail Repair
Sign/banner New
Sign/banner Repair
Signal/light New
Signal/light Repair
Smoke Detector
Smoking Ban Concerns
Snow/ice Removal
Speed Humps
Standing Water
Stray Animal
Taxi Concerns
Traffic Questions/concerns
Traffic Signal Issues
Tree/plant Removal Request
Utility Concerns
Vacant Property Questions/concerns
Weather Related
Zoning Concerns
http://lists.open311.org/groups/discuss/messages/topic/tTrrQO2z6VTEylY2iLIQC/0
) but I've started to do some work on it.
As Louisville's Chief Data Officer, I've been talking to other CDOs (San Diego,
Kansas City, others) to add standard categories to our 311 data so we can cross
compare. Andrew Nicklin has been involved as well.
It's been challenging. Louisville has over 250.
https://data.louisvilleky.gov/dataset/311-service-requests
Kansas City has about 125.
https://data.kcmo.org/311/311-Call-Center-Service-Requests/7at3-sxhp
San Diego has over 500.
https://data.sandiego.gov/datasets/get-it-done-311/
I worked on Louisville's and got it down to 22 high level categories. One
thing that I think is key though is to have standardized sub-categories under
each of these to ensure your data has the appropriate level of granularity. So
we created 69 sub-categories.
I wanted to share these here and get feedback. Not perfect yet at all. KC and
SD are working on aligning their current 311 data with these categories and
identifying gaps.
But these work well for Louisville and I've used them on some internal maps and
data analysis, finding they work much better than our bloated categorizations.
I haven't added them to our open data yet, but will. Even when I do, I will
likely keep the original group and sub-groups in the data because these can now
be used as a kind of description.
Category
Air Quality Concerns
Animal Issue
Building/construction Issue
Business Legal Needs
Emergency
Garbage/recycle/junk/yard Waste Issue
Graffiti
Health Issue
Illegal Dumping
Litter Concerns
Miscellaneous
Open Burning / Fire Concern
Other Concerns/opinions
Park/bike/pedestrian Issue
Pests
Police Issue
Sidewalk/curb/guardrail Issue
Traffic/roadway Issue
Tree/grass/plant Issue
Utility Concerns
Vehicle/parking Issue
Weather Issue
Sub Category
Abandoned Vehicle
Accessible Parking Zone
Adult Entertainment
Air Quality Concerns
Alcohol Beverage Control
Animal Cruelty
Animal Nuisance
Bedbugs
Bike Pedestrian
Building Construction
Building Violation
Charitable Solicitation
Codes And Regulations
Community Issue
Compliment
Dangerous Animal
Dead Animal
Emergency
Garbage/recycle/junk/yard Waste Concerns
Garbage/recycle/junk/yard Waste Missed
Garbage/recycle/junk/yard Waste Questions
Garbage/recycle/junk/yard Waste Violation
Get Garbage/recycle Cart/bin
Graffiti
Health Concerns
High Grass Weeds
Illegal Dumping
Illegal Parking
Lane Marking
Litter Concerns
Louisville Loop
Maintenance Of Metro Property
Miscellaneous
Mosquitos
Noise Concerns
Open Burning / Fire Concern
Other Concerns/opinions
Park Maintenance
Parking Meters
Pavement Repair/replace
Permit Questions
Pests
Police
Pothole
Request To Tow Vehicle From Private Property
Restaurant Complaint
Right Of Way Obstruction
Road Construction
Sidewalk/curb/guardrail New
Sidewalk/curb/guardrail Repair
Sign/banner New
Sign/banner Repair
Signal/light New
Signal/light Repair
Smoke Detector
Smoking Ban Concerns
Snow/ice Removal
Speed Humps
Standing Water
Stray Animal
Taxi Concerns
Traffic Questions/concerns
Traffic Signal Issues
Tree/plant Removal Request
Utility Concerns
Vacant Property Questions/concerns
Weather Related
Zoning Concerns