research-article

Photospread: a spreadsheet for managing photos

Authors:

Andreas Paepcke,

Martin Theobald,

Hector Garcia-Molina,

Eric AbelsonAuthors Info & Claims

CHI '08: Proceedings of the SIGCHI Conference on Human Factors in Computing Systems

Pages 1749 - 1758

https://doi.org/10.1145/1357054.1357327

Published: 06 April 2008 Publication History

Abstract

PhotoSpread is a spreadsheet system for organizing and analyzing photo collections. It extends the current spreadsheet paradigm in two ways: (a) PhotoSpread accommodates sets of objects (e.g., photos) annotated with tags (attribute-value pairs). Formulas can manipulate object sets and refer to tags. (b) Photos can be reorganized (tags and location changed) by drag-and-drop operations on the spreadsheet. The PhotoSpread design was driven by the needs of field biologists who have large collections of annotated photos. The paper describes the PhotoSpread functionality and the design choices made.

References

[1]

S. Ahern, M. Davis, D. Eckles, S. King, M. Naaman, R. Nair, M. Spasojevic, J. Hui-I Yang. Zonetag: Designing context-aware mobile media capture to increase participation. PICS '06, p. 3, 2006.

[2]

B. Bederson. Photomesa: a zoomable image browser using quantum treemaps and bubblemaps. UIST '01, pp. 71--80, 2001.

Digital Library

[3]

M. Cooper, J. Foote, A. Girgensohn, L. Wilcox. Temporal event clustering for digital photo collections. ACM Trans. Multimedia Comput. Commun. Appl., 1(3):269--288, 2005.

Digital Library

[4]

A. Graham, H. Garcia-Molina, A. Paepcke, T. Winograd. Time as essence for photo browsing through personal digital libraries. In JCDL '02, pp. 326--335, 2002.

Digital Library

[5]

S. Harada, M. Naaman, Y. Song, Q. Wang, A. Paepcke. Lost in memories: Interacting with photo collections on PDAs. JCDL '04, 2004.

Digital Library

[6]

A. F. Hasler, K. Palaniappan, M. Manyin, J. Dodge. A high performance interactive image spreadsheet (iiss). Comput. Phys., 8(3):325--342, 1994.

Digital Library

[7]

H. Hsieh and F. M. Shipman. Manipulating structured information in a visual workspace. UIST '02, pp. 217--226, 2002.

Digital Library

[8]

E. Chi, J. Riedl, P. Barry, J. Konstan. Principles for information visualization spreadsheets. IEEE Comput. Graph. Appl., 18(4):30--38, 1998.

Digital Library

[9]

D. Huynh, S. Drucker, P. Baudisch, C. Wong. Time quilt: scaling up zoomable photo browsers for large, unstructured photo collections. CHI '05, pp. 1937--1940, 2005.

Digital Library

[10]

E. Kandogan, E. Haber, R. Barrett, A. Cypher, P. Maglio, H. Zhao. A1: end-user programming for web-based system administration. UIST '05, pp. 211--220, 2005.

Digital Library

[11]

M. Levoy. Spreadsheets for images. Computer Graphics, 28:139--146, 1994.

Digital Library

[12]

K. Ma. Image graphs -- a novel approach to visual data exploration. VIS '99, pp. 81--88, 1999.

Digital Library

[13]

Merkitys-meaning. Available from http://meaning.3xi.org/, 2007.

[14]

M. Morris, A. Paepcke, T. Winograd. Teamtag: Exploring centralized versus replicated controls for co-located tabletop groupware. CHI'06, 2006.

Digital Library

[15]

M. Naaman, Y. Song, A. Paepcke, H. Garcia-Molina. Automatic organization for digital photographs with geographic coordinates. JCDL '04, pp. 53--62, 2004.

Digital Library

[16]

S. Kandel, A. Paepcke, M. Theobald, H. Garcia-Molina. The Photospread query language. T.R. available at http://dbpubs.stanford.edu/pub/2007-27, 2007.

[17]

