Categories
Uncategorized

“Douchebag” par Etienne Dano

Tu vas au salon de bronzage trois fois par semaine et au gym six fois par semaine? T’as pas fini ton secondaire? Tu t’habilles en T-shirts “Tap Out” et “Ed Hardy”? T’as une “douchebeard”? T’habites à Laval? T’aimeras ce chanson!

Categories
Uncategorized

A Man with a Plan to Scan (Whenever He Can)

You may have seen the blog entry containing a transcription of my notes from the Geek Girl Ottawa dinner, but have you seen the handwritten originals?

Scan of my handwritten notes from Geek Girl Dinner Ottawa, page 1

One of the items that came in the Bag O’ Stuff that I was given on my first day at Shopify was a Moleskine notebook and a Sacchi ballpoint pen. I have reasonably good penmanship and was once better known as a cartoonist than a programmer or accordion player, so I thought I’d put both to good use.

I know that in the age of laptops, iPads, Flip cameras and tweeting from your phone, taking notes with pen and paper seems a little passe, However, the old way still has a couple of advantages. First, you can be a little more free-form with where and how you write — you don’t have to do things is straight lines, and you can easily switch between writing and drawing and mix test and illustrations with abandon. Second, and possibly more important: paper isn’t as badly affected by crumbs or a spilled sauce or drink as electronic devices are, a consideration one must make when taking notes at a dinner.

Scan of my handwritten notes from Geek Girl Dinner Ottawa, page 2

At the end of 2009, I had a couple of coupons from Dell (thanks to TechDays) that entitled me to 25% off monitors, printers and scanners from their store. I used one coupon for their 24″ Ultrasharp monitor, which I’ve been using regularly at my home office since the start of 2010 — first with the developer machine first assigned to me, then the Dellasaurus, and now with “Vic Romano”, my Shopify-provided 15″ MacBook Pro (my machines are currently named after the hosts of Most Extreme Elimination Challenge).

Scan of my handwritten notes from Geek Girl Dinner Ottawa, page 3

I used the other coupon to get something I’d been meaning to buy for a while: a scanner. Not a cheap one integrated into one of those all-in-one printer/scanner/copier/fax machines chimeras, but an honest-to-goodness, dedicated flatbed scanner. I picked out the Epson Perfection 4490 Photo scanner. Unlike the monitor, the scanner languished unused, with its moving parts still immobilized in its packing material, until a month ago.

My plan was to return to cartooning, something I’d done for just about every student paper during my days in high school and Crazy Go Nuts University. I wasn’t going to go as far as posting webcomics, but perhaps I’d use comics as part of my blog entries. I fancied myself a less surreal, more saucy version of why the lucky stiff.

Scan of my handwritten notes from Geek Girl Dinner Ottawa, page 4

Like much of 2010, that plan didn’t quite work out. All that was prologue for 2011, which has been about throwing away old plans for new ones. Inspired by a brush with death and a couple of strange events in February that I like to call “The Battles in Seattle” (one personal, one professional, both unbloggable but tellable over drinks), I left  a comfortable and lucrative job at home for a startup and relocated, if only temporarily, to a town where I know only a few people and even less about where anything is.

So in that spirit of change, when the time came to pack my stuff for the move, I took the scanner with me, along with some sketchpads that had been lying fallow even longer than the scanner. I removed the last of the packing materials and hooked it up this evening. There was no better candidate item to scan than my Geek Girl Dinner Ottawa notes in my Moleskine.

Scan of my handwritten notes from Geek Girl Dinner Ottawa, page 5

So expect more scans of my handwritten notes, along with hand-drawn illustrations and comics in my blog posts. I hope you find them interesting.

This article also appears in Global Nerdy.

Categories
Uncategorized

Seen at the Tim Hortons in Kandahar Airfield

Tim hortons in kandahar

A rocket attack is pretty much the only thing that would keep Canadians away from Tim Hortons. I once walked through a blizzard because I had an insatiable craving for the sausage/egg breakfast sandwich on a biscuit and a double-double and nothing else would do.

Photo courtesy of Vidiot.

Categories
Uncategorized

A Box o’ Bears

Saw this in ByWard Market the other day – it’s just too adorable not to post:

box-o-bears

Categories
Uncategorized

Notes from Hacks/Hackers Ottawa, May 12, 2011

01

The term “hack” used to denote an unprincipled, untalented news reporter, but journalists have since reclaimed the word use it it proudly now. It’s still used in the publishing business to refer to a journeyman take-on-any-topic type of writer, as opposed to one who specializes in a given area.

