Megan Taylor

front-end dev, volunteacher, news & data junkie, bibliophile, Flyers fan, sci-fi geek and kitteh servant

post

Rambly Rambles, Updates, and Stuff

After almost two years of web searches, guides, tutorials and mucking about, I finally have a stable install of Django on OSX. For anyone who has gone the painful route of trying to get Django running smoothly on a Mac, I highly recommend free and open source Bitnami DjangoStack, which installs and is ready to go in just a few clicks. The stack includes Django 1.0.2, but will be updating to the latest release shortly, as one of their developers told me after I posted about the stack on Twitter.

Unfortunately, my adventures with Django only lasted a couple of days, as I was tossed into the deep end of the pool with Drupal this week. I’m working on building an e-commerce site, but the theme system in Drupal has my brain tied in knots. That’s what I’ll be working on for the next couple of weeks.

In other news, music is the future of journalism. Or Google Wave. Or tablet computers.

About a month ago, I traded my brick of a Creative Labs Nomad Zen Mp3 player for a Sony E Series Walkman. My Nomad lasted more than 4 years. If my Blackberry had better audio output (the volume on the Blackberry Pearl doesn’t go loud enough to be heard over the sound of the subway) I’d have used that, but I heard about the Walkman from Dave Winer’s Scripting News blog, and I love it. No, it doesn’t sync with iTunes, but I don’t want it to. The Walkman makes it easy to take in the podcasts I love while I’m walking or on the Subway. That’s all I want it to do.

On the subject of podcasts, I regularly listen to Dave Winer and Jay Rosen on Rebooting the News, Dave Stanton & Co., on Journalism Now, as well as some basic news analysis like Talk of the Nation, NOW on PBS and On the Media. I also listen to the New York Times Front Page podcast, just to see what the Grey Lady thinks is important today.


I also discovered that the New York Public Library has a great digital collection that can be checked out and downloaded online. My recent bedtime stories (audiobooks have been my salvation from insomnia since I was very young) have been the works of Orson Scott Card. I read the Ender’s Game series when I was in middle school, and again in high school, and again in college. But I never read Card’s less famous work. I’ve enjoyed Lost Boys, Hart’s Hope, Enchantment, and the Alvin Maker series immensely. Just my brand of fantasy+philosophy+sci-fi. I’m currently listening to Songmaster.

I realized something recently about my reading habits online. I use Google Reader to collect most of my news and information. Sometimes, I don’t have enough time to read everything, so I “star” things that I want to read later. The problem is, sometimes when “later” arrives, instead of reading and synthesizing something, I just bookmark it in Delicious. So now I have over 2,000 bookmarked items, a large part of which I haven’t even read. Lame.

In the same vein, I’ve been thinking about how I use Publish2. Most of the things I link to on P2 are blog posts and news articles relating to journalism. What people are doing and thinking and seeing for the future of the industry. I want to be able to share more fluidly, and while P2 can import shared items from Google Reader, not everything I share among my GR social circle is P2 material. At the same time, maybe I should go back to the slow method, take my time to add comments and quotes and tags, so my links will be more valuable.

On the subject of links, I have to confess that one of the reasons for this blog post was to test out Apture, a plugin that lets me add videos, images, Wikipedia, links, maps and more with just a few clicks. I have to say, I’m likin’ it. Another reason is that I’ve been out of the blogging groove for a long time, and this is yet another attempt to get back into it. I’ve been busy, and sometimes Twitter is so much easier, but I really think that it’s important to maintain the practice of long-form writing.

I think this blog design is one of the problems, though. It’s intimidating to think that I have to find images of a certain size for each post. And the design makes me feel like each blog post has to be an essay, instead of a few short paragraphs of thought. I’m not sure what the solution might be yet, but don’t be surprised when things start looking different around here.

post

Gainesville Restaurant Inspections / CAR Independent Study

This is a three-part project I submitted for my Independent Study on Computer-Assisted Reporting.

Part One: The Story

Dirty cutlery, unswept floors and greasy-looking employees are good clues that sanitary food preparation isn’t necessarily a restaurant’s No. 1 priority.

But when you don’t have to leave the house or even pick up the phone to get a late night snack, what do you really know about the kitchen your food is coming from?

There are over 700 restaurants in Gainesville and about 90 of these provide online ordering through Web sites like GatorFood.com and ChompMenus.com.

But these sites don’t publish state inspection reports.

According to the Florida Department of Business and Professional Regulation, the Division of Hotels and Restaurants does food service inspections 2-3 times a year. Violations can result in follow-up visits or temporary shut downs, depending on the severity.

