Mashup fun

Crime mapEnjoyed learning a bit about transforming XML documents with XSLT in doing some homicide mashup maps for a series of stories reporter Matt Lakin is doing.

He had complied homicide cases since 2000 into two OpenOffice Calc (Excel compatible) spreadsheets. I converted the spreadsheets to XML docs, then "transformed" each XML document into an HTML file and an XML file in Yahoo's map format using a simple perl program (all my perl programs are simple) and an XSLT stylesheet.

One gotcha I ran into was that the same spreadsheets saved by Excel and OpenOffice produced different XML for the date field and another field with using XML||Excel in perl. I'll have to look at that some more.

I did run into some issues of things I didn't know how to do in XSLT stylesheets, but I worked around them and I did have to clean up some addresses in Yahoo..

I used XML and Perl by Mark Riehl and Ilya Sterin to learn how to do this. It's a good introduction, but you'll need a book about XSLT if you want to do more than scratch the surface.

The results:

Knoxville homicides

Knox County homicides

Related Entries

2 Comments

Where did you get the data/spreadsheets for these?

The reporter created the spreadsheets after going through the reports. He'd been working on this for some time.

Leave a comment

Recent Entries

  • DIY blueprint: Creating a media venture in a weekend

    Great behind-the-scenes piece from search engine expert Danny Sullivan on the launch of laid-off newspaperman Greg Hernandez's Greg in Hollywood blog.Basically a tool-kit for doing...

  • Carl Malamud for Public Printer of the U.S.

    I can't think of anyone more qualified in the Digital Age to be the government's head printer than Carl Malamud.Find out about his campaign to...

  • Journalism is not a federal earmark

    Dave Winer, a guy who loves news and, who among his many pioneering achievements, put the New York Times into RSS, says the newsroom curmudgeons...

  • Records behind bars

    SPJ has joined an open records battle in Tennessee. INDIANAPOLIS - The Society of Professional Journalists has joined an amicus brief written by the Tennessee...

  • Reading is fundamental

    Read The Bill from Sunlight Foundation on Vimeo.It's not a novel, but it would be novel to read legislation before it's voted on. There's...

Activity Stream

  • Jack D. Lail tweeted, "[ Reader] Would You Pay to Read This Story? - The Daily Beast: Shared by jack Yet another take on pay m.. http://tinyurl.com/df9jzo"
  • Jack D. Lail shared Would You Pay to Read This Story? - The Daily Beast from www.thedailybeast.com
  • Jack D. Lail tweeted, "@RobRichards I caught up with the Daily Show piece on CNBC. He nailed them. They are parodies of themselves."
  • Jack D. Lail tweeted, "CNBC seems reactionary shrill. Declares stimulus a bust. It's barely started. Did somebody sit on their bonus?"
  • Jack D. Lail tweeted, "Houston and San Antonio newspapers might merge? http://tinyurl.com/addrnc (via @FrankStrovel)"
More ...
Close