The term “hacker”– at least within tech circles – describes a computer programming enthusiast who loves having a clear and complete understanding of the systems s/he works on and enjoys creating clever programs. The layperson’s use of the word “hacker” is more often than not used to denote people who break into computer systems – the preferred term for this sort of person is “cracker”.

While both fields appear to be quite different, there’s much that binds them together these days. Both now work online and both deal with the interpretation, processing and dissemination of information, each in its own way. We even have people who live in both worlds at the same time:

  • Adrian Holovaty: Journalist and programmer, he created Django while working at the Lawrence Journal-World and one of the first Google Maps mashups, ChicagoCrime.org (which became EveryBlock), which plotted Chicago Police data of crime locations on a map.
  • Jacqueline Cox: Programmer/journalist at the New York Times, she develops data-driven apps for the Times, such as the database of family members for the Haiti disaster.
  • Brian Boyer: Self-describe “hacker journalist”, he’s the editor of news applications at the Chicago Tribune

02

hacks hackers ottawaWith such an overlap, it was high time that hacks and hackers got together to talk about their respective fields, share ideas and start collaborations. That’s how the Hacks/Hackers meetups got started and spread far and wide. Hacks/Hackers Ottawa had its first meetup at the James Street Pub last night, and I was fortunate enough to catch it, thanks to a timely invite from my fellow Shopifolk Edward Ocampo-Gooding, Ottawa’s open data champion.

I took notes during both presentations and present them below. As always, any inaccuracies should be pointed out to me, either via email or in the comments. Feel free to copy the notes and accompanying photos and use them as you see fit!

Glen McGregor, Ottawa Citizen

03

  • We hacks call it “computer-assisted journalism”, which is a bit of a misnomer
  • It’s more accurate to call it “data-assisted journalism”
  • For us, the really useful old-school sources of data are:
    • Databases
    • Spreadsheets
    • Email
    • Maps
  • The new-school sources of data, which we’re still getting used to, are:
    • Tweets
    • Geotagged images
    • Foursquare
    • Facebook
    • and really, anything online

04

  • After the Dawson College shooting, I asked the RCMP how many of the type of guns used in that incident were registered in Canada.
  • They couldn’t – or wouldn’t – provide me with that information, so I did made a $5 access to information request for that info in the gun registry (we did spend a billion dollars on it, after all)
  • One of the interesting things I noticed was that after Dawson College, there was a spike in registrations of one of the guns used in the shooting: the Beretta Cx4 Storm
  • My original conclusion was that it was being purchased by “copycats” – people who wanted to repeat the incident elsewhere, or at least found some inspiration in the shooting
  • However, after talking to gun owners and enthusiasts, I found that those Berettas were being bought up for fear that they would be taken off the shelves after the shooting
  • The lesson here is that even though you’ve got the data, you still can’t jump to conclusions
  • Why use data?
  • You no longer have to solely rely on statements made by others, attribute a statement to them and take it as fact
  • When you assemble the data and analyze it, you become the authority and you don’t have to attribute statements to anyone else
  • In getting the data and analyzing it, you’ll find that it uncovers stories that even the stories’ subjects don’t know!
  • An example: we were wondering which Ottawa parking patrol officer issued the most tickets?
    • When we asked the city, they didn’t know – they never bothered to look at the data in that way
    • More on this later
  • Another interesting question that arose from looking at Ottawa parking data: where is the most-ticketed parking meter in the city?
    • It’s on Lisgar Street, one block west of Elgin
    • Why? It’s near City Hall, the Courthouse, a lot of nearby doctor’s and lawyer’s offices, and…oh yes, a “rub ‘n’ tug”

05

  • Looking at the data:
    • Confirms the obvious
      • For example, most parking tickets in Ottawa are issued in the Market and downtown. That’s what you would expect
    • But it also reveals the unexpected
      • For example, the third most-ticketed street is Linda Lane. Never heard of it? Neither had I
      • It’s across the street from the hospital
      • Finding this out led to a larger story about hospital visitors being targeted for parking tickets
      • Interviewed a woman who got a parking ticket because she went to the hospital for some reaction to food and had parked outside. She fell into a coma for a few days, but recovered. She had little money and was going to celebrate her recovery with a dinner but couldn’t because the money had to go to a parking ticket she’d received while in the hospital.
  • You get interesting results with mash-ups (the combination of two different data sources to get new revelations – in the old days, this would’ve been called “cross-referencing”)
    • One mash-up combined locations of lottery ticket vendors with geographical income data to reveal that poorer neighbourhoods have more people who sell lottery tickets
    • An analysis of school suspension data in Florida’s Emerald Coast area showed that black students were suspended twice as often as whites
      • Often, this sort of discovery is a jumping-off point for a story
  • Although data is very useful, most people can’t connect to it if you simply present it to them
  • People, and thus reporters, want a “face” to the story
    • Example: when researching New York City elevator inspection data, a journalist wanted to find the elevator that failed the most inspections
    • Found that elevator, but used a “face”: told the story of a person who lived in the building where that failing elevator was located; this person was handicapped and effectively trapped at home whenever the elevator was out of order

