Tag: analysis

Just how many taxi vs. bicycle crashes are there? A Google Refine story

On this Chicagoist story about how IDOT will now collect data on doorings (instead of ignoring that crash type as they preferred), I opened the story photo entitled “Cabbie takes down another” by Moe Martinez. His photo caption reads, “you see it alot … thankfully this guy seemed to be relatively ok … coherent and what not.”

I wanted to know just how often “we” see taxi drivers crashing with people riding bicycles. You can’t filter by vehicle type in either mine or Derek’s bike crash maps, but you can via the Fusion Table.

I decided to get the answer via Google Refine and make a screencast to show you just how quick and powerful a tool it is.

It’s dead simple:

  1. Load a CSV of the data into Google Refine.
  2. Click on the VEH1_SPECL column’s down arrow, then Facet>Text Facet.
  3. In the facet box, sorted alphabetically, find “TAXI/FORE HIRE.”
  4. The number of rows that apply is listed: 353.
  5. Divide 353 by the total number of rows, 4931, multiply by 100, and you get your percentage.

Taxi drivers are involved in just 7.2% of bicycle crashes in Chicago in 2007-2009.

The majority of crashes, at 66%, involve people driving “PERSONAL” vehicles. And 80% of those crashes are with a passenger vehicle that’s not a van, minivan, SUV, truck, or bus (so probably a sedan or coupe). Let’s look at more data.

How many taxis are there and how many personal vehicles are there? Are taxicabs involved in a disproportionately higher number of crashes?

About 781,023 people drive to work, either alone or with someone else, in Chicago (data from 2005-2009 5-year American Community Survey). 1,063,047 households have 1,218,594+ vehicles available in Chicago. Let’s assume the 7,000 taxicabs in Chicago are not counted as a “vehicle available.”* That’s 1,225,594 “personal” vehicles. If all were on the road at the same time, only 0.57% of them would be taxicabs. But they’re not on the road at the same time. So let’s take that number of people who drive to work and add 7,000 vehicles to it. So of those 788,023 “vehicles” now on the road, just 0.88% of them are taxicabs.

So it does seem that taxicabs are involved in a disproportionate number of crashes when compared to their presence on the streets. However, taxicabs are most likely driven more more miles and for more time than personal vehicles thus making their exposure to people bicycling greater than drivers of other vehicles. (A majority of “personal” trips are very short.)

New data coming soon

I can’t wait to get the 2010 crash data. Here’s why: In 2007, students in a taxi driver training course at Harold Washington College received some education about sharing the road with bicyclists:

A pilot “Share The Road” education module was launched at the taxi training school at Harold Washington College. It includes a 25-30 minute lecture, with discussion. After the pilot, the class will be required for all people training to drive taxis in Chicago. In the future, bicycle questions will be included on the exams required to become taxi drivers. June 2007 MBAC meeting minutes (PDF).

The number of crashes between taxi drivers and people riding bikes jumped from 2007 to 2008, but declined heavily between 2008 and 2009. More data will show us a clearer trend that may lend insight into the impact of the “Share The Road” education module.

*Notes

The question (PDF) on the American Community Survey asks, “How many automobiles, vans, and trucks of one-ton capacity or less are kept at home for use by members of this household?” This may or may not include taxicabs stored at home.

I don’t know how many taxicabs there are in Chicago, but the Chicago Sun-Times reported there are approximately 7,000.

The truth about Wal-Mart’s contribution to the tax roll

I recently wrote about how Wal-Mart plans to expand its reach in Chicago in a big way (30 new stores big). Politicians around the country consistently like to be heard saying how one way the store(s) will benefit the city is the additional tax revenue the city will see from property and sales tax contributions. Here are selected quotes from Chicagoans:

On Tuesday, [Chicago Mayor] Daley noted that a Wal-Mart expansion would pave the way for sales tax windfall for the cash-starved city budget.

In suburban Cook County, about 20 percent to 30 percent of all sales tax revenue comes from Wal-Marts, Daley said.

Chicago Sun-Times, June 15, 2010

“Everyone realizes we need the tax revenue,” [Alderman Anthony] Beale [9th Ward] said.

Chicago Sun-Times, May 5, 2010

Ald. Richard Mell, 33rd, a pro-union alderman, lamented Wal-Mart’s domination of the nation’s retail market and its tendency to sell foreign-made products, but voted for Pullman Park because of the need for jobs and additional tax revenue.

Chicago Tribune, June 30, 2010

Comparatively, Wal-Mart brings in little property tax revenue on a per acre basis, according to a study from Sarasota County (Florida) and Public Interest Projects and posted by Citiwire. I’ve summarized their findings:

  • Single-family home: $8,200 per acre
  • Wal-Mart and Sam’s Club: $150.00-$200.00 per acre
  • Southgate Mall: $22,000 per acre
  • High-rise mixed-use project in downtown Sarasota: $800,000

That last one’s the kicker! From the Citiwire article, “‘It takes a lot of WalMarts to equal the contribution of that one mixed-use building,’ [Peter] Katz noted.” Read the full story for more examples and for more discussion on how this specific breakdown of costs and benefits is only one way to look at fiscal and retail impact.

If the same tax revenues were true for Chicago or Cook County (and I can’t say it is or isn’t), then the city planners and aldermen should be seeking developers to build high-rise mixed-use projects. Right.

But the issue Chicago and other cities have is that Wal-Mart is one of the most willing developers – they will build where no one else will. They have capital that no one else has. They have the resources to sway the population. It’s more politically difficult to resist such a willing partner like Wal-Mart than it is to seek relationships with developers who have the resources to create more beneficial mixed-use projects in the neighborhoods Wal-Mart seems to prefer.