PhotoSpread Sean Kandel with Eric Ableson, Hector Garcia-Molina, Andreas Paepcke, Martin Theobald, Steven Whang Stanford University 1
Bio-Diversity • Collecting, managing and sharing bio- diversity information • How can we help? Altitude
campus main Jasper Ridge Jasper Ridge
Camera Trap
Photos
Camera Positions
Using Excel photo date time temp species individual marks x123 1/1/2007 9:00 35 deer bambi none x124 1/1/2007 9:01 35 deer bambi none x125 1/1/2007 9:02 35 deer bambi none x126 1/1/2007 9:03 35 deer bambi none x145 1/1/2007 9:33 36 rabbit godzilla scar x147 1/1/2007 9:35 36 rabbit godzilla scar x148 1/1/2007 9:45 6 rabbit godzilla scar
Demo
D Photo SpreadSheet deer C bobcat B night day A 2 3 4 1
Photo SpreadSheet A D B C deer 1 bobcat 2 day =D1[type=“deer” & time=“day” night 3 4
PhotoSpread Interface
Force Semantics
Non-Force Semantics
Cell Display
PhotoSpread Summary • Sets of Objects in Cells • Objects Have Meta Data • Similar to Excel • Extended Formulas • Drag & Drop Reorganization
Next Steps • Field Tests • “Pivot” Operations • Cell Display • P2P Photo Sharing • Relations Between Objects • Learning • …
Recommend
More recommend