urban planner | educator | maker
js6676@columbia.edu
cv  


projects
urban planningurban technologytransportation
climate
urban design
master’s thesis



blog 
about 





















© Jui Shih, 2023 - 2026




Urban Informatics:
Elucidating Housing Conditions in New York City




Subject(s)
Housing, Urban Planning, Spatial Analysis

Course
Urban Informatics & Analytics

Tools
Python, ArcGIS Pro

Project Location    
New York, NY

Completed Period
December 2025



Project best viewed on desktop browsers

Background


The relationship between housing and health has long been recognized, with the condition of housing identified as a major determinant of quality of life, health, and well-being (WHO, 2018; D’Alessandro et al., 2020; Rolfe et al., 2020; City of New York, 2024; OHCHR, 2014). Substandard housing conditions—such as mold, persistent leaks, inadequate heating, pest infestations, and structural deterioration—are closely associated with adverse physical and mental health outcomes, particularly among low-income households, children, the elderly, and people with disabilities. In dense urban environments like New York City, these risks are intensified by aging building stock, high housing costs, and unequal access to resources for maintenance and repair.

This project investigates housing conditions in New York City by examining patterns of housing violations, repeat offenses, and litigation activity from Housing Maintenance Code Violations, Housing Litigations and Housing Maintenance Code Violations NYCHA Properties datasets released by the Department of Housing Preservation and Development (HPD) and situating them within a broader social vulnerability framework. By spatially and statistically linking housing condition data with demographic and socio-economic indicators at the census tract level, the analysis seeks to illuminate where poor housing conditions are most concentrated, how persistently they occur, and which communities bear the greatest burden.


Methodology


This project uses multiple housing conditions datasets documented by HPD available through the NYC Open Data portal as well as American Community Survey (ACS) datasets from multiple years. 

I used Python to clean, filter, and standardize the datasets to focus on selected violation codes associated with severe housing conditions, vacate orders, and systemic building-level issues. Housing litigation data were also incorporated to examine buildings with repeated or ongoing legal action, providing insight into enforcement escalation and unresolved housing problems. 

As the datasets were complex with thousands of points, I decided to build interactive maps using kepler.gl - a web-based data visualization tool that allows functions such as hovering, zooming, toggling layers. This way users can explore the spatial distribution of these violations with additional notes appearing on hover. 
To contextualize housing conditions within a broader social vulnerability framework, multiple variables were extracted from the U.S. Census Bureau American Community Survey (ACS) 5-year estimates at the census tract level. Variables related to income, poverty, unemployment, education, disability status, housing tenure, rent burden, household composition, and limited English proficiency were selected and normalized to construct a social vulnerability index. All datasets were joined using GEOIDs and analyzed using Python and mapping techniques.

Datasets 
  • Housing Maintenance Code Violations
  • Housing Litigations, 
  • Housing Maintenance Code Violations NYCHA Properties
  • ACS 5-Year Estimates from 2023, 2020, 2016, and 2012


Mapping Housing Conditions


Explore what building violations exist in NYC, where they are located, and how they cluster across the 5 boroughs. The following are different interactive maps, each with a different function. You can scroll and zoom in and out to find where housing violations are. Every data point also has additional details - the violation code, short decription, their addresses, neighborhood, when violations were first investigated etc.

Major Building Violations throughout New York City





Violation Clusters








NYCHA Buildings Apartment Violations overlaying General Residential Building Stock





Open Litigations





Social Vulnerability Index

Here, violation points overlay social vulnerability index across NYC. One can see the spatial relationship between neighborhood level social vulnerability and open building violations, with darker census tracts indicating higher vulnerability scores. The clustering of violation points within many high-vulnerability areas highlights how severe and chronic housing conditions disproportionately burden socio-economically vulnerable communities.






BACK