06

  • People take more interest if the story has some kind of connection to them
    • In the story Hosed at the Pump, we looked at gasoline station pump inspection data
    • Found that 75% of the inaccuracies were in favour of the retailer
    • This sort of thing is a “water cooler story” – the kind we people people will talk about at the ofice, around the water cooler (or wherever people in offices gather on break)
  • Another water cooler story based on data: “Flushed with Olympic Pride” water usage during the final hockey game at the Olympics
    • Showed spikes between periods and after overtime
    • “I’ve written stories on topics like abortion and gun control, but no story I’ve done has received more negative comments than this one.”
  • Another interesting data-driven story: frequency of tweets on May 1, 2011, the day before the Canadian election
  • One thing I like about data is that it shows that underneath it all, we’re all alike
  • A great example of data-driven journalism: Joshua Benton’s and Holly Hacker’s (yes, that’s her real name) Faking the Grade
    • It was analysis of the scores from a standardized school test called TAKS, the Texas Assessment of Knowledge and Skills
    • She got the test returns for every student in Texas and subjected them to statistical analysis
    • Found cases where the patterns in which students gave answers to this multiple-choice exam were such that they could only be the result of cheating (statistically unlikely results)
    • A Canadian angle: the analysis was done with the help of George Wesolowsky, a math professor from McMaster
  • Yet another example: A Politician Looking for Funds? Here are Two Useful Addresses
    • Article in the New York Times that revealed, with the help of campaign contribution data, which addresses were associated with the most donations to presidential campaigns
    • These addresses are:
  • Crime data is also a good source of stories
    • “We like local stories…and [crime] scares people.”
    • Showed a mash-up of Google Maps and car theft data in and around Ottawa: most car thefts took place around a private golf and country club
      • That’s where the expensive cars are
    • The bike theft hot zones in the Ottawa area are:
      • Carleton
      • Downtown
      • Lincoln Field
      • Fisher / Meadowlands
  • Now about that story of the Ottawa cop who handed out the most parking tickets
  • He’s John Raine (he’s retired now), and in 7 years, he handed out 72,000 parking tickets
  • That’s 50% more than anyone else on the force
  • He didn’t want to be interviewed, but by looking at the data, we could find out when and where he typically worked, so I followed him every lunch hour for a while
  • Every ticket he issued was legit
    • He was just very efficient: he had a system by which he’d walk down a block, identify the violators and then hand out tickets
    • He issued them so quickly – “He’s a parking savant!”
  • To get a picture of him, we had to send out one of our surveillance photographers
  • The City had no idea he was their top guy
  • Looking at a table of data, you’ll find that each column is a story, or at least a potential story
  • Hackers know that there are lots of ways to present data; hacks don’t know that
  • For an example of how to present data well and in a way that’s easy to get, see Politifact and their “Truth-o-Meter”
  • Data sometimes comes in forms that don’t look like data tables
    • Example: The Slate article Not Sarah Palin’s Friends
      • They scraped her Facebook page every five minutes
      • Took note of changes, particularly negative comments that got deleted
    • This could be done for Canadian politicians as well: half the MPs have Twitter accounts
  • Looking for an idea? Try getting your hands on city overpass records
  • When it comes to city data, you’ll find it’s mostly maps
    • Why? Because they’re non-controversial
    • There’s no performance data on a map – most other types data can reveal that someone’s not doing their job, or doing it poorly or doing it wrong
  • Lots of municipal activity ends up creating some kind of electronic record of that activity having happened
    • Any kind of official inspection creates an electronic record
    • Any 311 call creates an electronic record
    • Any official disciplinary report creates an electronic record
    • Any application for a licence or any other kind of official registration creates an electronic record
  • You have to get past the notion that open data is the data that governments give us to use
    • Much of this “open data” is there, but they’re not happy to share it
    • Often, they’ll cite the mosaic effect as an excuse for not making data available: where anonymized data, when combined with other data, can be used to de-anonymize it
  • Keep an eye on the terms of use for open data databases – they seem to change quite often
  • The Canadian federal government maintains a licence on its data – “That is crap”
  • In Canada, privacy is practically a religion
    • In the US, there’s lots of data on sex offenders – who they are, where they live, and so on
    • In Canada, little of that data is available
  • Where to get data:
    • Ask for it
    • Download it
    • Scrape it
    • Build from documents
    • FOI or ATIP
  • Hacks are good at:
    • Discerning news from info
    • Interviewing subjects
    • Providing context
    • Writing
    • Offering a big platform
  • Hackers are good at:
    • Obtaining data
    • Processing it
    • Analyzing it
    • Building better platforms to present it
  • Resources:

