41554 blogs · [ { "id": "01a0d2b0-a8c8-71b8-9c79-a592efc5fe41", "title": "Determining dwelling unit count at an address using 1950 Census records", "url": "https://www.stevencanplan.com/2023/03/determining-dwelling-unit-count-at-an-address-using-1950-census-records/", "published_at": "2023-03-11T07:28:27+00:00" }, { "id": "01a0d2b1-59f1-70d7-ab5f-c846d5a0a2e0", "title": "Creating a PostgreSQL PostGIS function to get around a DataTables Editor limitation", "url": "https://www.stevencanplan.com/2023/03/creating-a-postgresql-postgis-function-to-get-around-a-datatables-editor-limitation/", "published_at": "2023-03-09T04:09:09+00:00" }, { "id": "01a0d2b1-59f1-70d7-ab5f-c846d5dc376a", "title": "Avoid “VARCHAR” columns in PostgreSQL [PGSQL Phriday #006]", "url": "https://www.stevencanplan.com/2023/02/avoid-varchar-columns-in-postgresql-pgsql-phriday-006/", "published_at": "2023-02-28T15:17:02+00:00" }, { "id": "01a0d2b1-59f1-70d7-ab5f-c846d6582ac3", "title": "Two-flat journal 8: Adding a third unit", "url": "https://www.stevencanplan.com/2023/02/two-flat-journal-8-adding-a-third-unit/", "published_at": "2023-02-18T00:28:51+00:00" }, { "id": "01a0d2b1-59f1-70d7-ab5f-c846d66c3f90", "title": "A short list of features of the Netherlands that I still try to wrap my head around", "url": "https://www.stevencanplan.com/2023/01/a-short-list-of-features-of-the-netherlands-that-i-still-try-to-wrap-my-head-around/", "published_at": "2023-01-19T02:03:24+00:00" }, { "id": "01a0d2b1-59f1-70d7-ab5f-c846d724693c", "title": "Chicago’s massive parking footprint – as measured on December 30, 2022", "url": "https://www.stevencanplan.com/2022/12/chicagos-massive-parking-footprint-as-measured-on-december-30-2022/", "published_at": "2022-12-31T18:18:29+00:00" }, { "id": "01a0d2b1-59f1-70d7-ab5f-c846d7da20b9", "title": "Automatically post your Flickr photos to your Mastodon account", "url": "https://www.stevencanplan.com/2022/12/automatically-post-your-flickr-photos-to-your-mastodon-account/", "published_at": "2022-12-24T17:24:00+00:00" }, { "id": "01a0d2b1-59f1-70d7-ab5f-c846d88ae3b6", "title": "I ran errands and measured the CO2 concentration everywhere I went", "url": "https://www.stevencanplan.com/2022/12/i-ran-errands-and-measured-the-co2-concentration-everywhere-i-went/", "published_at": "2022-12-24T07:29:02+00:00" }, { "id": "01a0d2b1-59f1-70d7-ab5f-c846d88bb02d", "title": "Say hello to Adanet, my new CO2 concentration monitor", "url": "https://www.stevencanplan.com/2022/12/say-hello-to-adanet-my-new-co2-concentration-monitor/", "published_at": "2022-12-17T02:51:45+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4e5937a67", "title": "Deferring a trip to another time is a part of “trip chaining”", "url": "https://www.stevencanplan.com/2022/12/deferring-a-trip-to-another-time-is-a-part-of-trip-chaining/", "published_at": "2022-12-17T01:03:06+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4e604c56f", "title": "How an 18-unit building on a Chicago boulevard disappeared and was re-zoned to allow 7 units", "url": "https://www.stevencanplan.com/2022/12/how-an-18-unit-building-on-a-chicago-boulevard-disappeared-and-was-re-zoned-to-allow-7-units/", "published_at": "2022-12-06T04:20:12+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4e68c6f1f", "title": "Prepare your kitchen for an induction stove in 2023", "url": "https://www.stevencanplan.com/2022/11/prepare-your-kitchen-for-an-induction-stove-in-2023/", "published_at": "2022-11-21T23:19:54+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4e76ed936", "title": "How I used ST_ClusterDBSCAN to locate clusters of multiple, similar parcels", "url": "https://www.stevencanplan.com/2022/11/how-i-used-st_clusterdbscan-to-locate-clusters-of-multiple-similar-parcels/", "published_at": "2022-11-18T10:35:32+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4e86e8e60", "title": "Shortlist: Four urbanism podcasts I listen to", "url": "https://www.stevencanplan.com/2022/11/shortlist-four-urbanism-podcasts-i-listen-to/", "published_at": "2022-11-04T04:25:49+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4e9635c49", "title": "Allowing cottage courts in Chicago requires changing the zoning code", "url": "https://www.stevencanplan.com/2022/08/allowing-cottage-courts-in-chicago-requires-changing-the-zoning-code/", "published_at": "2022-08-21T16:27:51+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4e9aa5d8f", "title": "Chicago Crash Browser updates with stats, filters, and news article links", "url": "https://www.stevencanplan.com/2022/08/chicago-crash-browser-updates-with-stats-filters-and-news-article-links/", "published_at": "2022-08-09T06:47:19+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4ea40d061", "title": "I tried to see the Vatican City train station", "url": "https://www.stevencanplan.com/2022/06/i-tried-to-see-the-vatican-city-train-station/", "published_at": "2022-06-17T20:46:41+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4ea7574da", "title": "Chicago Crash Browser is back", "url": "https://www.stevencanplan.com/2022/05/chicago-crash-browser-is-back/", "published_at": "2022-05-07T17:47:03+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4eb629a78", "title": "S-Bahn, RER, and Overground", "url": "https://www.stevencanplan.com/2022/01/s-bahn-rer-and-overground/", "published_at": "2022-01-08T04:51:52+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4ebdda6e7", "title": "INVEST South/West funding sources come from several corporations and philanthropies", "url": "https://www.stevencanplan.com/2021/12/invest-south-west-funding-sources-come-from-several-corporations-and-philanthropies/", "published_at": "2021-12-29T22:16:05+00:00" }, { "id": "01a0d2b1-59f2-73fc-8342-37e4ecb1b4a9", "title": "Two-flat journal 7: Plans are issued for bid", "url": "https://www.stevencanplan.com/2021/11/two-flat-journal-7-plans-are-issued-for-bid/", "published_at": "2021-11-15T17:24:32+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca42fa39305f", "title": "Where Chicago’s community colleges could build housing", "url": "https://www.stevencanplan.com/2021/07/where-chicagos-community-colleges-could-build-housing/", "published_at": "2021-07-15T05:30:39+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca42fb107f48", "title": "Metra is confusing, part 57 – Boarding trains at low-use stations", "url": "https://www.stevencanplan.com/2021/07/metra-is-confusing-part-57-boarding-trains-at-low-use-stations/", "published_at": "2021-07-03T16:04:15+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca42fc0c2a94", "title": "How to bike out to the Fox River Trolley Museum", "url": "https://www.stevencanplan.com/2021/05/how-to-bike-out-to-the-fox-river-trolley-museum/", "published_at": "2021-05-31T04:45:03+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca42fccd31b4", "title": "Two-flat journal 6: How to make an all-electric house", "url": "https://www.stevencanplan.com/2021/05/two-flat-journal-6-how-to-make-an-all-electric-house/", "published_at": "2021-05-02T21:52:36+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca42fd473def", "title": "Two-flat journal 5: Costs", "url": "https://www.stevencanplan.com/2021/04/two-flat-journal-5-costs/", "published_at": "2021-04-25T23:43:06+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca42fd7a5633", "title": "Two-flat journal 4: How’s the renovation going?", "url": "https://www.stevencanplan.com/2021/03/two-flat-journal-4-hows-the-renovation-going/", "published_at": "2021-03-22T21:04:51+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca42fe33a709", "title": "How to visualize the density of point data in a grid", "url": "https://www.stevencanplan.com/2021/02/how-to-visualize-the-density-of-point-data-in-a-grid/", "published_at": "2021-02-16T20:49:42+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca42fefce448", "title": "A new map for finding COVID vaccination sites in Illinois", "url": "https://www.stevencanplan.com/2021/02/a-new-map-for-finding-covid-vaccination-sites-in-illinois/", "published_at": "2021-02-16T20:14:09+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca42ff0c3d59", "title": "Two-flat owner journal 3: Choosing the right water heater", "url": "https://www.stevencanplan.com/2021/02/two-flat-owner-journal-3-choosing-the-right-water-heater/", "published_at": "2021-02-14T19:00:13+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca42ffbd10b5", "title": "Two-flat owner journal 2: Demolishing the interior", "url": "https://www.stevencanplan.com/2021/01/two-flat-owner-journal-2-demolishing-the-interior/", "published_at": "2021-01-27T03:56:03+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca4300440916", "title": "2020 year in review", "url": "https://www.stevencanplan.com/2021/01/2020-year-in-review/", "published_at": "2021-01-14T01:21:56+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca430106606f", "title": "The high rises of the Bronzeville lakefront", "url": "https://www.stevencanplan.com/2021/01/the-high-rises-of-the-bronzeville-lakefront/", "published_at": "2021-01-11T05:20:25+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca4301a0a252", "title": "Two-flat owner journal 1: Peoples Gas charges a lot of money for no gas", "url": "https://www.stevencanplan.com/2020/10/two-flat-owner-journal-1-peoples-gas-charges-a-lot-of-money-for-no-gas/", "published_at": "2020-10-05T15:37:59+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca43024c84bd", "title": "What is this place? Des Plaines “park” edition", "url": "https://www.stevencanplan.com/2020/10/what-is-this-place-des-plaines-park-edition/", "published_at": "2020-10-05T01:32:52+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca4303049df5", "title": "Chicago bonfire rules", "url": "https://www.stevencanplan.com/2020/09/chicago-bonfire-rules/", "published_at": "2020-09-04T04:59:27+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca4303936b1b", "title": "This is my process to improve the performance of my PostgreSQL database and queries", "url": "https://www.stevencanplan.com/2020/08/this-is-my-process-to-improve-the-performance-of-my-postgresql-database-and-queries/", "published_at": "2020-08-24T23:32:01+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca430422d156", "title": "My investment in crowdfunded projects hasn’t gone well", "url": "https://www.stevencanplan.com/2020/08/my-investment-in-crowdfunded-projects-hasnt-gone-well/", "published_at": "2020-08-02T14:33:42+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca4304df1211", "title": "Chicago’s Best Landlords, Inc.", "url": "https://www.stevencanplan.com/2020/07/chicagos-best-landlords-inc/", "published_at": "2020-07-22T05:14:21+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca43051f9d1d", "title": "Chicago’s Lake Street ‘L’ was originally supposed to be a monorail", "url": "https://www.stevencanplan.com/2020/04/chicagos-lake-street-l-was-originally-supposed-to-be-a-monorail/", "published_at": "2020-04-19T03:38:38+00:00" }, { "id": "01a0d2b1-da13-717d-a056-ca4305a5abb4", "title": "Damn, Metra is expensive", "url": "https://www.stevencanplan.com/2020/01/damn-metra-is-expensive/", "published_at": "2020-01-17T02:21:50+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a2356d62", "title": "My travel in 2019: North America and a quick hop over to Oceania", "url": "https://www.stevencanplan.com/2019/12/my-travel-in-2019-north-america-and-a-quick-hop-over-to-oceania/", "published_at": "2019-12-27T14:29:00+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a30caf07", "title": "Chicago’s massive parking footprint – as measured on December 25, 2019", "url": "https://www.stevencanplan.com/2019/12/chicagolands-massive-parking-footprint-as-measured-on-december-25-2019/", "published_at": "2019-12-25T15:49:49+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a3124525", "title": "Cities that have transit fare deals (capping) have fairer fares", "url": "https://www.stevencanplan.com/2019/08/cities-that-have-transit-fare-capping-have-fairer-fares/", "published_at": "2019-08-23T01:17:43+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a3b883b4", "title": "My idea for the Chicago prize: Build 1,000 ADUs collectively", "url": "https://www.stevencanplan.com/2019/07/my-idea-for-the-chicago-prize-build-1000-adus-collectively/", "published_at": "2019-07-18T16:36:21+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a3ff07e9", "title": "Pick the lowest and highest numbers in an array of numbers in PostgreSQL", "url": "https://www.stevencanplan.com/2019/06/pick-the-lowest-and-highest-numbers-in-an-array-of-numbers-in-postgresql/", "published_at": "2019-06-27T01:33:56+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a4c997fb", "title": "Lock off apartments: Does zoning allow them?", "url": "https://www.stevencanplan.com/2018/09/lock-off-apartments-does-zoning-allow-them/", "published_at": "2018-09-30T00:49:38+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a587dee5", "title": "Chicagoland’s massive parking footprint – as measured on September 16, 2018", "url": "https://www.stevencanplan.com/2018/09/the-amount-of-parking-in-chicago-as-measured-on-september-16-2018/", "published_at": "2018-09-16T07:07:21+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a5bde358", "title": "Why Jefferson Park residents should allow more housing", "url": "https://www.stevencanplan.com/2018/08/why-jefferson-park-residents-should-allow-more-housing/", "published_at": "2018-08-21T01:39:39+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a66ecdc5", "title": "In sci-fi, even parks get turned into parking lots", "url": "https://www.stevencanplan.com/2018/08/in-sci-fi-even-parks-get-turned-into-parking-lots/", "published_at": "2018-08-17T23:51:02+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a7539359", "title": "Don’t ban apartments on this vacant lot if you want more affordable housing – a case study", "url": "https://www.stevencanplan.com/2018/08/upzone-vacant-land-and-the-city-will-benefit-even-more-a-case-study/", "published_at": "2018-08-02T22:25:27+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a7a0596f", "title": "Elevated above the ‘L’", "url": "https://www.stevencanplan.com/2018/06/elevated-above-the-l/", "published_at": "2018-06-21T05:14:24+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a812bf01", "title": "Is it possible for us to “greenline” neighborhoods?", "url": "https://www.stevencanplan.com/2018/05/is-it-possible-for-us-to-greenline-neighborhoods/", "published_at": "2018-05-24T16:26:00+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a82f38ce", "title": "Which Chicago buildings have the worst energy efficiency?", "url": "https://www.stevencanplan.com/2018/04/which-chicago-buildings-have-the-worst-energy-efficiency/", "published_at": "2018-04-21T17:42:48+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a8e9dc80", "title": "Biss gives a short speech about good city-building policies", "url": "https://www.stevencanplan.com/2018/03/biss-gives-a-short-speech-about-good-city-building-policies/", "published_at": "2018-03-11T04:02:21+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a9252b19", "title": "Don’t know who to vote for? Start your research using my friends voter guide!", "url": "https://www.stevencanplan.com/2018/02/dont-know-who-to-vote-for-start-your-research-using-my-friends-voter-guide/", "published_at": "2018-02-27T01:27:37+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a9356920", "title": "New Illinois bill would prevent government employees from being paid to attend conferences", "url": "https://www.stevencanplan.com/2018/01/new-illinois-bill-would-prevent-government-employees-from-being-paid-to-attend-conferences/", "published_at": "2018-01-30T20:06:51+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a9673eb9", "title": "The genius of using ST_Subdivide to speed up PostGIS intersection comparisons", "url": "https://www.stevencanplan.com/2017/12/the-genius-of-using-st_subdivide-to-speed-up-postgis-intersection-comparisons/", "published_at": "2017-12-15T05:48:42+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953a9ac0b07", "title": "Upzone the 606", "url": "https://www.stevencanplan.com/2017/12/upzone-the-606/", "published_at": "2017-12-08T07:05:10+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953aaab4e44", "title": "Yes, please, to Accessory Dwelling Units and adopting Vancouver’s policy", "url": "https://www.stevencanplan.com/2017/11/yes-please-to-accessory-dwelling-units-and-adopting-vancouvers-policy/", "published_at": "2017-11-22T23:34:40+00:00" }, { "id": "01a0d2b2-7126-7066-8226-5953ab7076e3", "title": "How much of the land within walking distance of a CTA station is zoned to allow multi-family housing?", "url": "https://www.stevencanplan.com/2017/11/how-much-of-the-land-within-walking-distance-of-a-cta-station-is-zoned-to-allow-multi-family-housing/", "published_at": "2017-11-17T07:26:19+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb3ffb4373", "title": "Download GIS data from ArcGIS servers using a simple command", "url": "https://www.stevencanplan.com/2017/10/how-to-download-data-from-arcgis-mapservers-using-your-computers-command-line/", "published_at": "2017-10-21T20:21:53+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb40513d59", "title": "Fun with stats: Building permits by street name and number edition", "url": "https://www.stevencanplan.com/2017/09/fun-with-stats-building-permits-by-street-name-and-number-edition/", "published_at": "2017-09-17T12:10:58+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb40e0dc16", "title": "It’s impossible to track the many investment programs in disinvested Chicago neighborhoods", "url": "https://www.stevencanplan.com/2017/09/its-impossible-to-track-the-many-investment-programs-in-disinvested-chicago-neighborhoods/", "published_at": "2017-09-14T06:37:23+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb40f8c096", "title": "Amazing view of downtown Chicago as an Amtrak train cuts through wide open land in the South Loop", "url": "https://www.stevencanplan.com/2017/08/amazing-view-of-downtown-chicago-as-an-amtrak-train-cuts-through-wide-open-land-in-the-south-loop/", "published_at": "2017-09-01T04:34:18+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb4190a2e5", "title": "You won’t believe why Arcade Place in Chicago’s Loop was changed from an alley to a street", "url": "https://www.stevencanplan.com/2017/08/you-wont-believe-why-arcade-place-in-chicagos-loop-was-changed-from-an-alley-to-a-street/", "published_at": "2017-08-14T19:34:52+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb41f20349", "title": "A map of maps", "url": "https://www.stevencanplan.com/2017/08/a-map-of-maps/", "published_at": "2017-08-03T05:05:19+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb42156e66", "title": "Inclusionary zoning calculator will tell you how many units a developer can afford to make “affordable”", "url": "https://www.stevencanplan.com/2017/07/inclusionary-zoning-calculator-will-tell-you-how-many-units-a-developer-can-afford-to-make-affordable/", "published_at": "2017-07-28T15:50:36+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb42d9598e", "title": "360° spherical photos of Chicago from 300 feet in the air", "url": "https://www.stevencanplan.com/2017/06/360-spherical-photos-of-chicago-from-300-feet-in-the-air/", "published_at": "2017-06-28T18:16:56+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb4387e430", "title": "We can actually measure the “character of the neighborhood”", "url": "https://www.stevencanplan.com/2017/06/we-can-actually-measure-the-character-of-the-neighborhood/", "published_at": "2017-06-19T04:45:58+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb43d9a2ce", "title": "City selects buyer for former fire station in Rogers Park", "url": "https://www.stevencanplan.com/2017/06/city-selects-buyer-for-former-fire-station-in-rogers-park/", "published_at": "2017-06-02T00:52:16+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb44a6a72c", "title": "See how Chicago is a low-rise city from this 360° photo", "url": "https://www.stevencanplan.com/2017/05/see-how-chicago-is-a-low-rise-city-from-this-360-photo/", "published_at": "2017-05-24T20:43:55+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb44f59493", "title": "A Green Line train zooms by industrial and residential areas on the West Side", "url": "https://www.stevencanplan.com/2017/05/a-green-line-train-zooms-by-industrial-and-residential-areas-on-the-west-side/", "published_at": "2017-05-23T05:17:40+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb453d6563", "title": "See beyond the Bloomingdale Trail’s west end", "url": "https://www.stevencanplan.com/2017/05/see-beyond-the-bloomingdale-trails-west-end/", "published_at": "2017-05-16T22:36:18+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb46128bc3", "title": "The on-time trains and wonderful transit workers of Japan", "url": "https://www.stevencanplan.com/2017/04/the-on-time-trains-and-wonderful-transit-workers-of-japan/", "published_at": "2017-04-10T05:53:25+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb46f2c1a3", "title": "Where do those weird Chicago place labels on certain maps come from?", "url": "https://www.stevencanplan.com/2017/03/where-do-those-weird-chicago-place-labels-on-certain-maps-come-from/", "published_at": "2017-03-09T18:05:23+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb474d8acf", "title": "Looking back on my winter holiday in Europe two months ago", "url": "https://www.stevencanplan.com/2017/02/looking-back-on-my-winter-holiday-in-europe-two-months-ago/", "published_at": "2017-02-25T20:48:57+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb47516a91", "title": "Designing a new static map style for Chicago Cityscape", "url": "https://www.stevencanplan.com/2017/02/designing-a-new-static-map-style-for-chicago-cityscape/", "published_at": "2017-02-15T06:42:45+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb48501460", "title": "Chicago’s ward boundaries should go down alleys instead of main streets", "url": "https://www.stevencanplan.com/2017/02/chicagos-ward-boundaries-should-go-down-alleys-instead-of-main-streets/", "published_at": "2017-02-10T21:32:55+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb48ff9a7d", "title": "This map shows how transit access from Uptown would diminish if the Red Line wasn’t there", "url": "https://www.stevencanplan.com/2017/02/this-map-shows-how-transit-access-from-uptown-would-diminish-if-the-red-line-wasnt-there/", "published_at": "2017-02-09T22:55:48+00:00" }, { "id": "01a0d2b2-e5b9-7081-994c-b4eb499a3fa4", "title": "At least 2.5 percent of the land area in Chicago is covered in parking lots and garages", "url": "https://www.stevencanplan.com/2017/02/at-least-2-5-percent-of-the-land-area-in-chicago-is-covered-in-parking-lots-and-garages/", "published_at": "2017-02-06T00:11:39+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e827bc7c7", "title": "There are still $1 lots that no one has applied for", "url": "https://www.stevencanplan.com/2017/01/there-are-still-1-lots-that-no-one-has-applied-for/", "published_at": "2017-01-19T13:32:57+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e82adf2e3", "title": "Day two in Zurich: Combine transit and museums on a single pass", "url": "https://www.stevencanplan.com/2017/01/day-two-in-zurich-combine-transit-and-museums-on-a-single-pass/", "published_at": "2017-01-07T21:49:13+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e836f7364", "title": "You want a plan for Logan Square infrastructure? Let’s try out the one we got", "url": "https://www.stevencanplan.com/2016/12/you-want-a-plan-for-logan-square-infrastructure-lets-try-out-the-one-we-got/", "published_at": "2016-12-06T18:05:04+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e84370535", "title": "Bicyclists in Chicago can travel pretty far in 15 minutes", "url": "https://www.stevencanplan.com/2016/11/bicyclists-in-chicago-can-travel-pretty-far-in-15-minutes/", "published_at": "2016-11-21T20:48:48+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e852b6b86", "title": "To slow down drivers, we must speak up to our own drivers", "url": "https://www.stevencanplan.com/2016/11/to-slow-down-drivers-we-must-speak-up-to-our-own-drivers/", "published_at": "2016-11-21T02:57:05+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e85dcaaf0", "title": "Alder Pawar’s message to the 47th Ward – and all people", "url": "https://www.stevencanplan.com/2016/11/alder-pawars-message-to-the-47th-ward-and-all-people/", "published_at": "2016-11-11T19:44:44+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e86ba1410", "title": "Big Marsh Bike Park is the coolest new city park", "url": "https://www.stevencanplan.com/2016/11/big-marsh-bike-park-is-the-coolest-new-city-park/", "published_at": "2016-11-07T04:17:45+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e87888d0c", "title": "They didn’t pave paradise, but they still put up a parking lot", "url": "https://www.stevencanplan.com/2016/11/they-didnt-pave-paradise-but-they-still-put-up-a-parking-lot/", "published_at": "2016-11-02T00:23:23+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e884c040e", "title": "This is what I’m calling my #YIMBY party", "url": "https://www.stevencanplan.com/2016/10/this-is-what-im-calling-my-yimby-party/", "published_at": "2016-10-26T23:23:43+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e88563dd7", "title": "FOIA is great…if you know who and what to ask for", "url": "https://www.stevencanplan.com/2016/10/foia-is-great-if-you-know-who-and-what-to-ask-for/", "published_at": "2016-10-24T04:04:37+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e894b14cf", "title": "Vote “no” on the proposed constitutional amendment to create a “transportation lockbox”", "url": "https://www.stevencanplan.com/2016/10/the-illinois-ballot-includes-a-proposed-constitutional-amendment-to-create-a-transportation-lockbox/", "published_at": "2016-10-09T20:39:56+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e89525915", "title": "Should the Recorder of Deeds office go away?", "url": "https://www.stevencanplan.com/2016/10/should-the-recorder-of-deeds-office-go-away/", "published_at": "2016-10-08T23:36:27+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e89675665", "title": "Barcelona’s superblocks are being implemented now to convert car space to people space", "url": "https://www.stevencanplan.com/2016/10/barcelonas-superblocks-are-being-implemented-now-to-convert-car-space-to-people-space/", "published_at": "2016-10-04T04:36:56+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e899d3c51", "title": "German transit’s tight integration ensures timely connections in small cities", "url": "https://www.stevencanplan.com/2016/09/german-transits-tight-integration-ensures-timely-connections-in-small-cities/", "published_at": "2016-09-09T20:44:00+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e8a2ddd5b", "title": "Day trips from Amsterdam", "url": "https://www.stevencanplan.com/2016/07/day-trips-from-amsterdam/", "published_at": "2016-07-15T19:26:17+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e8a9ae9c7", "title": "Chicago has too many traffic signals", "url": "https://www.stevencanplan.com/2016/06/chicago-has-too-many-traffic-signals/", "published_at": "2016-06-21T16:23:18+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e8b4eda51", "title": "Essential apps for traveling in parts of Europe", "url": "https://www.stevencanplan.com/2016/05/essential-apps-for-traveling-in-parts-of-europe/", "published_at": "2016-05-29T23:28:43+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e8b50f629", "title": "There are many kinds of shared space", "url": "https://www.stevencanplan.com/2016/05/there-are-many-kinds-of-shared-space/", "published_at": "2016-05-29T22:54:53+00:00" }, { "id": "01a0d2b3-6f2c-7177-addd-208e8b6c2ee7", "title": "Oh, how Chicago land use is controlled by spot zoning", "url": "https://www.stevencanplan.com/2016/05/oh-how-chicago-land-use-is-controlled-by-spot-zoning/", "published_at": "2016-05-23T23:01:57+00:00" } ] posts Claim your blog

