Category: Bicycling

Finding a new way to measure cities’ bike friendliness in the United States

A really smart person could come up with a way to measure day-to-day bike friendliness based on how well cities adhere to standards that keep roads clear of obstructions that further frustrate the commute, like construction projects that squeeze bikes and cars together. 

I work at home. There are some days when I only leave my house to get milk from the Mexican grocery store at the end of my block (which makes awesome burritos). That means I ride my bike half as much as people who commute to work. on their bikes. Today I had a bunch of errands to run: drop off stuff, buy stuff, take pictures of stuff for my blog, Grid Chicago.

It was a very frustrating experience. I don’t need to go into details about how I was harassed by people who the state so graciously awarded a license to drive. But it happened. And it happens a hundred times a day to people cycle commuting in Chicago. I got to thinking about “bike friendly” cities. Is there a way to incorporate driver attitudes in there? I tweeted:

[tweet_embed id=264575958374305792]

Later I had the idea to use some very simple but objective measurements to create a new bike friendliness metric. It would help ensure that “Silver” (a ranking the League of American Bicyclists [LAB] uses) in one city means the same as “Silver”. It can expand from here but basically it works like this:

  • The share of people going to work who go by bike is a proxy for how “friendly” a city is to biking.
  • If a city has a lot of people biking to work, it must be friendly.
  • If a city has a few people biking to work, it must be non-friendly.
  • Cities are compared to each other to determine friendly and non-friendly.
  • The metric uses standard deviation to score cities.

Stop me if this has already been done.

I created a spreadsheet that lists the top 10 populous cities in the United States. I then added 10 more cities: Austin, Boston, Davis, Madison, Minneapolis, Portland, San Francisco, Seattle, and Washington, D.C. In the next column I listed their bike commute share from the American Community Survey 2006-2010 5-year estimates. I calculated the standard deviation and mean of these shares and then in another column used Apple Numbers’s STANDARDIZE function:

The STANDARDIZE function returns a normalized value from a distribution characterized by a given mean and standard deviation.

I think that’s what I want. And the output is close to what I expected. I then found the LAB ranking for each city and found the variance of each ranking to see how far apart each city within one ranking was from another city in the same ranking. The results were interesting: the higher the ranking, the more variance there was.

Hurricane Sandy prompted a lot of New Yorkers to bike. It made headlines, even. Photo by Doug Gordon. 

I wanted to add another metric of bike friendliness, and that’s density. To me, a higher density of people would mean a higher density of places to go (shop, eat, learn, enjoy) and friends and family would be closer, too. Or the possibility of meeting new people nearby would be higher. Yeah, I’m making a lot of assumptions here. So I applied the STANDARDIZE function there as well. I added this number to the previous STANDARDIZE result and that became the city’s score.

So, in this new, weird ranking system, the most bicycle friendly cities are…drum roll please…

  1. Davis, California (Platinum)
  2. New York City (Silver) *
  3. San Francisco (Gold) *
  4. Boulder (Platinum)
  5. Boston (Silver)
  6. Philadelphia (Silver)
  7. Tie: Chicago*, Washington, D.C. (Silver)
  8. Tie: Portland* (Platinum), Minneapolis* (Gold)

Remember, I said above that any author of a list should spend at least a day cycling in each city. I’ve starred the cities where I’ve done that – I’ve cycled in 5 cities for at least a day.

I only calculated 20 cities. Ideally I’d calculate it for the top 50 most populous cities AND for every city that’s been ranked by LAB.

LAB cities list (PDF). My spreadsheet (XLS).

See the Houten “Fietstransferium”, and other bikes and transit commentary

Video by Mark Wagenbuur, aka markenlei on YouTube. See his original blog post about it.

I’m going to take a wild guess and say that “Fietstransferium” means “bike transfer building”. It’s a structure underneath the train tracks at the Houten (in the Netherlands) main railway station (it has a secondary station on the same line a little bit south of the main one). You roll in directly from a car-free street in the center of a town, park your bike, and walk up to the platforms. Also available in the Fietstransferium are bike rentals (likely OV-fiets) and bike repair. It wasn’t open when I visited Houten in January 2011.

