Tag: census

How Chicagoans commute map: An interview with the cartographer

Chicago Commute Map by Transitized

A screenshot of the map showing Lakeview and the Brown, Red, Purple and Purple Line Express stations.

Shaun Jacobsen blogs at Transitized.com and yesterday published the How Chicagoans Commute map. I emailed him to get some more insight on why he made it, how, and what insights it tells about Chicago and transit. The map color-symbolizes census tracts based on the simple majority commuting transportation mode.

What got you started on it?

It was your post about the Census data and breaking it down by ZIP code to show people how many homes have cars. I’ve used that method a few times. The method of looking up each case each time it came up took too long, so this kind of puts it in one place.

What story did you want to tell?

I wanted to demonstrate that many households in the city don’t have any cars at all, and these residents need to be planned for as well. What I really liked was how the north side transit lines stuck out. Those clearly have an impact on how people commute, but I wonder what the cause is. Are the Red and Brown Lines really good lines (in people’s opinions) so they take them, or are people deciding to live closer to the lines because they want to use it (because they work downtown, for example)?

The reason I decided to post the map on Thursday was because while I was writing the story about a proposed development in Uptown and I wanted  information on how many people had cars around that development. As the map shows, almost all of Uptown is transit-commuting, and a lot of us don’t even own any cars.

What data and tools did you use?

I first used the Chicago Data Portal to grab the census tract boundaries. Then I grabbed all of the census data for B08141 (“means of transportation to work by number of vehicles available”) and DP04 (“selected housing characteristics”) for each tract and combined it using the tract ID and Excel’s VLOOKUP formula.

Read the rest of this interview on Web Map Academy.

How many cars are in Rogers Park?

There are a gazillion cars in Rogers Park, and there’s no place to park them. That’s the declaration you would gather if you listen to “Lakefront Car Tower” (a parking garage) proponents, including the 49th ward alderman, Joe Moore.

The parking problem is so bad in Rogers Park that a parking garage at Sherwin Avenue and Sheridan Road that would provide less than 100 overnight parking spaces to the public was actually sent from Asphaltia, the god of car parks. It’s so bad that “[m]any car owners find themselves stuck in their home at night” – yes, the alderman really published that on his website – because they find a parking space on Friday night and can’t move the car until Monday morning. The horror of using your feet, pedals, the bus, the train, car sharing, paratransit, or a Segway!

(I’d love to get into parking pricing policy now, but I’ll just leave you with this: of course there is going to be a demand problem when the supply of publicly-owned on-street parking costs $0 per year.)

This post is actually a tutorial on how to use United States Census data to find how many cars are in the neighborhood of Rogers Park, not a laugh about Asphaltia’s teachings.

Let’s begin! Continue reading

Expanding data collection to include other modes

I think the Census Bureau should start collecting “journey to work” data on trips made by electric or gas-powered standing scooters as well as Segways. And that we need to start organizing vehicle crashes by this category.

Saw this electric scooter locked up outside the Active Transportation Alliance headquarters a couple weeks ago, 9 W Hubbard Street. 

Alderman Laurino should start work on “leveling the playing field” between texting while driving with texting while biking to include a ban on texting while Segwaying. Seen at 2030 S Archer. 

Policy insight for Monday, August 1, 2011

This isn’t refined. These are just my notes that I speak from. I may not have spoke about everything written here and I may not have written here everything I spoke about. This is for Moving Design

There was report of cyclist crashing on the Tuff Curb at the on-street bike parking facility in Wicker Park.

Installing the Tuff Curb

experimental projects need reviews. I don’t mean projects that are considered experiments, I mean projects that are new to the people who designed it, and new to the people who will be using it.

we need good data collection.

Did the Kinzie bike lane cause congestion? So what if it did?
We would need data points that were collected using well-known methods, and probably at different times of the day and week. And we’d have to be sure to count cyclists, too.
Then 3, 6, or 12 months later, we’d have to do it again.

What was the change?
Is that a change that meets our goals?

Back to the cyclist crashing on tuff curb, what is the city’s plan to monitor the use (or disuse) of the facility? How will the city collect data on something like this?

Census – not gonna happen in 2020
American Community Survey – 5-year estimates (with data gathered annually) will replace decennial Census.

“Here are a few Streetsblog posts about Census and NYC DOT’s bike counts, and the problems with each. The first post has some stuff about what could be done to improve on them:” (Ben Fried, Editor in Chief, Streetsblog NYC)

http://www.streetsblog.org/2010/04/27/how-many-new-yorkers-bike-each-day/
http://www.streetsblog.org/2010/10/01/did-nyc-bike-commuting-decrease-in-2009-thats-what-the-census-says/
http://www.streetsblog.org/2011/04/13/actually-if-you-build-it-they-will-bike/

Read more policy insights from Steven Vance. 

Why did women in Chicago stop bicycling to work? And other stories about data

Why did women in Chicago stop bicycling to work?
Or is our data unreliable?

Showing relative cycling-to-work rates between 2005 and 2009 in Chicago. Data from table S0801 in American Community Survey, 1-year estimates. Read the comments on this post for why this is not the best data source – 3-year estimate shows same decline in women cycling to work.

Note: The sample size is puny – data was collected from 80,613 housing units in Illinois. I don’t know how many of those were in Chicago (and we have 1,063,047 housing units). The American Community Survey only collects data on transportation modes to work for ages 16 and up.

But we simply have no other data! Maybe the Chicago Metropolitan Agency for Planning can release the Chicago data they collected for the 2008 household travel survey to show us bicycling rates for all trip purposes (they divided the report into counties). The sample size would still be small, but we could compare the work rates to find some support between the datasets.

We should look into how New York City counts bicycling as an additional way to gauge trends in Chicago (it has limitations of geography and area).

They conduct two types of counts. The first is the screenline count for bridges, Staten Island Ferry, the Hudson River Greenway, and all Avenues at 50th Street. They do this three times per year. Then, seven more times a year, they count at the same places (except the Avenues) from April to October.

While this data does not give them information on who cycles in the boroughs, it does give them a good indicator of cycling levels in Manhattan. It also disregards trip purpose, counting everyone going to work, school, or for social activities.

Sidenote: The New York Police Department will begin making monthly statistical reports on bicycle crashes in the city.