Birdcam Birds Sorted by Number of ID’d Photos
Bryce Lee was kind enough to forward me a database dump of the CONE Sutro Forest metadata, which means I now can obsess much more efficiently than I could by clicking through the Public Gallery page by page.
For example, here’s a list of all the species identified in the game, along with the number of successfully ID’d photos for each:
+---------------------------+-------------+ | name | count(name) | +---------------------------+-------------+ | Yellow-rumped Warbler | 1 | | European Starling | 2 | | Wilson's Warbler | 3 | | American Crow | 7 | | Hooded Oriole | 8 | | Purple Finch | 8 | | Pine Siskin | 8 | | Lazuli Bunting | 9 | | White-crowned Sparrow | 11 | | Townsend's Warbler | 12 | | California Towhee | 22 | | Ring-necked Pheasant | 24 | | Red-tailed Hawk | 32 | | Song Sparrow | 34 | | Allen's Hummingbird | 182 | | Golden-crowned Sparrow | 206 | | Downy Woodpecker | 333 | | Anna's Hummingbird | 345 | | Steller's Jay | 365 | | Rock Pigeon | 696 | | Lesser Goldfinch | 724 | | American Robin | 975 | | Pygmy Nuthatch | 1275 | | Mourning Dove | 1681 | | Chestnut-backed Chickadee | 1752 | | Black-headed Grosbeak | 1789 | | Dark-eyed Junco | 1998 | | Western Scrub-Jay | 2742 | | House Finch | 4712 | | House Sparrow | 5384 | +---------------------------+-------------+ 30 rows in set (0.16 sec)
This is going to be so much fun to play with. 
November 30th, 2007 at 4:18 pm
I wonder who got the most species? I miss everyone! I’ve been snapping pictures of birds everywhere I go now. The one I thought was neat was a Red shafted Flicker. I didn’t know what it was but I wrote to vireo and got the answer. Thanks vireo!
November 30th, 2007 at 7:02 pm
Haha. Yes, I’ll just bet you want to know who had the most species. And now that I ran the query to see, I can’t wait to show you.