Projects

Quality of Life of NYC Children

Fall 2021
Intro to Urban Data Informatics
Columbia GSAPP
Prof. Boyeong Hong

Team:
Kirthi Balakrishnan,
Shreya Arora,
Lizzie Lee,
Christian Budow

Most quality-of-life indices don't really account for kids. We built one that does - a 0–10 score for children across all 55 NYC PUMAs that combines infrastructure access, economic pressure, and environmental quality, framed by who actually lives in each district.

Scroll

The Question

Method
Composite index
4 domains, 0–10 scale
55 NYC PUMAs

NYC Open Data
2019 ACS 5-Year

Most existing quality-of-life indices treat children as a footnote. But the things that matter for a kid - whether there's a library within walking distance, whether the air at school is clean, whether the rent is eating their family's budget - show up later in school outcomes, in health outcomes, in everything.

So we built a composite Quality of Life Index for children across all 55 of NYC's Public Use Microdata Areas. The frame is borrowed from UNICEF's Child Friendly Cities Initiative, Arup's Cities Alive: Designing for Urban Childhoods, and ONE NYC 2050's well-being indicators, then tuned for what New York actually looks like at the PUMA level.

The Index

Where quality of life for kids clusters, and where it thins out

The composite averages eight 0-10 measures of a district's everyday resources for kids: subway access, bus access, parks, libraries, health facilities, air quality, median income, and rent burden. The chips recolor the map by any single measure - flip between Rent burden and Air quality and watch the geography change.

Each indicator is min-max scaled across the 55 PUMAs: 10 is the best district in the city on that measure, 0 the worst - so a 10 means "best in the city by construction," not a perfect score. Click any district on the map.

Darker districts score higher. Central Harlem tops the composite: strong bus, health, and library access outweigh its income score.

Approach

Four Domains
Domains
Access
Economic
Environmental
Social

The matrix below drafted eleven indicators across four domains. Eight of them enter the final composite - the five access densities, income and rent burden, and air quality - each min-max normalized, then averaged and re-scaled to a single 0–10 score. Indicators where lower values are better (air quality, rent burden) are inverse-scored so the index reads consistently. The rest inform the framing without being scored: water quality's sources sit outside NYC, school lead testing covered too few schools, and the demographic indicators describe who lives in a district rather than how well it serves them.

  • Access. Density of bus stops, subway stations, healthcare facilities, libraries, and parks per PUMA - NYC Open Data shapefiles.
  • Economic. Median household income and rent burden (gross rent as % of income) - 2019 ACS 5-Year Estimates. Rent burden ≥ 35% scores 1.
  • Environmental. Air quality (AQI) and school lead testing - NYC Open Data Portal APIs. Water quality was examined but excluded from scoring; its sources sit outside NYC boundaries.
  • Social. Population under 18, age-group breakdowns, and race/ethnicity composition - 2019 ACS 5-Year Estimates.
Quality of Life Matrix for Children in NYC: eleven indicators across socio-economic factors, environmental character, and access to public amenities and critical infrastructure
THE MATRIX
The design-stage matrix: eleven candidate indicators in three colors - socio-economic (blue), environmental (green), access and infrastructure (pink). Eight survived into the scored composite.
Tools & Libraries

Python, GeoPandas, scikit-learn (MinMaxScaler), pandas, NumPy, Plotly, Folium, spatial joins on PUMA boundaries.

Outputs

The research posters, inspectable at full size
Research poster page one: framing, socioeconomic and environmental parameters, parks and water quality maps, children population and race charts, rent burden choropleth
POSTER 1 OF 2 · CLICK TO ZOOM
The framing and the parameters: research question, socioeconomic factors, environmental character, and the component charts behind them.
Research poster page two: infrastructure density heatmaps, the indicator matrix, limitations, and the final 0 to 10 Quality of Life Score choropleth
POSTER 2 OF 2 · CLICK TO ZOOM
Access heatmaps (subway, healthcare, bus, libraries), the aggregation method, and the final 0–10 Quality of Life Score by PUMA.

Findings

  • No single metric tells the whole story. A PUMA can score well on libraries and bus stops and badly on PM2.5. You need all four domains rolled together to see who's actually well-served.
  • Economic and environmental burdens land in different places. The PUMAs flagged for rent burden sit in Staten Island and eastern Queens as often as the Bronx, and none of them rank among the worst for air quality. Different pressures, different kids - which is exactly why one score can't stand in for the other.
  • The global frameworks needed translating, not just applying. UNICEF and Arup wrote for cities at every scale. Making their frameworks work for New York meant picking indicators that match how children actually experience a dense, vertical, transit-dependent city - subway stops and libraries as daily infrastructure, not amenities.

Limitations

Stated up front, because an index is only as honest as its assumptions
  • All indicators are weighted equally. There was no objective way to decide that air quality matters more than library access, so we didn't pretend there was. Every parameter carries the same weight, and the index should be read with that in mind.
  • No child-specific demographic data. No public dataset breaks down children's demographics at the resolution we needed, so we derived the picture from general population-by-age and population-by-race data.
  • The environmental data is uneven. Each environmental dataset arrives with its own predetermined scoring, and the school lead-testing data covers only volunteering schools in 2020. Water quality was ultimately excluded from the index because its sources sit outside NYC boundaries.

Kirthi Balakrishnan, Shreya Arora, Lizzie Lee, & Christian Budow

Professor Boyeong Hong, Columbia GSAPP