Tag: Chicago

A kludge to build a rental registry in Cook County 

Chicago should have a rental registry, a database of dwelling units that are rented to tenants, for at least two reasons:

  1. The city can know things about the rental units, including how much they cost, where they are, and if any are vacant and could be occupied if only people knew they were available and how to get in touch with the owner.
  2. The city can know who the owners are and contact them to issue citations or advise them, or fill out for them, emergency rental assistance during pandemics and other times of necessity.

Building and administering a rental registry from scratch would be very expensive – probably tens of millions to start and more than one million annually.

I propose a kludge that uses existing databases and modifies existing standard operating procedures amongst a small group of Cook County and Chicago agencies. A kludge is a workaround. It has other meanings and an uncertain etymology.

An ideal rental registry helps solve at least four problems:

  1. Identify who owns a rental home
  2. The number of rental units are in a building
  3. Rental price
  4. Rental unit availability [see my other blog post about counting vacant units]
A 9-unit apartment building in Little Italy is undergoing renovation.

The kludge has four parts

1. Incorporate data about the number of units declared on Real Estate Transfer Tax forms (which in Cook and many other counties are transmitted to the Illinois Department of Revenue digitally).

There is already a city office that reviews or audits these forms looking for instances where the buyer or seller incorrectly claimed certain exemptions from RETT, because of how the city can lose revenue. That office can also enforce that the number of units was correctly entered on the form. 

2. For banks that hold city deposits, amend legislation to require that their newly issued or refinanced mortgages specify the number of units in the required submitted documentation. The ordinance that regulates banks that hold city deposits was amended a few years ago to require that they report how many loans they issue in Chicago for both commercial and residential properties.

Databases 1 and 2 are checks for each other. 

3. “Hire” the Cook County Assessor’s Office to create and operate the database for the unit count data from 1 and 2 (likely as an augmentation of their existing database).

The database would also store any data the CCAO collects through the commercial valuation data they obtain from third party sources as well as from the owners who volunteer it (Assessor Kaegi is already collecting and publicly publishing this information). 

At this point, with features 1, 2, and 3, we are assembling a pretty broad but incomplete record of where rental units are. It will be come more complete over time as properties transfer (sell) and the details of the transfer (sale), and the properties themselves, are recorded.

It doesn’t have a clue as to the rental prices

4. The Cook County Assessor’s Office creates new property classifications. Property classifications allow for the comparison of like buildings for the purpose of establishing assessed values for all properties that are not tax exempt.

One of the most common classifications in Chicago is “2-11”, for apartment buildings with two to six units. This means that, generally, the value of the ubiquitous two-flats and three-flats get compared to other each other and sometimes to four-flats, etc.

I suggest that there should be a few new property classifications, but I have only one idea so far: classify limited equity and Chicago Housing Trust properties differently. 

Bickerdike is one organization that built a lot of limited equity row houses and detached houses in the 1990s and 2000s but I am not aware of a publicly accessible database identifying them.

These houses represent permanently affordable housing and we should have a better system to track them!

This screenshot of part of a spreadsheet is the apartments data that the Cook County Assessor’s Office collected for the 2021 tax year. 

How broad is the kludge?

  • Using the Real Estate Transfer Tax data from 2022 Q1 to Q3, there were 3,550 buildings in Chicago having 22,217 units transferred. (I don’t know how many were arms length transactions, meaning they were sold to new owners.)
  • In the CCAO’s apartments data collected for the Rogers Park Township, there is semi-detailed information about 715 buildings that have seven or more apartments comprising 18,541 units. Details include the unit size breakdown by bedroom count.

Chicago has 556,099 rented dwelling units in buildings with two or more units (according to the ACS 2021 1-year estimate). In my limited analysis I’ve already found data about 7.4 percent of them, and that’s only for part of the city [1].

Notes, limitations, and updates

[1] There may also be duplicates between the buildings in the RETT database and the CCAO apartments dataset.

These databases would not have information about detached (“single family”), single-unit semi-detached (rowhouses and townhouses), and condos used as rentals. This severely limits the coverage of information. As it stands, Chicago Cityscape has data coverage of unit count information for about 37 percent of multi-family (apartment) buildings.

5th Ward Alderperson Desmond Yancy proposed an ordinance that would establish a rental registry (O2023-0004085). The rationale for such is shown in the screenshot below. (Go directly to the ordinance’s PDF.)