K. Rodden, K. Wood. How do people manage their digital photographs? Proc. Human factors in computing systems, pp. 409--416, 2003.

Digital Library

[18]

B. Shneiderman. Tree visualization with tree-maps: 2-d space-filling approach. ACM Trans. Graph., 11(1):92--99, 1992.

Digital Library

[19]

N. Snavely, S. Seitz, R. Szeliski. Photo tourism: exploring photo collections in 3d. ACM Trans. Graph., 25(3):835--846, 2006.

Digital Library

[20]

Tableau Software. Available from http://www.tableausoftware.com/, 2007.

[21]

Kentaro Toyama, Ron Logan, and Asta Roseway. Geographic location tags on digital images. ACM Multimedia, pp. 156--166, 2003.

Digital Library

[22]

A. Varshney, A. Kaufman. Finesse: a financial information spreadsheet. INFOVIS '96, p. 70, 1996.

Digital Library

[23]

R. Veltkamp, M. Tanase. Content-based image retrieval systems: A survey. TR UU-CS-2000-34, C.S. Dept., Utrecht University, 2002.

[24]

Context watcher. Available from http://contextwatcher.lab.telin.nl/contextwatcherportal, 2007.

[25]

K. Yee, K. Swearingen, K. Li, M. Hearst. Faceted metadata for image search and browsing. Proc. Human factors in computing systems, pp. 401--408, 2003.

Digital Library

Cited By

Rahman SBendre MLiu YZhu SSu ZKarahalios KParameswaran A(2021)NOAHProceedings of the VLDB Endowment10.14778/3447689.344770114:6(970-983)Online publication date: 12-Apr-2021
https://dl.acm.org/doi/10.14778/3447689.3447701
Zahalka JWorring MVan Wijk J(2021)II-20: Intelligent and pragmatic analytic categorization of image collectionsIEEE Transactions on Visualization and Computer Graphics10.1109/TVCG.2020.303038327:2(422-431)Online publication date: Feb-2021
https://doi.org/10.1109/TVCG.2020.3030383
Ramachandran PDevarajan K(2017) ViXeN : An open‐source package for managing multimedia data Methods in Ecology and Evolution10.1111/2041-210X.128929:3(785-792)Online publication date: 12-Oct-2017
https://doi.org/10.1111/2041-210X.12892
Show More Cited By

Index Terms

Photospread: a spreadsheet for managing photos
1. Human-centered computing
  1. Human computer interaction (HCI)
2. Information systems
  1. Information systems applications
    1. Multimedia information systems

Recommendations

SpreadCluster: recovering versioned spreadsheets through similarity-based clustering
MSR '17: Proceedings of the 14th International Conference on Mining Software Repositories

Version information plays an important role in spreadsheet understanding, maintaining and quality improving. However, end users rarely use version control tools to document spreadsheets' version information. Thus, the spreadsheets' version information ...
VEnron: a versioned spreadsheet corpus and related evolution analysis
ICSE '16: Proceedings of the 38th International Conference on Software Engineering Companion

Like most conventional software, spreadsheets are subject to software evolution. However, spreadsheet evolution is rarely assisted by version management tools. As a result, the version information across evolved spreadsheets is often missing or highly ...
Tablexcel: a multi-user, multi-touch interactive tabletop interface for microsoft excel spreadsheets
INTERACT'11: Proceedings of the 13th IFIP TC 13 international conference on Human-computer interaction - Volume Part IV

In this paper, we present Tablexcel, a tabletop interface to Microsoft Excel. Single-user, desktop-based computer applications are pervasive in our daily lives and work. An application like Microsoft Excel, a widely deployed spreadsheet application, is ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

CHI '08: Proceedings of the SIGCHI Conference on Human Factors in Computing Systems

April 2008

1870 pages

ISBN:9781605580111

DOI:10.1145/1357054

General Chairs:
Mary Czerwinski
Microsoft Research, USA
,
Arnie Lund
Microsoft, USA
,
Program Chair:
Desney Tan
Microsoft Research, USA

Copyright © 2008 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 06 April 2008

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

