Page 108 of 172

Bike businesses that keep me pedaling: UV Metal Arts (1 of 4)

Four part series of Midwest bike-related businesses that keep me and my bike rolling without hassle.

If it ain’t broke, don’t fix it.

Well, my rear rack was broken and I wanted someone to fix it. I didn’t want to buy a new rack if it could be fixed – I don’t want to send raw materials to the landfill. I contacted Owen Lloyd for help with welding a piece of my Planet Bike Eco Rack back together. The “deck” had detached from the last rail and was flapping around making noise but also reduced the strength of the rack structure. Thinking about it now, I could probably have asked Planet Bike for a replacement as they have a lifetime warranty on all of their products. But I wanted it fixed here and now.

Owen brought me over to Yuval “UV” Awazu of UV Metal Arts in Bubbly Dynamics at 1048 West 37th Street and his UV Metal Arts workshop in Bridgeport. The rack is made of aluminum and UV was the only craftsperson in the “factory” who can weld it. He can do way more than repairing small parts like these. He also powdercoats bike frames and “bakes” them in a tall, custom oven he built himself.

10 minutes later, I had a rack that was stronger than brand new!

My repaired rack. I highly recommend this rack as it only costs $21 on Amazon, but if you expect it to last longer than two years and carry weight on it daily (and maybe sometimes too much or lopsided), then get something stronger.

UV at the Bike Winter Cycle Swap in February. See more photos from this event.

A bicycle that UV colored. UV says you can choose just about any color (including metallics) for your item (powder coating is for more than just bicycles).

More in this series

  1. UV Metal Arts – You’re reading it!
  2. Lloyd Cycles – coming soon
  3. Kozie Prery – coming soon, and with a contest!
  4. Planet Bike – coming soon

Two new beta apps for Chicago geography

I think 2011 is going to be the year of apps for me. I developed one for bikes and one for politics.

Bikes

I made the “Chicago Bike Data Portal” app on Saturday night. It gets your location via the HTML5 geolocation API and loads a list and map of all the reported bike crashes within half a mile. It works on some mobile phones, too (at least Android and iOS). Expect to see more data in the future, like ped and automobile crashes.

Politics

Then on Monday I made an app called, “Who is my Chicago Alderman?” where people can type in their address (or any address) and retrieve the alderman’s name, addresses, and phone numbers. I’ve already identified a problem where the app returns the wrong information for an address. I think this is a problem with the geocoder. Ever since CivicFootprint (a project of Center for Neighborhood Technology) disappeared, the city’s been missing an easy-to-use app for finding alderman. The city clerk’s website takes too long to use and is not as informative.

Other apps I built or worked on

Listening to Jeanne Gang

Buy the book, Reveal.

Jeanne Gang is Chicago’s “in-house” starchitect. Sure we’ve got Adrian Smith (Burj Khalifa), but he’s jumping around the world while Jeanne (like Jeanie) has been maintaining Chicago’s status as a city with architectural and design marvels.

Architecture critic Lynn Becker calls her part of the Chicago “third school”:

Gang, Garofalo, Ronan, and other local rising stars are on the verge of defining a third Chicago school of architecture, following in the footsteps of Sullivan, Burnham, and Root in the 19th century and Mies van der Rohe in the 20th. This new school won’t be characterized by the kind of uniform visual style that marked the architecture of Mies or Frank Lloyd Wright, but by diversity, changeability, and an intellectual restlessness that compulsively tests accepted wisdom. (From the Chicago Reader)

People around here know her for the Aqua Tower (see my dramatic photos) and J.C. Gabel and her talked a lot about it at a recent book release party in the Stop Smiling storefront at 1371 N Milwaukee Avenue in Wicker Park. But enough about that tower, I’d rather mention something else.

