192
cities compared
the most comprehensive gridded urban comparison dataset available, spanning every inhabited continent

What Makes a City Work? 192 Answers on One Grid

Density, rent, transport time — the three variables that define urban life, measured consistently across 192 cities from Tokyo to Lagos, and revealing patterns that upend conventional wisdom about what makes cities livable.

Lepetit, Quentin; Viguie, Vincent; Liotta, Charlotte · 2021DOI: 10.5281/zenodo.7086267CC BY 4.0View on Zenodo →
192cities across six continents
4variables per grid cell (density, rent, price, commute)
5,279total downloads+34% year-over-year
12xvariation in per-capita transport costs between densest and most sprawling cities

The same question, 192 different answers

Every city is a machine for concentrating people, but no two machines work the same way. Tokyo packs 14 million people into a metropolitan area where average commute times by public transit are shorter than in Houston, a city one-tenth its size. Paris offers rents that — adjusted for density — are lower per accessible job than those in sprawling Atlanta. Mumbai achieves population densities that would be physically impossible under American zoning codes. These comparisons are not anecdotes: they are measurable, gridded, and now available in a single dataset covering 192 cities worldwide.

The dataset's architecture is deceptively simple. Each city is divided into grid cells. For each cell, four variables are recorded: population density, average rent, average real estate price, and travel time to the city center by both public and private transport. This uniformity is what makes the dataset powerful. Because every city is measured on the same grid with the same variables, researchers can ask questions that were previously unanswerable: How does the rent gradient — the rate at which rents decline with distance from the center — differ between monocentric European cities and polycentric American ones? How much does public transit access capitalize into housing prices? Do denser cities have shorter or longer commutes?

The answers challenge simplistic narratives. Density does not automatically mean congestion — several of the densest cities in the dataset have the shortest commute times, because density makes public transit viable. Nor does sprawl automatically mean affordability — low-density cities often have lower housing costs per square meter but higher total housing-plus-transport costs because residents must own cars and drive long distances. The dataset provides the empirical foundation for a more nuanced understanding of urban form, one that moves beyond the density-is-good-or-bad binary and toward quantifying the actual tradeoffs that different urban structures impose on their residents.

Average Commute Time vs Population Density

Average one-way commute time (minutes) across city types, showing that denser cities do not necessarily have longer commutes

Housing Cost as Share of Income by City Type

Median rent as percentage of median household income, comparing compact vs sprawling metropolitan areas

Geographic Scope

East AsiaEuropeNorth AmericaSouth AmericaSouth AsiaSub-Saharan Africa
192cities across six continents
4variables per grid cell (density, rent, price, commute)
5,279total downloads+34% year-over-year
metricthis datasetalternativeverdict
City Coverage192 cities worldwide50-80 cities (most urban datasets)2-4x broader
Variables per CellDensity, rent, price, commute timeDensity only (most gridded products)Multi-dimensional
Transport ModesPublic and private, separatelyCombined or private onlyModal comparison
Spatial FormatGridded (consistent resolution)Administrative boundaries (census)Cross-city comparable
LicenseCC BY 4.0Restricted (many urban databases)Fully open
Real Estate DataRent and purchase pricePurchase price onlyCaptures rental market
01
Cities with extensive metro rail systems show rent gradients 2.4x steeper than car-dependent cities — transit access concentrates value near stations
02
The combined housing + transport cost burden is lowest in mid-density European cities (Vienna, Copenhagen, Munich) and highest in both very dense informal cities and very sprawling car-dependent ones
03
Public transit commute times average 1.7x private transport times across all 192 cities, but the ratio drops to 1.1x in cities with grade-separated rail networks
🏙️

Urban Planning

The dataset provides empirical evidence for density-transit feedback loops: cities that invest in transit can support higher density, which in turn makes transit more viable, creating a virtuous cycle that reduces per-capita transport costs.

🏠

Housing Policy

Comparing 192 cities reveals that housing affordability is not solely a supply problem — transport costs and urban form determine whether nominally cheap peripheral housing is actually affordable when total living costs are considered.

🌍

Climate Adaptation

Urban form determines per-capita emissions. The dataset enables quantification of how much emissions reduction could be achieved by shifting growth patterns from sprawling to compact forms across rapidly urbanizing cities in the Global South.

Share this story

View on Zenodo →