New Excel File Has 4 Years of Oregon Housing Permit and Production Data for Large Cities, Includes Missing Middle and Regulated Unit Data.

I  have constructed a comprehensive new Excel workbook HERE that includes housing permit AND production data for large cities in Oregon from 2018 to 2021 as well as housing unit counts from the 2021 ACS. 

It also includes a breakout of permit and production data for regulated (income restricted) units. 

Permit and production data comes from annual large city (population 10k+) reports sent to DLCD to comply with HB 4006, enacted in 2018.

I have enhanced the DLCD data by adding multiple columns

• A subtotal of missing middle housing unit permits and production. This subtotal includes single family attached, duplexes, ADU's, manufactured housing, triplexes, and quads. 
• A “Yes/No” indicator showing whether the city is located within the Portland Metro government jurisdiction.
• Columns that show the federal ID of the large city, the number of housing units, and the number of occupied housing units (Data source is 2021 5 year ACS Table DP-04, Selected Housing Characteristics).

Summary Worksheet, Cities Ranked by The Rate of Annual Housing Production Per 1, 000 Existing Housing Units.

The first worksheet is a summary of annual housing production by city. 

Cities are ranked from highest to lowest on the number of housing units produced divided by the existing housing unit count from the 2021 ACS.  I have posted this two page summary as a PDF file HERE, and embedded it below. 

Redmond led with an average of 47.4 units produced per 1,000 existing housing units. Happy Valley was close behind, and led all Portland metro cities, with an average of 45.5 units produced per 1,000 existing housing units.   

Portland ranked #10 with an average of 19.6 units produced for every 1,000 existing housing units. This was higher than the Portland metro cities average of 15.6 units produced per 1,000 existing housing units and the average for all of these cities, 13.7 units produced per 1,000 existing housing units). 

Data Worksheets and Pivot Tables; Regulated Production Lags 50% Share Called for in New Executive Order. 

One data work sheet and its related pivot table consist of ALL units (59, 582 units produced).

The second data work sheet contains only REGULATED unit data (4,546 units produced, 7.6% of all units produced; that's 76 units out of every 1,000 produced. Governor Kotek's recent executive order called for <80% MFI units to represent a much higher share of production, at "more than 50%" of unit production. 

Other worksheets have data used in formulas in the all unit and regulated unit data worksheets. 

The default pivot table view shows units produced by city per year, and includes a “in Metro jurisdiction”  filter at the top.

What Questions Can the Excel Database Help Answer?

Working with the data tables and the pivot tables the user can find answers to questions like these: 

• How many missing middle housing units were produced in these cities?
• What is the share of total production that was missing middle? Regulated housing share of total production?
• Did ADU unit production increase from 2018-2021? What about duplexes, triplexes, and quads?
• Which cities had the largest number/share of produced units in multifamily housing? Single family detached?
• Which cities have the highest ratio of housing production to existing housing units?  
• How does the city share of large city production compare to its share of existing housing units?
• If goal is to increase production by 80%, and increase the share for regulated housing to 50%, how many more units would need to be produced by city?
• What share of housing production by type was in the City of Portland? What was the share for all cities in Portland metro jurisdiction? 
• Is regulated housing production concentrated in multifamily 5+ units? 
• IF all cities, or Metro cities, produced at the rate of the City of Portland (19.6 units per 1,000 existing housing units) how many additional units would be produced?

Notes: 

To subtotal all large city data by year I have included a _totals row for each year in the “City” column. To avoid double counting insure you filter that row out when you you total all city data by year ( or select that row as the total). 

For the housing unit and occupied unit data columns I also subtotaled the housing units by year for all large cities. Because the cities reporting each year changed slightly the count of housing units for the annual total of large cities may change slightly from year to year, but the count of units for each city will not change. 

Note: Data lookups are used in formulas to extract data for several of the worksheets so be careful about deleting or hiding worksheets, columns, or rows that may contain those formulas. 

New 2022 Data Is Supposed to be Available Soon, But....

CY 2022 city data is due to DLCD in about two weeks, on February 1st; in past years many cities reported substantially later than the deadline. Let's see if the Governor's executive order improves on time reporting this year. 

Originally created and posted on the Oregon Housing Blog. 

>