Screenshot of the proposed rental registry benefits.

Determining dwelling unit count at an address using 1950 Census records

It’s possible to use 1950 U.S. Census records to establish a number of historic dwelling units at a building in Chicago for the purposes of the city generating a “zoning certificate”. That’s a recognition of the number of legal dwelling units especially useful when that number of dwelling units is greater than the current zoning code allows. They’re required to be generated (i.e. requested from the city’s planning department) during the sale of a small-scale residential property.

This Chicago zoning certificate was generated the “normal” way (which I don’t know how to describe), while this blog post is about digging up evidence in case the normal way doesn’t affirm the number of dwelling units you want it to affirm.

However, based on a recent experience of a client of mine, the zoning certificate – while supposedly valid for one year – is subject to dispute later! Finding Census records showing the same or more dwelling units in a given building has helped re-establish the validity of the number of units stated in a zoning certificate.

It will take you some time to research Census records! (I would budget at least one hour. There is a painstaking process to find the webpage that has the enumeration (counting) sheets for the address you want, and it will take some time to sift through those sheets (and you may have to look at multiple pages for the same address).

Here are the steps involved

  1. Find the enumeration district (ED).
  2. Review that ED’s set of sheets in the National Archives 1950 Census website.
  3. Page through and read every sheet until the address is found.

Tip: I recommend doing this, especially step 3, on a computer with the largest screen possible as it’s easier to view the scanned Census sheets that way.

1. Find the enumeration district

The New York Public Library has a great tutorial on their blog, and I recommend you start by reading section #2, “Generate an ED number”.

Once you locate the ED (following the instructions in “Generate an ED number”) I would say stop reading the NYPL blog post.

Alternatively, for Chicago address lookups, you can browse these maps of the enumeration districts and then search for those ED numbers directly on the National Archives website.

2. Review that ED’s set of sheets

The instructions will advise you to use Steve Morse’s third-party Unified Census ED Finder (which is the most useful part of this process). The ED Finder has a wizard asking you to select state, county, city, and street name and cross street. It will then produce a set of one or more ED numbers under the heading, “1950 ED numbers corresponding to your location”.

A screenshot of the ED Finder “wizard”.

Tip: ED Finder will likely show you multiple ED numbers; you may need to look at all of them to find an address. I think this happens because the link between each enumeration district and a city’s streets is imprecise

Click each ED number, which opens a new tab in the ED Finder website with links to three different image viewers. These are databases where scans of microfilm are shown online. One of them, NARA, is public – that’s the National Archives & Records Administration. I recommend that one as it’s free and doesn’t require an account.

3. Read each enumeration sheet

Once you arrive on the NARA website click on the “Population Schedules” to reveal the enumeration sheets. Start paging and reading!

Tip: Street names are written vertically on the left edge of the page.

A screenshot of the 1950 Census database and website of NARA. It’s necessary to click the “population schedules” button to display the enumeration sheets.

The NARA viewer isn’t the best – it doesn’t allow you to make it full-screen; I was constantly having to zoom in to read the street names and house numbers.

A screenshot of a 1950 Census enumeration sheet with two annotations.

Two-flat journal 5: Costs

Updated May 3, 2021, to add more insight from Robinson Meyer (The Atlantic) as to why lumber prices are so high.

My architect and I are still working on plans, slowly but surely. Read my previous entry, Two-flat journal #4, to understand why that seems to be taking awhile.

There is something else on my mind as we work toward the goal of a gut-rehabbed two-flat: How much this whole project is going to cost.

I’ve talked to several contractors, engaged a structural engineer to specify and design the new steel beam in the basement, and obtained quotes for all new windows from four manufacturers.

One contractor happily gave me an estimate, based on incomplete plans, that was about $220,000. That price could go down with more specific plans and instructions, as the estimate had variability based on unknowns, and it doesn’t include the cost of purchasing the windows. More likely, I think the price will go up due to material costs.

How much windows might cost

All window quotes I’ve obtained include installation by the manufacturer’s selected installers, which has a benefit from some companies, mainly that the maker will guarantee the installation for a period of time.

The first floor living room window is currently double hung with a mullion and a tripartite transom window above it (with stained glass, that’s been covered on the inside). This window will become a “Chicago window” with a centered picture window flanked by casement windows.

I would share the quotes with you but I don’t think they would be very helpful at this point because I haven’t evaluated each of the quotes on the quality of the window. For example, one of the window quotes was three times higher than the next highest quote, but the maker guarantees installation for 10 years and is a higher-quality window. But what is the factor of difference in quality, is it three times? And how valuable is a 10-year installation warranty? It’s unlikely I would need to avail that benefit and the three times difference in price means I could replace all of the windows *again* two times for the same price! (Assuming prices didn’t increase between now and that future moment.)

The 15 new windows, according to the four quotes, will cost anywhere from $12,000 to $46,000. I should mention that the highest quote doesn’t include any discounts or special offers, as those will be offered once I re-engage the estimator and ask for one.

Look at windows 1.1 and 1.3, which look like bay windows. These are both Chicago windows, which have a center picture (fixed) window flanked by two operable windows (casement windows, in this case).

There are a couple of opportunities to reduce window costs. I could convert more of the casement windows to be double hung windows (which I don’t want to do as I prefer single hung windows), or I could change the window opening size. A couple of the window openings are taller than most of the window makers have in their standard window design, so an upper transom (fixed) window would be required. However, changing the window opening size may end up shifting costs to a different plan of adding bricks and adjusting walls.

Another way to reduce the window cost would be to use models that are less energy efficient, but I also don’t want to do that. I’ve insisted that every window be Energy Star certified – this is about the only certification standard that I understand, and it’s common across most window makers in the Chicago area. (There are also Passive House and Passivhaus certified windows, and companies that import higher-quality and more efficient windows from European manufacturers, but I haven’t bothered with any of those because I assume the prices will be even higher.)

Lumber and other construction materials

That lumber prices have more than doubled over prices a year ago is well known if you read real estate industry news media, or if you’ve shopped for wood at Menards to build a couple of benches for some nicer outdoor space or installed a new porch.

My gut rehab will require a lot of plywood (to replace the subfloor), “soft lumber” replacement studs, and some replacement joists.

The St. Louis Federal Reserve maintains “FRED”, an amazing website with interactive charts to explore economics statistics, including lumber. The pricing information comes from the Bureau of Labor Statistics and their Producer Price Indexes.

The chart for the plywood price index below shows very stable pricing in fall and winter 2019-2020, and then in May 2020 prices start climbing and the index increased by 100 points to March 2021.

U.S. Bureau of Labor Statistics, Producer Price Index by Commodity: Lumber and Wood Products: Plywood [WPU083], retrieved from FRED, Federal Reserve Bank of St. Louis; https://fred.stlouisfed.org/series/WPU083, April 25, 2021.

BLS has monthly detailed reports so you can find data about more than the products FRED has charts for. Let’s dig in to the March 2021 report (indexes mean that the pricing represents percentage changes based on 100% being the price when the index was established):

  • “Softwood dressed 2-inch lumber, 2 inches in nominal thickness only, not edge worked” (a.k.a. 2×4 studs) (index established June 2012):
    • March 2020: 205.1
    • March 2021: 324.1 (this means that the price has increased by 119% year over year, a more than doubling of price)
  • “Softwood plywood products: rough, sanded, and specialties” (index established December 2011):
    • March 2020: 139.0
    • March 2021: 242.9 (again, this means that the price has increased by 103.9%, doubling the price)

In addition to general demand being much higher, there are other reasons why lumber costs so much more right now, according to Robinson Meyer writing in The Atlantic last week.

Since 2018, a one-two punch of environmental harms worsened by climate change has devastated the lumber industry in Canada, the largest lumber exporter to the United States. A catastrophic and multi-decade outbreak of bark-eating beetles, followed by a series of historic wildfire seasons, have led to lasting economic damage in British Columbia, a crucial lumber-providing province. Americans have, in effect, made a mad dash for lumber at the exact moment Canada is least able to supply it.

[snipped]

“There are people who say, ‘Climate change isn’t affecting me,’” Janice Cooke, a forest-industry veteran and biology professor at the University of Alberta, told me. “But they’re going to go to the hardware store and say, ‘Holy cow, the price of lumber has gone up.’”

[snipped]

It has lost 2.5 billion board feet of annual production capacity since 2019, enough to shift prices in a North American market of 70 billion annual board feet, Jalbert said.

Read Robinson’s full article to see how the bark-eating beetles overwhelmed the forests of British Columbia and the northern forest belt in Canada and why their rampage is fueled by climate change.


The same contractor, when they checked in with me recently, said that the prices of other construction materials had gone up, too.

In the same Producer Price Index report, it looks like wood doors and door frames went up 29.2% from March 2020 to March 2021; metal windows are up 7.1%, double hung wood windows are up 6.8% and wood casement windows are up 5.1%; wood moldings are up 16.9%.

I didn’t see any notable price increases in plumbing materials or kitchen cabinets – all were close to inflation. The PPI doesn’t have vinyl window products, or I don’t know under which category it falls.

The high rises of the Bronzeville lakefront

3600 S King Dr

I shot this aerial photo yesterday from the 3600 block of South Dr. Martin Luther King Jr. Drive.

The “towers in the park” are three groups of apartment buildings (none are public housing).

From north (background) to south (foreground):

  • Prairie Shores (5 identical buildings that are very hard to see)
  • Lake Meadows (4 identical buildings behind the associated one-story shopping center plus multiple buildings to the east, closer to the lakefront)
  • T.K. Lawless Gardens (3 identical buildings, that appear the tallest because they’re the closest, 746 units, and 54 townhouses not seen)

John Warren Moutoussamy (an architecture graduate of Illinois Institute of Technology who studied under Ludwig Mies van der Rohe) designed Lawless Gardens, according to this IIT Magazine article.

Two-flat owner journal 1: Peoples Gas charges a lot of money for no gas

One of the first things I did after I bought a two-flat in July was contact Peoples Gas and Comed to ensure utilities were in my name, and that the utility connections would not be interrupted.

A few days later I decided that I wasn’t going to move in, because I wanted to make a good amount of changes and the best time to do that would be when nobody is living there. “Good amount of changes” turned into “gut rehab”. One of my friends is an architect and we (mostly him) are drawing permit plans right now.

It wasn’t until a week ago (8 weeks since I bought the house) that I realized there’s no reason to be paying for Peoples Gas to maintain a connection when I’m not using natural gas.

I’m writing this journal entry to exclaim how expensive it is to just “leave the gas line connected”.

It costs $50 per month per unit to have the privilege of possibly purchasing the delivery of natural gas through a pipe. Both units used 0 therms in the longest-period bill I received. (I received three bills, only one of which was for 30 days.)

The bill for the only 30-day period Peoples Gas served one of the units in my two-flat. Both units are unoccupied until after the gut rehab is completed. See the “customer charge”, which is the charge just to have an account open and for the potential to use gas.

I’ve got to pay $50 per unit for no gas.

I visited a three-flat under construction in Pilsen on Friday, and talked to the developer, Brent. He described how he’s following high-efficiency building wall standards to create a “tight envelope” (one in which very little air can leak) so that the tenants can “receive the comfort they’re paying for”. When it comes to setting the thermostat, the air delivered by HVAC machines should match that exactly, no more, no less. No oversized furnaces pushing too much heated air because so much of the air leaks through the walls and windows.

And, as a way to control costs, Brent will not connect a natural gas pipe to the building, mostly because of the expensive and default customer charge that persists even when no gas is used. A VRF (variable refrigerant flow) and heat pump machines will be entirely powered by electricity to serve the tenant’s heating and cooling needs.

Brent said that the tight building envelope coupled with the high-efficiency HVAC means that it’s more cost effective to use electricity to heat a house than natural gas.

After our meeting, I looked again at my final bill from Peoples Gas (I closed the account two days prior) and understood what Brent was saying about controlling costs. With an electric water heater and an electric range, there’s no need to have any gas connection.

I will probably have to keep the gas at my two-flat, to power the furnaces, because I don’t have the expertise or financial resources to renovate an existing building to have a tight enough envelope to make electrically-generated heat more cost effective than gas-generated heat.

Update January 13, 2021: I turned off the gas and closed the accounts so I don’t have to waste any money while I’m not living there (a gut rehab still needs to happen).

To keep water pipes from freezing and bursting I cleared the vast majority of water lines and added an electric pipe heating cable to keep the remaining sections warm.

The two water service pipes (I don’t know why there are two) have an electric pipe heating cable and are wrapped in foam insulation. The cable has a thermostat that touches the pipe and starts heating when the pipe drops to 38°F. The pipe is heated until the thermostat detects ~46°F.