Page 31 of 178

Chicago’s massive parking footprint – as measured on December 25, 2019

No, I didn’t spend my day outside measuring parking lots. I spent it inside measuring existing, available data from OpenStreetMap. The last time I measured the amount of parking area in Chicagoland was on September 16, 2018, using the same data source. Using the footprints of parking lots and garages drawn into OpenStreetMap as a […]

Continue reading →

Cities that have transit fare deals (capping) have fairer fares

“Fare capping” is a jargon term for a fare policy that any transit agency can implement to save their riders money, make fares fairer, and potentially increase ridership. Another term is “deal”, as these policies net riders a break in the fares. Fare capping ensures that riders who pay for rides with a transit card* […]

Continue reading →

My idea for the Chicago prize: Build 1,000 ADUs collectively

I probably won’t actually submit my idea to the Chicago Prize, a $10 million grant competition to revitalize neighborhoods, so I’m posting it here for everyone to read. Basically, I want to use the $10 million as seed money to start a small organization that does design, construction administration, and property management to help homeowners […]

Continue reading →

Pick the lowest and highest numbers in an array of numbers in PostgreSQL

I thought solving this problem took longer than it should have. I thought there would have been an integrated function in PostgreSQL to pick the lowest (smallest or minimum) and highest (largest or maximum) numbers in an ARRAY of numbers. LEAST and GREATEST didn’t work, since those work on expressions, not arrays. MIN and MAX […]

Continue reading →

Lock off apartments: Does zoning allow them?

These are also known as Junior Accessory Dwelling Units (JADU) in the California ADU laws. Many bungalows in Chicago were built with basement ADUs that have an exterior entrance as well as an interior entrance that can be locked off.  At the YIMBYtown conference in Boston, Massachusetts, last week, I heard from a panel comprising […]

Continue reading →