Displacement Risk

Displacement Typologies, developed by the University of California, Berkeley's Urban Displacement Project (UDP), use housing and demographic data from the United States Census, as well as real estate market data from Zillow to classify a metropolitan area's census tracts into eight distinct categories. Each category represents a stage of neighborhood change, although should not be taken to represent a linear trajectory or to predetermine neighborhood outcomes. Instead, typologies allow practitioners and researchers to see patterns in their regions over a specified time period, and are meant to start conversations about how policy interventions and investment could respond and support more equitable development.

It is important to note that in considering the entire metropolitan region, UDP's typologies classify both low- and middle-income neighborhoods at risk of or experiencing displacement or gentrification, as well as high-income neighborhoods where housing markets are becoming increasingly 'exclusive' to low income residents. UDP believes that classifying tracts in such a way allows practitioners to get a broader picture of neighborhood dynamics, specifically the concentration of poverty and wealth within a region.

UDP's Typologies have evolved over time in response to community and partner feedback and the availability of new data sources. This code represents the code's most recent iteration. It makes use of data from the 2014-2018 American Community Survey; 1990, 2010 and 2000 Decennial Census; and 2012-2017 Zillow Home Value and Rent Indices.

For more information:

● Displacement typology data (includes graphic with category criteria) - https://github.com/urban-displacement/displacement-typologies

● Urban Displacement Project - https://www.urbandisplacement.org/

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bayareametro-gov/displacement-risk-juq7-jgnr\".\"displacement_risk\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.