skip to main |
skip to sidebar
I expanded my earlier post that provided an Excel file with Oregon and PDX Metro city place level data that I had downloaded from the new HUD/DOT/EPA location (housing and transportation) affordability portal.
The new Excel workbook HERE, and embedded below, starts with the same graph of HT costs for 50% HUD MFI households for Portland metro cities and includes the same Metro cities and all Oregon place level HT data worksheets in the earlier post.
I have added these worksheets:
- A table of contents, that includes a listing of worksheet and an explanation of additional data fields found in the CBSA and Block Group level worksheets. This TOC worksheet also includes a link to the HT data dictionary.
- A worksheet with all Oregon county level HT affordability data.
- A worksheet with all Oregon CBSA level HT affordability data.
- A worksheet with all HT affordability data for 1400+ Oregon census block groups.
All of the data worksheets include column headers I created using coded values in the downloaded data.
Originally created and posted on the Oregon Housing Blog
Below are images of three map snips showing location affordability index values for three Portland metro cities for a 3 person household at 50% of HUD median family income ($32,050).
Using these index values Portland is the most affordable, followed by Tigard and Lake Oswego; Lake Oswego has both the highest housing costs and transportation costs, as well as the most vehicle miles driven.
Originally created and posted on the Oregon Housing Blog.
Using location affordability index downloadable data I created a MS Word document with a table showing the ranking of 19 Oregon CBSA's (Core Based Statistical Area) by the share of income that a 3 person low income family (50% of HUD MFI) would spend on housing and transportation.
MS Word is HERE and embedded below. Three quick observations:
- Portland has second lowest share of income spent on housing and transportation because it has the lowest share of income spent on transportation.
- Conversely, Hood River has the highest combined share of income spent on housing and transportation because it has the highest share of income spent on housing.
- In ALL Oregon CBSA's families at this income level would spend more than 30% of their income for housing.
Originally created and posted on the Oregon Housing Blog.