Category: Information

I want to make a crash reporting tool

UPDATE 12-01-10: Thank you to Richard Masoner for posting this on Cyclelicious. I have started collecting everyone’s great ideas and responses in this development document.

Hot off the heels of making my “Can I bring my bike on Metra right now?” web application, I am ready to start on the next great tool*.

I want to create a bicycle crash reporting tool for Chicago (but release the source code for any city’s residents to adopt) along the lines of B-SMaRT for Portlanders and the Boston Cyclist’s Union crash map based on 911 calls.

I’d rather not reinvent the wheel (but I’m very capable of building a new web application based in PHP and MySQL) so I’ve been trying to get in contact with Joe Broach, the creator of B-SMaRT, to get my hands on that source code.

Not exactly the type of crash I’ll be looking for. Photo by Jason Reed.

I want the Chicago Crash Collector (please think of a better name) to have both citizen-reported data, and data from police reports. I just sent in my FOIA request for police data to the Chicago Police Department, but I’m not holding my breath for that.

Draft letter to my Alderman about the TSA

To my readers: I am concerned about transportation security in the United States. I am concerned that it grossly oversteps boundaries erected by my rights as a citizen. I am concerned about the effectiveness of security theater. I want to travel without my naked body being viewed, or my clothed body being touched, by strangers at the airport.* I want my elected politicians to do something. The first is to consider our options.

Below is a draft letter to my most local elected official, the 11th Ward Alderman of Chicago. I’ll send this to him to his office at 3659 S Halsted Street after Thanksgiving week.

Do you have ideas for making it better? My opinion is at the end.

Dear Alderman Balcer,

I understand that airports in the United States can elect to remove the Transportation Security Administration (TSA) and provide their passenger screening services.

You have probably heard that is widespread confusion, anger, and disgust at how some people passing through America’s airports are being treated. Many object to having strangers view them naked, and others are reporting feeling groped by strangers – all in the name of preventing terrorism. The federal Government Accountability Office reported that it could not confirm if the current “Advanced Imaging Technology” (AIT) machines (either backscatter x-ray or millimeter wave) would have detected the explosive material someone attempted to use around Christmas 2009.

I haven’t yet decided if I will include this photo of a sleeping TSA officer at Chicago’s Midway (MDW) airport in 2007. Photo by Erin Nekervis.

As the City of Chicago owns O’Hare and Midway Airports, the City Council has power and authority over their operations.

I urge you and your colleagues to investigate the effectiveness of the TSA’s AIT machines, their protection or lack of protection of Chicagoans’ privacy, the level of training each TSA worker receives, and the possibility of using different passenger screening techniques in the Chicago Airport System, without the aid of the TSA.

I have enclosed an article by the Toronto Star from December 30, 2009, that briefly explains how security works at airports in Israel, a country under daily threats of bombing, and real bombing, without the use of expensive and unexplained machinery.

Steven Vance
11th Ward Resident

*I really want some high-speed rail.

Addendum, 11/19/10: After reading how an airline pilot refused to have his body groped or viewed naked, and describing his experience with the TSA on a message board, I wanted to post the pilot’s comments (via Gizmodo):

Roberts’s reply: “If your perspective prevails [that Roberts’s actions had no effect in changing TSA policy] – and I’m afraid it may – we may all live to find ourselves wishing we had fought in earlier days, when we still had a fighting chance.”

This reminds me of the “If you’ve got nothing to hide, then why are you against it?” position. At the rate the TSA is removing rights protecting Americans from unreasonable searches (Fourth Amendment), I eventually won’t have anything to hide because I won’t be allowed to have anything – no water bottles, no 7 inches long bike tools, no shaving cream. This government, and many other governments, conducts intensive surveillance and collects godawful amounts of data. The government is not always benign, will share the data, and does a poor job of securing the data. I am not doing anything illegal, but that does not mean I want to share all of my activities with the government or the police.

Read more TSA horror stories, in this roundup from the UK-based Daily Mail.

Bike light giveaway event

I’ve volunteered for three different organizations this year for approximately 43 hours. I feel my record keeping is falling a little short, though.

Last night was my favorite time. I took photos for the Active Transportation Alliance during a bike light giveaway (or “distribution”). I also helped attach a few lights to the hundreds of people riding bikes through Wicker Park without headlights. I spent most of my time in front of Bank of America at 1585 N Milwaukee, in the northbound direction.

All of the volunteers, including two staff members from ActiveTrans, and lawyer Jim Freeman (who donated the lights), made a lot of people happy.

Most states have laws requiring people riding bikes at night to have a front white headlight and a rear red reflector, although I, and many others, including ActiveTrans, suggest that you also ride with a rear red light. I’ll help you find a local bike shop if you’re in need of a light.

Frequency of Chicago women riding their bikes to work is down

UPDATE: I added data from years 2005-2007 to complement existing 2008-2009 data in Table 1 as well as a visual representation. I have also added data from the 3-year estimates to Table 2.

UPDATE 01/20/11: Added the most recent 3-year estimate that the Census Bureau released in January 2011 to Table 2.

In September 2009, I wrote about “what the Census tells us about bicycle commuting” and a couple of days ago I compared Chicago to Minneapolis and St. Paul.

I want to update readers on the changes between the 1-year estimate data reported in that article (from 2008) and the most recent 1-year estimate data (from 2009). Percentages represent workers in the City of Chicago aged 16 and older riding bicycles to work.

Table 1 – Bicycling to work, 16 and older, 1-year estimates

