Editor's Note: We welcome a new regular feature and contributor here today. The MediaShift Innovation Spotlight will look in-depth at one great mash-up, database, mapping project or multimedia story that combines technology and journalism in useful ways. These projects can be at major newspaper or broadcast sites, or independent news sites or blogs. Web journalist extraordinaire Megan Taylor will be your guide to these regular bi-weekly spotlights.

St. Petersburg Times' Neighborhood Watch is a database application that tracks weekly house sales in Pinellas and Pasco counties, Florida. Readers can search for home sales by county, ZIP code or neighborhood. Median price and sale count trends are tracked and graphed at one year, six month, three month, and one month intervals. On a neighborhood level, the site plots geographical data on Google Maps and suggests listings to prospective buyers by ZIP code. The application also generates neighborhood-by-neighborhood trend stories by querying the database. The Times plans to expand Neighborhood Watch to cover more counties in the future.

Every paper has to do these kinds of real estate stories once or twice a year: The housing market has gone up, it's gone down, it stayed the same, etc. It's not big journalism, but it is important to the community and it takes a lot of time and resources to put together individual stories for different neighborhoods.

Neighborhood Watch not only provides weekly data on the housing market, but includes an instant story for each neighborhood -- a computer program analyzes sale trends to generate a short synopsis of a neighborhood's market.

This frees up real estate reporters to focus on bigger stories with context and depth. Given the current state of the market, freeing up a reporter's time to work on big stories is becoming more and more important.

The data is even appearing in the print St. Petersburg Times neighborhood sections; the paper has begun to reverse publish information that originally appeared on the web.

Matt Waite, the St. Petersburg Times News Technologist, is the brains behind Neighborhood Watch.

A Django evangelist and data hound, Waite worked as a reporter for the St. Petersburg Times for almost eight years. He is also the mastermind behind PolitiFact, a popular site where statements from U.S. presidential candidates were fact-checked and rated (including the "Pants on Fire" logo for worst offenders).

In 2004, Waite created maps to compare prices while he was house-hunting; those maps eventually became the seed for Neighborhood Watch.

Waite explained that even though newspapers only have the time and resources to cover broad, flashy stories, it was really the small, local details that interested readers. The same is true in regards to real estate stories:

Listen to Waite talk about the origins of Neighborhood Watch:

Neighborhood Watch is built on GeoDjango, a former branch of Django that has been merged with the framework in the 1.0 release.

The site uses a spatially enabled database back end called PostgreSQL, with an added SQL library called PostGIS.

For the most part, the city's neighborhood associated boundary files provided good neighborhood maps. But in the suburbs, there are developer boundaries, or common knowledge boundaries. In some places, boundaries and names were invented by the St. Petersburg Times.

The data comes from an FTP fetch through the property appraisers.

Waite started building Neighborhood Watch using the same technology he used for PolitiFact -- Django .96 and MySQL. But there was a problem: MySQL didn't support the kind of location relationships he needed.

"I had to establish a relationship between a neighborhood and a parcel," he said, "There's no real good way to do that in MySQL, so I resorted to how I did it originally: in a desktop GIS program."

This had its own problems: Updating.

"Every time I wanted to update the parcel layer, I'd have to recreate that relationship between parcel and neighborhood -- it's called a spatial join," he said. "If you're going to be updating something every week, that's bad."

So Waite started playing with GeoDjango, "which brings the functionality of a world class GIS system into the Django web framework. With GeoDjango, data models can contain geographic data, i.e. data becomes aware of space."

Have you received any complaints about the way you drew up neighborhoods?

Matt Waite: Funny thing, no, we haven't in the areas where we made them up. I've received two complaints about the maps. One was that we left out a neighborhood in an area -- and they were right, I'm adding it in -- and one was that the city neighborhood association map was just one parcel too far over the line in one small neighborhood. So it wasn't even my doing.

What was your favorite part of Neighborhood Watch to build?

Waite: The geographic components, without a doubt. Location and geography -- where you are, where you live -- is such a powerful prism for people to look at something through. It makes the data you have so much more visceral to someone when you can show them a map of their neighborhood or their house and how it relates to what you're showing them. Being able to do that efficiently and powerfully now on the server side is something very cool that I haven't even gotten my head all the way around yet.

So what has the response been like from people in the newsroom and people in the community?