CHI '08

Sponsor:

CHI '08: CHI Conference on Human Factors in Computing Systems

April 5 - 10, 2008

Florence, Italy

Acceptance Rates

CHI '08 Paper Acceptance Rate 157 of 714 submissions, 22%;

Overall Acceptance Rate 6,199 of 26,314 submissions, 24%

Upcoming Conference

CHI 2025

Sponsor:
sigchi

ACM CHI Conference on Human Factors in Computing Systems

April 26 - May 1, 2025

Yokohama , Japan

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

18
Total Citations
View Citations
814
Total Downloads

Downloads (Last 12 months)15
Downloads (Last 6 weeks)2

Reflects downloads up to 18 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

Rahman SBendre MLiu YZhu SSu ZKarahalios KParameswaran A(2021)NOAHProceedings of the VLDB Endowment10.14778/3447689.344770114:6(970-983)Online publication date: 12-Apr-2021
https://dl.acm.org/doi/10.14778/3447689.3447701
Zahalka JWorring MVan Wijk J(2021)II-20: Intelligent and pragmatic analytic categorization of image collectionsIEEE Transactions on Visualization and Computer Graphics10.1109/TVCG.2020.303038327:2(422-431)Online publication date: Feb-2021
https://doi.org/10.1109/TVCG.2020.3030383
Ramachandran PDevarajan K(2017) ViXeN : An open‐source package for managing multimedia data Methods in Ecology and Evolution10.1111/2041-210X.128929:3(785-792)Online publication date: 12-Oct-2017
https://doi.org/10.1111/2041-210X.12892
Worring MKoelma DZahalka J(2016)Multimedia Pivot Tables for Multimedia Analytics on Image CollectionsIEEE Transactions on Multimedia10.1109/TMM.2016.261438018:11(2217-2227)Online publication date: 1-Nov-2016
https://dl.acm.org/doi/10.1109/TMM.2016.2614380
Beheshti SBenatallah BSakr SGrigori DMotahari-Nezhad HBarukh MGater ARyu SBeheshti SBenatallah BSakr SGrigori DMotahari-Nezhad HBarukh MGater ARyu S(2016)Business Process ParadigmsProcess Analytics10.1007/978-3-319-25037-3_2(19-60)Online publication date: 29-Mar-2016
https://doi.org/10.1007/978-3-319-25037-3_2
Worring MKoelma DHauptmann ANgo CXue XJiang YSnoek CVasconcelos N(2015)Insight in Image Collections by Multimedia Pivot TablesProceedings of the 5th ACM on International Conference on Multimedia Retrieval10.1145/2671188.2749312(291-298)Online publication date: 22-Jun-2015
https://dl.acm.org/doi/10.1145/2671188.2749312
Ivan JNewkirk E(2015) C pw Photo Warehouse: a custom database to facilitate archiving, identifying, summarizing and managing photo data collected from camera traps Methods in Ecology and Evolution10.1111/2041-210X.125037:4(499-504)Online publication date: 18-Dec-2015
https://doi.org/10.1111/2041-210X.12503
Jónsson BTómasson GSigurþórsson HEiríksdóttir ÁAmsaleg LLárusdóttir M(2015)A Multi-Dimensional Data Model for Personal Photo BrowsingMultiMedia Modeling10.1007/978-3-319-14442-9_41(345-356)Online publication date: 2015
https://doi.org/10.1007/978-3-319-14442-9_41
Zahalka JWorring M(2014)Towards interactive, intelligent, and integrated multimedia analytics2014 IEEE Conference on Visual Analytics Science and Technology (VAST)10.1109/VAST.2014.7042476(3-12)Online publication date: Oct-2014
https://doi.org/10.1109/VAST.2014.7042476
Dekeyser SWatson R(2013)Metadata manipulation interface designProceedings of the Fourteenth Australasian User Interface Conference - Volume 13910.5555/2525493.2525497(33-42)Online publication date: 29-Jan-2013
https://dl.acm.org/doi/10.5555/2525493.2525497
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten