Category: Urban Planning

Outta left field: I recreated the city’s contractor listing website

March 13, 2014 / / 2 Comments
The site looks good and works quickly on mobile devices.

LicensedChicagoContractors.com looks good and works quickly on mobile devices.

I’m working on a secret project to get something installed on the public way. The process to find out how to do it is as arduous as getting it done because you never finish learning the process. Every time you think you’ve figured something out, there’s something else.

To get the secret project installed I need a licensed contractor. Not only do a need a licensed contractor, but they must have the license to do work in the public way (versus doing work at your private property).

The Chicago Department of Buildings publishes a continually updated list of licensed contractors on its website but it’s annoying to use. There’s no search, no permanent links, and if you leave the window open long enough this weird session manager kicks in and stops you from browsing to the next page of results.

I asked my followers on Twitter the best way to scrape the data. The ever-amusing Dan O’Neill, who leads the Smart Chicago Collaborative (which hosts the Chicago Crash Browser), recommended just copying and pasting all 10 pages. That would work fine for the first time, but I might need to do it a second time when the data updates. Nick Bennett jumped in and used Selenium, a tool that automates web browsers. He said, “it’s inefficient but for a small job like that I figured why bother with something faster”.

I imported the data into a MySQL table and ran through some of my “standard” data cleaning methods (like trimming leading and trailing spaces, removing odd characters, and extracting good information into other columns, like phone numbers and ZIP codes).

With PHP – my favorite web language – I created a single page website that loads all 3,930 licensed general contractors extremely fast, loads the DataTables JavaScript library to enhance the table with search and sort. I used Bootstrap to make a responsive design meaning it adjusts to fit multiple screen sizes including smartphones and tablets.

I call it LicensedChicagoContractors.com.

The new website still doesn’t solve my problem of finding a company that can do work in the public way – I’m still working on this. The last online dataset I could find is on the city’s old http://egov.cityofchicago.org domain, and was cached by the Internet Archive’s Wayback Machine on January 25, 2010. Ideally this information – plumbers, public way, and general contractors – should be posted on the City’s data portal.

One day left to enter the Divvy Data Challenge

March 10, 2014 / / 0 Comments
Divvy dock post-polar vortex

Divvy bikes have been covered in snow frequently this winter. Photo by Jennifer Davis.

As self-proclaimed Divvy Data Brigade Captain* in Chicago’s #opendata and #opengov community I must tell you that all Divvy Data Challenge submissions are due tomorrow, Tuesday, March 11. Divvy posted:

Help us illustrate the answers to questions such as: Where are riders going? When are they going there? How far do they ride? What are top stations? What interesting usage patterns emerge? What can the data reveal about how Chicago gets around on Divvy?

We’re interested in infographics, maps, images, animations, or websites that can help answer questions and reveal patterns in Divvy usage. We’re looking for entries to tell us something new about these trips and show us what they look like.

I’ve seen a handful of the entries so far, including some to which I’ve contributed, and I’m impressed. When the deadline passes I’ll feature my favorites.

Want to play with the data? You should start with these resources, in order:

  1. Divvy Data Challenge – rules and data download
  2. divvy-munging – download an enhanced version of Divvy’s data, with input from several #ChiHackNight hackers
  3. Bike Sharing Data Hackpad – this is where I’m consolidating all of the links to projects, visualizations, analysis, data, and blog posts.
  4. Divvy Data Google Group – a discussion group with over 25 members
  5. #DivvyData – chat on Twitter

It’s not too late to get started now on a project about the bikes themselves. Nick Bennet has crunched the numbers on the bikes’ activity and posted them to the Divvy Data Google Group. Want to use his data and initial analysis? He said “run with it”.

Share your work ahead of time and leave a comment with a link to your project.

* This title is a play on Christopher Whitaker’s position as Code For America Brigade Captain and all around awesome-doer of keeping track of everything that’s going on in these communities and publishing event write-ups on Smart Chicago Collaborative.

What if Metra employees were late to work as often as Metra passengers?

February 10, 2014 / / 8 Comments
trainmageddon

A malfunctioning Metra Electric train in January. Photo by Eric Rogers.

It was a big deal to news media this morning when new Metra CEO Don Orseno reported at an Illinois House mass transit committee hearing that the commuter-focused rail system experienced a 30% on-time rating in January, when the “polar vortex” hit. (Apparently polar vortex is not an event that happens to a place, but is the name of a climate pattern that’s always there hovering above Canada and occasionally dips down over the United States.)

Most Metra passengers are commuters, going to work. A hair over 300,000 travel each weekday; service is drastically lowered on weekends and holidays, offering less than half the service of weekdays.