Waite: Very positive on both accounts. I've mostly paid attention to the public's reaction to it and it's been very interesting. The bulk of the email I get about it is, 'We want more, more stats, more measures, more this, more that.' I've gotten a handful of emails from realtors who were mad that I included this sale and not that one, or one of their competitor's sales but not theirs. Every time, it's been because I screen out all but the most basic single-family house sales and toss all the rest. I learned with PolitiFact that the best marketing you can do is to answer your email, good or bad, and I've tried to do that.

Far and away, the most common comment I get is 'Where are the condos?' And the answer is 'We're working on it.' This version only deals with single family houses. The condo market and the house market are two very different things, and we're going to treat them that way.

The MediaShift Innovation Spotlight will run every other week. Please let me know of any innovative projects you are working on or have seen lately. It doesn't have to be from a major newspaper, it just has to be an innovative blend of journalism and technology. Please e-mail me at mtaylor[at]megantaylor[dot]org to submit a Spotlight recommendation.

Megan Taylor is a web journalist whose work focuses on combining traditional and computer-assisted information-gathering with multimedia production to create news packages online. Megan tells stories in English, HTML/CSS/, ActionScript, PHP, photos, video and audio, and blogs at her personal site.

MediaShift Spotlight Innovation illustration by Omar Lee for MediaShift.

This is a summary. Visit our site for the full post ».

Il y a quelques semaines, vous pouviez lire notre enthousiasme pour le Cathy’s book, ce roman atypique, farci de fac-similés et de numéros de téléphone à appeler. Dans la même catégorie d’ouvrages ambitieux, Sherlock Holmes : Les Crimes du docteur Watson vient de paraître aux éditions Tornade. À l’italienne, ce livre de Duane Swierczynski, auteur multicarte ayant participé à Punisher ou Immortal Iron Fist, est une véritable enquête interactive, aux pages remplies de preuves et de reproductions en tous genres. Après les deux superbes Holmes de Brunschwig et Cecil, les fans du détective sont servis.

Concrètement, l’auteur, dans la peau d’un journaliste, propose à ses lecteurs de découvrir une liasse de documents ayant appartenu à Watson, recueillis durant son incarcération pendant le grand hiatus – période où Holmes est présumé mort, disparu dans les chutes de Reichenbach. La longue lettre de Watson est adressée au colonel Resmo, seul personnage à même de le sortir du bourbier dans lequel il s’est fourré, sombre histoire de mutilation et d’incendie volontaire au 221 B Baker Street.

Si l’aspect ludique permet de découvrir le fond du mystère par soi-même, à l’aide des indices et preuves cachées dans des enveloppes, des reproductions de journaux ou de L’Ultime problème, récit de la mort présumée de Holmes, un cahier scellé en fin d’ouvrage contient la réponse du colonel, qui décrypte toute l’enquête. Bien écrit et original, le récit s’accompagne de nombreuses illustrations de Clint Hansen. En toute logique Batman : murder at Wayne manor, l’autre livre-enquête de Swierczynski qui vient de sortir aux USA, devrait arriver chez nous l’année prochaine. À moins que Piques assassines au PS n’envahisse les têtes de gondole d’ici là.

Sean Guillory of Sean's Russia Blog posts a graphic illustration for yet another one of PM Putin's crude remarks and writes about the Paul Klebnikov Fund’s event: “What is Russia Thinking? The Word from the Last of the Independent Media.”

• First, one of our main goals in combat was to make every fight grandiose and meaningful, to make every encounter feel more epic. Thus, we decided to make the new combat system a duel mode in which every enemy has special attributes, a unique personality, cool moves, and his strengths and weaknesses. Having one enemy to fight at one time gave us much more possibility to push this encounter to the limit. Every enemy is as strong as the Prince and will seize his chance to use the environment, his corrupted abilities to counter every mistake the player makes. Every enemy has a background and their own personal objectives that will help push the story forward. Also, there are multiple combat moves and these will take some time to figure them all out and access the most spectacular combos. Using your glove, Elika, your sword and acrobatics, players will be able to combine those to create some breathtaking moves. This new combat system is not meant to be button mashed, but instead requires timing, strategy and the right combo depending on the situation. Also, many quick real-time mini-games where the player has a little fraction of time to react will keep the tension high. The battle system uses some dramatic camera shots that make every fight feel even more epic. Battles will take place usually before saving a fertile ground and pushing away the Corruption. There are different challenges before healing a fertile ground, one might be an acrobatic challenge, a puzzle, a fight and a lot of them are mixes of them all.
  Sorry, there are no demo plans at this time.

• Fluidity of control and animation quality are hallmarks of Prince Of Persia games. We would never ship a POP title unless we were confident the player could fully appreciate the movement of the Prince in acro