A big deal here in Atlanta is the Peachtree Road Race, the world's largest 10K. This year at ajc.com, we decided to have some database-driven fun with the results. I ended up spending most of my day and night at the office creating the site -- but it turned out to be nifty, I think.
I got the race results at a little after noon today, popped them into a database, set up queries and wrote several programs to generate an assortment of pages. The final product is a wild forest of intertwined HTML pages. I hope users eat it up.
Here are the different ways I've presented the data:
- Results listed by finish time
- Results listed alphabetically by runner's last name
- Results sorted by age group
- Results sorted by runner's hometown city
- Results sorted by runner's state
- Results sorted by runner's country
I'm curious to see how much traffic the site gets -- although I'll quickly say that I'm definitely not a huge proponent of obsessing over site statistics. My personal philosophy is: Put every single bit of information online that you can, and if the information helps at least one person, it was worth it. As Rob Curley says, "Overkill is just the right amount."