What if the organization of Metra, including all 2,500 employees in addition to the contracted railroad workers (let’s say 3,000 people), showed up to work with the same performance rating that their passengers experience?

First, Orseno – a career railroader who drives to work from Manhattan where a train comes leaves three times each day – would miss 11 work days of work each year (of 260 work days), based on their overall 95.8% on-time rating in 2012. Some routes are worse and others better. But collectively 3,000 people would miss 32,760 work days each year. That’s a lot of missed work.

Put another way, everybody – all 3,000 of them – is going to show up 20.16 minutes late to work because they’re missing 87.36 hours each year (of 2,080 hours they’re supposed to work and being 4.2% hours late). But again, I have no idea who’s working 8 hours and who’s working longer. (One of the problems Metra had during #Chiberia is that many workers hit the federally mandated limit and there weren’t always workers to take their place.)

Thankfully the Chicago Transit Authority, Pace, and ever-expanding highways and tollways are available to pick up the slack in Chicagoland’s transportation supply.

Another thing, this post is full of averages of averages, so it’s really imprecise. Today, Metra was reporting delays on a single train run of 16-100 minutes – a pretty broad estimate, but another train had a possible delay of 26-110 minutes. During the worst storm Metra experienced on January 5th and 6th, some train runs dumped passengers on platforms in subzero temperature.

Orseno reported today at the committee hearing that a “I don’t want to say middle-level” manager at Union Pacific made the call to dump the passengers. This has been “corrected” by only allowing a senior level staffer at Union Pacific make this call. Metra, which doesn’t have any performance-related incentives in its contracts with the freight railroads, apparently cannot stop this decision.

I’m waiting for the day when Metra is run like a transit system and not a railroad.

Note: I excluded vacation days because, well, no law requires organizations to offer paid or unpaid vacation days and there are probably several tiers of vacation-giving at Metra that I don’t know about.

Car parking really is the root of all of Chicago’s transportation ills

January 27, 2014 /

Two pools! Read more about the Maryville Hospital site proposal from JDL Development.

Parking has a greater effect on new traffic impacts in a dense neighborhood, more than bike lanes, more than road diets, and more than the number of people who live or will move there.

Yet we require so gosh darn much of it in Chicago! A developer who proposed a 25-story residential tower in Uptown, one block from the lakefront, essentially said that parking is a waste. He’s already proposing the lowest without a special ordinance that favors (singles out) his development.

 

I think that Streetsblog Chicago, where I work, could have a part-time writer dedicated to new property developments and parking issues. But for now it’ll stay my beat!

Wayfinding signs at Van Buren Street Metra station are incomplete

January 13, 2014 /
New RTA interagency transfer signage near Van Buren Street Metra Electric station

“B” marks a new bus boarding area near the Van Buren Street Metra Electric station.

The Regional Transportation Authority has spent $2 million to improve wayfinding between CTA, Metra, and Pace train stations and bus stops in a needed effort to connect newbies and long-time residents to their next transfer.

Some of the signs need to show better information, though. The RTA installed signs at the Van Buren Street Metra Electric station at Michigan Avenue that create “bus loading groups,” similar to bus bays at suburban park & rides.

It works like this: you come across the nearest bus stop – I happened upon boarding area B – hoping to find the route you need. Instead, though, that route stops at boarding area A. The sign at boarding area B points you in the direction of A and from where you stand you can see a sign that identifies A.

RTA’s signs have two issues. First, they don’t tell you that boarding area C is across the street – unless you inspect the small map – and instead point you in the direction of A (from B). If you walk in the direction of the arrow from boarding area B you will not run into boarding area C or a sign that tells you where to cross the street in order to access C.

The first issue creates the second problem: by reading and relying upon the sign’s text you can’t know at which boarding area, A or C, you should board a bus route that stops at both boarding areas. (Those who also study the maps on another side of the sign will have better luck.) That’s because the same route operates in both directions and if you’re not familiar with the route, you won’t know which direction takes you towards your destination.

New RTA interagency transfer signage near Van Buren Street Metra Electric station

Both boarding areas A and C will get you on the 3, 4, J14, and 26, but only the map on the other side tells you which direction they go. Also, while the arrow points in the direction of boarding areas A and C, only the map tells you that A is across the street.

The fix seems an easy one. First, point the arrows on A and B across the street instead of north or south towards B or A, and add an intermediary sign along the walking path that communicates that “boarding area C is across the street.” Then, update the signs to indicate which direction the bus routes are going so that travelers are assured they need to visit C across the street for King Drive buses going towards Bronzeville or A for King Drive buses going toward Streeterville.

The RTA has installed other signage in this program at 95th and Western (CTA & Pace), Joliet Union Station (Metra & Pace), and Davis Station in Evanston (CTA, Metra, & Pace).