Category: Information

The importance of sharing data in KML format

The KML file is an important format in which to share locational data. KML was developed by a company called Keyhole, which Google purchased in 2004, and subsequently released Keyhole’s flagship product: Earth.

A Keyhole Markup Language file is a way to display on a map (particularly a 3D globe of Earth) a collection of points with a defined style. Google has added more functionality and style to the KML format, expanding the styles that can be applied and the information that can be embedded.

KML, like XML (eXtensible Markup Language), is extremely web-friendly. For a web application at work I developed, I included this PHP class that creates an KML file on-demand based on a predefined database query. The file contains locations and attributes of recently installed bike racks in Chicago. EveryBlock imports the file and its information into their location-based service, aggregating many news types around your block.

But a KML file is more important than being the native file for use within Google Earth. It’s an open source text file that can be manipulated by a number of software programs on any computer system on earth (or read on a printed page). It’s not encoded, like shapefiles, so I can read the file with my own mind and understand the data it would present in a compatible map viewer. I see lines of organized syntax describing points and polygons, listing their attributes in plain language.

Have you ever tried to see the “inside” of a shapefile? Only GIS programs can read them for you. KML provides data producers and consumers the opportunities to keep data open, available, and easy to use. We need locational data for our work, and we need tools to help us use it, not hide it.

What the Census says about bicycle commuting

UPDATE 11-08-10: I wrote a post comparing the commuting statistics between Chicago, Minneapolis, and St. Paul.

UPDATE 02-12-11: Added 2009 data.

Prompted by this entry on BikePortland about the rise of bicycle commuting and the bicycle mode share in Portland, Oregon, I decided to research what the American Community Survey says about the mode share of bicycles as part of commuting where I live: Chicago. I’ll also post bicycle’s share of commuting for other locales, as well.

Some definitions, first:

  • Commuting means travel to and from work – the Census Bureau calls this “MEANS OF TRANSPORTATION TO WORK.” The Census Bureau does not collect information on travel to shopping, medical services, and other places in the decennial census or the yearly American Community Survey (which will supposedly replace the decennial census).
  • Block means the smallest area for which the Census Bureau reports statistics. Any smaller and the possibility that someone could personally identify you from the responses increases. Find your block. The American Community Survey reports information for much larger areas: In some cases, researchers can only select data at the county level. The Census Bureau provides information for the City of Chicago and other municipal divisions of many counties in Illinois.
  • Subject definitions. These describe the question asked to participants and include clarifying information in the case the participant doesn’t understand the question, or their answer is complex. Download the subject definitions for the 2008 American Community Survey.
  • Margin of error (MOE) means the high and low end of confidence. Read more about margin of error on the Census Bureau’s website.

For the American Community Survey, I found table S0801, Commuting Characteristics by Sex. In the decennial census, I found table  P30. MEANS OF TRANSPORTATION TO WORK FOR WORKERS 16 YEARS AND OVER. If you want to check my research, look for these tables of sample data.

Chicago:
Margin of error for male and female categories varied. Combined always reported 0.2%.

  • 2009 – 1.1% travel to work by bicycle. 1.8% male (MOE: 0.3%), 0.4% female (MOE: 0.1%). Workers over 16: 1,271,744. Permalink.
  • 2008 – 1.0% travel to work by bicycle. 1.5% male (MOE: 0.3%), 0.5% female (MOE: 0.2%). Workers over 16: 1,260,741. Permalink.
  • 2007 – 1.1% travel to work by bicycle. 1.4% male (MOE: 0.3%), 0.7% female (MOE: 0.2%). Workers over 16: 1,230,933. Permalink.
  • 2006 – 0.9% travel to work by bicycle. 1.2% male (MOE: 0.3%), 0.7% female (MOE: 0.2%). Workers over 16: 1,209,122. Permalink.
  • 2005 – 0.7% travel to work by bicycle. 0.9% male (MOE: 0.1%), 0.4% female (MOE: 0.1%). Workers over 16: 1,162,550. Permalink.

