{"id":38377,"date":"2025-03-25T21:20:01","date_gmt":"2025-03-26T01:20:01","guid":{"rendered":"https:\/\/studentwork.prattsi.org\/infovis\/?p=38377"},"modified":"2025-03-27T19:57:01","modified_gmt":"2025-03-27T23:57:01","slug":"how-clean-is-nycs-air-a-borough-by-borough-look-at-the-data","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/how-clean-is-nycs-air-a-borough-by-borough-look-at-the-data\/","title":{"rendered":"How Clean Is NYC\u2019s Air? A Borough-by-Borough Look at the Data"},"content":{"rendered":"\n
Introduction<\/h2>\n\n\n\n
For this project, I analyzed the NYC Air Quality Surveillance Data to explore air pollution trends across different boroughs. The dataset consists of 18,025 records, and I discovered that 79% of the data (14,247 records) is related to air pollutants.<\/p>\n\n\n\n
Through my initial exploration, I found that the ‘Name’<\/strong> column contains a mix of different data types. With the help of ChatGPT, I identified that the entries could be grouped into four main pollutant categories: <\/p>\n\n\n\n
\n
Ozone (O3)<\/li>\n\n\n\n
Nitrogen dioxide (NO2)<\/li>\n\n\n\n
Fine particles (PM 2.5)<\/li>\n\n\n\n
Boiler Emissions (SO\u2082, NO\u2093, PM2.5)<\/li>\n<\/ul>\n\n\n\n\nThis pie chart shows nearly half (8,037) of the ‘Name’ column is Nitrogen Dioxide and Ozone, followed by nearly one-third (5,922) as Fine Particles (PM2.5).<\/strong> These pollutants became the focus of my analysis to understand their distribution across boroughs and how they have changed over time.<\/figcaption><\/figure>\n<\/figure>\n\n\n\n
I used Tableau to build bar charts and line graphs that compared pollutant levels across boroughs and tracked their trends over time. My objective was to identify borough-level pollution patterns and long-term trends in NYC\u2019s air quality.<\/p>\n\n\n\n
Data Exploration & Challenges<\/h2>\n\n\n\n
One major challenge in using this dataset was that each pollutant is measured using different units<\/strong>, making it difficult to combine them into a single comparison:<\/p>\n\n\n\n
\n
Boiler Emissions (SO\u2082, NO\u2093, PM2.5) \u2192 Measured per km\u00b2<\/strong><\/li>\n\n\n\n
Ozone (O3) and Nitrogen dioxide (NO2) \u2192 Measured in ppb <\/strong>(parts per billion)<\/li>\n\n\n\n
Fine particles (PM 2.5) \u2192 Measured in mcg\/m\u00b3 <\/strong>(micrograms per cubic meter)<\/li>\n<\/ul>\n\n\n\n
Because of this, I couldn’t create one single visualization for all pollutants. Instead, I analyzed them individually <\/strong>to see their distribution across NYC.<\/p>\n\n\n\n
I tried to display all four pollutants in a single chart like below, but I realized it could be hard to read and might convey misleading information. Therefore, I decided not to include it in my final dashboard.<\/p>\n\n\n\nThis chart titled \u201cPollutant by Borough\u201d displays the key pollutant levels by borough. However, it is difficult to read and does not convey the information effectively, so I decided not to include it in my final dashboard. <\/figcaption><\/figure>\n\n\n\n
Based on these challenges, I chose to visualize each pollutant separately and focus on those that appeared most frequently in the data.<\/p>\n\n\n\n
Key Analytical Decisions<\/strong><\/h3>\n\n\n\n
As Ozone (O3) and Nitrogen dioxide (NO2) appeared in nearly 8,000 records out of the 14,200 pollutant-related records, I decided to focus my first analysis on these two pollutants. Next, I analyzed Fine Particles (PM2.5) by borough, followed by Boiler Emissions by borough.<\/p>\n\n\n\n
Findings & Visualizations<\/h2>\n\n\n\n
Ozone (O3) and Nitrogen dioxide (NO2) Levels by Borough<\/strong><\/h4>\n\n\n\n
This visualization revealed that Manhattan consistently has the highest levels of both pollutants, which aligns with Manhattan’s urban profile.<\/p>\n\n\n\nThis bar chart titled \u201cOzone (O3) and Nitrogen dioxide (NO2) Levels by Borough\u201d shows that Nitrogen Dioxide levels are consistently higher than Ozone across all boroughs, with Manhattan recording the highest overall pollution levels (1,085.6 ppb and 409.1 ppb).<\/figcaption><\/figure>\n\n\n\n
Fine Particles (PM2.5) by Borough<\/strong><\/h4>\n\n\n\n
Again, Manhattan showed the highest concentration, followed by the Bronx.<\/p>\n\n\n\nThis bar chart titled \u201cFine Particles (PM2.5) by Borough\u201d shows that Fine Particles (PM2.5) levels are highest in Manhattan, followed by the Bronx and Brooklyn. Staten Island has the lowest PM2.5 concentration.<\/figcaption><\/figure>\n\n\n\n
Boiler Emissions by Borough<\/strong><\/h4>\n\n\n\n
While not as extreme, Manhattan and Brooklyn had the highest emissions per km\u00b2. Unlike other pollutants, boiler emissions are measured per km\u00b2, which means boroughs with higher building density<\/strong> tend to show higher emissions.<\/p>\n\n\n\nThis bar chart titled \u201cBoiler Emission by Borough\u201d shows that Manhattan has the highest boiler emissions, significantly surpassing all other boroughs, with NOx emissions making up the largest portion. The Bronx follows at 82.2\/km, while Brooklyn, Queens, and Staten Island have much lower emission levels.<\/figcaption><\/figure>\n\n\n\n
Pollution Trends Over Time (Annual Averages for Ozone and Nitrogen dioxide)<\/strong><\/h4>\n\n\n\n
Overall decline in Ozone and Nitrogen dioxide levels across all boroughs. While all boroughs show improvement, Manhattan remains the most polluted throughout the period, with Ozone and Nitrogen dioxide levels consistently higher than in other boroughs. In 2010, Manhattan had a significantly higher pollution level than other boroughs. By 2022, the gap has narrowed.<\/p>\n\n\n\nThis line chart titled \u201cAnnual Average Trends of Nitrogen Dioxide and Ozone\u201d shows a steady decline in annual average levels of Nitrogen Dioxide and Ozone across all boroughs from 2010 to 2022, with Manhattan consistently recording the highest values.<\/figcaption><\/figure>\n\n\n\n
Placing NYC\u2019s Air Quality in Context<\/strong><\/h2>\n\n\n\n
The findings from this project align broader research on city air pollution. Various studies show that traffic congestion, industrial activity, and high population density<\/strong> are major causes of bad air quality in cities. The dataset confirms that Manhattan always has the highest levels of Ozone, Nitrogen Dioxide, and Fine Particles. This supports earlier research that connects air pollution to areas with many vehicles and buildings that trap pollution.<\/p>\n\n\n\n
Also, the decline in Ozone and Nitrogen Dioxide levels from 2010 to 2022 lines up with efforts to make NYC\u2019s air cleaner, such as stronger air pollution laws (Clean Air Act), reducing car emissions, and using cleaner energy. However, even though the pollution gap between boroughs has become smaller, Manhattan is still the most polluted, showing how big city environments continue to affect air quality.<\/p>\n\n\n\n
Limitations<\/h3>\n\n\n\n
While this dataset is useful, it has a few limitations:<\/p>\n\n\n\n
\n
Borough-Level Aggregation:<\/strong> Without neighborhood-level data, we may miss local hotspots.<\/li>\n\n\n\n
Lack of Real-Time Data:<\/strong> These are annual averages, so temporary pollution spikes aren\u2019t visible.<\/li>\n\n\n\n
Different Units of Measurement:<\/strong> Pollutants are measured differently, making direct comparisons difficult.<\/li>\n<\/ul>\n\n\n\n
Reflections & Next Steps<\/strong><\/h2>\n\n\n\n
Areas for Improvement<\/strong><\/h3>\n\n\n\n
\n
Neighborhood-Level Analysis<\/strong>\n
\n
As I aggregated the visualization at the borough level, I would like to try more granule level of analysis and incorporate more localized air quality data and this will be helpful to understand which neighborhoods experience the worst or best pollution within corresponding borough and this can be more engaging to the audience like New Yorkers.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
Correlation with External Factors<\/strong>\n
\n
Air quality is influenced by many outside factors, like weather, how much people use public transportation, and industrial activities. Adding traffic data, energy use reports, and weather records could help us understand why pollution levels go up or down in different areas.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
Comparing Different Time Frames<\/strong>\n
\n
The dataset focuses on annual averages,because there is no consecutive but analyzing seasonal or daily trends could reveal fluctuations in air quality, such as higher Ozone levels in summer and increased Nitrogen Dioxide levels in winter due to heating emissions.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
Next Steps<\/strong><\/h3>\n\n\n\n
As a next step, I would like to incorporate a map-based data visualization into the project. Using this visualization, I aim to explore more granular data, such as neighborhood-level information, to provide a clearer picture of pollution hotspots within boroughs.<\/p>\n\n\n\n
Additionally, I plan to analyze the relationship between air pollution levels and hospitalization rates to determine if there is a link between respiratory diseases and cardiovascular conditions.<\/p>\n\n\n\n
Lastly, it would be interesting to compare New York City with other major cities like Los Angeles or Chicago and examine how city policies affect air quality.<\/p>\n\n\n\n
Conclusion<\/strong><\/h2>\n\n\n\n
Through this project, I was able to identify borough-level patterns in NYC\u2019s air pollution and observe how pollutant levels have changed over time. The visualizations clearly show that Manhattan consistently records the highest levels of Nitrogen Dioxide, Ozone, and Fine Particles, even as overall levels have declined citywide. While the data revealed long-term improvements, it also highlighted persistent disparities that reflect broader patterns found in urban air quality research. This analysis helped me better understand how data visualization can communicate complex environmental issues, and it provided a strong foundation for asking new questions and exploring deeper relationships in future work.<\/p>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2025\/03\/Screenshot-2025-03-25-at-2.08.35%E2%80%AFPM-1024x738.png?resize=840%2C605&ssl=1\")
![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2025\/03\/Screenshot-2025-03-25-at-2.53.03%E2%80%AFPM-1024x841.png?resize=840%2C690&ssl=1\")
![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2025\/03\/Screenshot-2025-03-25-at-2.55.37%E2%80%AFPM-1024x686.png?resize=840%2C563&ssl=1\")
![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2025\/03\/Screenshot-2025-03-25-at-2.56.41%E2%80%AFPM-1024x916.png?resize=840%2C751&ssl=1\")
![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2025\/03\/Screenshot-2025-03-25-at-2.58.00%E2%80%AFPM-1024x866.png?resize=840%2C710&ssl=1\")
![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2025\/03\/Screenshot-2025-03-25-at-2.59.16%E2%80%AFPM-1024x496.png?resize=840%2C407&ssl=1\")