The Division publishes inspection results on the Department of Business and Professional Regulation Web site and allows searches for specific businesses.

Roughly half of Gainesville’s eateries passed their last inspections with no warnings or follow-ups required. California Chicken Grill, Five Star Pizza, and Wing Zone, all of which allow online ordering, were among these.

In the past nine months, six restaurants were recommended for emergency closure: Wendy’s, Great Steak & Potatoe Co, Szechuan Panda, Sovereign Restaurant, China Super Buffet and Long John Silver’s. Of these, Szechuan Panda and China Super Buffet have online ordering.

China Super Buffet was shut down in July for 18 critical violations including roach activity and employees not washing their hands during food preparation. In October, the restaurant passed inspection with no violations.

Szechuan Panda was shut down nine times in 2007 with violations such as food stored on the floor, cigarette butts in the kitchen, and rodent activity. The most recent inspection, in March, resulted in a mandatory follow-up.

Forty-six restaurants were inspected within the last year after complaints were filed, among these were The Gelato Company and Las Margaritas. Both restaurants are listed on GatorFood.com and passed their inspections.

Alexis Antonacci, a representative from the Division of Hotels and Restaurants said the inspections are done randomly so the restaurants don’t know ahead of time.

Florida food inspections are not on a pass/fail system but rather require penalties based on the type and severity of violation.

There are 37 possible critical violations ranging from food protection to basic safety of the building.

Antonacci said that an administrative complaint of unacceptable critical violations can result in legal action against the restaurant.

“They can get a fine or continuing education or suspension,” Antonacci said. “Most often, it just requires a follow-up.”

104 restaurants in Gainesville received administrative complaints since June. Administrative complaints are logged by the inspectors for violations, while complaints are filed by consumers.

Of Szechuan Panda’s repeated closures she said that “repeated emergency closures are not typical, but inspectors are required to return within 24 hours to see if the problem has been eliminated.”

David Laiderman, a part-owner of ChompMenus, said that if restaurants are closed, then they are listed as closed for orders on the Web site.

“The restaurants call us and let us know when they’re closed,” he said.

Part Two: The Map

Gainesville Restaurant Inspections

gvilerestinspections A map of restaurant inspections a friend helped me with as part of my CAR Independent Study.

Part Three: How It Was Done

The first step for this assignment was to find a data set and story idea. After trying for several months to collect and study budget information for Florida state universities, this idea had to be set aside. Time elements, as well as the lack of organization of the data prevented this story from working out.

So I started looking at available data sets that would apply to Gainesville. I found that food inspection reports were available online and could be downloaded. The reports were provided as a .csv file with no column titles, so I had to find the key file and call up the Department of Business and Professional Regulation and have someone help me figure out how that whole thing worked. They were very kind and helpful, after a few false starts.

So at this point I had a huge file, with over 800 restaurants (some multiples with different locations) and what violations they got on various inspection dates.

Since my target publication is The Independent Florida Alligator, a college newspaper, I decided to narrow my field down a little. Gatorfood.com and Chompmenus.com allow online ordering for various restaurants. Which begs the question: If you never set foot in the restaurant, can you trust that your food is clean?

So I made a list of all the restaurants on those sites, and did searches for any other restaurants with Web sites for ordering online. This narrowed my data set to about 90 restaurants.

I sorted my data in several different ways to get a look at what restaurants were having inspection issues. I looked at critical and total number of violations, whether the reason for the inspection was routine or if a complaint had been filed, and what the result of the inspection was (did they have to shut down, or did they meet the standards?)

The big dataset I had didn’t provide too many details – just number of violations. But doing a search of the Department of Business and Professional Regulation Web site would pull up detailed reports with notes included by the inspectors.

I had to look up definitions for some of the terminology and called the Department of Business and Professional Regulation for clarification and interviews. I also called the contact numbers from the Web sites.

Finally, I decided what information I wanted to include in my story: a sort of overview of how restaurant inspections in Gainesville are going, highlighting any really crazy things and trying to keep the focus mainly on restaurants on my smaller list.

For the multimedia portion of the project I built a map that displays the restaurants and some basic information from the inspection reports. A script parses the .csv file and geocodes the restaurant addresses, then spits out a .xml file which generates the markers on the map.

Skills: Python, XML, Excel, Google Maps API, Writing, Reporting

Medium: Web, Text

April 30, 2008 | Comments Off on Gainesville Restaurant Inspections / CAR Independent Study | Categories: Posts | Tags: , | Permalink