United States:
Margin of error happened to be the same for each reported category (combined, male, female).

  • 2009 – 0.6% travel to work by bicycle. 0.8% male, 0.3% female. MOE: 0.1%. Workers over 16: 138,591,804 (decrease). Permalink.
  • 2008 – 0.5% travel to work by bicycle. 0.8% male, 0.3% female. MOE: 0.1%. Workers over 16: 143,995,967. Permalink.
  • 2007 – 0.5% travel to work by bicycle. 0.7% male, 0.2% female. MOE: 0.1%. Workers over 16: 139,259,684. Permalink.
  • 2006 – 0.5% travel to work by bicycle. 0.6% male, 0.2% female. MOE: 0.1%. Workers over 16: 138,265,905. Permalink.
  • 2005 – 0.4% travel to work by bicycle. 0.6% male, 0.2% female. MOE: 0.1%. Workers over 16: 133,091,043. Permalink.

Read the BikePortland article if you want to know that Portland has a higher share of commuters traveling by bicycle than Chicago has.

And what about my block? As I mentioned above, we can only find information at the block group level in the decennial census. I live in Block Group 1 of Census Tract 6009 in Chicago, Illinois. I didn’t live here in 2000, though, the last time the decennial census occurred. Back then, out of 168 workers over 16, 4 of them rode their bikes to work! That equals .024% of the worker population in my block group. Oddly, though, the Census Bureau reported 946 people living in this Block Group. Looking at table P8 (Sex By Age), I see that 674 have at least 16 years of age. 178 people have at least 55 years. Does this mean a lot of people in the Block Group didn’t work at the time of the survey in 2000? I don’t know. Permalink to data.

By far, though, driving alone won as the most popular way to get to work: 71.423% of the worker population.

Bicycling for college students

I write this article to all college students who choose to bike to class this semester (and any future semester). This post is a bit Chicago-centric, but can be applied universally.

Introduction

If you haven’t yet chosen to bike to campus, don’t read this – I’ve got another article in the works for you. Essentially, I gained my advice and education from information I found in multiple documents published by the Chicago Bicycle Program. But you can read my post in less than 10 minutes. I give my friends the same spiel, and now I’ve finally published it for everyone’s benefit.

My credentials: I’ve been commuting safely and effectively to the University of Illinois at Chicago campus for four years, attending undergraduate and graduate class. I’ve been bicycling all around Chicago (I can prove it with these maps) for the same period.

I divide my advice into three sections: Safety, Getting There, and The Right Equipment. You should have a copy of the Chicago Bike Map at your side (download as PDF; tambien disponible en espanol; request one to be mailed).

Safety
Safety is a combination of skills, following the rules of the road, and being alert.

You gain safe cycling skills by practicing safe cycling at all times on all roads upon which you cycle.
You most likely learned the rules of the road in high school driver’s education.

Bicyclists must follow the same traffic regulations as motorists (including stopping at yellow and red traffic lights). Additionally, you should practice several additional behaviors (found in the Sharing The Road section of the Bike Map):

  • Never ride against traffic. Bike Snob NYC calls this “bike salmoning.” No other road user expects vehicles to travel in the wrong direction, making this one of the most risky maneuvers.
  • Don’t ride on the sidewalk. You’re disrupting pedestrian traffic and it’s illegal.
  • Know about the door zone: the 4-feet invisible space on both sides of every vehicle that represents the width of a door swinging into a bicyclist’s path. Watch for recently parked cars and cars with people inside.
  • Lastly, ride in a straight, predictable line, and not weaving between parked cars in the parking lane. Passing motorists and bicyclists can safely travel past you because they know where you’re going.

Staying alert will help you avoid collisions and prevent you from getting boxed in by CTA buses. Part of being aware is being able to hear: Don’t use headphones while bicycling (this too is illegal).