From the video (and from other sources) 60% of NS passengers arrive by bike. Good connections between bikes and trains helps maintain that access rate, but probably also helps increase it. Bike connections to major train stations in Chicago is woeful, even at the stations that are new enough to support a good connection. Let’s call Houten’s bike to train connection quality “roll in, walk 100 feet, service”: you roll into the bike parking area, and walk upstairs to your train (there’s even a ticket machine in the bike parking area). This differs from “roll on service” as that means you roll your bike into the train.

Chicago

The LaSalle Street Metra Station got an upgrade in bike connections this year when the “intermodal center” adjacent to it on Congress Parkway and Financial Place was added. It came with bike parking, an elevator, and a staircase with bike ramp. The station has other access points, which are very well hidden. Unguarded.

Well-placed bike parking
The LaSalle Street intermodal center. 

Northwestern (Ogilvie) Station lacks indoor and guarded bike parking, and any that’s available is far away from the tracks. The sheltered bike parking is very undesirable, dark, and dirty; I don’t recommend parking on Washington Street. Nor do I recommend parking on any of the sidewalks surrounding the station block.

Union Station is similar to Northwestern Station: all bike parking is unguarded and far from the tracks. Millennium Station. Same problems.

The nexus of bikes and transit is something I enjoy planning, and talking and writing about. Read my past articles on the subject. I’ve created the biggest and best collection of bikes and transit photos in the eponymous Flickr group. It’s an important part of the Chicago Bike Map app. You can load train stations on the map, search for them, and get information about when and how to board a train or bus with your bike. Coming soon is information on accessible stations (which have wide gate turnstiles making for self-service bike entry) and stations that aren’t accessible but have the same wide gate turnstiles (called TWA, or turnstile wheelchair accessible).

Additionally, none of these stations are accessible by good bike lanes. Only Union Station and Northwestern Station have adjacent bike lanes, and then only ones that are north-south (Clinton and Canal). As the Chicago Department of Transportation noted in its multiple presentations about the upcoming installation of the Union Station bus intermodal station, biking on Canal Street is not good and the bike lane will probably be reconfigured during the Central Loop BRT project. To summarize, the connection quality that Chicago’s downtown train stations provide is “confusing service”: where does one park? will the bike be safe? how does one get to the platform now?

Getting to Union Station

Biking on Canal Street outside Union Station. It has multiple entrances and access routes but which one is best?  Another photo from biking on Canal Street.

Near Northwestern Station, the Washington Street bike lane ends abruptly three blocks away at Desplaines Street. The Madison Street bike lane doesn’t reach Northwestern Station, nor would it be effective with its current design, as it would constantly be occupied by things that aren’t bicycles.

Speeding zone

Biking on Washington Street, a very wide fast street, whose bike lane ends very soon (in the middle ground) where then you find yourself competing for space with buses and right-turning cars. As soon as one is “competing” on a street, the street fails to provide good space for either mode. 

Harrison Street just south of the LaSalle Street Station is usually a good street to bike on, but it lacks the kind of bikeway infrastructure that attracts new people to transportation bicycling, and more trips to be made. (I’ve lately been thinking of ways to synthesize the argument about why protected and European-style bikeway infrastructure is necessary, so here goes: Bicycle usage will not increase without them.)

San Francisco

Bikes on Bart Pilot Aug. 3, 2012

Photo of a man walking with his bicycle in a BART station by San Francisco Bicycle Coalition. 

BART in the San Francisco Bay Area tested in August policy of having no bike blackout periods on Fridays. That meant people could bring their bikes on the trains at all times on Fridays in August, and not just outside rush periods. Showing their high level of attention planning and policy, the agency evaluated the program with a proper survey. There’s a meeting tomorrow with the BART Bicycle Task Force; Chicago’s Regional Transportation Authority should have such a group!

Stolen Bike Registry data: Which train stations have the most bike theft?