Back to stevencanplan.com

Blog · corpus.blog/blogs/stevencanplan.com/posts

stevencanplan.com

stevencanplan.com

2023

Determining dwelling unit count at an address using 1950 Census records original ↗

11 Mar 2023

Creating a PostgreSQL PostGIS function to get around a DataTables Editor limitation original ↗

9 Mar 2023

Avoid “VARCHAR” columns in PostgreSQL [PGSQL Phriday #006]original ↗

28 Feb 2023

Two-flat journal 8: Adding a third unit original ↗

18 Feb 2023

A short list of features of the Netherlands that I still try to wrap my head around original ↗

19 Jan 2023

2022

Chicago’s massive parking footprint – as measured on December 30, 2022 original ↗

31 Dec 2022

Automatically post your Flickr photos to your Mastodon account original ↗

24 Dec 2022

I ran errands and measured the CO2 concentration everywhere I went original ↗

24 Dec 2022

Say hello to Adanet, my new CO2 concentration monitor original ↗

17 Dec 2022

Deferring a trip to another time is a part of “trip chaining”original ↗

17 Dec 2022

How an 18-unit building on a Chicago boulevard disappeared and was re-zoned to allow 7 units original ↗

6 Dec 2022

Prepare your kitchen for an induction stove in 2023 original ↗

21 Nov 2022

How I used ST_ClusterDBSCAN to locate clusters of multiple, similar parcels original ↗

18 Nov 2022

Shortlist: Four urbanism podcasts I listen to original ↗

4 Nov 2022

Allowing cottage courts in Chicago requires changing the zoning code original ↗

21 Aug 2022

Chicago Crash Browser updates with stats, filters, and news article links original ↗

9 Aug 2022

I tried to see the Vatican City train station original ↗

17 Jun 2022

Chicago Crash Browser is back original ↗

7 May 2022

S-Bahn, RER, and Overground original ↗

8 Jan 2022

2021

INVEST South/West funding sources come from several corporations and philanthropies original ↗

29 Dec 2021

Two-flat journal 7: Plans are issued for bid original ↗

15 Nov 2021

Where Chicago’s community colleges could build housing original ↗

15 Jul 2021

Metra is confusing, part 57 – Boarding trains at low-use stations original ↗

3 Jul 2021

How to bike out to the Fox River Trolley Museum original ↗

31 May 2021

Two-flat journal 6: How to make an all-electric house original ↗

2 May 2021

Two-flat journal 5: Costs original ↗

25 Apr 2021

Two-flat journal 4: How’s the renovation going?original ↗

22 Mar 2021

How to visualize the density of point data in a grid original ↗

16 Feb 2021

A new map for finding COVID vaccination sites in Illinois original ↗

16 Feb 2021

Two-flat owner journal 3: Choosing the right water heater original ↗

14 Feb 2021

Two-flat owner journal 2: Demolishing the interior original ↗

27 Jan 2021

2020 year in review original ↗

14 Jan 2021

The high rises of the Bronzeville lakefront original ↗

11 Jan 2021

2020

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

5 Oct 2020

What is this place? Des Plaines “park” edition original ↗

5 Oct 2020

Chicago bonfire rules original ↗

4 Sept 2020

This is my process to improve the performance of my PostgreSQL database and queries original ↗

24 Aug 2020

My investment in crowdfunded projects hasn’t gone well original ↗

2 Aug 2020

Chicago’s Best Landlords, Inc.original ↗

22 Jul 2020

Chicago’s Lake Street ‘L’ was originally supposed to be a monorail original ↗

19 Apr 2020

Damn, Metra is expensive original ↗

17 Jan 2020

2019

My travel in 2019: North America and a quick hop over to Oceania original ↗

27 Dec 2019

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

25 Dec 2019

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

23 Aug 2019

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

18 Jul 2019

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

27 Jun 2019

2018

Lock off apartments: Does zoning allow them?original ↗

30 Sept 2018

Chicagoland’s massive parking footprint – as measured on September 16, 2018 original ↗

16 Sept 2018

Why Jefferson Park residents should allow more housing original ↗

21 Aug 2018

In sci-fi, even parks get turned into parking lots original ↗

17 Aug 2018

Don’t ban apartments on this vacant lot if you want more affordable housing – a case study original ↗

2 Aug 2018

Elevated above the ‘L’original ↗

21 Jun 2018

Is it possible for us to “greenline” neighborhoods?original ↗

24 May 2018

Which Chicago buildings have the worst energy efficiency?original ↗

21 Apr 2018

Biss gives a short speech about good city-building policies original ↗

11 Mar 2018

Don’t know who to vote for? Start your research using my friends voter guide!original ↗

27 Feb 2018

New Illinois bill would prevent government employees from being paid to attend conferences original ↗

30 Jan 2018

2017

The genius of using ST_Subdivide to speed up PostGIS intersection comparisons original ↗

15 Dec 2017

Upzone the 606 original ↗

8 Dec 2017

Yes, please, to Accessory Dwelling Units and adopting Vancouver’s policy original ↗

22 Nov 2017

How much of the land within walking distance of a CTA station is zoned to allow multi-family housing?original ↗

17 Nov 2017

Download GIS data from ArcGIS servers using a simple command original ↗

21 Oct 2017

Fun with stats: Building permits by street name and number edition original ↗

17 Sept 2017

It’s impossible to track the many investment programs in disinvested Chicago neighborhoods original ↗

14 Sept 2017

Amazing view of downtown Chicago as an Amtrak train cuts through wide open land in the South Loop original ↗

1 Sept 2017

You won’t believe why Arcade Place in Chicago’s Loop was changed from an alley to a street original ↗

14 Aug 2017

A map of maps original ↗

3 Aug 2017

Inclusionary zoning calculator will tell you how many units a developer can afford to make “affordable”original ↗

28 Jul 2017

360° spherical photos of Chicago from 300 feet in the air original ↗

28 Jun 2017

We can actually measure the “character of the neighborhood”original ↗

19 Jun 2017

City selects buyer for former fire station in Rogers Park original ↗

2 Jun 2017

See how Chicago is a low-rise city from this 360° photo original ↗

24 May 2017

A Green Line train zooms by industrial and residential areas on the West Side original ↗

23 May 2017

See beyond the Bloomingdale Trail’s west end original ↗

16 May 2017

The on-time trains and wonderful transit workers of Japan original ↗

10 Apr 2017

Where do those weird Chicago place labels on certain maps come from?original ↗

9 Mar 2017

Looking back on my winter holiday in Europe two months ago original ↗

25 Feb 2017

Designing a new static map style for Chicago Cityscape original ↗

15 Feb 2017

Chicago’s ward boundaries should go down alleys instead of main streets original ↗

10 Feb 2017

This map shows how transit access from Uptown would diminish if the Red Line wasn’t there original ↗

9 Feb 2017

At least 2.5 percent of the land area in Chicago is covered in parking lots and garages original ↗

6 Feb 2017

There are still $1 lots that no one has applied for original ↗

19 Jan 2017

Day two in Zurich: Combine transit and museums on a single pass original ↗

7 Jan 2017

2016

You want a plan for Logan Square infrastructure? Let’s try out the one we got original ↗

6 Dec 2016

Bicyclists in Chicago can travel pretty far in 15 minutes original ↗

21 Nov 2016

To slow down drivers, we must speak up to our own drivers original ↗

21 Nov 2016

Alder Pawar’s message to the 47th Ward – and all people original ↗

11 Nov 2016

Big Marsh Bike Park is the coolest new city park original ↗

7 Nov 2016

They didn’t pave paradise, but they still put up a parking lot original ↗

2 Nov 2016

This is what I’m calling my #YIMBY party original ↗

26 Oct 2016

FOIA is great…if you know who and what to ask for original ↗

24 Oct 2016

Vote “no” on the proposed constitutional amendment to create a “transportation lockbox”original ↗

9 Oct 2016

Should the Recorder of Deeds office go away?original ↗

8 Oct 2016

Barcelona’s superblocks are being implemented now to convert car space to people space original ↗

4 Oct 2016

German transit’s tight integration ensures timely connections in small cities original ↗

9 Sept 2016

Day trips from Amsterdam original ↗

15 Jul 2016

Chicago has too many traffic signals original ↗

21 Jun 2016

Essential apps for traveling in parts of Europe original ↗

29 May 2016

There are many kinds of shared space original ↗

29 May 2016

Oh, how Chicago land use is controlled by spot zoning original ↗

23 May 2016