Year Total MOE Male MOE Female MOE
2005 0.7% +/-0.1 0.9% of 621,537 +/-0.2 0.4% of 541,013 +/-0.1
2006 0.9% +/-0.2 1.2% of 645,903 +/-0.3 0.7% of 563,219 +/-0.2
2007 1.1% +/-0.2 1.4% of 656,288 +/-0.3 0.7% of 574,645 +/-0.2
2008 1.0% +/-0.2 1.5% of 657,101 +/-0.3 0.5% of 603,640 +/-0.2
2009 1.1% +/-0.2 1.8% of 651,394 +/-0.3 0.4% of 620,350 +/-0.1

View graph of Table 1. MOE = margin of error, in percentage points.

We should be concerned about the possible decrease in the percentage of women riding bicycles to work, especially as the population size increased. The margin of error also decreased, thus suggesting an improvement in the accuracy of the data. There have already been many discussions (mine, others) as to why it is important to encourage women to ride bicycles and also what the woman cycling rate tells us about our cities and policies. If the decrease continues we must discover the causes.

But Table 1 doesn’t tell the full story.

As Matt points out in the comments below, the number of surveys returned for 1-year estimates is smaller than that from the Decennial Census. Therefore, I took a look at the two 3-year estimates available, each having a larger sample size than the 1-year estimates (see Table 2). The data below seem to show the opposite change than seen in Table 1: that the number of women bicycling to work has increased. The crux of our quandary is sample size. The sample size is the number of people who are asked, “How did this person usually get to work LAST WEEK?”

Table 2 – Bicycling to work, 16 and older, 3-year estimates

Click header for data source 2005-2007 2006-2008 2007-2009
Total workers 1,203,063 1,230,809 (+2.31%) 1,291,709 (+4.71%)
Males bicycling to work 7,549 9,014 (+19.41%) 11,014 (+18.16%)
Females bicycling to work 3,474 3,741 (+7.69%) 3,542 (-5.62%)

The number of discrete females who bike to work has decreased in the most recent survey (2007-2009) while the total number of workers 16 and older has increased, giving females bicycling to work a smaller share than the previous survey (2006-2008). We must be careful to also note the margin of error for females bicycling to work is ±499.

Matt suggested that sustainable transportation advocates “push for higher sampling” to reduce “data noise” and increase the accuracy of how this data represents actual conditions. I agree – I’d also like more data on all trips, and not just those made to go to work. Household travel surveys attempt to reveal more information about a region’s transportation.

One of the two overall goals of the Bike 2015 Plan is “to increase bicycle use, so that 5 percent of all trips less than five miles are by bicycle.” Unfortunately, the Plan doesn’t provide baseline data for this metric, but we can make some inferences (there will probably be no data for this in 2015, either). The CMAP Household Travel Survey summary from 2008 says that the mean trip distance (for all trips) for Cook County households is 4.38 miles (under five miles). The same survey says that for all trips, 1.3% were taken by bike. These can be our metrics. *See below for men/women breakdown. Note that no data for “all trips” exists for the City of Chicago.

We will not achieve the Bike 2015 Plan goal unless we do something about the conditions that promote and increase bicycling. Achieving the goals in the Bike 2015 Plan is not one group or agency’s responsibility. The Plan should be seen as a manifestation of what can and should be done for bicycling in Chicago and we all have a duty to promote its objectives.

Please leave a comment below for why you think the rate of women who bike to work has stayed flat and decreased, or what you think we can do to change this. Does it have to do with the urban environment, or are the reasons closer to home?

*The same survey also said: Cook County males used the bike for 1.9% of all trips. Cook County females used the bike for 0.8% of all trips.

Table 1 data comes from the 1-year estimates from the American Community survey, table S0801, Commuting Characteristics by Sex for the City of Chicago (permalink), which is a summary table of data in table B08006. Table 2 data directly from American Community Survey table B08006.

Readers Ask: Choosing a GPS-enabled camera

Readers Ask. Once or twice a month, a blog reader asks me a question about GIS, software, or schools. I’ll be relaying my responses and answers in this new column. This is the first entry.

Question

On Oct 29, 2010, J wrote:

I see from your blog that you use the Sony  DSC-HX5V camera to record the locations/photos, and that you also use ESRI software.  I am just about to buy that same camera for my work, and have been looking for information about if it is easy (or not) to upload the info in Arcinfo/ESRI software.  Would you mind letting me know?

Thanks,

J

I used an external GPS logger to create the map of my bicycle trip around New York City.

Response

Hi J,

I have no experience with using the GPS in the camera. I believed that reception would be poor, especially in urban areas, like where I live – Chicago. I use an external GPS logger (in the same list as the camera) and external antenna. When I get back from a trip, I use software to link the GPS tracks with the photos. The software embeds the coordinates into the JPEG metadata.

I also have no experience using GPS with ArcInfo. I know that ArcExplorer Desktop allows you to import GPX (GPS XML files) but I don’t know what you can do with them in the program. I tried, but failed. I use Windows inside Parallels for Mac, so not everything works 100% of the time.

I did load a GPX file from my external GPS logger into QGIS using the GpsTools plugin. I can export a shapefile from it to work in ArcGIS just fine.

I looked at your organization’s website and it seems you work in the open country. I think you’ll have better GPS tracking results out there with the camera than I do in Chicago. Even with the external antenna, the results in Chicago can be weird – it seems the signals bounce off skyscrapers and trick the GPS receiver into thinking it’s in Lake Michigan.

Lastly, I do recommend the camera for its low-light capabilities, iSweep panorama mode, and 1080i60 HD movie mode.

Steve – contact me