If you can help it, don’t park your bike on the sidewalk under the tracks at the Clybourn Metra Station. Too many opportunities for theft here. 

The Stolen Bike Registry is a website created by Chicagoans for people to notify the community that their bike has been stolen. I make no claims to the accuracy or completeness (or anything) about this list or the dataset from which it was created. Because of less than optimal data collection practices, and a diversity of website users, the location information is difficult to comb through and present. I’ve used Google Refine to clean up some of the location data so that I can pick out the theft locations that represent CTA or Metra stations.

This is a list of the most reported bike theft locations that are CTA or Metra stations, from about June 13, 2006, to April 2, 2011, representing 1,740 bike theft reports*. It’s not known how many bike thefts were reported to the police because they don’t know.

CTA (13 stations)

Logan Square Blue Line CTA 8
Rockwell Brown Line CTA 5
Addison Brown Line CTA 2
Fullerton Red/Brown Line CTA 2
Paulina Brown Line CTA 2
Western & Milwaukee (Blue Line) CTA 2
Western Brown Line CTA 2
Addison Blue Line CTA 1
Chicago Brown Line CTA 1
Damen Blue Line CTA 1
Ashland Orange Line CTA  1
Cumberland Blue Line CTA 1
Wellington Brown Line CTA 1

The new bike racks at Clybourn Metra station are in a more visible spot. Maybe there’s even a security camera pointed at them some of the time. 

Metra (24 stations)

Clybourn Metra 19
Ravenswood Metra 18
Edgebrook Metra 4
Evanston Main Street Metra 2
Forest Glen Metra 2
Healy Metra 2
Lake Cook Metra 2
Ogilvie Metra 2
57th Street Metra 1
College Avenue Metra Train Station 1
Corner of Maple & Church in downtown Evanston, near Metra 1
Glenview Metra Station 1
Harlem Metra Station Berwyn, IL 1
Irving Park Metra Stop 1
Jefferson Park Metra 1
LaSalle Street Metra 1
Mayfair Metra 1
Metra Station at Davis Street, Evanston 1
Morton Grove Metra Station 1
Prairie Crossing Metra Station 1
Rogers Park Metra 1
Union Station Metra 1
Western Metra Station 1
Wilmette Metra 1

* Reports come from around the world. 10 dates have been excluded because their dates were anomalous, empty, or not possible.

Updated September 30 to correct a Metra station and combine it with another.

Testing the Abus Bordo “folding” lock

Testing the Abus Bordo lock

Abus Bordo 6500 Granit X-Plus 85cm locked around my WorkCycles Fr8’s frame, front wheel, and the standard Chicago bike rack (a u-rack).

Updated May 2016: After having two keys break inside the lock, I can no longer recommend it. While Abus replaced the first lock for free, I didn’t bother asking them to replace the second lock because I felt the problem would happen again. The keys broke, in part, because of the way I turned the key, as the lock rested, putting a lot of pressure on, and bending, the key. I did it like this so I could detach the lock with one hand. I now recommend chain locks because they fit around all kinds of fixed objects. Abus locks are still really good quality. I’ve been using this Abus chain lock for two months and I like it – it won’t have the key breakage problem because I have to grab and hold the lock before I can insert the key.

—–

I’ve been using the Abus Bordo 6500 Granit X-Plus lock for my Fuji Royale fixed gear bicycle for about three weeks now. Previously I had been using a Kryptonite Evolution Series 4 Standard u-lock. The Abus Bordo lock style is very hard to describe; Abus calls it the “foldable lock”. It has a small block for the locking mechanism, and 6 rotating and connecting bars (“links”). One bar is fixed to the locking block, and the last bar gets hooked into the other side of the locking block. (They have the unique ability to be locked to another Bordo, in a chain of them.)