Wanna see these tips in action? Watch the CDOT/Chicago Police video on traffic enforcement for bicyclist safety.

Getting There
You can journey safely by determining the best way to get to your destination. Mark your origin (home) and destination (school) on the bike map and then follow the bike lanes, marked shared lanes, and recommended routes to the end. Practice your trip with a friend during the day.

Indoor, sheltered bike parking at the recently reopened Damen Brown Line station.

Also consider making a multi-modal trip using transit. All CTA stations in Chicago have bike parking, and most Metra stations have bike parking. A bus will carry your bike for you at any time, and you can take your bike on the L outside of rush hours.

*More information on bikeway facilities in Chicago below.


The Blue Island bike lane on my way to class from Pilsen.

Try your hardest to never let a motorist scare you off the road with their hurtful and pointless words (or honking). You have the right to bike on the street. If you get into a verbal altercation with a motorist, TAKE A BREAK. Your adrenaline and heart rate will have increased, and emotions may decide your next move. Pull over and breathe. You need to stay in control of you, your bike, and your trip. If the motorist is operating their vehicle that’s a danger to you or other street users, pull over and immediately call 911 to report reckless driving.

Additionally, college campuses often have a lot of buses (either public transit or shuttles). Let the bus driver “do their thing” and don’t try to compete for space with the bus. Wait or signal and pass safely in the adjacent lane.

The Active Transportation Alliance, the Chicago bike advocate, has a crash support hotline: 312-869-HELP (4357).

The Right Equipment
To bike somewhere safely, you need the right equipment:
LIGHTS and a LOCK. Right now, throw away your cable lock. It’s completely useless unless part of a locking scheme that includes a high-quality u-lock.

Buy the most expensive, new u-lock you can afford. You spent a lot of money on your bike, so you should spend a little money on the device that will keep your bike yours! Once you buy, learn how to use it by following these depictions.

Chicago law requires a headlight, and a rear reflector or taillight. Forget the rear reflector – it’s close to worthless. You want road users to see your presence. So get two blinkies: a white light for the front, and a red light for the rear (with a rear light, you’ll be honoring the law). These two accessories will make you visible. Bike shops shouldn’t let you leave until you buy these or prove you already own a set.

If you want be really visible, you can get cold cathode fluorescent lights for your bike. I built this setup as a fun, DIY project.

More equipment you may want:

  • Fenders. Keep your feet and pants dry.
  • Water bottle cage. Being outside and active dehydrates your body.
  • Rear rack or front basket. Shuck your backpack into a basket to keep sweat off your back and reduce back pain.


I built a pannier from a kitty litter bucket. My Nishiki Prestige parked at the UIC Richard J. Daley library.

Please comment on this blog, add me on Facebook or email me with questions.

*The bike map’s road designations are based on actual field observations completed several years ago by City and Active Transportation Alliance staff. Bike lanes, indicated by two white stripes, a bicycle symbol, and an arrow, are for the exclusive use of bicyclists. Marked shared lanes, shown with a bicycle symbol and two chevrons, tell motorists and bicyclists that this is a shared lane and motorists should expect a higher number of bicyclists than most streets. (All lanes in Chicago are shared lanes and bicyclists ALWAYS have the right to use the entire lane when the bicyclist feels they cannot safely share the lane with a motorist, or when changing lanes.)

What a new bike lane looks like (this is Clinton Street at the railroad crossing between Kinzie and Fulton).

Pilsen pollution

Pilsen is a neighborhood in Chicago’s Lower West Side that is made mostly of Mexican immigrants and descendants. It’s sister neighborhood is Little Village, which is close by to the southwest. I lived here for two years from 2006-2008.

When I moved in, the smoke from a nearby, but yet unseen, exhaust stack was quite apparent. An uninformed or malicious local offered that it was a heat generation plant for the nearby public housing homes. This seemed unlikely, and only slightly plausible, but I didn’t question it.

