Categories for NYC311 Service Requests

There are 283 complaint_types, and over 1,800 complaint_type plus descriptor combinations. We have grouped these into 16 helpful Categories. All abbreviations, punctuation, and capitalization in the complaint_types are as they appear in the raw data. Some complaint_types appear under multiple categories. You can read about why this happens on our How are requests categorized page. You can also view the code for the categorization process on that page. If you would like to suggest a new Category or the re-categorization of a complaint_type, please Contact Us.

To generate the Category-complaint_type look up table below, you can run the following query in Google Bigquery: 

If you are new to Google Bigquery, read our set up tutorial

Cat_1.JPG
Cat_2.JPG
Cat_3.JPG

Does Geographic Data Change?

Spatial filters