Tornado map, a.k.a “some like it windy”

The database reporter at the Tulsa World at the beginning of each tornado season does a yearly review of the tornadoes of the last season. This year he got a database from the National Weather Service of each tornado that crossed the state in ’09 and ’10.

Read More

Okla. higher education pay database, a.k.a. “That one got away from me”

I love a challenge and I hate bad solutions to good problems. This often leads me into situations when I am doing things no one at the Tulsa World has done before. I had on of those moments when I looked at how we treated databases.

Read More

Mapping Tulsa County property values with Fusion Tables

With the recession ravaging home values all over the nation, it seemed about time to do some looking locally. One of our pair of excellent database reporters got data from the county assessor’s office and crunched it up by neighborhood and from that I was able to piece together this map.

Read More

Driven, a.k.a. “Just the photos, please”

Once in a very long while a reporter, or in this case a photographer, will know exactly what they want from a project at the outset. That is what happened with “Driven“.

Read More

2010 Census map, a.k.a. “Forget it. We’ll just do one big map.”

This map was one of my first attempts using the Google Maps API and Google Fusion Tables to build an interactive map. It turned out a bit trickier than I had originally planned since it eventually combined four maps from four data sets into the space of one map.

Read More