Turning my photoblog into a book
November 30, 2008
At January 1st, 2009 I want to compile a list of images which have high ratings on my photoblog. The top 40 most rated images will be compiled into a real-life book.
However, compiling such a list proved to be a nice challenge based upon the information stored in the database. Currently all images have three types of statistics: Number of votes, Total rating and Averaged rating. In this case I couldn’t just sort on the Averaged rating, since images with only one vote but with a five star rating will float to the top. So basically I had to do something with the number of votes for each image.
Since the maximum rating for my blog is 5 stars I decided to divide each average rating by this maximum rating. The result is then multiplied by the number of votes. This will give a weighted rating based upon both the average rating and the number of votes.
Sorting on this results gives me a list of the top rated images which will be in a book after January 1st, 2009. Please vote for your favorite images over at my photoblog and see if your image makes it into the book.
Curious which images are currently in the book? Take a look at this crude and unstyled output of the top40 script.
Sounds kind of like Flickr's "interestingness" rating. I'd also
Jay | November 30, 2008Sounds kind of like Flickr’s “interestingness” rating. I’d also add comments into the rating mix. As photos that make people want to comment are normally more interesting.
Maybe something like this:
rating + views + comments
Views of a particular image might be difficult in the
Dennis | November 30, 2008Views of a particular image might be difficult in the current Pixelpost setup. As for comments: the photoblog has received 130 comments. The first image was posted at 07-22-2006, so it has been running for a little over two years now (863 days to be exact). That means I got one comment per week (6.6 days to be exact).
Somehow I doubt it will influence the outcome much.
Hoi Dennis. Any chance of sharing your db query? Cheers!
TunaFish | December 21, 2008Hoi Dennis.
Any chance of sharing your db query?
Cheers!
[...] the end of November I blogged about my idea
.::Schonhose.nl::. » Downloads are up again and some notes about the book | December 21, 2008[...] the end of November I blogged about my idea of taking 40 of the highest rated images and turning it into a book. In the post I have described a method for selecting the highest rated images but there were some [...]
TunaFish: please find an updated post (with SQL) here. Enjoy!
Dennis | December 21, 2008TunaFish: please find an updated post (with SQL) here. Enjoy!