In the photo above you see a model of interior of a University of Chicago study room. Think about all the dramatic films that take place in heralded college campuses: the study room in the library is a big hall with desks in neat rows for quiet, private research. But more often students must work in groups and need closed off spaces to avoid disturbing others. So Studio Gang Architects envisioned little cubicle rooms and built the 3D model of the study room and then threw in an ice cube tray to represent the cubicles.

Said Gang about the ice cube tray, and I’m paraphrasing, “Our studio, like many others, has a 3D printer so we can quickly create models of our work. But all the models end up looking the same. We just wanted to envision it differently.”

One of the coolest parts of the evening was when this self-identified substitute teacher (in above photo) stood up to talk about one of his students, an 8th grader who has a knack for drawing and 3D computer design. Someone at the school asked the student to design a new campus building. The teacher was concerned about the student’s design being stolen or ripped off and wanted advice on how he can protect his work. Jeanne laughed and said she didn’t think she would be asked to talk about copyright laws tonight. She then said that the student should continue his passion for drawing and that manual drawing was a dying but still revered skill. Jeanne agreed to meet with the student and teacher afterwards to take a look at his drawing. (I saw the drawing on paper the student made as well as the version he drew in Google SketchUp – very impressive.)

Buy the book, Reveal.

Using Google Refine to get the stories out of your data

Let’s say you’re perusing the 309,425 crash reports for automobile crashes in Chicago from 2007 to 2009 and you want to know a few things quickly.

Like how many REAR END crashes there were in January 2007 that had more than 1 injury in the report. With Google Refine, you could do that in about 60 seconds. You just need to know which “facets” to setup.

By the way, there are 90 crash reports meeting those criteria. Look at the screenshot below for how to set that up.

Facets to choose to filter the data

  1. Get your January facet
  2. Add your 2007 facet
  3. Select the collision type of “REAR END” facet
  4. Choose to include all the reports where injury is greater than 1 (click “include” next to each number higher than 1)

After we do this, we can quickly create a map using another Google tool, Fusion Tables.

Make a map

  1. Click Export… and select “Comma-separated value.” The file will download. (Make sure your latitude and longitude columns are called latitude and longitude instead of XCOORD and YCOORD or sometimes Fusion Tables will choke on the location and try to geocode your records, which is redundant.)
  2. Go to Google Fusion Tables and click New Table>Import Table and select your file.
  3. Give the new table a descriptive title, like “January 2007 rear end crashes with more than 1 injury”
  4. In the table view, click Visualize>Map.
  5. BAM!

I completed all the tasks on this page in under 5 minutes and then spent 5 more minutes writing this blog. “The power of Google.”

The stories the IDOT automobile crash data can tell

Lots of stuff to learn from the 2007-2009 car crash data, with 309,425 crash reports.

What I noticed

  • SUV drivers do not cause all crashes, contrary to some stereotypes. That vehicle type (for both vehicle 1 and vehicle 2) is only involved in 45,776 crashes (14.79% of all crash reports)
  • The vehicle type most commonly involved in crashes is “personal passenger,” with 294,941 “personal passenger” vehicles involved in 208,888 crashes (67.51% of all crash reports)
  • 1,465 crash reports report “unknown” for both vehicle 1 type and vehicle 2 type (0.47% of all crash reports)
  • 61,645 crash reports have vehicle 1 hitting a parked car (19.92% of all crash reports)
  • There were 16,554 taxis involved in 15,223 crashes (4.92% of all crash reports). And there were 1,311 “taxi on taxi” crashes (0.42% of all crash reports)
  • 3,861 CTA transit buses (that can hold more than 15 passengers) were involved in 3,853 crashes (1.25% of all crash reports). And there were 8 “bus on bus” crashes (0.003% of all crash reports)
  • 1,644 school buses were involved in 1,635 crashes (0.53%). And there were 9 “school bus on school bus” crashes (0.003% of all crash reports)

Data does not include estimated cost of property damage.

Not all vehicles may be unique – some vehicles may be involved in more than one crash.