Friday, November 15, 2013

CORRECTED--FINAL Data: ALL Oregon Housing/Transportation Affordability Data for 2,800 Block Groups, Places, Metro Cities, Counties, and CBSA's.

I discovered that the Oregon Block Group data worksheet included data for only the Portland CBSA, including WA state portion.  I copied and pasted data for 18 other Oregon CBSA's (major PITA) into that worksheet-there is now housing and transportation data for nearly 2,800 block groups now, not 1,400. If you downloaded workbook previously I recommend you discard and download the updated version. 

Apologies for the error.
HUD/DOT/EPA have finally opened their long awaited housing and transportation affordability portal.

I  have downloaded from the new location (housing and transportation) affordability portal ALL the available Oregon data.
The new Excel workbook HERE, and embedded below, starts with a worksheet with THREE graphs showing the share of income that a 3 person rental HH at 50% of MFI is projected to spend for housing and transportation costs. The graphs include 
  1. Portland Metro Cities
  2. All Oregon CBSA's
  3. All Oregon counties.
I have also included these worksheets:
  1. 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.
  2. A worksheet with all Oregon county level HT affordability data.
  3. A worksheet with all Oregon CBSA level HT affordability data.
  4. A worksheet with ALL US CBSA level HT affordability data.
  5. A worksheet with all HT affordability data for nearly 2,800 census block groups from Oregon CBSA's (Includes state of Washington BG in Portland CBSA).
All of the data worksheets include lengthy column headers I created using coded values in the downloaded data. Column headers for renter HH;s are highlighted in yellow. Note that there are 8 distinct households modeled by income and composition ranging from a single household at the national poverty rate to the dual earner household at 150% of area income. Each of those households types are further modeled by tenure: all households, home owner households and renter households.  The end result is that each geography has 100+ columns of data.

Originally created and posted on the Oregon Housing Blog

No comments:

Post a Comment