js6676@columbia.edu
cv
urban planningurban technologytransportation
climateurban 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
Methodology
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.
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
Major Building Violations throughout New York City
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.