South Florida Sun-Sentinel


« Florida sea level rise: Will we be submerged? | Main | USDA fire maps: Track the year's fires »

Mall crime in South Florida: How the database was built


Over the weekend, the Sun-Sentinel published a report on violent crimes at 13 South Florida malls. Part of our online storytelling included a searchable database (above) that lets readers explore the information.

The database was compiled by reporters Brian Hass and Sofia Santana and editor Dana Williams. They examined more than 22,000 police reports, found that more than 500 cases were violent crimes and cataloged the details in a spreadsheet. It was handed off to the graphics department and I designed and programmed the interface in Flash with a ton of help from Multimedia Director R. Scott Horner, our Flash wiz.

The rest of the Flash package was produced by Karsten Ivey, Belinda Long-Ivey and Lindsay Dubois.

We are always tying to improve and would love to hear comments on your experience with the project. Was it easy to use? Could something have been better?

POSTED IN: Government (24), Len De Groot (21)

Discuss this entry

TrackBack

TrackBack URL for this entry:
http://blogs.trb.com/cgi-bin/mt/mt-t.cgi/70940

Comments

Looks like Sawgrass Mall wins hands down.

Post a comment

To help keep spam off our site, please enter the letter "g" in the field below:

About This Blog

What happens when you merge artist and journalist? You get news from an artist's perspective. You get images that tell stories in ways words cannot. You get News Illustrated.



More

Related links
News Illustrated .pdf archive
The Edge multimedia gallery
History of News Illustrated (Wikipedia)

Subscribe by email

We'll send you every News Illustrated post.
Just enter your email address:

Delivered by FeedBurner

Or subscribe through an RSS reader.

Powered by Movable Type 3.36
Hosted by LivingDot

Add News Illustrated | Sun-Sentinel Blogs to Technorati Favorites