Are you curious to know about the NYC 311 data?
This article will be showcasing some breakdowns of the most important findings in the NYC 311 entries from 2010 until 2020.
For context, the hotline, 311, serves the public and processes non-emergency complaints for both government and civic agencies. The NYC 311 data used in this post is gathered from NYC Open Data and the Department of Information Technology and Telecommunications (DoITT).
We will be answering questions on the statistics of the complaint types in New York City.
Important note: Despite stating to select 100 million rows, the count of all rows seems to be limited to 1000 — either a) API offers only until 1000 rows, or b) Python automatically samples the large dataset down to 1000 rows. For the purposes of this assignment, we will be assuming that Python automatically samples the large dataset down to 1000 rows. Hence we will treat the numbers as part of the 24 million rows, and use proportions/equivalence accordingly (i.e. 1000 = 24,130,631).
The sampling of 1000 datasets out of the 24 million datasets is actually not reflective of the reality, as seen in the visualizations in the dataset webpage: https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/7ahn-ypff
What borough has the most complaints?
Bronx has the most complaints, followed by Queens, Brooklyn, and Manhattan.
Bronx: 302
Queens: 272
Brooklyn: 205
Manhattan: 187
Staten Island: 32
Unspecified: 2
What are the most problematic issues in the city over the time period?
The most problematic issues in the city are listed below:
- Residential Noise
2. Street/Sidewalk Noise
3. Illegal Parking
4. Blocked Driveway
5. Commercial Noise
6. Vehicle Noise
In the top 6 complaints, we can see that half are noise complaints.
What are the most problematic issues in the boroughs (Bronx, Brooklyn and Manhattan)?
For the Bronx: Residential Noise, Street Noise, Blocked Driveway, Illegal Parking, Vehicle Noise, Commercial Noise
For Brooklyn: Residential Noise, Street Noise, Illegal Parking, Blocked Driveway, Commercial Noise
For Manhattan: Residential Noise, Street Noise, Illegal Parking, Homeless Person Assistance, Commercial Noise,