Showing posts with label mashups. Show all posts
Showing posts with label mashups. Show all posts

Wednesday, June 11, 2008

Interactivity

Sometimes, you just have to "see" a story to get an idea of its scope. Merging video, text, photos and graphics gives such a richer story than just reading an article or watching a video.

StarTribune.com proved the power of this with its "13 Seconds in August" project looking at the I-35 collapse.

Now, the folks at DesMoinesRegister.com have shown us -- in ways made possible only by using the power of the Web -- the terrible damage to a town destroyed by a ferocious tornado. The Des Moines team has assembled graphics, photos, data and stories into an amazingly interactive package that's worthy of emulation.

Charles Apple, at VisualEditors.com, quotes the Registor's data editor, James Wilkerson, about how the project came together:

For base data about the properties, I scraped the county assessor’s web site using a perl script and put the results in a spreadsheet. There were about a thousand records for Parkersburg.

One of our graphics people, Kelli Morris, walked the route of the storm, taking pictures and talking to survivors. She then used the property spreadsheet to link to “after” pictures and built a library of survivor stories from her data and stories we published. We later went through all of the properties for which Kelli had pictures and downloaded the “before” photo from the assessor’s web site.

A parcel map shapefile was not available in a timely and affordable manner. So another graphics person — Craig Johnson — built his by hand. He then built the Flash display using some dummy xml data. Putting Kelli’s spreadsheet in mySQL, I built an xml page in php, which was used to fuel the final display.

The end product is something I believe is truly unique and visually powerful. It also shows what can be accomplished by graphics folks who understand how to use data and think ahead about how to best weave it into their work.


Wonderful example of the power of merging data and multimedia.

Friday, April 11, 2008

What j-schools should teach

Mindy McAdams at the University of Florida challenged her blog readers to share ideas about measurable skills that journalism students (and journalists) need.
The problem for j-schools has always been to teach up-to-date skills that will help students get jobs while at the same time giving them longer-lasting skills and ideals.
I learned how to use a proportion wheel and count headlines at the University of Georgia. The longer-lasting skills came from ethical discussions over beer after work at The Red and Black.
So too much emphasis on the latest technology -- Flash, or editing video for a particular outlet like Youtube -- won't last. The first, primary skill any student or worker needs is the ability to continue to learn.
Still, here's a small list, from a journalist and mom of a soon-to-be college freshman, broken into core classes and j-school classes. The j-schools can't and shouldn't do this work alone. Full colleges need to evaluate core requirements for the new generation of "net natives," who live on Facebook but just might not know how to make a balance sheet.

Core curriculum:
1. How do you identify and evaluate "good" information? Students should learn this skill starting in elementary and middle school. But public universities can't count on that education being deep and strong enough for future journalists. This class can be part of a library sciences curriculum, a liberal arts curriculum, or a science curriculum. Genie Tyburski asks that question in the syllabus for JOMC 714 through the UNC j-school's distance-learning program this fall.
2. How do you write a business plan or grant proposal? (Echoing Amy Gahran) This question can naturally evolve from students' (or their parents) efforts to get into college in the first place, or their efforts to pay for it. Navigating the maze of financial aid forms is just the first step. I know a freelance photographer mom who has told her musical college son that he can do anything he wants -- as long as he can get someone else to pay for it. That's the grant-writing part. The corporate/capitalist side is knowing how to quantify the cost of a business idea, write a business plan and make a sales pitch. Prerequisite: Accounting 101, Excel proficiency.
3. How do you organize, archive and share research? New tools are rapidly evolving here, from Google apps to institutional software available to students at specific schools. Plan a course for freshman year (or for re-entering grad school students) that mirrors middle-school organization classes -- electronic "notebook" checks, note-taking and citation-saving skills. Teach how to break down deadlines into small checkpoints. Teach the importance of deadlines for personal time management, not just for external requirements.

Journalism curriculum:

