Tag: Chicago

Using Google Fusion Tables to create individual Chicago Ward maps

September 13, 2011 / / 0 Comments

I wanted to create a map of the 35th Ward boundaries using Google My Maps for a story on Grid Chicago. I planned to create this by taking the Chicago Wards boundary shapefile and exporting just the 35th Ward using QGIS into a KML file. I ran into many problems and ended up using Google Fusion Tables as the final solution.

The problems

First, QGIS creates invalid KML files. Google Earth will tell you this. I opened the KML file in a text editor and removed the offending parts (Google Earth mildly tells you what these are; you can use this validator to get more information).

Second, Google My Maps would not import the KML file. I tried a different browser and a different KML file; a friend ran into the same issue. I reported this problem to Google.

The solution

I uploaded to Google Fusion Tables a KML file containing all wards. I did this instead of uploading the single Ward because, like a database, I can filter values in the column, selecting only the row I want with “ward=35”.

After applying the filter, the map will show the boundary for just that ward. I grab the HTML code for an embeddable map and voila, the article now displays an interactive map of the 35th Ward.

Whenever I want to create a map for a different ward, I go back to this Fusion Table, make a new filter and copy the new HTML code.

A screenshot of the embedded map, showing just 1 of 50 wards, in the Grid Chicago article. 

Elsewhere

I had the same problems with QGIS exporting and uploading the KML files to My Maps the other day when I was creating maps for the abandoned railroads for Monday’s Grid Chicago article. Not thinking about Fusion Tables, I drew on the map with my mouse the lines.

Screenshot of the map of abandoned railroads. 

On sucker poles

July 19, 2011 / / 0 Comments

Twice in the past seven days I’ve encountered an unsecured sucker pole.

A sucker pole next to a highly-secure bike rack provided by the City of Chicago’s Bicycle Program. The adjacent placement of the two fixtures is an unfortunate side effect of construction crews who didn’t receive guidance on bike rack placement. 

What’s a sucker pole? Any sign pole that’s not embedded in concrete or securely fastened to the ground in another fashion. A simple hex nut on a bolt fastens the pole to the base.

So last Saturday I encountered my latest one in front of India House (59 W Grand), just hours after Alexis Finch of Thought You Knew pinup calendar fame mentioned a specific sucker pole at the Green Eye (2403 W Homer) – I could completely remove the pole from its base.

Alexis reported that when she visits that bar, she removes the pole from its base and lays it on the sidewalk to prevent others from locking their bikes there.

I want you to spread the word about sucker poles while at the same time requesting a bike rack for that spot. I invite designers to remake this crappy poster I created and thankfully never printed.

Remake this “beware of sucker poles” poster into something cool and I’ll pay to print a few copies for you to keep and give to friends or bike shops. 

Park beauty

June 23, 2011 / / 0 Comments

My friend and her son cross the lagoon on their bike in Humboldt Park, Chicago.

Other views of the park:

“Angry geese in Humboldt Park. They were really hissing.” Photo by Joshua Koonce.

“A lovely gravel path by a lagoon in Humboldt Park.” Photo by Eric Rogers.

Give the CTA a medal, or a pony, for Train Tracker

June 20, 2011 / / 0 Comments

The Chicago Transit Authority released the Train Tracker API to developers with little fanfare. But it’s some high-quality stuff. At least this guy thinks the documentation is excellent*:

“Dear CTA: please give whoever wrote the Train Tracker API docs a medal, or a pony, or something. Thanks.” Original tweet by cieslak.

I think they got the message. You can bet they asked for the pony.

*I haven’t taken a look at the Train Tracker API documentation, but I did review the Trademark/Branding Guidelines for developers. It’s very clear how you should and shouldn’t use the CTA name and service marks and graphics. I also had a sneak preview in December 2010 of the Train Tracker website, to give user feedback. I was shocked and impressed to find that it worked on my Samsung Slash, a remarkably dumb phone that happens to be able to run Opera Mini (see photo below). The API wasn’t available until June 2011.

Carnage culture: Extrapolating blood alcohol content levels

June 20, 2011 / / 0 Comments

A breathalyzer test, to measure an automobile driver’s Blood Alcohol Content (BAC), is not always administered at the time and scene of a crash. I don’t know why it took four hours for Drew Forquer to have his BAC measured, but it registered at 0.045 percent, slightly more than half the legal limit of 0.08 percent.

Drew was convicted on Friday, June 17, 2011, of reckless homicide and aggravated drunken driving, but not “aggravated DUI charges that specified he was over the legal limit.”

…but the judge said it was clear to him simply from the results of field-sobriety tests, eyewitness testimony and Forquer’s “bizarre” turn — which was caught on surveillance video — that he was impaired.

The prosecution hired an expert witness to extrapolate Drew’s BAC at the time of the crash, “estimated…to be from 0.084 to 0.123 percent.”

What extrapolation means

Using evidence, prosecution and defense argue about the estimated BAC based on a variety of factors, including:

  • witness statements about driving behaviors (prosecution)
  • evidence of drinking before or during crash (prosecution)
  • field sobriety test (prosecution)
  • individual’s metabolism (defense)
  • “what the driver ate or drank that day” (defense)
  • other health issues (defense)

(The parentheses indicate which side used the factor in Drew Forquer’s case.)

In Drew’s case, his defense attorney argued that the BAC was lower because him having liver disease and chronic alcoholism would have slowed his metabolism (meaning alcohol would enter the blood stream more slowly).

Drew awaits sentencing, which can be from probation to 15 years in prison. They must be joking about probation – he’s gone to court for four previous DUI arrests!

More carnage culture articles

Story sources

Chicago Tribune – Thursday, June 16, 2011

Chicago Tribune – Friday, June 17, 2011

A taxi driver exited Lake Shore Drive and drove across the grass separating it from the Lakefront Trail. This photo, taken on July 4, 2010, is not related to the story above. Photo by Andrew Ciscel.