Both neighborhoods have coal-fired power plants. There is Fisk Generating Station at 1111 W. Cermak in Pilsen (which I mentioned above and pictured above), and Crawford Generating Station at 3501 S. Pulaski in Little Village. Both are owned by Midwest Generation

It was not long until I read several news reports in the major Chicago newspapers about the actions of local social advocacy organizations trying to bring awareness about the danger the Fisk plant was causing for the minority residents in Pilsen. The problems became well-known in 2001 after a group of five researchers from Harvard and two private consulting agencies (one for wind, and one for environment) studied coal-fired power plants in the Midwest exempt from the provisions of the Clean Air Act. See “More information” below for a local group’s opinion on these plants’ impacts on health using information derived from the study.

The most recent call for action was from the Little Village Environmental Justice Organization, who, in August 2008, demanded that Mayor Daley close the Fisk plant on Cermak.

Now, the Sierra Club magazine is reporting on a new and younger organization ready and willing to fight alongside LVEJO the battle to fix the pollution problems in Chicago’s west side Latino neighborhoods. I recently read this article at work in our “office lending library” – this along with the fact that I pass by the station quite often prompted me to write this blog entry.

More information:

Earmarks: Good and bad, put simply

Earmarks are wonderful for the people and organizations for whom they’re designated. It’s a way to bypass normal funding procedures and jumpstart or finish a project. Instead of a bureaucrat in Washington, D.C., and your state capitol analyzing your project for its funding worthiness, you work with your locally elected official to get project funding.

Earmarks also help institutions ineligible for federal funding (for example: many local museums) get projects built for them. Earmarks may mean that your project starts getting federal grants earlier.

What earmarks also do is reduce the amount of money available for formula and Department of Transportation discretionary funding as well as lower the statewide “transportation pot.” It’s also probably immoral to use political instead of objective considerations to decide which projects are funded and which aren’t. 

However, with the right politician and the right group speaking in their ear, earmarks may mean the difference in your town getting that bike lane funded or not, because the state Department of Transportation continues to say no.

In the federal spending bill President Obama plans to sign soon, there are $7.7 billion dollars in earmarks, according to Taxpayers for Common Sense (TCS). This, so far, only includes disclosed earmarks (a handy table listing all earmarks and requesting politicians is downloadable), and the group is searching through the bill text to find the billions more in undisclosed earmarks.

Here I note a couple items of interest to Illinoisans in transportation (download searchable PDF with national table or download Excel spreadsheet from TCS):

  • Alternative Analysis Study for the J-Route Bus Rapid Transit (BTR) Project; $237,500; Rep. Roskam
  • Peoria Regional Airport; $950,000; Sen. Durbin
  • DeKalb/Taylor Municipal Airport, Various Improvements; $1,235,000; Rep. Foster, Sen. Durbin
  • CTA Red line Extension (Alternatives Analysis); $285,000; Rep. Jackson, Sen. Durbin
  • CTA Yellow Line Extension (Alternatives Analysis); $237,500; Rep. Schakowsky, Sen. Durbin
  • CTA Brown Line* (Capital Investment Grant); $30,00,000; Sen. Durbin
  • CTA Circle Line** (Capital Investment Grant); $6,000,000; Sen. Durbin
  • Metra Rock Island 35th St. Station Improvements; $712,500; Rep. Rush
  • Multimodal Center in Normal; $237,500; Rep. Weller
  • Paratransit Vehicles, West Central Mass Transit District; $104,500; Rep. LaHood
  • Replacement Heavy Duty Transit Buses, Madison County Mass Transit District; $475,000; Rep. Costello
  • Replacement of Paratransit Vehicles, Greater Peoria Mass Transit District, Peoria; $380,000; Rep. LaHood

And the list goes on. Click Read More for the notes about the CTA, info on Metra’s share, and BRT. Continue reading