1. How do you evaluate and bring sense to raw data? Database information is proliferating, and is often available free from nonprofit organizations like the Sunlight Foundation or directly from government sources. Many organizations are finding new, cheap ways like Caspio to publish that information, but few are crunching, mashing up and analyzing the data. The easy way out is to stick it in a database ghetto on a website and watch the web hits come. Journalists need to evaluate that information and the sources and know how to mash it up into maps and categories to find patterns. Example: Binyamin Appelbaum, Ted Mellnik and friends at The Charlotte Observer demonstrated that skill with home foreclosure information long before other outlets jumped on the mortgage crisis. Prerequisite: Accounting 101, Excel and perhaps Access proficiency.
2. How do you continue to find and evaluate new tools for searching and sharing of information? Tyburski's class at UNC in the past has envisioned what life would be like without Google. Former colleague Leslie Wilkinson blogged for class about the challenge. Many journalists have at one time or another had to deal with email being down or having another crucial tool unavailable. This track would focus on alternative ways of finding and sharing reliable information when the standard methods don't work. Evaluating Twitter and mobile tools is key as technology and business evolves. Figure out how to find new tools and evaluate their effectiveness in terms of efficiency and usability.
3. Where do you draw the ethical and legal lines these days? Mindy lists an online ethics class. Going a little further and playing off Amy's post again, give students some up-to-date case studies involving business and ethics. As media companies try to find new ways to make money and also explore new roles for "citizen journalism," explore where the ethical line is now. (How to test and measure success in this class? Toughie. It would be a seminar class, with discussion, group work and papers.) Real-world examples:
A. Private corporations are buying up student newspapers. What are the ethical and business implications of the move? Will it affect what information campuses can produce and receive? What are the implications for other media in college towns?
B. The Hoya at Georgetown wants to go independent, but the college wants the paper to change its name so the college can retain the Hoya name. What's right there? How much is a name worth?
C. Should ads for egg donors be allowed in campus newspapers but ads for condoms be disallowed?
D. Should a newspaper publish the last names of children in a photo caption submitted by a reader if the reader prefers no last names because of concerns about privacy and safety?
E. Should a newspaper ignore or publish photos from an event staged by an activist group to bring publicity to their cause? Is there one standard if the photo comes from the wire versus a "citizen journalist" with the activist organization itself?

Monday, October 29, 2007

Bike versus car (And you can too!)


Apologies to Mr. Colbert on the title.

Wonderful visual presentation of bike-car wrecks from The Oregonian.

We could do it in Charlotte and Raleigh, with information at sites like this one and this one and this one.

I spent about two minutes at the last one and made the (not so pretty) chart shown here. The hard part: The crash data site says, "For a detailed review of crashes in specific locations (e.g., corridors or certain intersections within a community), it will be necessary to obtain such information at the local level."

But it's possible.

Here's another example of mashing up publicly available information to make it useful for readers, from Marc Matteo with McClatchy in California.

Utopian ideas: Foundations could give rewards or grants to creators of such projects so they can take the time to write project "cookbooks" for other papers. Or foundations could fund time for local reporters and graphic artists to develop their own projects, without eviscerating slim newspaper staffs. The ideas are spinning off Ed Wasserman's critique of Propublica.

Tuesday, June 12, 2007

Who needs a full time web developer?

Hire a company to do it for you.

I had an interview today with Jean Dubail, the AME/Online at the Cleveland Plain Dealer. They've been working with a California-based company called Caspio. Basic idea is that you get them your data through a wizard on their servers. They will then generate html code that you import onto your pagees. Readers can then search the database from your site, pulling information from their servers. Cleveland.com has used this a great deal for campaign finance information, crime, etc. Seems like a great way to get the developer in your hands when you need them most.

Couple examples built with the help of this Caspio technology:
Guitarmania http://www.cleveland.com/guitarmania/
A United Way fundraiser - like the cows or the rocking chairs Charlotte had a while back. Start from this database, pick the guitar you want to look at and it pulls the vitals from the database and then maps the location for you.

The King James Statistical Bible http://www.cleveland.com/sports/lebron_stats/
One of Dubail's favorites, this one lets you take a look at Lebron's stats in any number of ways.

Earthquake report http://www.cleveland.com/weather/earthquake_report/
A minor earthquake a couple months ago. The website asked readers to add their information to the database. It's then mapped on a Google map.

Cleveland.com's top hits are routinely sports - with the Cavs in the NBA Finals that's off the charts right now. Browns fans can't get enough. Dubail gave me today's stats: the top 5 stories were all sports. About half of Monday's unique visitors went to sports pages and accounted for about 45% of the page views.
They're developing a database of all things Browns that will encompass the 60-some year history of the team. It's taking a lot of manpower, but they're aiming to have it running in time for preseason. The hope is this database will let you search game by game for stats AND for stories from the PD. There's also one in the works for a huge high school sports database of schedules, records, results and the like.
For a town where sports traffic means big business, these two seem like fabulous ideas.