Alice Funke, PunditsGuide.ca

07

  • I used to work on Parliament Hill, but then I took my database programming hobby up a notch and retrained
  • A lot of data exists in flat files, and that’s not the way big data is stored
  • A lot of data is used for decision support:
    • Collect the data
    • Ask questions
    • In our case, the decision support is for political strategy
  • Election data is used for all sorts of things that people don’t think about, including:
    • reapportioning seats
    • redrawing ridings
  • There’s a lot of data downloadable from Elections Canada
    • The problem is that it’s not formatted properly
    • No unique ID code for each riding appears in the data tables they make available
    • There exists a five-character fedcode that’s supposed to uniquely identify any given riding
    • Without this fedcode, it’s much harder to make a consistent database, and a lot of additional manual work is required to massage the data
      • Without things like unique IDs – so basic to databases – you’d interpret “Peter Mackay” and “Peter G. Mackay” as two different candidates
    • So the process of working with Elections Canada’s data is to get the data, then massage it, then put it into a proper relational database
  • The data also exists at different levels. For the election, there’s
    • The “Who won the seat?” level
    • The “How many votes did each candidate get?” level
    • The “How many votes did each candidate get for each riding?” level

08

  • “There’s a special kind of hell for Elections Canada because they use .NET for their site, which gives you this giant ViewState hidden variable”
  • PunditsGuide.ca was never made for the media, at least not originally
    • It was for maybe 15 geeky people like me, and it grew from there
  • Interesting fact: Which riding walks or bikes to work the most? It’s not who you’d think:

This article also appears in Global Nerdy.

Categories
Uncategorized

Meanwhile, in Toronto…

My friend Maria snapped this photo of a guy in a squid suit on Bathurst Street by the Amsterdam Brewery:

Squid on bathurst

I’m reminded of this fella:

Zoidberg

Categories
Uncategorized

aloft Wedding Party

Last Saturday in Minneapolis, after spending the earlier part of the evening doing this:

Joey deVilla bowling

…and the later part of the evening doing this:

Bottle of Auchentoshan scotch

…I returned back here at around 3:00 a.m.:

Exterior of aloft Minneapolis

The lobby was still packed with people, many of whom were still dressed up pretty nicely. A quick look confirmed that it was a wedding party that didn’t want to stop, even though last call for alcohol in Minneapolis is 1:00 a.m. (it used to be that way in Ontario until the mid-’90s). They’d turned the lobby into their own private party, and the aloft management, as hip as they are, let them be. The tables were covered in boxes from Pizza Luce and bottles of beer.

I made my way to the elevator, but was stopped by a big grey-haired gentleman who said “Oh, no you don’t!”

“Pardon me?” I asked

“You just can’t wander through a lobby at three in the morning, with an accordion, without at least explaining what it is you’re doing!”

“I take it out a lot. Good things happen when I do,” I replied.

Aloft wedding 1

“That’s my son,” the guy said as he pointed to a young, shaven-headed guy in a dark grey T-shirt. “He just got married!”

“Congrats,” I said. “Would you like a song?”

“That is exactly what I want. Play whatever you like!”

And so I stayed for another hour, chatting with the bride, various wedding guests and relatives, and singing with the groom, who knew the lyrics to a lot of songs. We did The Clash, Black Eyed Peas, Britney, Cee-Lo, Stone Temple Pilots, AC/DC, Violent Femmes and Steppenwolf. People sang aloug — boisterously — and all the while, I could see the night manager at the front desk, smiling. aloft run an extremely cool hotel.

I made it to my room at 4:00 a.m.. A nice night all ’round.

Aloft wedding 2