I’m not a lock designer, nor a bicycle thief, so I cannot talk about the advantages or disadvantages of this design over another lock design (like the ubiquitous u-lock, the style I’ve been using for six years). I can tell you its advantages on use: it’s a lot easier to use than a u-lock as it makes possible additional locking situations. The 6 flexible bars (or links) means you can wrap the lock around a variety of bike rack sizes and shapes, through two bikes, or through your bike’s frame and wheel (which is annoying to do with u-locks).

It took me a few days to find the fastest way to lock my bike with the Bordo and I think I’ve found it. Unlock the locking block and let all of the 6 bars drop towards the ground. Then thread the first one through your wheel (no handling necessary), grab it from the other side of your bike, pull it around the fixed object to which you’re locking, and pull it towards the locking block. It takes the same or less time to lock with the Bordo than with a u-lock. U-locks are difficult to get through a front wheel and frame unless the bike rack is empty and you’re the first one there, meaning you get to decide how to place your bike against the rack’s metal tubes.

Testing the Abus Bordo lock

I can fairly quickly lock with a Bordo by slipping the open link through the wheel spokes first, then around the fixed object. Then with both hands I grab each end of the lock and insert the open link into the locking bracket, shuffling them around the bike frame until the open link can reach the locking bracket. The Bordos are covered in a rubber-feeling plastic that protects your frame’s cover/coating.

The specific Bordo model I’ve been using is the Granit X-Plus 6500, which weighs a little more than the standard model (see weight specifications below). It comes with a carrying case that straps to any tube on your bicycle. There are two ways to mount the case: temporary and semi-permanent. With the temporary method, you wrap the velcro straps around the seat tube (reduce the chance for theft of the carrier by wrapping zip ties on it). By having it attached this way, you can move it to another bike in 30 seconds. The semi-permanent method lets you screw the case into braze-ons on the tubes, typically ones meant for a water bottle cage.

My new bike, a WorkCycles Fr8, provides me a new opportunity to test the folding lock’s abilities. The Fr8 has very wide tubes and large wheel rims and tires. I suspect that my Kryptonite u-lock won’t be able to wrap around the front wheel, frame, and the fixed object to which I’m locking. I tested the Bordo: it can definitely hold the front wheel, frame, and fixed object, but only if I’m really close to the fixed object. I haven’t tested the u-lock yet.

For people who are concerned about weight, they are as follows:

  • Abus Bordo 6000 75cm, 1.03 kg
  • Abus Bordo 6000 90cm, 1.22 kg
  • Abus Bordo Granit X-Plus 6500 85 cm, 1.58 kg
  • Kryptonite Evolution Series 4, 1.70 kg

The top-of-the-line Abus Bordo still weighs less than the Kryptonite Evolution Series 4. Kryptonite’s New York Standard weighs 1.97 kg. See the full product line up on Abus’s website and see Kryptonite’s line up of u-locks.

This review shouldn’t be taken as a dis-recommendation of the Kryptonite u-locks. I like them – I have three – and they may have prevented theft of the various bicycles I’ve used for 6 years; the lock in combination with other factors prevented theft, which can’t be known unless my bike was monitored 24/7 (in other words, have no idea if anyone’s tried to steal my bicycles). The Bordo lock’s sole disadvantage is its price: $100 for the short version, and $117 for the 15cm longer version. The Granit X-Plus is $153. My personal bike locking strategy is to buy the most expensive lock you can afford and to make your bicycle harder to steal than the bikes you park next to. The Bordo should do that.

My only gripe about the lock is the velcro strap on the carrier: it’s long and sticks out to the side a little and scratches my leg on every pedal. I used a zip tie to hold it down; I would prefer a kind of slot to insert the extra velcro to keep it out of the way.

Abus was a sponsor of the 2012 Cargo Bike Roll Call, donating a Bordo 6100 combination lock to the raffle. They gave me a second lock to test, a Bordo 6000, 75cm. However, I gave that lock to Brandon Gobel and I was given the lock I’m using in this review by Harry (Hans) of Larry vs. Harry. Here’s Brandon’s short review:

