stevevance

New Construction Sprinkler System Analysis

Overview

This reference documents an analysis of sprinkler system prevalence in new residential construction permits issued in Chicago between January 1, 2020, and December 31, 2025. Permits are grouped by building type (single-family, small multi-family, large multi-family) and by whether their work_description references a sprinkler system.

Analysis Date: 2026-02-24

Query Criteria

stevevance

Gov. Pritzker’s Affordability Agenda Proposes Suite of Housing Solutions to Cut Red Tape,
Increase Supply, and Lower Costs
Working families are struggling to buy or rent a home because the United States, including Illinois, is facing a
housing crisis. Illinois is short about 142,000 housing units and will need to build over 225,000 units in five
years to keep up with growing demand. With few housing options to choose from, Illinoisans are spending
more of their income on housing – oftentimes in inadequate spaces for their families.
Developer demand to build is high, but red tape gets in the way. A patchwork of different local building
restrictions makes it harder for developers to get permits to build, driving up the costs of building new
housing. In the past five years alone, the number of home listings has dropped 64 percent and new construction
permits have dipped to 13 percent.

stevevance

stevevance

stevevance

with zips as (
	select
		vp1.zcta as name,
		vp1.geom as geom,
		st_area(vp1.geom) area_zip
	from b_zcta_il_in_2020 as vp1, b_wards_2022 AS vp2
	where st_intersects(vp1.geom, vp2.geom)
	and vp1.slug not in (
		'zip-60625-no-rosehill-cemetery'
	)

stevevance

with zips as (
	select
		vp1.zcta as name,
--		am.name as park,
		st_difference(first(vp1.geom), st_union(am.geom)) as geom,
		st_area(st_difference(first(vp1.geom), st_union(am.geom))) area_zip_without_parks,
		st_area(first(vp1.geom)) area_zip
	from b_zcta_il_in_2020 as vp1, b_wards_2022 AS vp2, view_amenities_combined_2024_08_14 as am
	where st_intersects(vp1.geom, vp2.geom)
	and am.type = 'park'

stevevance

/* the main query */
select 
	st_area(first(vp.geom)) area_ward,
	st_area(st_difference(first(vp.geom), st_union(am.geom))) area_ward_without_parks,
	vp.metadata::int as ward
from view_places as vp, view_amenities_combined_2024_06_19b as am
where vp.type = 'ward'
and vp.metadata in (
	'33', 
	'35',

stevevance

[
    {
        "date": "2024-06-11T05:00:00+00:00",
        "votes": [],
        "description": "Substituted"
    },
    {
        "date": "2024-06-11T05:00:00+00:00",
        "votes": [],
        "description": "Recommended to Pass"

stevevance

Dear Alderperson [their name],

My name is [your first and last name], and I am a Ward [x] resident residing at [your address]. I am writing to share my strongest support for Alderperson Lawson's ordinance to support the legalization of Accessory Dwelling Units citywide. As my elected official, I urge you to vote in favor of this ordinance.

Legalizing ADUs citywide will expand housing options, leading to numerous benefits that are well-documented in other parts of the United States and Chicago is just beginning to know. These include offering lower income renters more options, allowing older residents to age in place and supporting multi-generational households, offering additional income streams through rent to prevent the displacement of low-income homeowners and retirees on fixed-incomes, providing gentle density in existing neighborhoods without impacting its appearance, and reducing demand for sprawling, greenfield development. New construction ADUs are also highly efficient and often all-electric, leve

stevevance

/* select properties with coach houses */
with properties as (select 
	pt.pin14,
	pt.total_assessed_value,
	pin_num_cards > 1 as has_coach_house
from assessor_single_mf_characteristics AS ac inner join propertytaxes_combined AS pt on ac.pin = pt.pin14
where year = '2023'
	and city = 'CHICAGO'
	and property_Class = '2-11'
	and ac.units = 2