I like this lock for its compact size and light weight, while maintaining strength. It takes longer to lock, unlock and put in the frame holster than a mini u-lock, though. [For comparison, the Kryptonite Mini weighs 0.98kg and the lock Brandon is using is 1.03kg.] I carry the mini u-lock in my back pocket so it’s slightly more convenient. However, the Bordo is much more versatile, and you can wrap it around objects that are larger than the typical Chicago bike rack.

Testing the Abus Bordo lock

This photo of a Kryptonite mini lying on top of the Bordo 6000 75cm shows the open areas of each lock. The Bordo has a significantly larger open area and weighs less. 

Both of us are also using an Abus brand rear-wheel lock. Mine came with the WorkCycles Fr8 while Brandon’s was a gift from Harry. We both appreciate the piece of mind and ease of use of the rear-wheel locks. See all photos in the Abus lock review gallery.

 

Buying links

How to split a bike lane in two and copy features with QGIS

A screenshot of the splash image seen on users with iPad retina displays in landscape mode. 

To make the Chicago Offline Bike Map, I need bikeways data. I got this from the City of Chicago’s data portal, in GIS shapefile format. It has a good attribute table listing the name of the street the bikeway is on and the bikeway’s class (see below). After several bike lanes had been installed, I asked the City’s data portal operators for an updated shapefile. I got it a month later and found that it wasn’t up-to-date. I probably could have received a shapefile with the current bikeway installations marked, but I didn’t have time to wait: every day delayed was one more day I couldn’t promote my app; I make 70 cents per sale.

Since the bikeway lines were already there, I could simply reclassify the sections that had been changed to an upgraded form of bikeway (for example, Wabash Avenue went from a door zone-style bike lane to a buffered bike lane in 2011). I tried to do this but ran into trouble when the line segment was longer than the bikeway segment that needed to be reclassified (for example, Elston Avenue has varying classifications from Milwaukee Avenue to North Avenue that didn’t match the line segments for that street). I had to divide the bikeway into shorter segments and reclassify them individually.

Enter the Split Features tool. QGIS is short on documentation and I had trouble using this feature. I eventually found the trick after a search that took more time than I expected. Here’s how to cut a line:

  1. Select the line using one of the selection tools. I prefer the default one, Select Features, where you have to click on the feature one-by-one. (It’s not required that you select the line, but doing so will ensure you only cut the selected line. If you don’t select the line, you can cut many lines in one go.)
  2. Toggle editing on the layer that contains the line you want to cut.
  3. Click Edit>Split Features to activate that tool, or find its icon in one the toolbars (which may or may not be shown).
  4. Click once near where you want to split the line.
  5. Move the cursor across the line you want to split, in the desired split location.
  6. When the red line indicating your split is where you desire, press the right-click mouse button.

Your line segment has now been split. A new entry has been added to the attribute table. There are now two entries with duplicate attributes representing that together make up the original line segment, before you split it.

This screenshot shows a red line across a road. The red line indicates where the road will be split. Press the right-click mouse button to tell QGIS to “split now”.

After splitting, open the attribute table to see that you now have two features with identical attributes. 

Copying features in QGIS

A second issue I had when creating new bikeways data was when a bikeway didn’t exist and I couldn’t reclassify it. This was the case on Franklin Boulevard: no bikeway had ever been installed there. I solved this problem by copying the relevant street segments from the Transportation (roads) shapefile and pasted them into the bikeways shapefile. New entries were created in the attribute table but with blank attributes. It was simple to fill in the street name, class, and extents.

Chicago bikeways GIS description

Bikeway classes (TYPE in the dataset) in the City of Chicago data portal are:

  1. Existing bike lane
  2. Existing marked shared lane
  3. Proposed on-street bikeway
  4. Recommended bike route
  5. Existing trail
  6. Proposed off-street trail
  7. Access path (to existing trail)
  8. Existing cycle track (also known as protected bike lane)
  9. Existing buffered bike lane

It remains to be seen if the City will identify the “enhanced marked shared lane” on Wells Street between Wacker Drive and Van Buren street differently than “existing marked shared lane” in the data.